using SqlSugar; using System; namespace DeviceRepairAndOptimization.Models { [SugarTable("DriveMaintencePlan")] public class DrivePlan { /// /// 自增长主键 /// [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int AutoID { get; set; } /// /// 设备编号 /// [SugarColumn(ColumnName = "EquipmentID")] public int EquipmentID { get; set; } /// /// 预计保养日期 /// [SugarColumn(ColumnName = "CompleteDate")] public DateTime? CompleteDate { get; set; } /// /// 保养年份 /// [SugarColumn(ColumnName = "MaintenanceYear")] public int MaintenanceYear { get; set; } /// /// 保养月份 /// [SugarColumn(ColumnName = "MaintenanceMonth")] public int MaintenanceMonth { get; set; } /// /// 保养类型(Semi-an、Quarterly、Annual、Monthly) /// [SugarColumn(ColumnName = "MaintenanceType")] public string MaintenanceType { get; set; } /// /// 新PM起始月份 /// [SugarColumn(ColumnName = "PMStartMonth")] public DateTime PMStartMonth { get; set; } /// /// 创建日期 /// [SugarColumn(ColumnName = "CreatDate")] public DateTime CreatDate { get; set; } /// /// 创建人 /// [SugarColumn(ColumnName = "CreatUser")] public int CreatUser { get; set; } /// /// 修改日期 /// [SugarColumn(ColumnName = "ChangeDate")] public DateTime ChangeDate { get; set; } /// /// 修改人 /// [SugarColumn(ColumnName = "ChangeUser")] public int ChangeUser { get; set; } /// /// 备注 /// [SugarColumn(ColumnName = "Remarks")] public string Remarks { get; set; } /// /// 计划维修时间 /// [SugarColumn(IsIgnore = true)] public string PlanMaintenanceDate { get { return MaintenanceYear + "-" + MaintenanceMonth.ToString().PadLeft(2, '0'); } } [SugarColumn(IsIgnore = true)] public string MonthStr { get; set; } } }