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; }
|
}
|
