U9查询值集值和枚举值sql

值集值查询

SELECT Base_DefineValue_Trl.Name FROM Base_DefineValue  --值集值
LEFT JOIN Base_DefineValue_Trl ON Base_DefineValue.ID = Base_DefineValue_Trl.ID AND Base_DefineValue_Trl.SysMLFlag = 'zh-CN' --值集值Trl
LEFT JOIN Base_ValueSetDef ON Base_ValueSetDef.ID = Base_DefineValue.ValueSetDef  --值集
WHERE Base_ValueSetDef.Code = 'zfbz' AND Base_DefineValue.Code = 'N'

枚举值查询

SELECT UBF_Sys_ExtEnumValue.Code,* FROM UBF_Sys_ExtEnumType
LEFT JOIN UBF_Sys_ExtEnumValue ON UBF_Sys_ExtEnumValue.ExtEnumType = UBF_Sys_ExtEnumType.ID
LEFT JOIN UBF_Sys_ExtEnumValue_Trl ON UBF_Sys_ExtEnumValue_Trl.ID = UBF_Sys_ExtEnumValue.ID
WHERE UBF_Sys_ExtEnumType.Code = 'QR.ZHXY.CGHTBE.MonthEnum'