From fead835ac26d5b10e56b02e83b5369ffb81615d0 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期二, 21 十一月 2023 16:54:10 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
index b89da24..61b3a57 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
@@ -13,6 +13,7 @@
 public interface WrkDetlMapper extends BaseMapper<WrkDetl> {
 
     List<WrkDetl> selectByWrkNo(Integer wrkNo);
+    List<WrkDetl> selectByWrkNoUnstacking(Integer wrkNo);
 
     int deleteItem(@Param("wrkNo")Integer wrkNo, @Param("matnr")String matnr, @Param("batch")String batch);
 
@@ -20,4 +21,9 @@
 
     List<WrkDetl> selectAndLogByOrderNo(String orderNo);
 
+    int updateInspect( @Param("wrkNo")Integer wrkNo, @Param("matnr")String matnr, @Param("batch")String batch);
+
+    List<WrkDetl> selectPakoutQuery(@Param("staNo")Integer staNo, @Param("matnr")String matnr);
+
+    List<WrkDetl> selectAndLogByOrderNoGroupByMatnrOfSum(String orderNo);
 }

--
Gitblit v1.9.1