using SqlSugar; namespace PadApplication.Entites.DbModels; /// /// 设备点检明细表 /// [SugarTable("MES_EquipmentInspectionDetail")] public class MesEquipmentInspectionDetail { /// /// 明细ID,自增主键 /// [SugarColumn(ColumnName = "DetailId", IsPrimaryKey = true, IsIdentity = true)] public long DetailId { get; set; } /// /// 点检记录ID,关联主表 /// [SugarColumn(ColumnName = "InspectionId")] public long InspectionId { get; set; } /// /// 点检类型:daily=日常点检,monthly=月度点检 /// [SugarColumn(ColumnName = "ItemType")] public string ItemType { get; set; } /// /// 点检项目索引(0-5为日常,0-1为月度) /// [SugarColumn(ColumnName = "ItemIndex")] public int ItemIndex { get; set; } /// /// 点检项目名称(冗余字段,便于查询) /// [SugarColumn(ColumnName = "ItemName")] public string ItemName { get; set; } /// /// 月内日期(1-31) /// [SugarColumn(ColumnName = "DayOfMonth")] public int DayOfMonth { get; set; } /// /// 是否完成点检:0=未完成,1=已完成 /// [SugarColumn(ColumnName = "IsChecked")] public bool IsChecked { get; set; } /// /// 点检人账号 /// [SugarColumn(ColumnName = "CheckedBy")] public string? CheckedBy { get; set; } /// /// 点检人姓名 /// [SugarColumn(ColumnName = "CheckedByName")] public string? CheckedByName { get; set; } /// /// 点检时间 /// [SugarColumn(ColumnName = "CheckedTime")] public DateTime? CheckedTime { get; set; } /// /// 点检结果:正常、异常等 /// [SugarColumn(ColumnName = "CheckResult")] public string? CheckResult { get; set; } /// /// 异常备注 /// [SugarColumn(ColumnName = "AbnormalRemark")] public string? AbnormalRemark { get; set; } /// /// 点检图片URL列表(JSON格式) /// [SugarColumn(ColumnName = "ImageUrls")] public string? ImageUrls { get; set; } /// /// 是否已审核:0=否,1=是 /// [SugarColumn(ColumnName = "IsReviewed")] public bool IsReviewed { get; set; } /// /// 审核人账号 /// [SugarColumn(ColumnName = "ReviewedBy")] public string? ReviewedBy { get; set; } /// /// 审核人姓名 /// [SugarColumn(ColumnName = "ReviewedByName")] public string? ReviewedByName { get; set; } /// /// 审核时间 /// [SugarColumn(ColumnName = "ReviewedTime")] public DateTime? ReviewedTime { get; set; } /// /// 审核备注 /// [SugarColumn(ColumnName = "ReviewRemark")] public string? ReviewRemark { get; set; } /// /// 创建时间 /// [SugarColumn(ColumnName = "CreatedTime")] public DateTime CreatedTime { get; set; } /// /// 修改时间 /// [SugarColumn(ColumnName = "UpdatedTime")] public DateTime? UpdatedTime { get; set; } }