| | |
| | | } |
| | | System.out.println(map); |
| | | createWord(sonLaboratory, document, exceldata, map, biaozhun, insOrderFile); |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | } finally { |
| | | // 关闭资源 |
| | | try { |
| | |
| | | orderFile.setSonLaboratory(sonLaboratory); |
| | | insOrderFileMapper.insert(orderFile); |
| | | |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | } finally { |
| | | // 关闭资源 |
| | | try { |
| | |
| | | Map<String, List<Map<String, Object>>> aggregatedMap = new HashMap<>(); |
| | | Map<String, List<Map<String, Object>>> o1 = (Map<String, List<Map<String, Object>>>) dataRow.get(result); |
| | | for (String s2 : collect) { |
| | | if (s2.contains("端口")) { |
| | | if (s2.contains("端口")||s2.contains("P")) { |
| | | List<Map<String, Object>> mapList = o1.get(s2); |
| | | list.addAll(mapList); |
| | | } |
| | |
| | | } |
| | | int rowNum = 2; |
| | | for (String s2 : aggregatedMap.keySet()) { |
| | | if (s2.equals("端口") || s2.equals("频率")) { |
| | | if (s2.equals("端口") || s2.equals("频率") || s2.equals("P")) { |
| | | continue; |
| | | } |
| | | List<Map<String, Object>> mapList = aggregatedMap.get(s2); |
| | |
| | | run9.setText(""); |
| | | for (int i = 0; i < collect.size(); i++) { |
| | | String s3 = collect.get(i); |
| | | if (s3.contains("端口")) { |
| | | if (s3.contains("端口") ||s3.contains("P")) { |
| | | XWPFParagraph paragraph10 = table1.getRow(rowNum + 1).getCell(5 + i).getParagraphArray(0); |
| | | paragraph10.setAlignment(ParagraphAlignment.CENTER); |
| | | XWPFRun run10 = paragraph10.createRun(); |
| | |
| | | List<Map<String, Object>> mapList1 = group.get(aDouble); |
| | | for (Map<String, Object> stringObjectMap : mapList1) { |
| | | String port = stringObjectMap.get("端口").toString(); |
| | | if (ObjectUtils.isNull(port)){ |
| | | port = stringObjectMap.get("P").toString(); |
| | | } |
| | | for (int i = 5; i < cell - 1; i++) { |
| | | String text = table1.getRow(rowNum + 1).getCell(i).getText(); |
| | | if (text.equals(port)) { |
| | |
| | | |
| | | |
| | | List<String> collect = Arrays.stream(split).collect(Collectors.toList()); |
| | | collect.remove(collect.size() - 1); |
| | | collect.sort((o1, o21) -> Integer.parseInt(o1.substring((o1.length() - 1))) - Integer.parseInt(o21.substring(o21.length() - 1))); |
| | | |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | |
| | | |
| | | Map<String, List<Map<String, Object>>> o1 = (Map<String, List<Map<String, Object>>>) dataRow.get(result); |
| | | for (String s2 : collect) { |
| | | if (s2.contains("端口") || s2.contains("P")) { |
| | | if (s2.contains("端口") || s2.contains("P") || s2.contains("广播") || s2.contains("业务")) { |
| | | List<Map<String, Object>> mapList = o1.get(s2); |
| | | list.addAll(mapList); |
| | | } |
| | |
| | | XWPFRun run9 = paragraph9.createRun(); |
| | | run9.setText(""); |
| | | |
| | | for (int i = 0; i < collect.size() - 1; i++) { |
| | | for (int i = 0; i < collect.size(); i++) { |
| | | String s3 = collect.get(i); |
| | | if (s3.contains("端口") || s3.contains("P")) { |
| | | if (s3.contains("端口") || s3.contains("P") || s3.contains("广播") || s3.contains("业务")) { |
| | | XWPFParagraph paragraph10 = table1.getRow(rowNum+1).getCell(5 + i).getParagraphArray(0); |
| | | paragraph10.setAlignment(ParagraphAlignment.CENTER); |
| | | XWPFRun run10 = paragraph10.createRun(); |