| src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml | ●●●●● patch | view | raw | blame | history |
src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
@@ -181,11 +181,12 @@ <!--根据街路巷编号查询街路巷门牌名称集合--> <select id="getDoorplateNameList" resultType="org.springblade.modules.doorplateAddress.vo.FuncNode"> select address_code as addressCode,doorplate_name as floor from jczz_doorplate_address select address_code as addressCode,concat(doorplate_num,sub_door_plate_no) as floor from jczz_doorplate_address where 1=1 and street_ru_code = #{code} and nei_code = #{name} and aoi_code is null order by doorplate_num,sub_door_plate_no </select> <select id="getDoorplateAddressDetail"