| | |
|---|
| | | import com.ruoyi.basic.mapper.CustomerMapper; |
|---|
| | | import com.ruoyi.basic.pojo.Customer; |
|---|
| | | import com.ruoyi.basic.service.ICustomerService; |
|---|
| | | import com.ruoyi.common.utils.DateUtils; |
|---|
| | | import com.ruoyi.common.utils.SecurityUtils; |
|---|
| | | import com.ruoyi.common.utils.StringUtils; |
|---|
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
|---|
| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public AjaxResult importData(MultipartFile file) { |
|---|
| | | String nickName = SecurityUtils.getLoginUser().getNickName(); |
|---|
| | | try { |
|---|
| | | ExcelUtil<Customer> util = new ExcelUtil<Customer>(Customer.class); |
|---|
| | | List<Customer> userList = util.importExcel(file.getInputStream()); |
|---|
| | | if(CollectionUtils.isEmpty(userList)){ |
|---|
| | | return AjaxResult.warn("模板错误或导入数据为空"); |
|---|
| | | } |
|---|
| | | for (Customer customer : userList) { |
|---|
| | | customer.setMaintenanceTime(DateUtils.getNowDate()); |
|---|
| | | customer.setMaintainer(nickName); |
|---|
| | | } |
|---|
| | | this.saveOrUpdateBatch(userList); |
|---|
| | | return AjaxResult.success(true); |
|---|
| | | }catch (Exception e){ |
|---|
