java/zhihuishenqu.git

			@@ -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);
			}