Feedeem.Coding 17.11.1

/************************************************************ From: http://www.feedeem.com/
Create Date: 20110823
************************************************************/

using System; using System.Data; using System.Linq;

namespace Feedeem.Coding { /// <summary> /// Database Table's Column. /// </summary> [Serializable] public class Column { // sql data types extracted from sql server: SELECT * FROM systypes private string[] dbTypes;

    /// <summary>
    /// 列名
    /// </summary>
    public string ColumnName { get; set; }

    /// <summary>
    /// 原始列名（在数据库定义）
    /// </summary>
    public string ColumnNameOriginal { get; set; }

    /// <summary>
    /// 列名（中文）
    /// </summary>
    public string ColumnNameCN { get; set; }

    /// <summary>
    /// 是否为键（主键或外键）
    /// </summary>
    public bool IsKey
    {
        get;
        set;
    }

    /// <summary>
    /// 是否为主键
    /// </summary>
    public bool IsPrimaryKey { get; set; }

    /// <summary>
    /// 是否为外键
    /// </summary>
    public bool IsForeignKey
    {
        get
        {
            return this.IsKey && !this.IsPrimaryKey;
        }
    }

    /// <summary>
    /// 是否自增
    /// </summary>
    public bool IsIdentity { get; set; }

    /// <summary>
    /// 是否为计算列
    /// </summary>
    public bool IsComputed { get; set; }

    /// <summary>
    /// 数据库数据类型
    /// </summary>
    public string DbType { get; set; }

    /// <summary>
    /// 枚举类型SqlDbType
    /// </summary>
    public string SqlDbType
    {
        get
        {
             dbTypes  = new string[]{"image","text","uniqueidentifier",
            "tinyint","smallint","int","smalldatetime",
            "real","money","datetime","float","sql_variant", /* no found */
            "ntext","bit","decimal","numeric", /* no found. */
            "smallmoney","bigint","varbinary","varchar","binary",
            "char","timestamp","nvarchar","nchar","xml",};
            
            var dbtype = this.DbType;

            if (this.DbType == "sql_variant")
            {
                dbtype = "variant";
            }
            else if (this.DbType == "numeric")
            {
                dbtype = "numeric";
            }
            else if(!dbTypes.Contains(this.DbType))
            {
                dbtype = "Udt";
            }

            return ((SqlDbType)Enum.Parse(typeof(SqlDbType), dbtype, true)).ToString();
        }
    }

    /// <summary>
    /// C#语言数据类型
    /// </summary>
    public string CsType { get; set; }

    /// <summary>
    /// Java语言数据类型
    /// </summary>
    public string JavaType { get; set; }

    /// <summary>
    /// 是否为可空
    /// </summary>
    public bool Nullable { get; set; }

    /// <summary>
    /// 允许存入的字符长度
    /// </summary>
    /// <example>1024,(max),(18,2)</example>
    public string Length { get; set; }

    /// <summary>
    /// Scale
    /// </summary>
    public string Scale { get; set; }

    /// <summary>
    /// 序号
    /// </summary>
    public int Order { get; set; }

    /// <summary>
    /// 列默认值
    /// </summary>
    public string DefaultValue { get; set; }

    /// <summary>
    /// 描述
    /// </summary>
    private string description;
    public string Description
    {
        get
        {
            if (string.IsNullOrWhiteSpace(description)) { return this.ColumnName; }
            return description;
        }
        set
        {
            description = value;
        }
    }
}

}