From fa59bd5bf64f818111b26744a3b51b936ab6f389 Mon Sep 17 00:00:00 2001 From: liyong <18434998025@163.com> Date: 星期二, 01 七月 2025 09:50:00 +0800 Subject: [PATCH] 2025-07-01 bug修改 --- src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java b/src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java index 006ed90..913156c 100644 --- a/src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java +++ b/src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java @@ -3,6 +3,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.bean.BeanUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.device.dto.DeviceLedgerDto; @@ -11,13 +12,16 @@ import com.ruoyi.device.pojo.DeviceLedger; import com.ruoyi.device.service.IDeviceLedgerService; import com.ruoyi.framework.web.domain.AjaxResult; +import com.ruoyi.project.system.domain.SysUser; import com.ruoyi.project.system.mapper.SysUserMapper; import lombok.AllArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; +import java.io.IOException; import java.util.ArrayList; import java.util.Arrays; import java.util.List; @@ -88,4 +92,23 @@ } } + + @Override + public Boolean importData(MultipartFile file) throws IOException { + ExcelUtil<DeviceLedgerExeclDto> util = new ExcelUtil<DeviceLedgerExeclDto>(DeviceLedgerExeclDto.class); + List<DeviceLedgerExeclDto> userList = util.importExcel(file.getInputStream()); + userList.forEach(c -> { + DeviceLedger deviceLedger = new DeviceLedger(); + SysUser sysUser = sysUserMapper.selectUserByUserName(c.getCreateUser()); + if (sysUser!=null) { + deviceLedger.setCreateUser(sysUser.getUserId().intValue()); + }else { + deviceLedger.setCreateUser(SecurityUtils.getUserId().intValue()); + } + BeanUtils.copyProperties(c,deviceLedger); + deviceLedgerMapper.insert(deviceLedger); + }); + + return true; + } } -- Gitblit v1.9.3