CH/Common/DBTypeMap.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace CH.Common
{
    /// <summary>
    /// 数据类型映射
    /// </summary>
    public class DBTypeMap
    {
        /// <summary>
        /// 映射数据类型
        /// </summary>
        /// <param name="typeName"></param>
        /// <param name="isNullable"></param>
        /// <returns></returns>
        public static string GetTypeNameByDBType(string typeName, string isNullable)
        {
            string result = "";
            switch (typeName)
            {
                case "bit":
                    result = string.Format("bool{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "tinyint":
                    result = string.Format("byte{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "smallint":
                    result = string.Format("short{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "int":
                    result = string.Format("int{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "bigint":
                    result = string.Format("long{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "numeric":
                case "decimal":
                case "smallmoney":
                case "money":
                    result = string.Format("decimal{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "float": 
                    result = string.Format("double{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "real":
                    result = string.Format("Single{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "datetime":
                case "smalldatetime":
                case "date":
                case "time":
                case "datetimeoffset":
                case "datetime2":
                    result = string.Format("DateTime{0}", isNullable.Equals("Y") ? "?" : "");
                    break;
                case "char":
                case "varchar":