using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Runtime.Serialization;
using System.Web.Script.Serialization;
using System.Xml.Serialization;
using NewLife;
using NewLife.Data;
using XCode;
using XCode.Cache;
using XCode.Configuration;
using XCode.DataAccessLayer;

namespace Rainbow.Entity;

/// <summary>DHCP选项模板。定义DHCP选项集合，可被DeviceGroup引用</summary>
[Serializable]
[DataObject]
[Description("DHCP选项模板。定义DHCP选项集合，可被DeviceGroup引用")]
[BindIndex("IU_DhcpOptionProfile_Name", true, "Name")]
[BindIndex("IX_DhcpOptionProfile_UpdateTime", false, "UpdateTime")]
[BindTable("DhcpOptionProfile", Description = "DHCP选项模板。定义DHCP选项集合，可被DeviceGroup引用", ConnName = "Rainbow", DbType = DatabaseType.None)]
public partial class DhcpOptionProfile
{
    #region 属性
    private Int32 _Id;
    /// <summary>编号</summary>
    [DisplayName("编号")]
    [Description("编号")]
    [DataObjectField(true, true, false, 0)]
    [BindColumn("Id", "编号", "")]
    public Int32 Id { get => _Id; set { if (OnPropertyChanging("Id", value)) { _Id = value; OnPropertyChanged("Id"); } } }

    private String? _Name;
    /// <summary>名称</summary>
    [DisplayName("名称")]
    [Description("名称")]
    [DataObjectField(false, false, true, 50)]
    [BindColumn("Name", "名称", "", Master = true)]
    public String? Name { get => _Name; set { if (OnPropertyChanging("Name", value)) { _Name = value; OnPropertyChanged("Name"); } } }

    private String? _Description;
    /// <summary>描述</summary>
    [DisplayName("描述")]
    [Description("描述")]
    [DataObjectField(false, false, true, 200)]
    [BindColumn("Description", "描述", "")]
    public String? Description { get => _Description; set { if (OnPropertyChanging("Description", value)) { _Description = value; OnPropertyChanged("Description"); } } }

    private String? _Gateway;
    /// <summary>网关。DHCP Option 3</summary>
    [DisplayName("网关")]
    [Description("网关。DHCP Option 3")]
    [DataObjectField(false, false, true, 45)]
    [BindColumn("Gateway", "网关。DHCP Option 3", "")]
    public String? Gateway { get => _Gateway; set { if (OnPropertyChanging("Gateway", value)) { _Gateway = value; OnPropertyChanged("Gateway"); } } }

    private String? _DnsServers;
    /// <summary>DNS服务器。DHCP Option 6，逗号分隔</summary>
    [DisplayName("DNS服务器")]
    [Description("DNS服务器。DHCP Option 6，逗号分隔")]
    [DataObjectField(false, false, true, 500)]
    [BindColumn("DnsServers", "DNS服务器。DHCP Option 6，逗号分隔", "")]
    public String? DnsServers { get => _DnsServers; set { if (OnPropertyChanging("DnsServers", value)) { _DnsServers = value; OnPropertyChanged("DnsServers"); } } }

    private String? _DomainName;
    /// <summary>域名。DHCP Option 15</summary>
    [DisplayName("域名")]
    [Description("域名。DHCP Option 15")]
    [DataObjectField(false, false, true, 200)]
    [BindColumn("DomainName", "域名。DHCP Option 15", "")]
    public String? DomainName { get => _DomainName; set { if (OnPropertyChanging("DomainName", value)) { _DomainName = value; OnPropertyChanged("DomainName"); } } }

    private String? _NtpServer;
    /// <summary>NTP服务器。DHCP Option 42</summary>
    [DisplayName("NTP服务器")]
    [Description("NTP服务器。DHCP Option 42")]
    [DataObjectField(false, false, true, 200)]
    [BindColumn("NtpServer", "NTP服务器。DHCP Option 42", "")]
    public String? NtpServer { get => _NtpServer; set { if (OnPropertyChanging("NtpServer", value)) { _NtpServer = value; OnPropertyChanged("NtpServer"); } } }

