From 9431c85fa78ea946d49f1b201d8ea4067ec31e69 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期二, 26 十一月 2024 13:03:14 +0800
Subject: [PATCH] 发货核对限制出库单据

---
 src/main/resources/mapper/OrderDetlMapper.xml |    2 +-
 src/main/resources/mapper/OrderMapper.xml     |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/resources/mapper/OrderDetlMapper.xml b/src/main/resources/mapper/OrderDetlMapper.xml
index 3097092..c40e7a5 100644
--- a/src/main/resources/mapper/OrderDetlMapper.xml
+++ b/src/main/resources/mapper/OrderDetlMapper.xml
@@ -139,7 +139,7 @@
         and md.danger = 0
     </select>
     <select id="selectDetlList" resultType="java.lang.String">
-        select brand from man_order_detl where order_no = #{orderNo}
+        select brand from man_order_detl where order_no = #{orderNo} and doc_type in(21,23)
     </select>
 
     <update id="increase">
diff --git a/src/main/resources/mapper/OrderMapper.xml b/src/main/resources/mapper/OrderMapper.xml
index 6aed376..54d4bb0 100644
--- a/src/main/resources/mapper/OrderMapper.xml
+++ b/src/main/resources/mapper/OrderMapper.xml
@@ -111,7 +111,7 @@
           and mo.settle = 1
     </select>
     <select id="selectOrderNosByOrderNoLike" resultType="java.lang.String">
-        select order_no from man_order where settle = 4 and order_no like '%' + #{orderNo} + '%'
+        select order_no from man_order where settle = 4 and order_no like '%' + #{orderNo} + '%' and doc_type in(21,23)
     </select>
 
 </mapper>

--
Gitblit v1.9.1