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