From 1fda5036e0f08bf7388c2b5ba206d17f5c1b6d4b Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期六, 30 九月 2023 10:14:51 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java | 35 ++++++++++++++++++++++++++++------- 1 files changed, 28 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java index 597f97d..bf76e41 100644 --- a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java @@ -44,14 +44,14 @@ } - public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued) { + public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq) { //鏍规嵁鐗╂枡鍙峰拰鎵规鎵惧埌瀵瑰簲鐨勫簱瀛橈紝骞朵笖鎸夌収淇敼鏃堕棿鎺掑簭 Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).orderBy("modi_time"); - if(Cools.isEmpty(batch)){ - wrapper.isNull("batch"); - }else { - wrapper.eq("batch",batch); - } + + wapperSetCondition(wrapper,"batch",batch); + wapperSetCondition(wrapper,"three_code",csocode); + wapperSetCondition(wrapper,"dead_time",isoseq); + List<AgvLocDetl> agvLocDetls = this.selectList(wrapper); for (AgvLocDetl agvLocDetl: agvLocDetls) { @@ -67,7 +67,9 @@ //int ioType = anfme > issued ? 101 : 103; anfme = anfme > issued ? issued : anfme; LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNo, anfme); - + locDto.setCsocode(csocode); + locDto.setIsoseq(isoseq); + locDto.setContainerCode(agvLocDetl.getZpallet()); //褰撳墠搴撲綅鎵�澶勬ゼ灞� int floor = Integer.parseInt(agvLocDetl.getLocNo().split("@")[1]); locDto.setAgvStaNos(queryAgvStaNosByFloor(floor)); @@ -128,6 +130,17 @@ return this.selectList(wrapper); } + public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch) { + if (anfme <= 0) { + return this.delete(new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).eq("loc_no", locNo)); + } else { + AgvLocDetl agvLocDetl = this.selectOne(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo).eq("matnr", matnr)); + agvLocDetl.setAnfme(anfme); + return this.update(agvLocDetl,new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo).eq("matnr", matnr)); + //return baseMapper.updateAnfme(anfme, locNo, matnr, batch) > 0; + } + } + private List<String> queryAgvStaNosByFloor(int floor){ List<String> agvStaNos = new ArrayList<>(); if(floor == 1){ @@ -141,4 +154,12 @@ return agvStaNos; } + + private void wapperSetCondition(Wrapper wrapper,String column, String condition){ + if(Cools.isEmpty(condition)){ + wrapper.isNull(column); + }else { + wrapper.eq(column,condition); + } + } } -- Gitblit v1.9.1