| | |
|---|
| | | |
|---|
| | | private void getPropertyWhiteListFlowDtos(Workbook workbook, List<PropertyWhiteListFlowDto> whiteLists) { |
|---|
| | | Sheet sheet = null; |
|---|
| | | sheet = ImportExcelUtils.getSheet(workbook, "白单流水 导入新模板"); |
|---|
| | | List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet); |
|---|
| | | List<Object[]> oList; |
|---|
| | | try { |
|---|
| | | sheet = ImportExcelUtils.getSheet(workbook, "白单流水 导入新模板"); |
|---|
| | | oList = ImportExcelUtils.listFromSheet(sheet); |
|---|
| | | } catch (IllegalArgumentException e) { |
|---|
| | | sheet = ImportExcelUtils.getSheet(workbook, "Sheet1"); |
|---|
| | | oList = ImportExcelUtils.listFromSheet(sheet); |
|---|
| | | } |
|---|
| | | PropertyWhiteListFlowDto white = null; |
|---|
| | | List<Map<String, Object>> maps = BeanConvertUtil.beanCovertMapListC(communityInnerServiceSMOImpl.queryCommunitys(new CommunityDto())); |
|---|
| | | for (int osIndex = 0; osIndex < oList.size(); osIndex++) { |
|---|
| | |
|---|
| | | if (osIndex == 0) { // 第一行是 头部信息 直接跳过 |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | if (StringUtil.isNullOrNone(os[3])) { |
|---|
| | | if (os == null || os.length < 4 || StringUtil.isNullOrNone(os[3])) { |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | Assert.hasValue(os[3], (osIndex + 1) + "行收费日期不能为空"); |
|---|
