From f48878cdae5652be9e8f1145eda84d2ca9ca0544 Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期二, 07 一月 2025 13:52:05 +0800 Subject: [PATCH] 优化订单同步逻辑及环境配置 --- src/main/java/com/zy/asrs/service/LocDetlService.java | 26 ++++++++++++++++++++++++-- 1 files changed, 24 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 4b4ccce..d8580cc 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -4,22 +4,27 @@ import com.baomidou.mybatisplus.service.IService; import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.result.StockVo; +import com.zy.common.model.LocDto; import java.util.List; import java.util.Set; public interface LocDetlService extends IService<LocDetl> { - LocDetl selectItem(String locNo, String matnr, String batch); + LocDetl selectItem(String locNo, String matnr, String batch,String suppCode); + + LocDetl selectItem(String locNo, String matnr, String batch, String csocode, String isoCode); Page<LocDetl> getStockOut(Page<LocDetl> page); /** * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍 */ - boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); + boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String containerCode, String csoCode, String isoCode); boolean updateLocNo(String newLocNo, String oldLocNo); + + int updateStockFreeze(String matnr, String locNo, Integer stockFreeze); /** * 鑾峰彇鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� @@ -27,6 +32,11 @@ * @return locNo 搴撲綅鍙� */ List<String> getSameDetl(String matnr); + + /** + * 鑾峰彇鐩稿悓瑙勬牸璐х墿 + */ + List<String> getSameLevDetl(String matnr, Integer lev); /** * 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� @@ -49,6 +59,10 @@ List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos); + double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq); + + double queryStockAndSetLocDto1(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq); + Double queryStockAnfme(String matnr, String batch); List<StockVo> queryStockTotal(); @@ -62,4 +76,12 @@ List<LocDetl> selectByLocNo(String locNo); + List<String> selectLocNo(String matnr); + + Set<String> selectLocNos(String matnr); + + LocDetl selectByContainerCode(String containerCode); + + List<LocDetl> selectByLocWithoutContainer(String locNo); + } -- Gitblit v1.9.1