From 051d84a86d86fbb71e0292a09a6d03874d4fb0e5 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期二, 25 十一月 2025 13:51:12 +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