/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Entity.SystemModels;

namespace WIDESEA_Entity.DomainModels
{
    [Table("Sys_Dictionary")]
    [Entity(TableCnName = "字典数据", DetailTable = new Type[] { typeof(Sys_DictionaryList) }, DetailTableCnName = "字典明细")]
    public class Sys_Dictionary : BaseEntity
    {
        /// <summary>
        ///字典ID
        /// </summary>
        [Key]
        [Display(Name = "字典ID")]
        [Column(TypeName = "int")]
        [Required(AllowEmptyStrings = false)]
        public int Dic_ID { get; set; }

        /// <summary>
        ///字典编号
        /// </summary>
        [Display(Name = "字典编号")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        [Editable(true)]
        [Required(AllowEmptyStrings = false)]
        public string DicNo { get; set; }

        /// <summary>
        ///字典名称
        /// </summary>
        [Display(Name = "字典名称")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        [Editable(true)]
        [Required(AllowEmptyStrings = false)]
        public string DicName { get; set; }

        /// <summary>
        ///父级ID
        /// </summary>
        [Display(Name = "父级ID")]
        [Column(TypeName = "int")]
        [Editable(true)]
        [Required(AllowEmptyStrings = false)]
        public int ParentId { get; set; }

        /// <summary>
        ///配置项
        /// </summary>
        [Display(Name = "配置项")]
        [MaxLength(10000)]
        [Column(TypeName = "nvarchar(10000)")]
        [Editable(true)]
        public string Config { get; set; }

        /// <summary>
        ///sql语句
        /// </summary>
        [Display(Name = "sql语句")]
        [MaxLength(10000)]
        [Column(TypeName = "nvarchar(10000)")]
        [Editable(true)]
        public string DbSql { get; set; }

        /// <summary>
        ///DBServer
        /// </summary>
        [Display(Name = "DBServer")]
        [MaxLength(10000)]
        [Column(TypeName = "nvarchar(10000)")]
        public string DBServer { get; set; }

        /// <summary>
        ///排序号
        /// </summary>
        [Display(Name = "排序号")]
        [Column(TypeName = "int")]
        [Editable(true)]
        public int? OrderNo { get; set; }

        /// <summary>
        ///备注
        /// </summary>
        [Display(Name = "备注")]
        [MaxLength(2000)]
        [Column(TypeName = "nvarchar(2000)")]
        [Editable(true)]
        public string Remark { get; set; }

        /// <summary>
        ///是否启用
        /// </summary>
        [Display(Name = "是否启用")]
        [Column(TypeName = "tinyint")]
        [Editable(true)]
        [Required(AllowEmptyStrings = false)]
        public byte Enable { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "CreateID")]
        [Column(TypeName = "int")]
        public int? CreateID { get; set; }

        /// <summary>
        ///创建人
        /// </summary>
        [Display(Name = "创建人")]
        [MaxLength(30)]
        [Column(TypeName = "nvarchar(30)")]
        public string Creator { get; set; }

        /// <summary>
        ///创建时间
        /// </summary>
        [Display(Name = "创建时间")]
        [Column(TypeName = "datetime")]
        [Editable(true)]
        public DateTime? CreateDate { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "ModifyID")]
        [Column(TypeName = "int")]
        public int? ModifyID { get; set; }

        /// <summary>
        ///修改人
        /// </summary>
        [Display(Name = "修改人")]
        [MaxLength(30)]
        [Column(TypeName = "nvarchar(30)")]
        public string Modifier { get; set; }

        /// <summary>
        ///修改时间
        /// </summary>
        [Display(Name = "修改时间")]
        [Column(TypeName = "datetime")]
        public DateTime? ModifyDate { get; set; }

        [Display(Name = "字典明细")]
        [ForeignKey("Dic_ID")]
        public List<Sys_DictionaryList> Sys_DictionaryList { get; set; }

        /// <summary>
        /// 系统类型
        /// </summary>
        [Editable(true)]
        public int systemType { get; set; } = 0;
    }
}