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