queryByCondition

select 
@pageTag(){
t.*
@}
from core_dict t
where del_flag=0  

@if(!isEmpty(value)){
    and  t.VALUE like #"%"+value+"%"#
@}
@if(!isEmpty(name)){
    and  t.NAME like #"%"+name+"%"#
@}
@if(!isEmpty(type)){
        and  t.type=#type#
    @}
@if(!isEmpty(typeName)){
    and  t.TYPE_NAME like #"%"+typeName+"%"#
@}
@if(!isEmpty(parent)){
    and  t.PARENT like #"%"+parent+"%"#
@}
@pageIgnoreTag(){
    order by id  desc
@}

batchDelCoreDictByIds

• 批量逻辑删除

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