From ce5f3c4a6a9bed1c9f2317c45698fe49e63e5d36 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期一, 02 十月 2023 06:48:32 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java | 26 ++++++++++++++++++++------ 1 files changed, 20 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java index 3ab967b..a6f231a 100644 --- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java @@ -100,13 +100,16 @@ } //鍑哄簱 - 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<LocDetl> wrapper = new EntityWrapper<LocDetl>().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); +// if(Cools.isEmpty(batch)){ +// wrapper.isNull("batch"); +// }else { +// wrapper.eq("batch",batch); +// } List<LocDetl> locDetlList = this.selectList(wrapper); for (LocDetl locDetl : locDetlList) { @@ -122,6 +125,9 @@ LocDto locDto = new LocDto(locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getMaktx(), locDetl.getBatch(), orderNo, anfme); List<Integer> staNos = staDescService.queryOutStaNosByLocNo(locDetl.getLocNo(), ioType); locDto.setStaNos(staNos); + locDto.setCsocode(csocode); + locDto.setIsoseq(isoseq); + locDto.setContainerCode(locDetl.getSuppCode()); locDtoList.add(locDto); // 鍓╀綑寰呭嚭鏁伴噺閫掑噺 issued = issued - locDetl.getAnfme(); @@ -178,4 +184,12 @@ public int updateStockFreeze(String matnr, String locNo, Integer stockFreeze) { return this.baseMapper.updateStockFreeze(matnr, locNo, stockFreeze); } + + 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