| | |
| | | import org.springblade.common.utils.NodeTreeUtil; |
| | | import org.springblade.common.utils.SpringUtils; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.core.tool.utils.BeanUtil; |
| | | import org.springblade.core.tool.utils.ObjectUtil; |
| | | import org.springblade.modules.category.dto.CategoryDTO; |
| | | import org.springblade.modules.category.service.ICategoryService; |
| | |
| | | import org.springblade.modules.district.entity.DistrictEntity; |
| | | import org.springblade.modules.district.service.IDistrictService; |
| | | import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity; |
| | | import org.springblade.modules.doorplateAddress.excel.ImportDoorplateExcel; |
| | | import org.springblade.modules.doorplateAddress.mapper.DoorplateAddressMapper; |
| | | import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService; |
| | | import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO; |
| | |
| | | // backblastPubRecord.setJwGridCode(policeAffairsGridEntity.getJwGridCode()); |
| | | // } |
| | | } |
| | | |
| | | @Override |
| | | public String importDoorplate(List<ImportDoorplateExcel> read) { |
| | | int i = 1; |
| | | for (ImportDoorplateExcel importDoorplateExcel : read) { |
| | | System.out.println("第-" + i + "-条记录"); |
| | | i++; |
| | | DoorplateAddressEntity copyDoorplateAddress = Objects.requireNonNull(BeanUtil.copy(importDoorplateExcel, DoorplateAddressEntity.class)); |
| | | DoorplateAddressEntity doorplateAddressEntity = baseMapper.selectOne(Wrappers.<DoorplateAddressEntity>lambdaQuery() |
| | | .eq(DoorplateAddressEntity::getAddressCode, importDoorplateExcel.getAddressCode())); |
| | | if (null == doorplateAddressEntity) { |
| | | baseMapper.insert(copyDoorplateAddress); |
| | | } else { |
| | | doorplateAddressEntity.setStreetRuCode(copyDoorplateAddress.getStreetRuCode()); |
| | | doorplateAddressEntity.setStreetRuName(copyDoorplateAddress.getStreetRuName()); |
| | | doorplateAddressEntity.setNeiName(copyDoorplateAddress.getNeiName()); |
| | | doorplateAddressEntity.setAoiCode(copyDoorplateAddress.getAoiCode()); |
| | | doorplateAddressEntity.setAoiName(copyDoorplateAddress.getAoiName()); |
| | | baseMapper.update(doorplateAddressEntity, Wrappers.<DoorplateAddressEntity>lambdaQuery() |
| | | .eq(DoorplateAddressEntity::getAddressCode, importDoorplateExcel.getAddressCode())); |
| | | } |
| | | } |
| | | return null; |
| | | } |
| | | } |