queryByCondition

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

batchDelXzxUserRoleInfoByIds

• 批量逻辑删除
  update xzx_user_role_info set del_flag = 1 where id in( #join(ids)#)

updatePunchChannel
===
UPDATE xzx_sys_config_info SET config_value = #status# WHERE config_type_code= #configTypeCode#

queryPunchChannel
===
select config_value from xzx_sys_config_info WHERE config_type_code= 'CODE_SCAN_RK'

queryMaxAppRole

select a.* from xzx_user_role_info a where a.role_code = (select max(b.role_code) from xzx_user_role_info b)