| | |
|---|
| | | @Param(value = "villageId") Long villageId); |
|---|
| | | |
|---|
| | | @Select("<script> " |
|---|
| | | + "select id as houseId,cmv.alley,cmv.house_num from com_mng_population_house as cmph left join com_mng_village as cmv on cmv.village_id = cmph.village_id where cmph.community_id = ${communityId}" |
|---|
| | | + "select id as houseId,cmv.alley,cmv.house_num,cmv.name from com_mng_population_house as cmph left join com_mng_village as cmv on cmv.village_id = cmph.village_id where cmph.community_id = ${communityId}" |
|---|
| | | + "<if test='name != null and name != ""'>" + "and cmv.alley = #{name}" + " </if> " |
|---|
| | | + "<if test='villageId != null'>" + "and cmv.village_id = #{villageId}" + " </if> " + " </script>") |
|---|
| | | List<ComMngCascadeHouseVO> getHouseLevelByHouseNum(@Param("name") String name, |
|---|
