src/main/java/com/ruoyi/basic/controller/CustomerController.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/ruoyi/basic/service/ICustomerService.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/ruoyi/basic/controller/CustomerController.java
@@ -61,7 +61,7 @@ @PostMapping("/importData") public AjaxResult importData(MultipartFile file) throws Exception { return success(customerService.importData(file)); return customerService.importData(file); } /** src/main/java/com/ruoyi/basic/service/ICustomerService.java
@@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.basic.pojo.Customer; import com.ruoyi.framework.web.domain.AjaxResult; import org.springframework.web.multipart.MultipartFile; import java.util.List; @@ -66,5 +67,5 @@ List<Customer> selectCustomerLists(Customer customer); Boolean importData(MultipartFile file); AjaxResult importData(MultipartFile file); } src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java
@@ -14,12 +14,14 @@ import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.framework.security.LoginUser; import com.ruoyi.framework.web.domain.AjaxResult; import com.ruoyi.project.system.domain.SysUser; import com.ruoyi.sales.mapper.SalesLedgerMapper; import com.ruoyi.sales.pojo.SalesLedger; import lombok.AllArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import org.springframework.web.multipart.MultipartFile; import java.util.Arrays; @@ -153,17 +155,20 @@ } @Override public Boolean importData(MultipartFile file) { public AjaxResult importData(MultipartFile file) { try { ExcelUtil<Customer> util = new ExcelUtil<Customer>(Customer.class); List<Customer> userList = util.importExcel(file.getInputStream()); if(CollectionUtils.isEmpty(userList)){ return AjaxResult.warn("模板错误或导入数据为空"); } this.saveOrUpdateBatch(userList); return true; return AjaxResult.success(true); }catch (Exception e){ e.printStackTrace(); return AjaxResult.error("导入失败"); } return false; } @Override