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#