| | |
|---|
| | | String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd")); |
|---|
| | | if (insert > 0) { |
|---|
| | | // 查询今日已存在的最大工单号 |
|---|
| | | QueryWrapper<ProductWorkOrder> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.likeRight("work_order_no", datePrefix) |
|---|
| | | .orderByDesc("work_order_no") |
|---|
| | | .last("LIMIT 1"); |
|---|
| | | ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectOne(queryWrapper); |
|---|
| | | ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectMax(datePrefix); |
|---|
| | | int sequenceNumber = 1; // 默认序号 |
|---|
| | | if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) { |
|---|
| | | String lastNo = lastWorkOrder.getWorkOrderNo().toString(); |
|---|
| | |
|---|
| | | ProductWorkOrder productWorkOrder = new ProductWorkOrder(); |
|---|
| | | productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId()); |
|---|
| | | productWorkOrder.setProductOrderId(productProcessRouteItem.getProductOrderId()); |
|---|
| | | productWorkOrder.setLotNo(productOrder.getLotNo()); |
|---|
| | | productWorkOrder.setPriority(productOrder.getPriority()); |
|---|
| | | productWorkOrder.setPlanQuantity(productOrder.getQuantity()); |
|---|
| | | productWorkOrder.setWorkOrderNo(workOrderNoStr); |
|---|
| | | productWorkOrder.setStatus(1); |
|---|
