| | |
| | | and t.detail_id= #{detailId} |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | and t.car_num like concat('%',#{carNum},'%') |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and t.car_type= #{carType} |
| | |
| | | and t.detail_id= #{detailId} |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | and t.car_num like concat('%',#{carNum},'%') |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and t.car_type= #{carType} |
| | |
| | | </foreach> |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | and t.car_num like concat('%',#{carNum},'%') |
| | | </if> |
| | | <if test="carType !=null and carType != ''"> |
| | | and cid.car_type= #{carType} |
| | |
| | | </foreach> |
| | | </if> |
| | | <if test="carNum !=null and carNum != ''"> |
| | | and t.car_num= #{carNum} |
| | | and t.car_num like concat('%',#{carNum},'%') |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | |
| | | |
| | | String startTime = excelDoubleToDate(os[4].toString()); |
| | | String endTime = excelDoubleToDate(os[6].toString()); |
| | | Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行开始时间格式错误 请填写YYYY-MM-DD 文本格式"); |
| | | Assert.isDate(endTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行结束时间格式错误 请填写YYYY-MM-DD 文本格式"); |
| | | Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行上期度数时间格式错误 请填写YYYY-MM-DD 文本格式"); |
| | | Assert.isDate(endTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行本期度数时间格式错误 请填写YYYY-MM-DD 文本格式"); |
| | | |
| | | |
| | | importRoomFee = new ImportExportMeterWaterDto(); |