| | |
| | | if(Cools.isEmpty(excel.getBatch()) || Cools.isEmpty(excel.getPackageNo())){ |
| | | throw new CoolException("第" + index++ + "数据错误,包号或者批号为空"); |
| | | } |
| | | Pla pla = plaService.selectByBatchAndPackageNo(excel.getBatch(),excel.getPackageNo()); |
| | | Pla pla = plaService.selectByBatchAndPackageNo(excel.getBatch(),excel.getPackageNo(),excel.getBrand()); |
| | | if (pla == null) { |
| | | pla = plaCreate(pla,excel,matService,nodeService); |
| | | pla.setCreateTime(new Date()); |
| | |
| | | // throw new CoolException("保存商品信息失败,商品编码:" + excel.getMatnr()); |
| | | // } |
| | | total++; |
| | | }else if(Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_0) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_1) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_00)){ |
| | | }else if(Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_0) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_00) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_1) ){ |
| | | excel.setId(pla.getId()); |
| | | excel.setCreateTime(pla.getCreateTime()); |
| | | excel.setStatus(pla.getStatus()); |
| | | excel.setPakinTime(pla.getPakinTime()); |
| | | excel.setStash(pla.getStash()); |
| | | excel.setLocNo(pla.getLocNo()); |
| | | excel.setStockFreeze(pla.getStockFreeze()); |
| | | if(Cools.isEmpty(excel.getLocNo())){ |
| | | excel.setLocNo(pla.getLocNo()); |
| | | } |
| | | BeanUtils.copyProperties(excel,pla); |
| | | pla = plaCreate(pla,excel,matService,nodeService); |
| | | try { |
| | |
| | | pla.setWorkshop("三车间"); |
| | | } |
| | | }else if ("改性树脂".equals(pla.getType())){ |
| | | if ("01".equals(line) || "02".equals(line) || "03".equals(line) || "04".equals(line)){ |
| | | if (pla.getBrand() != null && (pla.getBrand().equals("161") || pla.getBrand().equals("171") || pla.getBrand().equals("181"))) { |
| | | pla.setOwner(OWNER_HZ); |
| | | pla.setWorkshop("一车间"); |
| | | } else if ("01".equals(line) || "02".equals(line) || "03".equals(line) || "04".equals(line)){ |
| | | pla.setOwner(OWNER_HNE); |
| | | pla.setWorkshop("二车间"); |
| | | } |
| | |
| | | pla.setStep(2); |
| | | pla.setModifyTime(new Date()); |
| | | pla.setStatus(GlobleParameter.PLA_STATUS_00); |
| | | pla.setStockFreeze(1); |
| | | pla.setStockFreeze(Cools.isEmpty(excel.getStockFreeze()) ? 1 : excel.getStockFreeze()); |
| | | pla.setWeightAnfme(pla.getWeight()); |
| | | Mat mat = matService.selectByMaktx(pla.getBrand()); |
| | | if(Cools.isEmpty(mat)){ |