From c0b683ca5c119f485946340c7afba25ef65da988 Mon Sep 17 00:00:00 2001 From: Junjie <xjj@123> Date: 星期五, 19 四月 2024 08:20:50 +0800 Subject: [PATCH] #严格控制深浅库位出库 --- src/main/resources/mapper/LocMastMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml index d26a4e3..5e839b2 100644 --- a/src/main/resources/mapper/LocMastMapper.xml +++ b/src/main/resources/mapper/LocMastMapper.xml @@ -89,7 +89,7 @@ <foreach item="loc" collection="locNos" index="index" separator="," open="(" close=")"> #{loc} </foreach> - and loc_sts not in ('O','P') + and loc_sts not in ('O') order by row1 </select> </mapper> -- Gitblit v1.9.1