From 5320ce66cf18a6646de2b85b18cf4b7085ede98a Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期一, 10 十一月 2025 15:38:51 +0800
Subject: [PATCH] #1
---
src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
index bee4e81..ff288c2 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -113,4 +113,13 @@
WrkMast selectPickStep2(@Param("barcode")String barcode);
WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo);
+
+ @Select("select count(*) from asr_wrk_mast where io_type = 1 OR io_type = 10 OR io_type = 53 OR io_type = 54 OR io_type = 57;")
+ Integer selectIn();
+
+ @Select("select count(*) from asr_wrk_mast where io_type = 101 OR io_type = 103 OR io_type = 104 OR io_type = 107 OR io_type = 110;")
+ Integer selectOut();
+
+ @Select("select count(*) from asr_wrk_mast where wrk_sts = 11 OR wrk_sts = 12;")
+ Integer selectOutCount();
}
--
Gitblit v1.9.1