edit | blame | history | raw

queryByCondition

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

batchDelXzxPartnerBankByIds

  • 批量逻辑删除

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

queryByBankNo

select bank_no from xzx_partner_bank where bank_no=#bankNo#
 @if(isNotEmpty(id)){
                      AND id <>#id#
      @}

queryByBankList

select * from xzx_partner_bank where partner_id=#id# and del_flag=0

queryBankByAccount

select * from xzx_partner_bank where account_id=#accountNo#