From b4b2da143af53a7422135abffd5306b282be6a39 Mon Sep 17 00:00:00 2001 From: zwl <1051256694@qq.com> Date: 星期三, 16 四月 2025 09:46:11 +0800 Subject: [PATCH] 2.0版本 --- src/main/java/com/zy/asrs/service/LocDetlService.java | 27 +++++++++++++++++++++++++-- 1 files changed, 25 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java index 6e4f51d..4a72ba4 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -3,17 +3,25 @@ import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.service.IService; import com.zy.asrs.entity.LocDetl; +import com.zy.asrs.entity.result.StockVo; +import org.apache.ibatis.annotations.Param; import java.util.List; +import java.util.Map; +import java.util.Set; public interface LocDetlService extends IService<LocDetl> { + + Page<LocDetl> getPage(Page<LocDetl> page); + + LocDetl selectItem(String locNo, String matnr, String batch); Page<LocDetl> getStockOut(Page<LocDetl> page); /** * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍 */ - boolean updateAnfme(Double anfme, String locNo, String matnr); + boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); boolean updateLocNo(String newLocNo, String oldLocNo); @@ -36,7 +44,22 @@ // -------------------------------------------------- + List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos); - List<LocDetl> queryStock(String matnr, String batch, String orderNo); + List<LocDetl> queryStockOther(String matnr, String batch, String orderNo, Set<String> locNos,String locNo); + + Double queryStockAnfme(String matnr, String batch); + + List<StockVo> queryStockTotal(); + + + Integer sum(); + + List<LocDetl> unreason(); + + Double getLocDetlSumQty(String locNo); + LocDetl selectByMatnr(String matnr); + + LocDetl selectMatnrSpecs(String matnr, String specs, String locNo); } -- Gitblit v1.9.1