update portal_sys_dictionary set flag_= #{status} where id_ in #{valueList} update portal_sys_dictionary set TREE_ID_= #{treeId} where id_ in #{valueList} select s.NAME from sys_dictionary_detail s where s.DICTIONARY_ID = ( select id from sys_dictionary where del_flag =1 and flag=1 and code = #{code} and company_id = #{companyId} and KIND_ID = 1 ) and s.flag =1 and s.value = #{key} select de.* from portal_sys_dictionary de where de.flag_=1 and id_ in( select c.LOWER_DIC_ID_ from portal_sys_dictionary_cascade c where c.DETAIL_ID_ = #{detailId} )