From f39fd71eedfd828e715d33356a8c38ffbe66eb1a Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期五, 24 五月 2024 15:28:09 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/mapper/LoadGlassMapper.java | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/mapper/LoadGlassMapper.java b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/mapper/LoadGlassMapper.java new file mode 100644 index 0000000..93ba7fb --- /dev/null +++ b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/mapper/LoadGlassMapper.java @@ -0,0 +1,18 @@ +package com.mes.workstation.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.mes.workstation.entity.UpWorkstation; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.Map; + +@Mapper +public interface LoadGlassMapper extends BaseMapper<UpWorkstation> { + //鍒ゆ柇浼樺厛宸ヤ綅鍚哥墖 + @Select("select b.layout_sequence,a.number from up_workstation a left join up_patten_usage b " + + "on a.pattern_width=b.width and a.pattern_height=b.height " + + "and a.pattern_thickness=b.thickness where a.workstation_id=#{id}") + Map<String, Object> selectPriority(int id); + +} -- Gitblit v1.8.0