| | |
| | | import com.java110.utils.util.CommonUtil; |
| | | import com.java110.utils.util.ImportExcelUtils; |
| | | import com.java110.utils.util.StringUtil; |
| | | import com.java110.vo.ResultVo; |
| | | import org.apache.poi.ss.usermodel.Sheet; |
| | | import org.apache.poi.ss.usermodel.Workbook; |
| | | import org.slf4j.Logger; |
| | |
| | | |
| | | List<ImportOwnerRoomDto> tmpImportOwnerRoomDtos = new ArrayList<>(); |
| | | int flag = 0; |
| | | |
| | | int successCount = 0; |
| | | try { |
| | | for (int roomIndex = 0; roomIndex < ownerRoomDtos.size(); roomIndex++) { |
| | | tmpImportOwnerRoomDtos.add(ownerRoomDtos.get(roomIndex)); |
| | |
| | | throw new IllegalArgumentException("保存失败"); |
| | | } |
| | | tmpImportOwnerRoomDtos = new ArrayList<>(); |
| | | |
| | | successCount += flag; |
| | | } |
| | | } |
| | | |
| | |
| | | if (flag < 1) { |
| | | throw new IllegalArgumentException("保存失败"); |
| | | } |
| | | successCount += flag; |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error("导入失败", e); |
| | |
| | | throw e; |
| | | } |
| | | |
| | | return responseEntity; |
| | | return ResultVo.createResponseEntity("总共导入:" + ownerRoomDtos.size() + ";成功导入:" + successCount + ";导入失败:" + (ownerRoomDtos.size() - successCount)); |
| | | } |
| | | |
| | | //解析Excel日期格式 |