queryByCondition

select 
@pageTag(){
*
@}
FROM core_user_role t LEFT JOIN core_user u on t.USER_ID=u.ID WHERE 
1=1
and t.ROLE_ID='203'
 @if(!isEmpty(userId)){
    and  t.USER_ID= #userId#
@}
 @if(!isEmpty(name)){
    and  u.name= #name#
@}
@if(!isEmpty(userName)){
    and  u.code= #userName#
@}
@//数据权限，该sql语句功能点  
and #function("re.query")#

queryByConditionORG

select 
@pageTag(){
t.*
@}
from re_org t
LEFT JOIN core_org o on t.ORG_ID=o.ID  
where 1=1 
 @if(!isEmpty(userId)){
    and  t.USER_ID= #userId#
@}
@//数据权限，该sql语句功能点  
and #function("re.query")#

batchDelReOrgByIds

• 批量逻辑删除

  DELETE FROM re_org where ID in( #join(ids)#)