linwe
2024-07-15 8f5aeec641d916806553ef9772d55e17e93db150
src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
@@ -30,6 +30,7 @@
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;
@@ -38,6 +39,7 @@
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;
@@ -1225,4 +1227,28 @@
//         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;
   }
}