| | |
|---|
| | | @Transactional(rollbackFor = Exception.class) |
|---|
| | | public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) { |
|---|
| | | insOrder.setState(0); |
|---|
| | | String code = customMapper.selectById(insOrder.getCompanyId()).getCode2(); |
|---|
| | | //insOrder.setEntrustCode(giveCode.giveCode("JCZX-" + code + "-", "ins_order", "", "yyMMdd")); |
|---|
| | | //客户代号 |
|---|
| | | Custom custom = customMapper.selectById(insOrder.getCompanyId()); |
|---|
| | | String code = custom.getCode2(); |
|---|
| | | if (!custom.getCompany().equals(insOrder.getCompany())){ |
|---|
| | | Custom one = customMapper.selectOne(Wrappers.<Custom>lambdaQuery().eq(Custom::getCompany, insOrder.getCompany())); |
|---|
| | | insOrder.setCompanyId(one.getId()); |
|---|
| | | code=one.getCode2(); |
|---|
| | | } |
|---|
| | | //实验室编号 |
|---|
| | | String code2 = baseMapper.selLaboratoryCode(insOrder.getLaboratory()); |
|---|
| | | if (StringUtils.isEmpty(code2)) { |
|---|
| | | code2 = ""; |
|---|
| | | } |
|---|
| | | //外部委托编号 |
|---|
| | | insOrder.setOutEntrustCode(giveCode.giveCode3("ZT/" + code2 + "-" + code + "-", insOrder.getCompanyId(), insOrder.getLaboratory(), "ins_order", "", "yyMM")); |
|---|
| | | String giveCode = this.giveCode.giveCode("JCZX-" + code + "-", "ins_sample", "", "yyMMdd"); |
|---|
| | | insOrderMapper.insert(insOrder); |
|---|
| | | AtomicInteger count = new AtomicInteger(); |
|---|
| | |
|---|
| | | .collect(Collectors.groupingBy(CostStatisticsDto::getCompany)); |
|---|
| | | try { |
|---|
| | | // 新建ExcelWriter |
|---|
| | | ExcelWriter excelWriter = |
|---|
| | | EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build(); |
|---|
| | | |
|---|
| | | ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build(); |
|---|
| | | for (Map.Entry<String, List<CostStatisticsDto>> companyDataEntry : groupByCompany.entrySet()) { |
|---|
| | | String sheetName = companyDataEntry.getKey(); |
|---|
| | | List<CostStatisticsDto> dataList = companyDataEntry.getValue(); |
|---|
| | | WriteSheet mainSheet = EasyExcel.writerSheet(sheetName).head(CostStatisticsDto.class).build(); |
|---|
| | | excelWriter.write(dataList, mainSheet); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | // 关闭流 |
|---|
| | | excelWriter.finish(); |
|---|
| | | } catch (IOException e) { |
|---|
