From 9e40c63ecc04d9d7b3dd98cd2f396c0ff2a79e13 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期二, 03 十二月 2024 16:11:00 +0800
Subject: [PATCH] 添加订单电话更新功能及优化查询

---
 src/main/java/com/zy/asrs/service/WrkDetlService.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/WrkDetlService.java b/src/main/java/com/zy/asrs/service/WrkDetlService.java
index 8b3c512..7018d0f 100644
--- a/src/main/java/com/zy/asrs/service/WrkDetlService.java
+++ b/src/main/java/com/zy/asrs/service/WrkDetlService.java
@@ -10,4 +10,18 @@
 
     void createWorkDetail(Integer workNo, List<DetlDto> detlDtos, String barcode, Long userId);
 
+    List<WrkDetl> selectByWrkNo(Integer wrkNo);
+
+    boolean updateAnfme(Double anfme, Integer wrkNo, String matnr, String batch);
+
+    List<WrkDetl> selectAndLogByOrderNo(String orderNo);
+
+    List<WrkDetl> selectAndLogByOrderNoGroupByMatnrOfSum(String orderNo);
+
+    boolean updateInspect(Integer wrkNo, String matnr, String batch);
+
+    List<WrkDetl> selectPakoutQuery(Integer staNo, String matnr);
+
+    boolean updateOrderNo(String orderNo, Integer wrkNo, String matnr, String batch);
+
 }

--
Gitblit v1.9.1