U9枚举值集sql

枚举：

select trl.Name,t.* from MO_CompleteRptDocType t
inner join UBF_Sys_ExtEnumValue e on e.EValue=t.businessType
inner join UBF_Sys_ExtEnumType et on e.extenumtype=et.id and et.Code='UFIDA.U9.Base.Doc.BusinessTypeEnum'
inner join UBF_Sys_ExtEnumValue_trl trl on trl.id=e.ID and trl.SysMLFlag='zh-CN'

值集值：

select  A.[ID], A.[Code], A1.[Name], A.[DependantCode] from  Base_DefineValue as A  
inner join Base_ValueSetDef d on A.ValueSetDef=d.ID
left join [Base_DefineValue_Trl] as A1 on (A1.SysMlFlag = 'zh-CN') and (A.[ID] = A1.[ID]) 
where  d.Code = '529'