using Magicodes.ExporterAndImporter.Core;
using SqlSugar;
using WIDESEA_Core.DB.Models;
using WIDESEA_Core.Filter;
using WIDESEA_Core.Tenants;

namespace WIDESEA_Model.Models
{
    [MultiTenant]
    [Exporter(ExporterHeaderFilter = typeof(ExporterHeaderFilter))]
    [SugarTable("Sys_Dictionary", "字典数据")]
    public class Sys_Dictionary : BaseEntity
    {
        /// <summary>
        /// 字典ID
        /// </summary>
        [ExporterHeader(DisplayName = "字典ID")]
        [SugarColumn(IsIdentity = true, IsPrimaryKey = true, ColumnDescription = "字典ID")]
        public int DicId { get; set; }

        /// <summary>
        /// 配置项
        /// </summary>
        [ExporterHeader(DisplayName = "配置项")]
        [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "配置项")]
        public string Config { get; set; }

        /// <summary>
        /// 数据库服务
        /// </summary>
        [ExporterHeader(DisplayName = "数据库服务")]
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "数据库服务")]
        public string DBServer { get; set; }

        /// <summary>
        /// Sql语句
        /// </summary>
        [ExporterHeader(DisplayName = "Sql语句")]
        [SugarColumn(IsNullable = true, Length = 500, ColumnDescription = "Sql语句")]
        public string DBSql { get; set; }

        /// <summary>
        /// 字典名称
        /// </summary>
        [ExporterHeader(DisplayName = "字典名称")]
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "字典名称")]
        public string DicName { get; set; }

        /// <summary>
        /// 字典编号
        /// </summary>
        [ExporterHeader(DisplayName = "字典编号")]
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "字典编号")]
        public string DicNo { get; set; }

        /// <summary>
        /// 是否启用
        /// </summary>
        [ExporterHeader(DisplayName = "是否启用")]
        [SugarColumn(IsNullable = true, ColumnDescription = "是否启用")]
        public byte? Enable { get; set; }

        /// <summary>
        /// 排序号
        /// </summary>
        [ExporterHeader(DisplayName = "排序号")]
        [SugarColumn(IsNullable = true, ColumnDescription = "排序号")]
        public int? OrderNo { get; set; }

        /// <summary>
        /// 父级ID
        /// </summary>
        [ExporterHeader(DisplayName = "父级ID")]
        [SugarColumn(IsNullable = true, ColumnDescription = "父级ID")]
        public int ParentId { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [ExporterHeader(DisplayName = "备注")]
        [SugarColumn(IsNullable = true, Length = 2000, ColumnDescription = "备注")]
        public string Remark { get; set; }

        /// <summary>
        /// 系统类型
        /// </summary>
        [ExporterHeader(DisplayName = "系统类型")]
        [SugarColumn(IsNullable = false, ColumnDescription = "系统类型")]
        public int SystemType { get; set; }

        [ExporterHeader(IsIgnore = true)]
        [Navigate(NavigateType.OneToMany, nameof(DicId),nameof(DicId)), SugarColumn(IsIgnore = true, IsNullable = true)]
        public List<Sys_DictionaryList> DicList { get; set; }
    }
}