From 8091c40627ad0628f465b2926152172983216a76 Mon Sep 17 00:00:00 2001
From: xiejun <xj@2023>
Date: 星期一, 19 六月 2023 20:50:41 +0800
Subject: [PATCH] 历史导入下载模板接口调试完善
---
Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/bo/WriteExcelOption.java | 125 +++++++++++++++++++++++++++++++----------
1 files changed, 95 insertions(+), 30 deletions(-)
diff --git a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/bo/WriteExcelOption.java b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/bo/WriteExcelOption.java
index 94ebd20..426ac40 100644
--- a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/bo/WriteExcelOption.java
+++ b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/bo/WriteExcelOption.java
@@ -2,53 +2,111 @@
import com.vci.ubcs.starter.bo.WriteExcelData;
+import org.apache.commons.collections4.map.LinkedMap;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
public class WriteExcelOption {
- private Map<String, List<WriteExcelData>> writeDataMap;
+
+ /**
+ * 瑕佸啓鍏ョ殑鏁版嵁
+ */
+ private LinkedMap<String/**宸ヤ綔琛ㄧ殑鍚嶇О**/, LinkedList<WriteExcelData> /**瑕佸啓鍏ョ殑鏁版嵁**/> writeDataMap ;
+
+ /**
+ * 瑕侀殣钘忕殑宸ヤ綔琛ㄥ悕绉�
+ */
private List<String> hideSheetList;
+
+ /**
+ * 鏄惁涓鸿拷鍔犵殑鍐呭锛屽嵆宸ヤ綔琛ㄥ凡缁忓瓨鍦�
+ */
private boolean append = false;
+
+ /**
+ * 鏄惁07鐨勭増鏈�
+ */
private boolean revision07 = false;
- private Map<String, List<ExcelColumnMap>> extendAttrMap;
- public WriteExcelOption() {
+ /**
+ * 鎵╁睍灞炴�х殑鏄犲皠閰嶇疆锛宲o瀵硅薄涓婂睘鎬ф槸map鐨勫舰寮忔椂浣跨敤锛宬ey涓巈xcelColumn娉ㄨВ鐨剉alue()鐩稿悓锛屽�兼槸瀵瑰簲鐨勬爣棰�
+ */
+ private LinkedMap<String,List<ExcelColumnMap>> extendAttrMap ;
+
+ /**
+ * 榛樿鏋勯�犳柟娉�
+ */
+ public WriteExcelOption(){
+
}
- public WriteExcelOption(List<WriteExcelData> excelDataList) {
- this.writeDataMap = new HashMap();
- this.writeDataMap.put("Sheet1", excelDataList);
+ /**
+ * 鍖呭惈涓�涓伐浣滆〃鐨勫唴瀹�
+ * @param excelDataList 瑕佸啓鍏ョ殑宸ヤ綔琛ㄥ唴瀹癸紝宸ヤ綔琛ㄧ殑鍚嶇О榛樿涓篠heet1
+ */
+ public WriteExcelOption(List<WriteExcelData> excelDataList){
+ writeDataMap = new LinkedMap<>();
+ LinkedList newList=new LinkedList();
+ newList.addAll(excelDataList);
+ writeDataMap.put("Sheet1",newList);
}
- public void addSheetDataList(String sheetName, List<WriteExcelData> excelDataList) {
- if (this.writeDataMap == null) {
- this.writeDataMap = new HashMap();
+ /**
+ * 鍖呭惈涓�涓伐浣滆〃鐨勫唴瀹�
+ * @param excelDataList 瑕佸啓鍏ョ殑宸ヤ綔琛ㄥ唴瀹癸紝宸ヤ綔琛ㄧ殑鍚嶇О榛樿涓篠heet1
+ */
+ public WriteExcelOption(LinkedList<WriteExcelData> excelDataList){
+ writeDataMap = new LinkedMap<>();
+ writeDataMap.put("Sheet1",excelDataList);
+ }
+
+ /**
+ * 娣诲姞宸ヤ綔琛ㄧ殑鏁版嵁瀵硅薄
+ * @param sheetName 宸ヤ綔琛ㄥ悕绉�
+ * @param excelDataList 宸ヤ綔琛ㄧ殑鏁版嵁鍒楄〃
+ */
+ public void addSheetDataList(String sheetName,LinkedList<WriteExcelData> excelDataList){
+ if(writeDataMap == null){
+ writeDataMap = new LinkedMap<>();
}
-
- this.writeDataMap.put(sheetName, excelDataList);
+ writeDataMap.put(sheetName,excelDataList);
}
- public void addHideSheet(String sheetName) {
- if (this.hideSheetList == null) {
- this.hideSheetList = new ArrayList();
+ /**
+ * 娣诲姞宸ヤ綔琛ㄧ殑鏁版嵁瀵硅薄
+ * @param sheetName 宸ヤ綔琛ㄥ悕绉�
+ * @param excelDataList 宸ヤ綔琛ㄧ殑鏁版嵁鍒楄〃
+ */
+ public void addSheetDataList(String sheetName,List<WriteExcelData> excelDataList){
+ if(writeDataMap == null){
+ writeDataMap = new LinkedMap<>();
}
-
- this.hideSheetList.add(sheetName);
+ LinkedList newList=new LinkedList();
+ newList.addAll(excelDataList);
+ writeDataMap.put(sheetName,newList);
}
- public Map<String, List<WriteExcelData>> getWriteDataMap() {
- return this.writeDataMap;
+ /**
+ * 娣诲姞闇�瑕佸奖鍝嶇殑宸ヤ綔琛ㄥ悕绉�
+ * @param sheetName 宸ヤ綔琛ㄥ悕绉�
+ */
+ public void addHideSheet(String sheetName){
+ if(hideSheetList == null){
+ hideSheetList = new ArrayList<>();
+ }
+ hideSheetList.add(sheetName);
}
- public void setWriteDataMap(Map<String, List<WriteExcelData>> writeDataMap) {
+ public Map<String, LinkedList<WriteExcelData>> getWriteDataMap() {
+ return writeDataMap;
+ }
+
+ public void setWriteDataMap(LinkedMap<String, LinkedList<WriteExcelData>> writeDataMap) {
this.writeDataMap = writeDataMap;
}
public List<String> getHideSheetList() {
- return this.hideSheetList;
+ return hideSheetList;
}
public void setHideSheetList(List<String> hideSheetList) {
@@ -56,7 +114,7 @@
}
public boolean isAppend() {
- return this.append;
+ return append;
}
public void setAppend(boolean append) {
@@ -64,22 +122,29 @@
}
public boolean isRevision07() {
- return this.revision07;
+ return revision07;
}
public void setRevision07(boolean revision07) {
this.revision07 = revision07;
}
- public Map<String, List<ExcelColumnMap>> getExtendAttrMap() {
- return this.extendAttrMap;
+ public LinkedMap<String, List<ExcelColumnMap>> getExtendAttrMap() {
+ return extendAttrMap;
}
- public void setExtendAttrMap(Map<String, List<ExcelColumnMap>> extendAttrMap) {
+ public void setExtendAttrMap(LinkedMap<String, List<ExcelColumnMap>> extendAttrMap) {
this.extendAttrMap = extendAttrMap;
}
+ @Override
public String toString() {
- return "WriteExcelOption{writeDataMap=" + this.writeDataMap + ", hideSheetList=" + this.hideSheetList + ", append=" + this.append + ", revision07=" + this.revision07 + ", extendAttrMap=" + this.extendAttrMap + '}';
+ return "WriteExcelOption{" +
+ "writeDataMap=" + writeDataMap +
+ ", hideSheetList=" + hideSheetList +
+ ", append=" + append +
+ ", revision07=" + revision07 +
+ ", extendAttrMap=" + extendAttrMap +
+ '}';
}
}
--
Gitblit v1.9.3