From 07a64ae2621fe7806e3d35497f22efa8f235a53e Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期二, 22 十月 2024 16:07:55 +0800
Subject: [PATCH] 1

---
 src/main/java/com/zy/asrs/service/AgvLocDetlService.java |   31 ++++++++++++++++++++++++++++++-
 1 files changed, 30 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
index d0b67a4..3d4a3a3 100644
--- a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
@@ -4,7 +4,10 @@
 import com.baomidou.mybatisplus.service.IService;
 import com.zy.asrs.entity.AgvLocDetl;
 import com.zy.common.model.LocDto;
+import com.zy.common.model.TaskDto;
+import org.springframework.web.multipart.MultipartFile;
 
+import java.io.IOException;
 import java.util.List;
 
 public interface AgvLocDetlService extends IService<AgvLocDetl> {
@@ -17,6 +20,16 @@
 
     Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page);
 
+    Double getSumAnfme(String matnr, String threeCode);
+
+    Double getSumAnfmeProcess(String matnr, String threeCode);
+
+    Double getSumAnfmeProcessed(String matnr, String threeCode);
+
+    Double getSumAnfmeDb(String matnr, String threeCode, Integer floor);
+
+    Double getSumAnfmeback(String matnr, String threeCode, Integer floor);
+
     Integer sum();
 
     List<AgvLocDetl> getStockStatisExcel();
@@ -26,8 +39,24 @@
     /**
      * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍
      */
-    boolean updateAnfme(Double anfme, String locNo, String matnr, String batch);
+    boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode);
+
+    boolean updateAnfmeProcess(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode,Integer process);
 
     public AgvLocDetl selectByLocNo(String locNo);
 
+    public List<AgvLocDetl> selectByTaskDto(TaskDto taskDto);
+
+    public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode(String locNo, String matnr, String batch, String csocode, String isocode);
+
+    public Double selectSumAnfmeByLocNo(String locNo);
+
+    public Double selectSumAnfmeByMatnr(String matnr);
+
+    public AgvLocDetl selectLocdetl(String locNo,String matnr,String batch,String csocode,String isocode);
+
+    public void compareToEss(MultipartFile file) throws IOException;
+
+    public void updateLocNo(String locNo, String sourceLoc,AgvLocDetl agvLocDetl);
+
 }

--
Gitblit v1.9.1