档查询出来有多条数据时,加上数量条件,进行匹配,如果数量也匹配不上,就默认返回第一个
| | |
| | | |
| | | OrderDetl selectItem(String orderNo, String matnr, String batch,Double qty); |
| | | |
| | | OrderDetl selectQtyItem(String orderNo, String matnr, String batch, Double qty); |
| | | |
| | | OrderDetl findByLook(List<OrderDetl> orderDetls, Long orderId, String matnr, String batch); |
| | | |
| | | boolean increase(Long orderId, String matnr, String batch, Double qty); |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public OrderDetl selectQtyItem(String orderNo, String matnr, String batch, Double qty) { |
| | | List<OrderDetl> detlList = this.baseMapper.selectItemByOrderNo(orderNo, matnr, batch); |
| | | if (detlList == null || detlList.isEmpty()) { |
| | | return null; |
| | | } else if (detlList.size() == 1) { |
| | | return detlList.get(0); |
| | | } else { |
| | | if (qty != null) { |
| | | for (OrderDetl orderDetl : detlList) { |
| | | if (!orderDetl.getQty().equals(orderDetl.getWorkQty()) && qty.equals(orderDetl.getAnfme())) { |
| | | return orderDetl; |
| | | } |
| | | } |
| | | } |
| | | return detlList.get(0); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public OrderDetl selectItem(String orderNo, String matnr, String batch, Double qty) { |
| | |
| | | } |
| | | |
| | | // 更新订单完成数量 |
| | | OrderDetl orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | OrderDetl orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | if (orderDetl==null){ |
| | | orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | } |
| | | try { |
| | | if(!Cools.isEmpty(orderDetl)){ |
| | |
| | | } |
| | | |
| | | // 更新订单完成数量 |
| | | OrderDetl orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | OrderDetl orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | if (orderDetl==null){ |
| | | orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | } |
| | | try { |
| | | if(!Cools.isEmpty(orderDetl)){ |
| | |
| | | } |
| | | for (WrkDetl wrkDetl : wrkDetls101) { |
| | | // 更新订单完成数量 |
| | | OrderDetl orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | OrderDetl orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getAnfme()); |
| | | if (orderDetl==null){ |
| | | orderDetl = orderDetlService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | orderDetl = orderDetlService.selectQtyItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), null,wrkDetl.getAnfme()); |
| | | } |
| | | try { |
| | | if(!Cools.isEmpty(orderDetl)){ |