From c7327dd666e07d2aceca6e138ed62b89adfb0b09 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期二, 06 十二月 2022 14:30:10 +0800
Subject: [PATCH] #

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

diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index 433363f..946ad3a 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -175,7 +175,9 @@
         where 1=1
         and
         (
-            (wrk_sts in (2,3,4,5,6,7))
+            (wrk_sts = 2 and crn_no != 2)
+            or
+            (wrk_sts in (3,4,5,6,7))
             or
             (wrk_sts in (11,12,13,14,15,16))
         )

--
Gitblit v1.9.1