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 JT808.Data.Safety;

/// <summary>TPMS报警。胎压监测报警</summary>
[Serializable]
[DataObject]
[Description("TPMS报警。胎压监测报警")]
[BindIndex("IX_TPMSAlarm_DeviceId_AlarmTime", false, "DeviceId,AlarmTime")]
[BindTable("TPMSAlarm", Description = "TPMS报警。胎压监测报警", ConnName = "Safety", DbType = DatabaseType.None)]
public partial class TPMSAlarm : ITPMSAlarm, IEntity<ITPMSAlarm>
{
    #region 属性
    private Int64 _Id;
    /// <summary>编号</summary>
    [DisplayName("编号")]
    [Description("编号")]
    [DataObjectField(true, false, false, 0)]
    [BindColumn("Id", "编号", "", DataScale = "time")]
    public Int64 Id { get => _Id; set { if (OnPropertyChanging("Id", value)) { _Id = value; OnPropertyChanged("Id"); } } }

    private Int32 _DeviceId;
    /// <summary>设备编号</summary>
    [DisplayName("设备编号")]
    [Description("设备编号")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("DeviceId", "设备编号", "")]
    public Int32 DeviceId { get => _DeviceId; set { if (OnPropertyChanging("DeviceId", value)) { _DeviceId = value; OnPropertyChanged("DeviceId"); } } }

    private String? _Mobile;
    /// <summary>手机号</summary>
    [DisplayName("手机号")]
    [Description("手机号")]
    [DataObjectField(false, false, true, 20)]
    [BindColumn("Mobile", "手机号", "")]
    public String? Mobile { get => _Mobile; set { if (OnPropertyChanging("Mobile", value)) { _Mobile = value; OnPropertyChanged("Mobile"); } } }

    private Int64 _EventId;
    /// <summary>报警事件编号</summary>
    [DisplayName("报警事件编号")]
    [Description("报警事件编号")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("EventId", "报警事件编号", "")]
    public Int64 EventId { get => _EventId; set { if (OnPropertyChanging("EventId", value)) { _EventId = value; OnPropertyChanged("EventId"); } } }

    private Int32 _AlarmType;
    /// <summary>报警类型。1-胎压低 2-胎压高 3-胎温高 4-漏气</summary>
    [DisplayName("报警类型")]
    [Description("报警类型。1-胎压低 2-胎压高 3-胎温高 4-漏气")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("AlarmType", "报警类型。1-胎压低 2-胎压高 3-胎温高 4-漏气", "")]
    public Int32 AlarmType { get => _AlarmType; set { if (OnPropertyChanging("AlarmType", value)) { _AlarmType = value; OnPropertyChanged("AlarmType"); } } }

    private Int32 _Level;
    /// <summary>报警级别</summary>
    [DisplayName("报警级别")]
    [Description("报警级别")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("Level", "报警级别", "")]
    public Int32 Level { get => _Level; set { if (OnPropertyChanging("Level", value)) { _Level = value; OnPropertyChanged("Level"); } } }

    private Int32 _TireNo;
    /// <summary>轮胎编号</summary>
    [DisplayName("轮胎编号")]
    [Description("轮胎编号")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("TireNo", "轮胎编号", "")]
    public Int32 TireNo { get => _TireNo; set { if (OnPropertyChanging("TireNo", value)) { _TireNo = value; OnPropertyChanged("TireNo"); } } }

    private Double _Pressure;
    /// <summary>胎压(Pa)</summary>
    [DisplayName("胎压(Pa)")]
    [Description("胎压(Pa)")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("Pressure", "胎压(Pa)", "")]
    public Double Pressure { get => _Pressure; set { if (OnPropertyChanging("Pressure", value)) { _Pressure = value; OnPropertyChanged("Pressure"); } } }

    private Int16 _Temperature;
    /// <summary>温度(℃)</summary>
    [DisplayName("温度(℃)")]
    [Description("温度(℃)")]
    [DataObjectField(false, false, false, 0)]
    [BindColumn("Temperature", "温度(℃)", "")]
    public Int16 Temperature { get => _Temperature; set { if (OnPropertyChanging("Temperature", value)) { _Temperature = value; OnPropertyChanged("Temperature"); } } }

    private DateTime _AlarmTime;
    /// <summary>报警时间</summary>
    [DisplayName("报警时间")]
    [Description("报警时间")]
    [DataObjectField(false, false, true, 0)]
    [BindColumn("AlarmTime", "报警时间", "")]
    public DateTime AlarmTime { get => _AlarmTime; set { if (OnPropertyChanging("AlarmTime", value)) { _AlarmTime = value; OnPropertyChanged("AlarmTime"); } } }

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

    #region 拷贝
    /// <summary>拷贝模型对象</summary>
    /// <param name="model">模型</param>
    public void Copy(ITPMSAlarm model)
    {
        Id = model.Id;
        DeviceId = model.DeviceId;
        Mobile = model.Mobile;
        EventId = model.EventId;
        AlarmType = model.AlarmType;
        Level = model.Level;
        TireNo = model.TireNo;
        Pressure = model.Pressure;
        Temperature = model.Temperature;
        AlarmTime = model.AlarmTime;
        CreateTime = model.CreateTime;
    }
    #endregion

