| | |
| | | WriteSheet sheet1 = EasyExcel.writerSheet(1, "拧紧数据") |
| | | .head(DaParamCollection.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
| | | .build(); |
| | | WriteSheet sheet2 = EasyExcel.writerSheet(2, "相机检测") |
| | | .head(DaParamCollection.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
| | | .build(); |
| | | // WriteSheet sheet2 = EasyExcel.writerSheet(2, "相机检测") |
| | | // .head(DaParamCollection.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
| | | // .build(); |
| | | WriteSheet sheet3 = EasyExcel.writerSheet(3, "外漏检测") |
| | | .head(DaParamCollection.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
| | | .build(); |
| | |
| | | .build(); |
| | | excelWriter.write(followReportList.getMainList(),mainSheet); |
| | | excelWriter.write(followReportList.getList1(),sheet1); |
| | | excelWriter.write(followReportList.getList2(),sheet2); |
| | | // excelWriter.write(followReportList.getList2(),sheet2); |
| | | excelWriter.write(followReportList.getList3(),sheet3); |
| | | excelWriter.write(followReportList.getList4(),sheet4); |
| | | excelWriter.write(followReportList.getList5(),sheet5); |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | @GetMapping("/changeBoxCode") |
| | | public R changeBoxCode(String sfcCode,String newBoxCode){ |
| | | if (StringUtils.isEmpty(newBoxCode)){ |
| | | return R.fail(500,"箱体码不能为空,请重试"); |
| | | } |
| | | if (StringUtils.isEmpty(sfcCode)){ |
| | | return R.fail(500,"发动机号不能为空,请重试"); |
| | | } |
| | | if (!newBoxCode.contains(",")){ |
| | | return R.fail(500,"箱体码格式有误,请重试"); |
| | | } |
| | | ProductNewPassStation checkStation = new ProductNewPassStation(); |
| | | checkStation.setSfcCode(sfcCode); |
| | | List<ProductNewPassStation> productPassStationList = productNewPassStationService.getProductPassStationList(checkStation); |
| | | if (CollUtil.isNotEmpty(productPassStationList)){ |
| | | productNewPassStationService.updateBoxCodeBySfcCode(sfcCode, newBoxCode); |
| | | return R.ok(); |
| | | } else { |
| | | return R.fail("未查找到该发动机号对应的箱体"); |
| | | } |
| | | } |
| | | } |