From 932b89aff065d3e7a6da133f5f70d828e7e14c0f Mon Sep 17 00:00:00 2001 From: pjb <pjb123456> Date: 星期五, 04 七月 2025 18:08:32 +0800 Subject: [PATCH] 自动补空桶-判断没在罐装线里空桶数量 --- src/main/java/com/zy/mapper/WrkMastMapper.java | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/mapper/WrkMastMapper.java b/src/main/java/com/zy/mapper/WrkMastMapper.java index 3454d25..b525888 100644 --- a/src/main/java/com/zy/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/mapper/WrkMastMapper.java @@ -11,6 +11,12 @@ @Repository public interface WrkMastMapper extends BaseMapper<WrkMast> { + /** + * 鏌ヨ鍏ョ亴瑁呯嚎绔欑偣鍦ㄩ�斾换鍔℃暟锛堟湭杩涚綈瑁呯嚎閲岄潰锛� + * @param site 鍏ョ綈瑁呯嚎绔欑偣 + */ + int selectInGzxCount(@Param("site") int site); + WrkMast selectByLocNo(@Param("sourceLocNo") String sourceLocNo); WrkMast selectByLocNo1(@Param("sourceLocNo") String sourceLocNo); @@ -31,7 +37,7 @@ // 鍏ュ簱绗簩姝ワ紝褰撴墭鐩樼墿鏂欏湪鍫嗗灈鏈哄叆搴撶珯鏃舵椂鏌ヨ // @Select("select top 1 * from dbo.asr_wrk_mast where wrk_sts=2 and crn_no=#{crnNo} and wrk_no=#{workNo} and (io_type=1 or io_type=10 or io_type=53 or io_type=54 or io_type=57) order by io_pri desc,io_time,wrk_no ASC") - WrkMast selectPakInStep2(@Param("crnNo")Integer crnNo, @Param("workNo")Integer workNo, @Param("staNo")Integer staNo); + WrkMast selectPakInStep2(@Param("crnNo")Integer crnNo, @Param("workNo")Integer workNo); // 鍏ュ簱绗笁姝ワ紝褰撳爢鍨涙満鎶婅揣鏀惧叆搴撲綅鏃� // @Select("select top 1 from dbo.asr_wrk_mast where wrk_no=#{workNo}") -- Gitblit v1.9.1