    private Int32 _LeaseTime;
    /// <summary>租约时间。秒，默认86400</summary>
    [DisplayName("租约时间")]
    [Description("租约时间。秒，默认86400")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("LeaseTime", "租约时间。秒，默认86400", "")]
    public Int32 LeaseTime { get => _LeaseTime; set { if (OnPropertyChanging("LeaseTime", value)) { _LeaseTime = value; OnPropertyChanged("LeaseTime"); } } }

    private String? _TftpServer;
    /// <summary>TFTP服务器。DHCP Option 66</summary>
    [DisplayName("TFTP服务器")]
    [Description("TFTP服务器。DHCP Option 66")]
    [DataObjectField(false, false, true, 200)]
    [BindColumn("TftpServer", "TFTP服务器。DHCP Option 66", "")]
    public String? TftpServer { get => _TftpServer; set { if (OnPropertyChanging("TftpServer", value)) { _TftpServer = value; OnPropertyChanged("TftpServer"); } } }

    private String? _BootFile;
    /// <summary>启动文件。DHCP Option 67</summary>
    [DisplayName("启动文件")]
    [Description("启动文件。DHCP Option 67")]
    [DataObjectField(false, false, true, 200)]
    [BindColumn("BootFile", "启动文件。DHCP Option 67", "")]
    public String? BootFile { get => _BootFile; set { if (OnPropertyChanging("BootFile", value)) { _BootFile = value; OnPropertyChanged("BootFile"); } } }

    private Boolean _Enable;
    /// <summary>启用</summary>
    [DisplayName("启用")]
    [Description("启用")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("Enable", "启用", "")]
    public Boolean Enable { get => _Enable; set { if (OnPropertyChanging("Enable", value)) { _Enable = value; OnPropertyChanged("Enable"); } } }

    private Int32 _CreateUserId;
    /// <summary>创建用户</summary>
    [Category("扩展")]
    [DisplayName("创建用户")]
    [Description("创建用户")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("CreateUserId", "创建用户", "")]
    public Int32 CreateUserId { get => _CreateUserId; set { if (OnPropertyChanging("CreateUserId", value)) { _CreateUserId = value; OnPropertyChanged("CreateUserId"); } } }

    private String? _CreateIp;
    /// <summary>创建地址</summary>
    [Category("扩展")]
    [DisplayName("创建地址")]
    [Description("创建地址")]
    [DataObjectField(false, false, true, 50)]
    [BindColumn("CreateIp", "创建地址", "")]
    public String? CreateIp { get => _CreateIp; set { if (OnPropertyChanging("CreateIp", value)) { _CreateIp = value; OnPropertyChanged("CreateIp"); } } }

    private DateTime _CreateTime;
    /// <summary>创建时间</summary>
    [Category("扩展")]
    [DisplayName("创建时间")]
    [Description("创建时间")]
    [DataObjectField(false, false, true, 0)]
    [BindColumn("CreateTime", "创建时间", "")]
    public DateTime CreateTime { get => _CreateTime; set { if (OnPropertyChanging("CreateTime", value)) { _CreateTime = value; OnPropertyChanged("CreateTime"); } } }

    private Int32 _UpdateUserId;
    /// <summary>更新用户</summary>
    [Category("扩展")]
    [DisplayName("更新用户")]
    [Description("更新用户")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("UpdateUserId", "更新用户", "")]
    public Int32 UpdateUserId { get => _UpdateUserId; set { if (OnPropertyChanging("UpdateUserId", value)) { _UpdateUserId = value; OnPropertyChanged("UpdateUserId"); } } }

    private String? _UpdateIp;
    /// <summary>更新地址</summary>
    [Category("扩展")]
    [DisplayName("更新地址")]
    [Description("更新地址")]
    [DataObjectField(false, false, true, 50)]
    [BindColumn("UpdateIp", "更新地址", "")]
    public String? UpdateIp { get => _UpdateIp; set { if (OnPropertyChanging("UpdateIp", value)) { _UpdateIp = value; OnPropertyChanged("UpdateIp"); } } }

    private DateTime _UpdateTime;
    /// <summary>更新时间</summary>
    [Category("扩展")]
    [DisplayName("更新时间")]
    [Description("更新时间")]
    [DataObjectField(false, false, true, 0)]
    [BindColumn("UpdateTime", "更新时间", "")]
    public DateTime UpdateTime { get => _UpdateTime; set { if (OnPropertyChanging("UpdateTime", value)) { _UpdateTime = value; OnPropertyChanged("UpdateTime"); } } }

