From 63818e4689955ecd117cedba7c59d7147fcf88c8 Mon Sep 17 00:00:00 2001 From: zyx <zyx123456> Date: 星期五, 17 五月 2024 09:57:57 +0800 Subject: [PATCH] 检测当前站点入库任务是否已经走出储位204L --- src/main/java/com/zy/asrs/service/AgvLocDetlService.java | 25 ++++++++++++++++++++++++- 1 files changed, 24 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 6c7550f..c6b771d 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,10 @@ Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page); + Double getSumAnfme(String matnr, String threeCode); + + Double getSumAnfmeDb(String matnr, String threeCode, Integer floor); + Integer sum(); List<AgvLocDetl> getStockStatisExcel(); @@ -26,6 +33,22 @@ /** * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负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); + + 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