| | |
|---|
| | | int insert = productProcessRouteItemMapper.insert(productProcessRouteItem); |
|---|
| | | 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(); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // 生成完整的工单号 |
|---|
| | | String workOrderNoStr = String.format("%s%03d", datePrefix, sequenceNumber); |
|---|
| | | String workOrderNoStr ="FG" +String.format("%s%03d", datePrefix, sequenceNumber); |
|---|
| | | ProductWorkOrder productWorkOrder = new ProductWorkOrder(); |
|---|
| | | productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId()); |
|---|
| | | productWorkOrder.setProductOrderId(order.getId()); |
|---|
