From fcc5194c1b671e76cb9054c9a14360139fe3be72 Mon Sep 17 00:00:00 2001 From: fei <791364011@qq.com> Date: 星期二, 16 九月 2025 22:23:50 +0800 Subject: [PATCH] 新增了代码 --- archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java | 27 +++++++++++++++++++++++++++ 1 files changed, 27 insertions(+), 0 deletions(-) diff --git a/archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java b/archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java index a0fd31e..8ed5789 100644 --- a/archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java +++ b/archiveManager/src/main/java/com/ruoyi/service/impl/DocumentMaterialsServiceImpl.java @@ -7,7 +7,11 @@ import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.utils.MapUtils; import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.bean.BeanUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ArchiveCategory; import com.ruoyi.domain.DocumentMaterials; +import com.ruoyi.domain.vo.DocumentMaterialFileSmallVo; import com.ruoyi.domain.vo.DocumentMaterialFileStyle; import com.ruoyi.domain.vo.DocumentMaterialsVo; import com.ruoyi.domain.vo.DocumentMaterialsVoLarge; @@ -15,6 +19,7 @@ import com.ruoyi.service.IDocumentMaterialsService; import com.ruoyi.util.ErrorcodeExceptionextends; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; import java.time.LocalDateTime; import java.time.ZoneId; @@ -192,4 +197,26 @@ public List<DocumentMaterialFileStyle> findFileStyleInfo(int recordId) { return this.baseMapper.getFileStyleInfo(recordId); } + + @Override + public AjaxResult importExcel(MultipartFile file, String recordId) { + ExcelUtil<DocumentMaterialFileSmallVo> util = new ExcelUtil<>(DocumentMaterialFileSmallVo.class); + List<DocumentMaterialFileSmallVo> dataList = null; + try { + dataList = util.importExcel(file.getInputStream()); + } catch (Exception e) { + throw new RuntimeException("娌℃湁鎸夌収瑙勫垯瀵煎叆鏁版嵁"); + } + + assert dataList != null; + + for (DocumentMaterialFileSmallVo archiveCategory : dataList) { + // physcialService.mySave(physcial); + DocumentMaterials documentMaterials = new DocumentMaterials(); + BeanUtils.copyProperties(archiveCategory, documentMaterials); + documentMaterials.setRecordId(Long.parseLong(recordId)); + this.insertDocumentMaterials(documentMaterials); + } + + return AjaxResult.success(); } } -- Gitblit v1.9.1