From b471ab5edf72439cf6e37c4635c07e7a5fc08a4f Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期二, 03 十一月 2026 19:10:14 +0800
Subject: [PATCH] fix(excel): Excel 导入报错统一转为可读中文提示，不再出现「系统异常」500
---
yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/dict/DictTypeController.java | 28 +++++++++++++++++++++++++---
1 files changed, 25 insertions(+), 3 deletions(-)
diff --git a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/dict/DictTypeController.java b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/dict/DictTypeController.java
index 3bb279d..b9f720a 100644
--- a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/dict/DictTypeController.java
+++ b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/dict/DictTypeController.java
@@ -6,6 +6,9 @@
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
+import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypeImportExcelVO;
+import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypeImportReqVO;
+import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypeImportRespVO;
import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypePageReqVO;
import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypeRespVO;
import cn.iocoder.yudao.module.system.controller.admin.dict.vo.type.DictTypeSaveReqVO;
@@ -23,6 +26,7 @@
import org.springframework.web.bind.annotation.*;
import java.io.IOException;
+import java.util.Arrays;
import java.util.List;
import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
@@ -73,7 +77,6 @@
@GetMapping("/page")
@Operation(summary = "鑾峰緱瀛楀吀绫诲瀷鐨勫垎椤靛垪琛�")
- @PreAuthorize("@ss.hasPermission('system:dict:query')")
public CommonResult<PageResult<DictTypeRespVO>> pageDictTypes(@Valid DictTypePageReqVO pageReqVO) {
PageResult<DictTypeDO> pageResult = dictTypeService.getDictTypePage(pageReqVO);
return success(BeanUtils.toBean(pageResult, DictTypeRespVO.class));
@@ -82,7 +85,6 @@
@Operation(summary = "/鏌ヨ瀛楀吀绫诲瀷璇︾粏")
@Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
@GetMapping(value = "/get")
- @PreAuthorize("@ss.hasPermission('system:dict:query')")
public CommonResult<DictTypeRespVO> getDictType(@RequestParam("id") Long id) {
DictTypeDO dictType = dictTypeService.getDictType(id);
return success(BeanUtils.toBean(dictType, DictTypeRespVO.class));
@@ -98,7 +100,6 @@
@Operation(summary = "瀵煎嚭鏁版嵁绫诲瀷")
@GetMapping("/export-excel")
- @PreAuthorize("@ss.hasPermission('system:dict:query')")
@ApiAccessLog(operateType = EXPORT)
public void export(HttpServletResponse response, @Valid DictTypePageReqVO exportReqVO) throws IOException {
exportReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
@@ -108,4 +109,25 @@
BeanUtils.toBean(list, DictTypeRespVO.class));
}
+ @GetMapping("/get-import-template")
+ @Operation(summary = "鑾峰緱瀵煎叆瀛楀吀绫诲瀷妯℃澘")
+ public void importTemplate(HttpServletResponse response) throws IOException {
+ // 鎵嬪姩鍒涘缓瀵煎嚭 demo
+ List<DictTypeImportExcelVO> list = Arrays.asList(
+ DictTypeImportExcelVO.builder().name("绀轰緥瀛楀吀").type("demo_dict_type")
+ .status(0).remark("").build()
+ );
+ // 杈撳嚭
+ ExcelUtils.write(response, "瀛楀吀绫诲瀷瀵煎叆妯℃澘.xls", "瀛楀吀绫诲瀷鍒楄〃", DictTypeImportExcelVO.class, list);
+ }
+
+ @PostMapping("/import")
+ @Operation(summary = "瀵煎叆瀛楀吀绫诲瀷")
+ @PreAuthorize("@ss.hasPermission('system:dict:import')")
+ public CommonResult<DictTypeImportRespVO> importExcel(@Valid DictTypeImportReqVO importReqVO)
+ throws Exception {
+ List<DictTypeImportExcelVO> list = ExcelUtils.read(importReqVO.getFile(), DictTypeImportExcelVO.class);
+ return success(dictTypeService.importDictTypeList(list, importReqVO));
+ }
+
}
--
Gitblit v1.9.3