From 56ced53fa6de7d929f4eb6ef722def330d44853d Mon Sep 17 00:00:00 2001 From: mrzhssss <pro6@qq.com> Date: 星期一, 28 十一月 2022 17:33:30 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 3 +++ src/main/resources/mapper/WrkMastMapper.xml | 3 +++ 2 files changed, 6 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 4685cbd..6bfd8f0 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java @@ -107,4 +107,7 @@ WrkMast selectPakoutEmpty(@Param("staNo")Integer outSite); + Integer selectExistInEmpty(); + + } diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml index d078984..8e22381 100644 --- a/src/main/resources/mapper/WrkMastMapper.xml +++ b/src/main/resources/mapper/WrkMastMapper.xml @@ -182,4 +182,7 @@ <select id="selectPakoutEmpty" resultMap="BaseResultMap"> select top 1 * from dbo.asr_wrk_mast where io_type = 110 and sta_no = #{staNo} order by io_time,wrk_no </select> + <select id="selectExistInEmpty" resultType="java.lang.Integer"> + SELECT COUNT(*) FROM dbo.asr_wrk_mast Where io_type = 10 and wrk_sts in (1,2,3) + </select> </mapper> -- Gitblit v1.9.1