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