From 6199ca12ba496c9205b67c4a6e5a04cf92a6f870 Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期五, 18 七月 2025 17:55:33 +0800
Subject: [PATCH] 20秒后转历史档

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

diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index f0de5cb..4e439ad 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -79,11 +79,11 @@
         LEFT JOIN asr_bas_devp b ON a.wrk_no = b.wrk_no
         WHERE b.wrk_no IS NULL
         AND (
-        (a.wrk_sts = 5 AND a.modi_time &lt; DATEADD(mi, -1, GETDATE()))
+        (a.wrk_sts = 5 AND a.modi_time &lt; DATEADD(s, -20, GETDATE()))
         OR
         (a.wrk_sts = 15 AND (
         a.ove_mk = 'Y' OR
-        a.modi_time &lt;= DATEADD(mi, -1, GETDATE()) OR
+        a.modi_time &lt;= DATEADD(s, -20, GETDATE()) OR
         a.crn_end_time IS NULL
         ))
         ) OPTION (RECOMPILE)

--
Gitblit v1.9.1