| | |
| | | importRoomFee.setStoreId(paramIn.getString("storeId")); |
| | | importRoomFee.setCommunityId(paramIn.getString("communityId")); |
| | | // importRoomFee.setFeeTypeCd(paramIn.getString("feeTypeCd")); |
| | | importRoomFee.setObjType(paramIn.getString("objType")); |
| | | } |
| | | return importRoomFees; |
| | | } |
| | |
| | | if (osIndex == 0) { // 第一行是 头部信息 直接跳过 |
| | | continue; |
| | | } |
| | | if (os[2] == null) { |
| | | continue; |
| | | if (os == null ||(os[0] == null && os[1] == null && os[2] == null)) { |
| | | break; |
| | | } |
| | | if ((StringUtil.isNullOrNone(os[0]) && StringUtil.isNullOrNone(os[1])) || (!StringUtil.isNullOrNone(os[0]) && !StringUtil.isNullOrNone(os[1]))) { |
| | | Assert.hasValue(os[2], (osIndex + 1) + "行请写入费用主体和车牌号其中一列"); |
| | | continue; |
| | | } |
| | | Assert.hasValue(os[2], (osIndex + 1) + "行费用类型不能为空"); |
| | | Assert.hasValue(os[3], (osIndex + 1) + "行费用项目不能为空"); |
| | | |
| | | String startTime = handleExcelDateString(os[4].toString()); |
| | | String endTime = handleExcelDateString(os[5].toString()); |
| | | Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行开始时间格式错误 请填写YYYY/MM/DD 文本格式"); |
| | |
| | | |
| | | importRoomFee = new ImportRoomFee(); |
| | | importRoomFee.setPayerObjName(os[0]==null?os[1].toString():os[0].toString()); |
| | | // importRoomFee.set |
| | | importRoomFee.setFeeTypeCd(os[2].toString()); |
| | | |
| | | importRoomFee.setFeeName(os[3].toString()); |
| | | importRoomFee.setObjType(os[0] == null ? "6666" : "3333"); |
| | | importRoomFee.setFeeTypeCd(os[2] == null ? null : os[2].toString()); |
| | | importRoomFee.setFeeName(os[3] == null ? null : os[3].toString()); |
| | | if(startTime != null){ |
| | | importRoomFee.setStartTime(startTime); |
| | | } |
| | | if(endTime != null){ |
| | | importRoomFee.setEndTime(endTime); |
| | | } |
| | | importRoomFee.setAmount(os[7].toString()); |
| | | if (os.length > 6){ |
| | | importRoomFee.setCreateTime(os[6] == null ? null : os[6].toString()); |
| | | importRoomFee.setAmount(os[7] == null ? null : os[7].toString()); |
| | | }else{ |
| | | importRoomFee.setCreateTime(null); |
| | | importRoomFee.setAmount("0"); |
| | | } |
| | | importRoomFees.add(importRoomFee); |
| | | } |
| | | } |