MSSQL根据数据库字段类型判断存储过程参数类型

<script runat="template">

public string GetAllDbType(ColumnSchema column)
{
string re="";

switch (column.NativeType.ToString().ToLower())
{
case "bigint":re="BigInt";break;
case "binary":re="Binary";break;
case "varbinary":re="VarBinary";break;
case "char":re="Char";break;
case "carchar":re="VarChar";break;
case "nchar":re="NChar";break;
case "nvarchar":re="NVarChar";break;
case "varchar":re="VarChar";break;
case "datetime":re="DateTime";break;
case "smalldatetime":re="SmallDateTime";break;
case "decimal":re="Decimal";break;
case "numeric":re="Numeric";break;
case "float":re="Float";break;
case "real":re="Real";break;
case "int":re="Int";break;
case "smallint":re="SmallInt";break;
case "tinyint":re="TinyInt";break;
case "money":re="Money";break;
case "smallmoney":re="SmallMoney";break;
case "bit":re="Bit";break;
case "timestamp":re="Timestamp";break;
case "uniqueidentifier":re="UniqueIdentifier";break;
case "text":re="Text";break;
case "image":re="Image";break;
case "ntext":re="NText";break;
}

if (column.Size > 0&&column.NativeType.ToString().ToLower()!="ntext"&&column.NativeType.ToString().ToLower()!="text")
{
re+=","+column.Size;
}
//re=column.NativeType.ToLower();
return re;
}

</script>