From 726e88daef65147f766230d434b544e3731d991d Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 21 七月 2023 12:45:52 +0800
Subject: [PATCH] io_type

---
 src/main/resources/mapper/WrkMastMapper.xml |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index fa04560..d9e619d 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -244,6 +244,7 @@
         and ((wrk_sts = 4) or (wrk_sts = 8 and shuttle_no is not null))
         and sta_no = #{staNo}
         and wrk_no=#{workNo}
+        and io_type in (1)
         order by io_pri desc,wrk_sts desc
     </select>
 
@@ -271,6 +272,7 @@
     <select id="selectBy2125" resultMap="BaseResultMap">
         select * from dbo.asr_wrk_mast
         where wrk_sts in (21,25)
+        and io_type in (101)
         order by io_pri desc,wrk_sts desc
     </select>
 

--
Gitblit v1.9.1