    private String? _Remark;
    /// <summary>备注</summary>
    [Category("扩展")]
    [DisplayName("备注")]
    [Description("备注")]
    [DataObjectField(false, false, true, 500)]
    [BindColumn("Remark", "备注", "")]
    public String? Remark { get => _Remark; set { if (OnPropertyChanging("Remark", value)) { _Remark = value; OnPropertyChanged("Remark"); } } }
    #endregion

    #region 获取/设置 字段值
    /// <summary>获取/设置 字段值</summary>
    /// <param name="name">字段名</param>
    /// <returns></returns>
    public override Object? this[String name]
    {
        get => name switch
        {
            "Id" => _Id,
            "Name" => _Name,
            "Description" => _Description,
            "Gateway" => _Gateway,
            "DnsServers" => _DnsServers,
            "DomainName" => _DomainName,
            "NtpServer" => _NtpServer,
            "LeaseTime" => _LeaseTime,
            "TftpServer" => _TftpServer,
            "BootFile" => _BootFile,
            "Enable" => _Enable,
            "CreateUserId" => _CreateUserId,
            "CreateIp" => _CreateIp,
            "CreateTime" => _CreateTime,
            "UpdateUserId" => _UpdateUserId,
            "UpdateIp" => _UpdateIp,
            "UpdateTime" => _UpdateTime,
            "Remark" => _Remark,
            _ => base[name]
        };
        set
        {
            switch (name)
            {
                case "Id": _Id = value.ToInt(); break;
                case "Name": _Name = Convert.ToString(value); break;
                case "Description": _Description = Convert.ToString(value); break;
                case "Gateway": _Gateway = Convert.ToString(value); break;
                case "DnsServers": _DnsServers = Convert.ToString(value); break;
                case "DomainName": _DomainName = Convert.ToString(value); break;
                case "NtpServer": _NtpServer = Convert.ToString(value); break;
                case "LeaseTime": _LeaseTime = value.ToInt(); break;
                case "TftpServer": _TftpServer = Convert.ToString(value); break;
                case "BootFile": _BootFile = Convert.ToString(value); break;
                case "Enable": _Enable = value.ToBoolean(); break;
                case "CreateUserId": _CreateUserId = value.ToInt(); break;
                case "CreateIp": _CreateIp = Convert.ToString(value); break;
                case "CreateTime": _CreateTime = value.ToDateTime(); break;
                case "UpdateUserId": _UpdateUserId = value.ToInt(); break;
                case "UpdateIp": _UpdateIp = Convert.ToString(value); break;
                case "UpdateTime": _UpdateTime = value.ToDateTime(); break;
                case "Remark": _Remark = Convert.ToString(value); break;
                default: base[name] = value; break;
            }
        }
    }
    #endregion

    #region 关联映射
    #endregion

    #region 扩展查询
    /// <summary>根据编号查找</summary>
    /// <param name="id">编号</param>
    /// <returns>实体对象</returns>
    public static DhcpOptionProfile? FindById(Int32 id)
    {
        if (id < 0) return null;

        // 实体缓存
        if (Meta.Session.Count < 1000) return Meta.Cache.Find(e => e.Id == id);

        // 单对象缓存
        return Meta.SingleCache[id];

        //return Find(_.Id == id);
    }

    /// <summary>根据名称查找</summary>
    /// <param name="name">名称</param>
    /// <returns>实体对象</returns>
    public static DhcpOptionProfile? FindByName(String? name)
    {
        if (name == null) return null;

        // 实体缓存
        if (Meta.Session.Count < 1000) return Meta.Cache.Find(e => e.Name.EqualIgnoreCase(name));

        // 单对象缓存
        return Meta.SingleCache.GetItemWithSlaveKey(name) as DhcpOptionProfile;

        //return Find(_.Name == name);
    }
    #endregion

    #region 高级查询
    /// <summary>高级查询</summary>
    /// <param name="enable">启用</param>
    /// <param name="start">更新时间开始</param>
    /// <param name="end">更新时间结束</param>
    /// <param name="key">关键字</param>
    /// <param name="page">分页参数信息。可携带统计和数据权限扩展查询等信息</param>
    /// <returns>实体列表</returns>
    public static IList<DhcpOptionProfile> Search(Boolean? enable, DateTime start, DateTime end, String key, PageParameter page)
    {
        var exp = new WhereExpression();

        if (enable != null) exp &= _.Enable == enable;
        exp &= _.UpdateTime.Between(start, end);
        if (!key.IsNullOrEmpty()) exp &= SearchWhereByKeys(key);

        return FindAll(exp, page);
    }
    #endregion

