/// <summary>

        /// 数据库中与C#中的数据类型对照

        /// </summary>

        /// <param name="type"></param>

        /// <returns></returns>

        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;

        }