From 6af9c1de7445337be2e13e150a476497a9708c99 Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期四, 24 七月 2025 21:08:16 +0800
Subject: [PATCH] 10秒后转历史

---
 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 4e439ad..cd03793 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(s, -20, GETDATE()))
+        (a.wrk_sts = 5 AND a.modi_time &lt; DATEADD(s, -10, GETDATE()))
         OR
         (a.wrk_sts = 15 AND (
         a.ove_mk = 'Y' OR
-        a.modi_time &lt;= DATEADD(s, -20, GETDATE()) OR
+        a.modi_time &lt;= DATEADD(s, -10, GETDATE()) OR
         a.crn_end_time IS NULL
         ))
         ) OPTION (RECOMPILE)

--
Gitblit v1.9.1