using SqlSugar;

namespace PadApplication.Entites.DbModels;

/// <summary>
/// 设备点检主表
/// </summary>
[SugarTable("MES_EquipmentInspection")]
public class MesEquipmentInspection
{
    /// <summary>
    /// 点检记录ID，自增主键
    /// </summary>
    [SugarColumn(ColumnName = "InspectionId", IsPrimaryKey = true, IsIdentity = true)]
    public long InspectionId { get; set; }

    /// <summary>
    /// 机台编号（如：01, 02, 03）
    /// </summary>
    [SugarColumn(ColumnName = "MachineNo")]
    public string MachineNo { get; set; }

    /// <summary>
    /// 点检年份（如：2025）
    /// </summary>
    [SugarColumn(ColumnName = "InspectionYear")]
    public int InspectionYear { get; set; }

    /// <summary>
    /// 点检月份（1-12）
    /// </summary>
    [SugarColumn(ColumnName = "InspectionMonth")]
    public int InspectionMonth { get; set; }

    /// <summary>
    /// 点检年月（冗余字段，格式：yyyy-MM，如：2025-11）
    /// </summary>
    [SugarColumn(ColumnName = "InspectionDate")]
    public string InspectionDate { get; set; }

    /// <summary>
    /// 创建人账号
    /// </summary>
    [SugarColumn(ColumnName = "CreatedBy")]
    public string? CreatedBy { get; set; }

    /// <summary>
    /// 创建人姓名
    /// </summary>
    [SugarColumn(ColumnName = "CreatedByName")]
    public string? CreatedByName { get; set; }

    /// <summary>
    /// 创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CreatedTime")]
    public DateTime CreatedTime { get; set; }

    /// <summary>
    /// 最后修改人账号
    /// </summary>
    [SugarColumn(ColumnName = "UpdatedBy")]
    public string? UpdatedBy { get; set; }

    /// <summary>
    /// 最后修改人姓名
    /// </summary>
    [SugarColumn(ColumnName = "UpdatedByName")]
    public string? UpdatedByName { get; set; }

    /// <summary>
    /// 最后修改时间
    /// </summary>
    [SugarColumn(ColumnName = "UpdatedTime")]
    public DateTime? UpdatedTime { get; set; }

    /// <summary>
    /// 日常点检完成率（%）
    /// </summary>
    [SugarColumn(ColumnName = "DailyCompletionRate")]
    public decimal? DailyCompletionRate { get; set; }

    /// <summary>
    /// 月度点检完成率（%）
    /// </summary>
    [SugarColumn(ColumnName = "MonthlyCompletionRate")]
    public decimal? MonthlyCompletionRate { get; set; }

    /// <summary>
    /// 总点检次数
    /// </summary>
    [SugarColumn(ColumnName = "TotalCheckCount")]
    public int? TotalCheckCount { get; set; }

    /// <summary>
    /// 已完成点检次数
    /// </summary>
    [SugarColumn(ColumnName = "CompletedCheckCount")]
    public int? CompletedCheckCount { get; set; }

    /// <summary>
    /// 状态：0=草稿，1=已提交，2=已审核
    /// </summary>
    [SugarColumn(ColumnName = "Status")]
    public int Status { get; set; }

    /// <summary>
    /// 是否已删除：0=否，1=是
    /// </summary>
    [SugarColumn(ColumnName = "IsDeleted")]
    public bool IsDeleted { get; set; }

    /// <summary>
    /// 备注
    /// </summary>
    [SugarColumn(ColumnName = "Remark")]
    public string? Remark { get; set; }
}