From 2d6cdc6d4a4feac22724b516ffbaec629896255c Mon Sep 17 00:00:00 2001
From: whycq <913841844@qq.com>
Date: 星期四, 19 九月 2024 20:30:56 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/service/AgvLocDetlService.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
index 301da48..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,10 +20,43 @@
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();
List<AgvLocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);
+ /**
+ * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍
+ */
+ 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