From 00ecb40e3882df465f70f715531796912bd3c29c Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期日, 13 七月 2025 16:54:27 +0800
Subject: [PATCH] 增加空托出库条件(堆垛机自动+无报警码)
---
src/main/resources/mapper/LocMastMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 25e2ad2..630a9ba 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -207,9 +207,9 @@
select
top 1 *
from
- asr_loc_mast alm
+ asr_loc_mast alm inner join asr_bas_crnp abc on alm.crn_no = abc.crn_no
where
- alm.loc_sts = #{locType}
+ alm.loc_sts = #{locType} and abc.crn_err = 0 and abc.crn_sts = 3
<if test="rowList != null and !rowList.isEmpty()">
and alm.row1 in
<foreach collection="rowList" item="item" open="(" close=")" separator=",">
--
Gitblit v1.9.1