From 015b9522a1a70a3e727fccfcc2f56365d82aaaf3 Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期六, 05 七月 2025 17:01:36 +0800
Subject: [PATCH] WCS优化
---
src/main/java/com/zy/mapper/WrkMastMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/mapper/WrkMastMapper.java b/src/main/java/com/zy/mapper/WrkMastMapper.java
index cddcc58..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}")
@@ -112,4 +118,10 @@
WrkMast selectPickStep2(@Param("barcode")String barcode);
WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo);
+
+ /**
+ * 鑾峰彇涓�鏉″埌104绔欑偣鐨勫嚭搴撲换鍔�
+ * @return 宸ヤ綔涓绘。
+ */
+ WrkMast selectBy104();
}
--
Gitblit v1.9.1