re.md

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)#)