| | |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | |
|---|
| | | standardRequest.setStandardName(standardRequest.getEquipmentName() + "点检标准"); |
|---|
| | | standardRequest.setStandardName(equipment.getEquipmentName() + "点检标准"); |
|---|
| | | standardRequest.setMaintenanceCategory(MaintenanceCategoryEnum.POINT_INSPECTION.name()); |
|---|
| | | standardRequest.setEquipmentId(equipment.getId()); |
|---|
| | | |
|---|
| | |
|---|
| | | throw new JeecgBootException("Excel【" + file.getOriginalFilename() + "】第二行第一列获取到的设备编号为空！"); |
|---|
| | | } |
|---|
| | | request.setFileCode(fileCodeValue.trim()); |
|---|
| | | // if(CellType.NUMERIC.equals(equipmentCode.getCellType())) { |
|---|
| | | // request.setEquipmentCode(String.valueOf((int) equipmentCode.getNumericCellValue())); |
|---|
| | | // }else if(CellType.STRING.equals(equipmentCode.getCellType())) { |
|---|
| | | // request.setEquipmentCode(equipmentCode.getStringCellValue()); |
|---|
| | | // } |
|---|
| | | String equipmentCodeStr = extractEquipmentCode(equipmentCode); |
|---|
| | | if (StringUtils.isBlank(equipmentCodeStr)) { |
|---|
| | | throw new JeecgBootException("Excel【 " + file.getOriginalFilename() + "】没有读取到有效的设备编号，导入失败！"); |
|---|
| | |
|---|
| | | } else { |
|---|
| | | request.setInitialDate(new Date()); |
|---|
| | | } |
|---|
| | | //设备名称 |
|---|
| | | // Cell equipmentName = row.getCell(13); |
|---|
| | | // request.setEquipmentName(equipmentName.getStringCellValue()); |
|---|
| | | |
|---|
| | | |
|---|
| | | row = sheet.getRow(4); |
|---|
| | | //保养周期 |
|---|
| | | Cell period = row.getCell(7); |
|---|
