From df654c8bbe24a659833d436a2e7e2013e3592142 Mon Sep 17 00:00:00 2001
From: manailin <261030956@qq.com>
Date: 星期三, 04 八月 2021 11:01:57 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/test' into test
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
index 88f44b0..5d8622b 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
@@ -11,7 +11,9 @@
import com.panzhihua.common.model.vos.grid.PopulationListVO;
import com.panzhihua.common.model.vos.grid.admin.ComMngSubordinateVO;
import com.panzhihua.common.model.vos.user.ComMngHouseVo;
+import com.panzhihua.service_community.model.dos.ComMngPopulationDO;
import com.panzhihua.service_community.model.dos.ComMngPopulationHouseDO;
+import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -254,4 +256,19 @@
@Select("select id as houseId,house_no from com_mng_population_house where village_id = #{villageId} and floor = #{floor} and unit_no = #{unitNo} order by create_at asc")
List<ComMngSubordinateVO> getHouseLevelByHouseNos(@Param("villageId") Long villageId,@Param("floor") String floor,@Param("unitNo") String unitNo);
+
+ @Insert("<script> " +
+ "insert into com_mng_population_house(`id`,`street_id`,`community_id`,`village_id`" +
+ ",`alley`,`house_num`,`unit_no`,`floor`,`house_no`,`code`,`address`,`status`" +
+ ",`purpose`,`control_status`,`is_empty`,`construct_purpose`,`construct_area`" +
+ ",`path`,`create_at`) values " +
+ "<foreach collection=\"houseList\" item=\"item\" index=\"index\" separator=\",\">\n" +
+ " (#{item.id},#{item.streetId},#{item.communityId},#{item.villageId}" +
+ ",#{item.alley},#{item.houseNum},#{item.unitNo},#{item.floor}" +
+ ",#{item.houseNo},#{item.code},#{item.address},#{item.status}" +
+ ",#{item.purpose},#{item.controlStatus},#{item.isEmpty},#{item.constructPurpose}" +
+ ",#{item.constructArea},#{item.path},now())" +
+ " </foreach>" +
+ " </script>")
+ void insertAll(@Param("houseList") List<ComMngPopulationHouseDO> houseList);
}
--
Gitblit v1.7.1