| | |
|---|
| | | if (null!=region){ |
|---|
| | | gridEntity.setCommunityCode(region.getCode()); |
|---|
| | | } |
|---|
| | | gridEntity.setGridName(split[1]); |
|---|
| | | gridEntity.setGeom(gridExcel.getGeom()); |
|---|
| | | gridEntity.setCreateUser(AuthUtil.getUserId()); |
|---|
| | | gridEntity.setCreateTime(new Date()); |
|---|
| | | gridEntity.setUpdateUser(AuthUtil.getUserId()); |
|---|
| | | gridEntity.setUpdateTime(new Date()); |
|---|
| | | list.add(gridEntity); |
|---|
| | | // 比对网格是否存在，如果已存在则更新，否则则新增 |
|---|
| | | QueryWrapper<GridEntity> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("is_deleted",0) |
|---|
| | | .eq("grid_name",split[1]) |
|---|
| | | .eq("community_code",region.getCode()); |
|---|
| | | GridEntity one = getOne(queryWrapper); |
|---|
| | | if (null!=one){ |
|---|
| | | one.setGridCode(gridExcel.getGridCode()); |
|---|
| | | one.setGridName(split[1]); |
|---|
| | | one.setGeom(gridExcel.getGeom()); |
|---|
| | | one.setUpdateUser(AuthUtil.getUserId()); |
|---|
| | | one.setUpdateTime(new Date()); |
|---|
| | | // 更新 |
|---|
| | | updateById(one); |
|---|
| | | }else { |
|---|
| | | // 设置网格数据 |
|---|
| | | gridEntity.setGridCode(gridExcel.getGridCode()); |
|---|
| | | gridEntity.setGridName(split[1]); |
|---|
| | | gridEntity.setGeom(gridExcel.getGeom()); |
|---|
| | | gridEntity.setCreateUser(AuthUtil.getUserId()); |
|---|
| | | gridEntity.setCreateTime(new Date()); |
|---|
| | | gridEntity.setUpdateUser(AuthUtil.getUserId()); |
|---|
| | | gridEntity.setUpdateTime(new Date()); |
|---|
| | | list.add(gridEntity); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // 批量导入 |
|---|
| | | saveBatch(list); |
|---|
