From 428d3cb6cc6c2cd1e12a0311586df26ea82f6ba1 Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期二, 03 九月 2024 12:43:21 +0800
Subject: [PATCH] 123
---
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 2 +-
src/main/resources/mapper/LocDetlMapper.xml | 24 ++++++++++--------------
2 files changed, 11 insertions(+), 15 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index 30da07a..91f71db 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -57,7 +57,7 @@
// -------------------------------------------------
- List<LocDetl> queryStock(@Param("sPgNO")String sPgNO, @Param("model")String model, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos);
+ List<LocDetl> queryStock(@Param("sPgNO")String sPgNO, @Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos);
Double queryStockAnfme(String matnr, String batch);
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 24dbdd0..83e08fa 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -245,18 +245,14 @@
<!-- </otherwise>-->
<!-- </choose>-->
- <choose>
- <when test="sPgNO != null and sPgNO != ''">
- and a.pg_no = #{sPgNO}
- </when>
- <otherwise>
- and (pg_no IS NULL OR pg_no = '')
- </otherwise>
- </choose>
- <if test="batch != null and batch != ''">
- and a.batch = #{batch}
- </if>
-<!-- <choose>-->
+
+ <if test="sPgNO != null and sPgNO != ''">
+ and a.pg_no = #{sPgNO}
+ </if>
+ <if test="batch != null and batch != ''">
+ and a.batch = #{batch}
+ </if>
+ <!-- <choose>-->
<!-- <when test="batch != null and batch != ''">-->
<!-- and batch = #{batch}-->
<!-- </when>-->
@@ -267,8 +263,8 @@
<!-- <if test="orderNo != null and orderNo != ''">-->
<!-- and a.order_no = #{orderNo}-->
<!-- </if>-->
- <if test="model != null and model != ''">
- and a.model = #{model}
+ <if test="matnr != null and matnr != ''">
+ and a.matnr = #{matnr}
and (a.pg_no is null or LEN(LTRIM(RTRIM(pg_no))) = 0)
</if>
--
Gitblit v1.9.1