queryByCondition

select 
@pageTag(){
t.*
@}
from xzx_sys_address_level_info t
where 1=1  
@//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
and #function("xzxSysAddressLevelInfo.query")#

batchDelXzxSysAddressLevelInfoByIds

• 批量逻辑删除

  update xzx_sys_address_level_info set del_flag = 1 where id in( #join(ids)#)

queryAllProvince

select level_1_id as code,level_1_name as value   
from xzx_sys_address_level_info where 1=1 group by level_1_id

queryAllCity

select level_2_id as code,
       level_2_name as value  
from xzx_sys_address_level_info where 1=1 and level_1_id=#pId# group by level_2_id

queryAllArea

select level_3_id as code,level_3_name as value  
from xzx_sys_address_level_info where 1=1 and  level_2_id=#cId#