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