    #region 字段名
    /// <summary>取得DHCP选项模板字段信息的快捷方式</summary>
    public partial class _
    {
        /// <summary>编号</summary>
        public static readonly Field Id = FindByName("Id");

        /// <summary>名称</summary>
        public static readonly Field Name = FindByName("Name");

        /// <summary>描述</summary>
        public static readonly Field Description = FindByName("Description");

        /// <summary>网关。DHCP Option 3</summary>
        public static readonly Field Gateway = FindByName("Gateway");

        /// <summary>DNS服务器。DHCP Option 6，逗号分隔</summary>
        public static readonly Field DnsServers = FindByName("DnsServers");

        /// <summary>域名。DHCP Option 15</summary>
        public static readonly Field DomainName = FindByName("DomainName");

        /// <summary>NTP服务器。DHCP Option 42</summary>
        public static readonly Field NtpServer = FindByName("NtpServer");

        /// <summary>租约时间。秒，默认86400</summary>
        public static readonly Field LeaseTime = FindByName("LeaseTime");

        /// <summary>TFTP服务器。DHCP Option 66</summary>
        public static readonly Field TftpServer = FindByName("TftpServer");

        /// <summary>启动文件。DHCP Option 67</summary>
        public static readonly Field BootFile = FindByName("BootFile");

        /// <summary>启用</summary>
        public static readonly Field Enable = FindByName("Enable");

        /// <summary>创建用户</summary>
        public static readonly Field CreateUserId = FindByName("CreateUserId");

        /// <summary>创建地址</summary>
        public static readonly Field CreateIp = FindByName("CreateIp");

        /// <summary>创建时间</summary>
        public static readonly Field CreateTime = FindByName("CreateTime");

        /// <summary>更新用户</summary>
        public static readonly Field UpdateUserId = FindByName("UpdateUserId");

        /// <summary>更新地址</summary>
        public static readonly Field UpdateIp = FindByName("UpdateIp");

        /// <summary>更新时间</summary>
        public static readonly Field UpdateTime = FindByName("UpdateTime");

        /// <summary>备注</summary>
        public static readonly Field Remark = FindByName("Remark");

        static Field FindByName(String name) => Meta.Table.FindByName(name)!;
    }

    /// <summary>取得DHCP选项模板字段名称的快捷方式</summary>
    public partial class __
    {
        /// <summary>编号</summary>
        public const String Id = "Id";

        /// <summary>名称</summary>
        public const String Name = "Name";

        /// <summary>描述</summary>
        public const String Description = "Description";

        /// <summary>网关。DHCP Option 3</summary>
        public const String Gateway = "Gateway";

        /// <summary>DNS服务器。DHCP Option 6，逗号分隔</summary>
        public const String DnsServers = "DnsServers";

        /// <summary>域名。DHCP Option 15</summary>
        public const String DomainName = "DomainName";

        /// <summary>NTP服务器。DHCP Option 42</summary>
        public const String NtpServer = "NtpServer";

        /// <summary>租约时间。秒，默认86400</summary>
        public const String LeaseTime = "LeaseTime";

        /// <summary>TFTP服务器。DHCP Option 66</summary>
        public const String TftpServer = "TftpServer";

        /// <summary>启动文件。DHCP Option 67</summary>
        public const String BootFile = "BootFile";

        /// <summary>启用</summary>
        public const String Enable = "Enable";

        /// <summary>创建用户</summary>
        public const String CreateUserId = "CreateUserId";

        /// <summary>创建地址</summary>
        public const String CreateIp = "CreateIp";

        /// <summary>创建时间</summary>
        public const String CreateTime = "CreateTime";

        /// <summary>更新用户</summary>
        public const String UpdateUserId = "UpdateUserId";

        /// <summary>更新地址</summary>
        public const String UpdateIp = "UpdateIp";

        /// <summary>更新时间</summary>
        public const String UpdateTime = "UpdateTime";

        /// <summary>备注</summary>
        public const String Remark = "Remark";
    }
    #endregion
}