From cddcf22a61489ee9c2dfee169d817ccd66f95430 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期五, 03 九月 2021 02:23:43 +0800
Subject: [PATCH] 优化代码
---
service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportMeterWaterSMOImpl.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 58 insertions(+), 2 deletions(-)
diff --git a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportMeterWaterSMOImpl.java b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportMeterWaterSMOImpl.java
index fbc1566..0ca118f 100755
--- a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportMeterWaterSMOImpl.java
+++ b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportMeterWaterSMOImpl.java
@@ -176,13 +176,13 @@
//宸ヤ綔琛�
workbook = new XSSFWorkbook();
//鑾峰彇妤间俊鎭�
- getMeterWater(pd, result, workbook);
+ getMeterWater2(pd, result, workbook);
ByteArrayOutputStream os = new ByteArrayOutputStream();
MultiValueMap headers = new HttpHeaders();
headers.add("content-type", "application/octet-stream;charset=UTF-8");
- headers.add("Content-Disposition", "attachment;filename=meteWaterImport_" + DateUtil.getyyyyMMddhhmmssDateString() + ".xlsx");
+ headers.add("Content-Disposition", "attachment;filename=meteWaterImport2_" + DateUtil.getyyyyMMddhhmmssDateString() + ".xlsx");
headers.add("Pargam", "no-cache");
headers.add("Cache-Control", "no-cache");
//headers.add("Content-Disposition", "attachment; filename=" + outParam.getString("fileName"));
@@ -202,6 +202,62 @@
return new ResponseEntity<Object>(context, headers, HttpStatus.OK);
}
+ /**
+ * 鑾峰彇 鎴垮眿淇℃伅
+ *
+ * @param componentValidateResult
+ * @param workbook
+ */
+ private void getMeterWater2(IPageData pd, ComponentValidateResult componentValidateResult, Workbook workbook) {
+ JSONObject reqJson = JSONObject.parseObject(pd.getReqData());
+ Sheet sheet = workbook.createSheet("鎴垮眿璐圭敤淇℃伅");
+ Row row = sheet.createRow(0);
+ Cell cell0 = row.createCell(0);
+ cell0.setCellValue("涓婃湡搴︽暟: 璇峰～鍐欎笂鏈熻〃璇绘暟 锛沑n涓婃湡璇昏〃鏃堕棿: " +
+ "鏍煎紡涓篩YYY-MM-DD锛� \n鏈湡搴︽暟: 鏈琛ㄨ鏁帮紱\n鏈湡璇昏〃鏃堕棿: 鏍煎紡涓篩YYY-MM-DD锛� " +
+ "\n娉ㄦ剰锛氭墍鏈夊崟鍏冩牸寮忎负鏂囨湰");
+ CellStyle cs = workbook.createCellStyle();
+ cs.setWrapText(true); //鍏抽敭
+ cell0.setCellStyle(cs);
+ row.setHeight((short) (200 * 10));
+ row = sheet.createRow(1);
+ row.createCell(0).setCellValue("妤兼爧缂栧彿");
+ row.createCell(1).setCellValue("鍗曞厓缂栧彿");
+ row.createCell(2).setCellValue("鎴垮眿缂栫爜");
+ row.createCell(3).setCellValue("璐圭敤绫诲瀷");
+ row.createCell(4).setCellValue("鍗曚环");
+ row.createCell(5).setCellValue("涓婃湡搴︽暟");
+ row.createCell(6).setCellValue("涓婃湡璇昏〃鏃堕棿");
+ row.createCell(7).setCellValue("鏈湡搴︽暟");
+ row.createCell(8).setCellValue("鏈湡璇昏〃鏃堕棿");
+ row.createCell(9).setCellValue("澶囨敞");
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getExistsRoom(pd, componentValidateResult);
+ if (rooms == null) {
+ CellRangeAddress region = new CellRangeAddress(0, 0, 0, 6);
+ sheet.addMergedRegion(region);
+ return;
+ }
+
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 2);
+ row.createCell(0).setCellValue(rooms.getJSONObject(roomIndex).getString("floorNum"));
+ row.createCell(1).setCellValue(rooms.getJSONObject(roomIndex).getString("unitNum"));
+ row.createCell(2).setCellValue(rooms.getJSONObject(roomIndex).getString("roomNum"));
+ row.createCell(3).setCellValue(reqJson.getString("feeName"));
+ row.createCell(4).setCellValue(rooms.getJSONObject(roomIndex).getString("price"));
+ row.createCell(5).setCellValue(rooms.getJSONObject(roomIndex).getString("preDegrees"));
+ row.createCell(6).setCellValue(rooms.getJSONObject(roomIndex).getString("preReadingTime"));
+ row.createCell(7).setCellValue("");
+ row.createCell(8).setCellValue("");
+ row.createCell(9).setCellValue("");
+ }
+
+ CellRangeAddress region = new CellRangeAddress(0, 0, 0, 6);
+ sheet.addMergedRegion(region);
+ }
+
public RestTemplate getRestTemplate() {
return restTemplate;
}
--
Gitblit v1.8.0