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