| | |
| | | Set<String> fileKeys = new HashSet<>(); |
| | | for (int i = 0; i < rows.size(); i++) { |
| | | String managementNumber = required(rows.get(i).getManagementNumber(), i + 2, "管理编号"); |
| | | String deviceName = required(rows.get(i).getDeviceName(), i + 2, "仪器名称"); |
| | | String deviceName = required(rows.get(i).getDeviceName(), i + 2, "设备名称"); |
| | | String specificationModel = required(rows.get(i).getSpecificationModel(), i + 2, "规格型号"); |
| | | if (!fileKeys.add(deviceKey(deviceName, specificationModel, managementNumber))) { |
| | | throw new RuntimeException("第" + (i + 2) + "行:仪器名称+规格型号+管理编号在文件中重复"); |
| | | throw new RuntimeException("第" + (i + 2) + "行:设备名称+规格型号+管理编号在文件中重复"); |
| | | } |
| | | } |
| | | Set<String> existingKeys = baseMapper.selectList(Wrappers.<Device>lambdaQuery() |
| | |
| | | int rowNumber = i + 2; |
| | | DeviceImport row = rows.get(i); |
| | | String managementNumber = required(row.getManagementNumber(), rowNumber, "管理编号"); |
| | | String deviceName = required(row.getDeviceName(), rowNumber, "仪器名称"); |
| | | String deviceName = required(row.getDeviceName(), rowNumber, "设备名称"); |
| | | String specificationModel = required(row.getSpecificationModel(), rowNumber, "规格型号"); |
| | | if (existingKeys.contains(deviceKey(deviceName, specificationModel, managementNumber))) { |
| | | throw new RuntimeException("第" + rowNumber + "行:仪器名称“" + deviceName + "”+规格型号“" + specificationModel + "”+管理编号“" + managementNumber + "”已存在"); |
| | | throw new RuntimeException("第" + rowNumber + "行:设备名称“" + deviceName + "”+规格型号“" + specificationModel + "”+管理编号“" + managementNumber + "”已存在"); |
| | | } |
| | | |
| | | Device device = new Device(); |