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 | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
index 3c4accb..ff288c2 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -114,9 +114,12 @@
WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo);
- @Select("select count(*) from asr_wrk_mast where io_type = 1 and io_type = 10 and io_type = 53 and io_type = 54 and io_type = 57;")
+ @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 and io_type = 103 and io_type = 104 and io_type = 107 and io_type = 110;")
+ @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