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