From e6d092d364c5f11f864b34a7dfe81977e65fb232 Mon Sep 17 00:00:00 2001
From: whycq <10027870+whycq@user.noreply.gitee.com>
Date: 星期四, 13 六月 2024 09:02:07 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/service/AgvLocDetlService.java |   18 +++++++++++++++++-
 1 files changed, 17 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 dc3a97a..ad725e0 100644
--- a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
@@ -5,7 +5,9 @@
 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 +19,12 @@
     public void updateStock(String sourceLoc, String targetLoc);
 
     Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page);
+
+    Double getSumAnfme(String matnr, String threeCode);
+
+    Double getSumAnfmeProcess(String matnr, String threeCode);
+
+    Double getSumAnfmeDb(String matnr, String threeCode, Integer floor);
 
     Integer sum();
 
@@ -33,8 +41,16 @@
 
     public List<AgvLocDetl> selectByTaskDto(TaskDto taskDto);
 
-    public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode(String matnr, String batch, String csocode, String isocode);
+    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