VRSystem/EasyTemplate.Tool/Entity/App/WarningStatistics.cs

using SqlSugar;
using System;

namespace EasyTemplate.Tool.Entity.App
{
    /// <summary>
    /// 油枪预警告统计数据（35 天累计）
    /// </summary>
    [SugarTable("v_warning_statistics", "预警告统计视图")]
    public class WarningStatistics
    {
        /// <summary>
        /// 油枪 ID
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public int nozzle { get; set; }

        /// <summary>
        /// 统计日期
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public DateOnly statistics_date { get; set; }

        /// <summary>
        /// 累计加油笔数（最近 35 天，笔数>=5 的累计）
        /// </summary>
        public int total_count { get; set; }

        /// <summary>
        /// 累计超标数
        /// </summary>
        public int total_overproof { get; set; }

        /// <summary>
        /// 累计超标率（%）
        /// </summary>
        public int total_overproofrate { get; set; }

        /// <summary>
        /// 累计严重超标数（overproof_alert）
        /// </summary>
        public int total_overproof_alert { get; set; }

        /// <summary>
        /// 累计严重超标率（%）
        /// </summary>
        public int total_overproofrate_alert { get; set; }

        /// <summary>
        /// 累计二级超标数（overproof_2）
        /// </summary>
        public int total_overproof_2 { get; set; }

        /// <summary>
        /// 累计二级超标率（%）
        /// </summary>
        public int total_overproofrate_2 { get; set; }

        /// <summary>
        /// 当天加油笔数
        /// </summary>
        public int daily_total { get; set; }

        /// <summary>
        /// 当天超标数
        /// </summary>
        public int daily_overproof { get; set; }

        /// <summary>
        /// 当天超标率（%）
        /// </summary>
        public int daily_overproofrate { get; set; }

        /// <summary>
        /// 当天严重超标数
        /// </summary>
        public int daily_overproof_alert { get; set; }

        /// <summary>
        /// 当天严重超标率（%）
        /// </summary>
        public int daily_overproofrate_alert { get; set; }

        /// <summary>
        /// 当天二级超标数
        /// </summary>
        public int daily_overproof_2 { get; set; }

        /// <summary>
        /// 当天二级超标率（%）
        /// </summary>
        public int daily_overproofrate_2 { get; set; }

        /// <summary>
        /// 是否满足累计条件（最近连续天数总笔数>=5）
        /// </summary>
        public bool is_accumulated { get; set; }

        /// <summary>
        /// 累计天数
        /// </summary>
        public int accumulated_days { get; set; }

        /// <summary>
        /// 连续超标天数（普通超标）
        /// </summary>
        public int continue_days { get; set; }

        /// <summary>
        /// 连续超标天数（二级超标/广东中石化）
        /// </summary>
        public int continue_days_2 { get; set; }

        /// <summary>
        /// 连续超标天数（严重超标）
        /// </summary>
        public int continue_days_alert { get; set; }

        /// <summary>
        /// 最后累计超标率（用于显示）
        /// </summary>
        public int last_overproofrate { get; set; }

        /// <summary>
        /// 最后二级超标率（用于显示）
        /// </summary>
        public int last_overproofrate_2 { get; set; }

        /// <summary>
        /// 最后严重超标率（用于显示）
        /// </summary>
        public int last_overproofrate_alert { get; set; }
    }

    /// <summary>
    /// 预警告统计查询参数
    /// </summary>
    public class WarningStatisticsQuery
    {
        /// <summary>
        /// 油枪 ID（可选）
        /// </summary>
        public int? NozzleId { get; set; }

        /// <summary>
        /// 开始日期（可选）
        /// </summary>
        public DateOnly? StartDate { get; set; }

        /// <summary>
        /// 结束日期（可选）
        /// </summary>
        public DateOnly? EndDate { get; set; }

        /// <summary>
        /// 页码
        /// </summary>
        public int PageIndex { get; set; } = 1;

        /// <summary>
        /// 每页数量
        /// </summary>
        public int PageSize { get; set; } = 20;
    }
}