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 < DATEADD(s, -20, GETDATE())) + (a.wrk_sts = 5 AND a.modi_time < DATEADD(s, -10, GETDATE())) OR (a.wrk_sts = 15 AND ( a.ove_mk = 'Y' OR - a.modi_time <= DATEADD(s, -20, GETDATE()) OR + a.modi_time <= DATEADD(s, -10, GETDATE()) OR a.crn_end_time IS NULL )) ) OPTION (RECOMPILE) -- Gitblit v1.9.1