From 3aea803e459e7938c11e7bbc224c66595f45668f Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期二, 11 三月 2025 18:34:56 +0800
Subject: [PATCH] #优化 代码优化
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
index e52ff03..8ffcc4f 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
@@ -1,12 +1,34 @@
package com.vincent.rsf.server.manager.service.impl;
+import cn.afterturn.easypoi.excel.ExcelImportUtil;
+import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult;
+import com.vincent.rsf.server.common.utils.ExcelUtil;
+import com.vincent.rsf.server.manager.entity.excel.MatnrsTemplate;
import com.vincent.rsf.server.manager.mapper.MatnrMapper;
import com.vincent.rsf.server.manager.entity.Matnr;
import com.vincent.rsf.server.manager.service.MatnrService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
@Service("matnrService")
public class MatnrServiceImpl extends ServiceImpl<MatnrMapper, Matnr> implements MatnrService {
+ /**
+ * @author Ryan
+ * @description 鐗╂枡鏁版嵁瀵煎叆鎺ュ鐞嗗疄鐜�
+ * @throws
+ * @return
+ * @time 2025/3/3 13:08
+ */
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void importExcels(MultipartFile file) throws Exception {
+ //璇诲彇涓婁紶鏂囦欢鍐呭
+ ExcelImportResult<MatnrsTemplate> result = ExcelImportUtil.importExcelMore(file.getInputStream(), MatnrsTemplate.class, ExcelUtil.getDefaultImportParams());
+ //TODO 鐗╂枡鍐欏叆澶勭悊
+ }
}
--
Gitblit v1.9.1