--得到下拉框的文本
go
create function GetStringMapValue
(
@entityName varchar(100),
@attributeName varchar(100),
@attributeValue int
)
returns varchar(100)
as
begin
declare @code int
select @code = objecttypecode from MetadataSchema.Entity where Name = @entityName
declare @valueText varchar(100)
select @valueText = Value
from StringMap where AttributeName = @attributeName and AttributeValue = @attributeValue
and ObjectTypeCode = @code
return @valueText
end
go
create function GetStringMapValue
(
@entityName varchar(100),
@attributeName varchar(100),
@attributeValue int
)
returns varchar(100)
as
begin
declare @code int
select @code = objecttypecode from MetadataSchema.Entity where Name = @entityName
declare @valueText varchar(100)
select @valueText = Value
from StringMap where AttributeName = @attributeName and AttributeValue = @attributeValue
and ObjectTypeCode = @code
return @valueText
end