| | |
| | | |
| | | private long orderId; |
| | | |
| | | private long docTypeId; |
| | | |
| | | List<ImportOrderDto> list = new ArrayList<>(); |
| | | /** |
| | | * 假设这个是一个DAO,当然有业务逻辑这个也可以是一个service。当然如果不用存储这个对象没用。 |
| | |
| | | throw new ExcelAnalysisException("单据类型错误:" + list.get(1).getColumn2()); |
| | | } |
| | | orderNo = list.get(0).getColumn2(); |
| | | docTypeId = docType.getDocId(); |
| | | Order order = new Order(); |
| | | order.setUuid(String.valueOf(snowflakeIdWorker.nextId())); |
| | | order.setOrderNo(orderNo); |
| | |
| | | List<OrderDetl> orderDetlList = new ArrayList<>(); |
| | | list.forEach(importOrderDto -> { |
| | | OrderDetl orderDetl = new OrderDetl(); |
| | | orderDetl.setBrand(importOrderDto.getColumn1()); |
| | | if (docTypeId == 24) { |
| | | orderDetl.setSpecs(String.format("%07d",Integer.parseInt(importOrderDto.getColumn1()))); // 源库位 |
| | | if (importOrderDto.getColumn2() != null) { |
| | | orderDetl.setModel(String.format("%07d",Integer.parseInt(importOrderDto.getColumn2()))); // 目标库位 |
| | | } |
| | | if (importOrderDto.getColumn3() != null) { |
| | | orderDetl.setBeBatch(Integer.parseInt(importOrderDto.getColumn3())); //巷道 |
| | | } |
| | | } else { |
| | | orderDetl.setBrand(importOrderDto.getColumn1()); |
| | | } |
| | | orderDetl.setBatch(""); |
| | | orderDetl.setOrderId(orderId); |
| | | orderDetl.setOrderNo(orderNo); |