From 2a4d9802f9117d5d110e63ddaa41aada68731c4d Mon Sep 17 00:00:00 2001 From: liyong <18434998025@163.com> Date: 星期一, 16 六月 2025 17:08:51 +0800 Subject: [PATCH] tenantId修改类型 + 客户导入+ 供应商导入+产品导入 --- src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java | 25 +++++++++++++++++++++---- 1 files changed, 21 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java index afc1c30..07431ac 100644 --- a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java +++ b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java @@ -11,10 +11,13 @@ import com.ruoyi.basic.service.ICustomerService; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.framework.security.LoginUser; +import com.ruoyi.project.system.domain.SysUser; import lombok.AllArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; import java.util.Arrays; import java.util.List; @@ -98,8 +101,8 @@ @Override public int insertCustomer(Customer customer) { LoginUser loginUser = SecurityUtils.getLoginUser(); - Integer tenantId = loginUser.getTenantId(); - customer.setTenantId(Long.valueOf(tenantId)); + Long tenantId = loginUser.getTenantId(); + customer.setTenantId(tenantId); return customerMapper.insert(customer); } @@ -112,8 +115,8 @@ @Override public int updateCustomer(Customer customer) { LoginUser loginUser = SecurityUtils.getLoginUser(); - Integer tenantId = loginUser.getTenantId(); - customer.setTenantId(Long.valueOf(tenantId)); + Long tenantId = loginUser.getTenantId(); + customer.setTenantId(tenantId); return customerMapper.updateById(customer); } @@ -142,6 +145,20 @@ } @Override + public Boolean importData(MultipartFile file) { + try { + ExcelUtil<Customer> util = new ExcelUtil<Customer>(Customer.class); + List<Customer> userList = util.importExcel(file.getInputStream()); + + this.saveOrUpdateBatch(userList); + return true; + }catch (Exception e){ + e.printStackTrace(); + } + return false; + } + + @Override public List<Map<String, Object>> customerList(Customer customer) { LambdaQueryWrapper<Customer> queryWrapper = Wrappers.lambdaQuery(); queryWrapper.select(Customer::getId, Customer::getCustomerName, Customer::getTaxpayerIdentificationNumber); -- Gitblit v1.9.3