update portal_sys_dictionary_detail set flag_= #{status} where id_ in #{valueList} select t.* from portal_sys_dictionary_detail t left join portal_sys_dictionary t1 on t.DICTIONARY_ID_=t1.ID_ where t1.CODE_ = #{code} and t1.TENANT_ID_ = #{tenantId} select t.* from portal_sys_dictionary_detail t left join portal_sys_dictionary t1 on t.DICTIONARY_ID_=t1.id where t1.flag_ = 1 and t.flag_ = 1 and t1.code_ = #{code} and t1.TENANT_ID_ = #{tenantId} and t1.KIND_ID_ = 1 select de.* from portal_sys_dictionary_detail de INNER JOIN portal_sys_dictionary d on d.ID_ = de.DICTIONARY_ID_ INNER JOIN portal_sys_dictionary_cascade c on c.LOWER_DETAIL_ID_ = de.id_ WHERE d.flag_=1 and de.flag_=1 and c.LOWER_DIC_ID_=#{dictLowerId} and c.DETAIL_ID_=#{detailId} select c.detail_id_ parentId,dic.name_ dictionaryName,dic.code_ dictionaryCode,d.* from portal_sys_dictionary_cascade c inner join portal_sys_dictionary dic on c.lower_dic_id_ = dic.id_ and dic.flag_='1' inner join portal_sys_dictionary_detail d on c.lower_detail_id_ = d.id_ and d.flag_='1' select de.id_, de.dictionary_id_, de.name_, de.value_, de.sn_ sequence,d.name_ dictionaryName,d.code_ dictionaryCode,d.sn_ dictionarySn from portal_sys_dictionary d left JOIN portal_sys_dictionary_detail de on d.ID_ = de.DICTIONARY_ID_ WHERE d.flag_=1 and de.flag_=1 order by d.sn_,de.sn_