水电话费

jialh

1 天以前 dd6687b118561100e1677e88a9c2f5842a54c531

 service-api/src/main/java/com/java110/api/importData/adapt/ImportReportMainDataV2CleaningAdapt.java

@@ -4,6 +4,7 @@
import com.java110.api.importData.DefaultImportDataAdapt;
import com.java110.api.importData.IImportDataCleaningAdapt;
import com.java110.dto.importData.ImportOwnerRoomDto;
import com.java110.dto.importData.Vtil;
import com.java110.dto.system.ComponentValidateResult;
import com.java110.utils.util.ImportExcelUtils;
import org.apache.poi.ss.usermodel.Sheet;
@@ -40,15 +41,23 @@
     */
    private void getOwnerRooms(Workbook workbook, List<Object[]> ownerRoomDtos, ComponentValidateResult result) throws ParseException {
        Sheet sheet = null;
        sheet = ImportExcelUtils.getSheet(workbook, "荣顺苑签报单");
        String sheetName = "荣顺苑签报单";
        sheet = ImportExcelUtils.getSheet(workbook, sheetName);
        List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);
        ImportOwnerRoomDto importOwnerRoomDto = null;
        for (int osIndex = 0; osIndex < oList.size(); osIndex++) {
            if (osIndex < 5) {
            if (osIndex < 2) {
                continue;
            }
            Object[] os = oList.get(osIndex);

            try {
                if (Vtil.defaultValue(os[2]) == null) {
                    continue;
                }
            }catch (Exception e){
                continue;
            }
            ownerRoomDtos.add(os);

        }