    #region 获取/设置 字段值
    /// <summary>获取/设置 字段值</summary>
    /// <param name="name">字段名</param>
    /// <returns></returns>
    public override Object? this[String name]
    {
        get => name switch
        {
            "Id" => _Id,
            "DeviceId" => _DeviceId,
            "Mobile" => _Mobile,
            "EventId" => _EventId,
            "AlarmType" => _AlarmType,
            "Level" => _Level,
            "TireNo" => _TireNo,
            "Pressure" => _Pressure,
            "Temperature" => _Temperature,
            "AlarmTime" => _AlarmTime,
            "CreateTime" => _CreateTime,
            _ => base[name]
        };
        set
        {
            switch (name)
            {
                case "Id": _Id = value.ToLong(); break;
                case "DeviceId": _DeviceId = value.ToInt(); break;
                case "Mobile": _Mobile = Convert.ToString(value); break;
                case "EventId": _EventId = value.ToLong(); break;
                case "AlarmType": _AlarmType = value.ToInt(); break;
                case "Level": _Level = value.ToInt(); break;
                case "TireNo": _TireNo = value.ToInt(); break;
                case "Pressure": _Pressure = value.ToDouble(); break;
                case "Temperature": _Temperature = Convert.ToInt16(value); break;
                case "AlarmTime": _AlarmTime = value.ToDateTime(); break;
                case "CreateTime": _CreateTime = value.ToDateTime(); break;
                default: base[name] = value; break;
            }
        }
    }
    #endregion

    #region 关联映射
    #endregion

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

        return Find(_.Id == id);
    }
    #endregion

    #region 高级查询
    /// <summary>高级查询</summary>
    /// <param name="deviceId">设备编号</param>
    /// <param name="alarmTime">报警时间</param>
    /// <param name="start">编号开始</param>
    /// <param name="end">编号结束</param>
    /// <param name="key">关键字</param>
    /// <param name="page">分页参数信息。可携带统计和数据权限扩展查询等信息</param>
    /// <returns>实体列表</returns>
    public static IList<TPMSAlarm> Search(Int32 deviceId, DateTime alarmTime, DateTime start, DateTime end, String key, PageParameter page)
    {
        var exp = new WhereExpression();

        if (deviceId >= 0) exp &= _.DeviceId == deviceId;
        exp &= _.Id.Between(start, end, Meta.Factory.Snow);
        if (!key.IsNullOrEmpty()) exp &= SearchWhereByKeys(key);

        return FindAll(exp, page);
    }
    #endregion

    #region 数据清理
    /// <summary>清理指定时间段内的数据</summary>
    /// <param name="start">开始时间。未指定时清理小于指定时间的所有数据</param>
    /// <param name="end">结束时间</param>
    /// <param name="maximumRows">最大删除行数。清理历史数据时，避免一次性删除过多导致数据库IO跟不上，0表示所有</param>
    /// <returns>清理行数</returns>
    public static Int32 DeleteWith(DateTime start, DateTime end, Int32 maximumRows = 0)
    {
        return Delete(_.Id.Between(start, end, Meta.Factory.Snow), maximumRows);
    }
    #endregion

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

        /// <summary>设备编号</summary>
        public static readonly Field DeviceId = FindByName("DeviceId");

        /// <summary>手机号</summary>
        public static readonly Field Mobile = FindByName("Mobile");

        /// <summary>报警事件编号</summary>
        public static readonly Field EventId = FindByName("EventId");

        /// <summary>报警类型。1-胎压低 2-胎压高 3-胎温高 4-漏气</summary>
        public static readonly Field AlarmType = FindByName("AlarmType");

        /// <summary>报警级别</summary>
        public static readonly Field Level = FindByName("Level");

        /// <summary>轮胎编号</summary>
        public static readonly Field TireNo = FindByName("TireNo");

        /// <summary>胎压(Pa)</summary>
        public static readonly Field Pressure = FindByName("Pressure");

        /// <summary>温度(℃)</summary>
        public static readonly Field Temperature = FindByName("Temperature");

        /// <summary>报警时间</summary>
        public static readonly Field AlarmTime = FindByName("AlarmTime");

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

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

    /// <summary>取得TPMS报警字段名称的快捷方式</summary>
    public partial class __
    {
        /// <summary>编号</summary>
        public const String Id = "Id";

        /// <summary>设备编号</summary>
        public const String DeviceId = "DeviceId";

        /// <summary>手机号</summary>
        public const String Mobile = "Mobile";

        /// <summary>报警事件编号</summary>
        public const String EventId = "EventId";

        /// <summary>报警类型。1-胎压低 2-胎压高 3-胎温高 4-漏气</summary>
        public const String AlarmType = "AlarmType";

        /// <summary>报警级别</summary>
        public const String Level = "Level";

        /// <summary>轮胎编号</summary>
        public const String TireNo = "TireNo";

        /// <summary>胎压(Pa)</summary>
        public const String Pressure = "Pressure";

        /// <summary>温度(℃)</summary>
        public const String Temperature = "Temperature";

        /// <summary>报警时间</summary>
        public const String AlarmTime = "AlarmTime";

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