From 710deccd42576ad2dcbdc22e75f18b455d5ce2ff Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期一, 14 四月 2025 18:04:00 +0800 Subject: [PATCH] 1 --- src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 11 ++++++++--- 1 files changed, 8 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java index 9dd9c7e..8fb73e0 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java @@ -2,7 +2,8 @@ import com.baomidou.mybatisplus.mapper.BaseMapper; import com.zy.asrs.entity.WrkMast; -import org.apache.ibatis.annotations.*; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.List; @@ -14,13 +15,15 @@ // wcs --------------------------------------------- // 鍏ュ簱绗竴姝ワ紝鎵爜浠幏鍙栨潯鐮佷俊鎭椂鏌ヨ // @Select("select top 1 * from asr_wrk_mast where source_sta_no=#{sourceStaNo} and wrk_sts=2 and barcode=#{barcode} and (io_type=1 or io_type=10) order by io_pri desc,io_time,wrk_no ASC") - WrkMast selectPakInStep1(@Param("sourceStaNo")Integer sourceStaNo, @Param("barcode")String barcode); + WrkMast selectPakInStep1(@Param("sourceStaNo") Integer sourceStaNo, @Param("barcode") String barcode); - WrkMast selectPakInStep11(@Param("sourceStaNo")Integer sourceStaNo); + WrkMast selectPakInStep11(@Param("sourceStaNo") Integer sourceStaNo); List<WrkMast> selectInStep4(); WrkMast selectByWorkNo(Integer workNo); + + WrkMast selectByMainWrkNo(Integer workNo); List<WrkMast> selectLiftStep223103(); @@ -37,6 +40,8 @@ WrkMast selectLiftWrkMast(Integer liftNo); + WrkMast selectLiftWrkMastAndWrkNo(@Param("liftNo") Integer liftNo, @Param("wrkNo") Integer wrkNo, @Param("wrkNo2") Integer wrkNo2); + List<WrkMast> selectLocToLocWrkMast();//鏌ヨ搴撲綅绉昏浆宸ヤ綔妗� WrkMast selectPickStepByBarcode(String barcode); -- Gitblit v1.9.1