findAllList
===
	select * from core_dict where del_flag = 0
	@if(!isEmpty(type)){
	    and  type = #type#
	@}
	ORDER BY type, sort DESC

findTypeList
===
    SELECT
       DISTINCT (type),type_name
    FROM core_dict
    WHERE del_flag = #delFlag#
    ORDER BY type


findNameByType
===
    SELECT
       name
    FROM core_dict
    WHERE value = #value# 
    limit 1    



findChildByParent
===
    SELECT
        *
    FROM core_dict
    WHERE
    parent = #id# and del_flag = 0 order by sort DESC


bathDelByValue
===
    update core_dict set del_flag =1 where value in ( #join(values)#)