〖/// /// /// 数据库中与C#中的数据类型对照 /// /// /// private string ChangeToCSharpType(string type) { string reval=string.Empty; switch(type.ToLower()) { case "int": reval= "Int32"; break; case "text": reval= "String"; break; case "bigint": reval= "Int64"; break; case "binary": reval= "System.Byte[]"; break; case "bit": reval= "Boolean"; break; case "char": reval= "String"; break; case "datetime": reval= "System.DateTime"; break; case "decimal": reval= "System.Decimal"; break; case "float": reval= "System.Double"; break; case "image": reval= "System.Byte[]"; break; case "money": reval= "System.Decimal"; break; case "nchar": reval= "String"; break; case "ntext": reval= "String"; break; case "numeric": reval= "System.Decimal"; break; case "nvarchar": reval= "String"; break; case "real": reval= "System.Single"; break; case "smalldatetime": reval= "System.DateTime"; break; case "smallint": reval= "Int16"; break; case "smallmoney": reval= "System.Decimal"; break; case "timestamp": reval= "System.DateTime"; break; case "tinyint": reval= "System.Byte"; break; case "uniqueidentifier": reval= "System.Guid"; break; case "varbinary": reval= "System.Byte[]"; break; case "varchar": reval= "String"; break; case "Variant": reval="Object"; break; default: reval= "String"; break; } return reval; } |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 23:30 , Processed in 0.130626 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.