From d9f7a85a470c5384c1685e4e1564c5651449d4b2 Mon Sep 17 00:00:00 2001
From: TQS <56479841@qq.com>
Date: 星期二, 31 一月 2023 15:19:45 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/WrkMastMapper.xml | 2 +-
src/main/resources/mapper/BasDevpMapper.xml | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/resources/mapper/BasDevpMapper.xml b/src/main/resources/mapper/BasDevpMapper.xml
index 4dc85dc..ba12642 100644
--- a/src/main/resources/mapper/BasDevpMapper.xml
+++ b/src/main/resources/mapper/BasDevpMapper.xml
@@ -77,10 +77,10 @@
select * from dbo.asr_bas_devp where 1=1
and loading = 'Y'
<if test="sour > 200">
- and (dev_no = 204 or dev_no = 208 or dev_no = 209)
+ and dev_no = 204
</if>
<if test="sour < 200">
- and (dev_no = 104 or dev_no = 108 or dev_no = 109)
+ and dev_no = 104
</if>
</select>
diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index 33873d4..a18dcf2 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -190,7 +190,7 @@
</select>
<select id="selectWrkStsAndIoType" resultMap="BaseResultMap">
- select * from dbo.asr_wrk_mast where 1=1 and wrk_sts>11 and (io_type==103 or io_type==107)
+ select * from dbo.asr_wrk_mast where 1=1 and wrk_sts>11 and (io_type=103 or io_type=107) and crn_no=2
<if test="sour > 200">
and source_sta_no > 200
</if>
--
Gitblit v1.9.1