From 09dff569d0d7ef08b66e5b5864adad148bcd8cd1 Mon Sep 17 00:00:00 2001
From: zouyu <2723363702@qq.com>
Date: 星期三, 10 九月 2025 11:24:29 +0800
Subject: [PATCH] 检验项中英文去除多余的空格以及[NBSP]非断行空格
---
cnas-manage/src/main/java/com/ruoyi/manage/excel/ManageDocumentListListener.java | 29 ++++++++++++++++++++++++++---
1 files changed, 26 insertions(+), 3 deletions(-)
diff --git a/cnas-manage/src/main/java/com/ruoyi/manage/excel/ManageDocumentListListener.java b/cnas-manage/src/main/java/com/ruoyi/manage/excel/ManageDocumentListListener.java
index 389b6b6..362fee6 100644
--- a/cnas-manage/src/main/java/com/ruoyi/manage/excel/ManageDocumentListListener.java
+++ b/cnas-manage/src/main/java/com/ruoyi/manage/excel/ManageDocumentListListener.java
@@ -2,12 +2,13 @@
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
+import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.manage.pojo.ManageDocumentList;
import com.ruoyi.manage.service.ManageDocumentListService;
import lombok.Data;
+import org.springframework.util.CollectionUtils;
-import java.util.ArrayList;
-import java.util.List;
+import java.util.*;
@Data
public class ManageDocumentListListener extends AnalysisEventListener<ManageDocumentList> {
@@ -31,7 +32,29 @@
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
- save();
+ int size = list.size();
+ if(size == 0){
+ throw new BaseException("瀵煎叆鏁版嵁涓嶅緱涓虹┖");
+ }else {
+ save();
+ }
+ }
+
+ @Override
+ public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
+ // 鑾峰彇琛ㄥご淇℃伅
+ if(CollectionUtils.isEmpty(headMap) || headMap.size() != 8){
+ throw new RuntimeException("瀵煎叆妯℃澘鏈夎");
+ }
+ List<String> colums = Arrays.asList(
+ "搴忓彿", "鏂囦欢缂栧彿", "绫诲埆", "鍚嶇О",
+ "鏂囦欢鐗堟湰", "浣滆��", "鐢熸晥鏃ユ湡", "鏂囦欢鐘舵��"
+ );
+ for (int i = 0; i < colums.size(); i++) {
+ if(!headMap.get(i).equals(colums.get(i))){
+ throw new BaseException("瀵煎叆妯℃澘鏈夎");
+ }
+ }
}
private void save() {
--
Gitblit v1.9.3