| | |
| | | String[] fillColorArr = {"#e5e5e5", "#3498DB", "#F1C40F", "#E74C3C", "#2ECC71", "#006400"}; |
| | | String[] fontColorArr = {"#e5e5e5", "#3498DB", "#F1C40F", "#E74C3C", "#2ECC71", "#006400"}; |
| | | |
| | | public List<DjJdgzNetworkLevel3> getList(Long shipId, Long deptId, Long teamId, Long cabinId, String type, String name) { |
| | | List<DjJdgzNetworkLevel3> list = baseDao.getList(shipId, deptId, teamId, cabinId, type, name); |
| | | public List<DjJdgzNetworkLevel3> getList(Long shipId, Long deptId, Long teamId, Long cabinId, String type,Integer isealCabin, String name) { |
| | | List<DjJdgzNetworkLevel3> list = baseDao.getList(shipId, deptId, teamId, cabinId, type,isealCabin, name); |
| | | return list; |
| | | } |
| | | |
| | |
| | | Row row = sheet.getRow(j); |
| | | |
| | | String name = ImportUtil.getCellValue(row, 0, pattern); |
| | | String deptStr = ImportUtil.getCellValue(row, 1, pattern); |
| | | String teamGroupStr = ImportUtil.getCellValue(row, 2, pattern); |
| | | String cabinStr = ImportUtil.getCellValue(row, 3, pattern); |
| | | String typeStr = ImportUtil.getCellValue(row, 4, pattern); |
| | | String time1 = ImportUtil.getCellValue(row, 5, pattern); |
| | | String time2 = ImportUtil.getCellValue(row, 6, pattern); |
| | | String time3 = ImportUtil.getCellValue(row, 7, pattern); |
| | | String time4 = ImportUtil.getCellValue(row, 8, pattern); |
| | | String time5 = ImportUtil.getCellValue(row, 9, pattern); |
| | | String repairUnit = ImportUtil.getCellValue(row, 10, pattern); |
| | | String repairUnitDirector = ImportUtil.getCellValue(row, 11, pattern); |
| | | String repairUnitContact = ImportUtil.getCellValue(row, 12, pattern); |
| | | String generalRepairUnit = ImportUtil.getCellValue(row, 13, pattern); |
| | | String generalRepairUnitDirector = ImportUtil.getCellValue(row, 14, pattern); |
| | | String generalRepairUnitContact = ImportUtil.getCellValue(row, 15, pattern); |
| | | String isealCabinStr = ImportUtil.getCellValue(row, 1, pattern); |
| | | String deptStr = ImportUtil.getCellValue(row, 2, pattern); |
| | | String teamGroupStr = ImportUtil.getCellValue(row, 3, pattern); |
| | | String cabinStr = ImportUtil.getCellValue(row, 4, pattern); |
| | | String typeStr = ImportUtil.getCellValue(row, 5, pattern); |
| | | String time1 = ImportUtil.getCellValue(row, 6, pattern); |
| | | String time2 = ImportUtil.getCellValue(row, 7, pattern); |
| | | String time3 = ImportUtil.getCellValue(row, 8, pattern); |
| | | String time4 = ImportUtil.getCellValue(row, 9, pattern); |
| | | String time5 = ImportUtil.getCellValue(row, 10, pattern); |
| | | String repairUnit = ImportUtil.getCellValue(row, 11, pattern); |
| | | String repairUnitDirector = ImportUtil.getCellValue(row, 12, pattern); |
| | | String repairUnitContact = ImportUtil.getCellValue(row, 13, pattern); |
| | | String generalRepairUnit = ImportUtil.getCellValue(row, 14, pattern); |
| | | String generalRepairUnitDirector = ImportUtil.getCellValue(row, 15, pattern); |
| | | String generalRepairUnitContact = ImportUtil.getCellValue(row, 16, pattern); |
| | | |
| | | Integer isealCabin = 0; |
| | | if (isealCabinStr.equals("是")){ |
| | | isealCabin = 1; |
| | | } |
| | | |
| | | Long id = UUIDUtil.generateId(); |
| | | if (StringUtils.isEmpty(name)) { |
| | |
| | | data.setLevel1NetworkId(level1NetworkId); |
| | | data.setLevel2NetworkId(level2NetworkId); |
| | | data.setLevel2NodeId(level2NodeId); |
| | | data.setIsealCabin(isealCabin); |
| | | } |
| | | |
| | | if (StringUtils.isEmpty(deptStr)) { |