| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 |
- namespace Admin.NET.Plugin.AiDOP.WorkOrder;
- /// <summary>
- /// 工单工序表(WorkOrdRouting)
- /// </summary>
- [SugarTable("WorkOrdRouting", "工单工艺路线")]
- public class WorkOrdRouting
- {
- /// <summary>自增列</summary>
- [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
- public long RecID { get; set; }
- /// <summary>工单流水号</summary>
- [SugarColumn(ColumnName = "WorkOrdMasterRecID", IsNullable = true)]
- public long? WorkOrdMasterRecID { get; set; }
- [SugarColumn(ColumnName = "Domain", Length = 8, IsNullable = true)]
- public string? Domain { get; set; }
- [SugarColumn(ColumnName = "WorkOrd", Length = 64, IsNullable = true)]
- public string? WorkOrd { get; set; }
- [SugarColumn(ColumnName = "OP", Length = 6, IsNullable = true)]
- public string? OP { get; set; }
- [SugarColumn(ColumnName = "ItemNum", Length = 30, IsNullable = true)]
- public string? ItemNum { get; set; }
- [SugarColumn(ColumnName = "WorkCtr", Length = 8, IsNullable = true)]
- public string? WorkCtr { get; set; }
- [SugarColumn(ColumnName = "ProdLine", Length = 8, IsNullable = true)]
- public string? ProdLine { get; set; }
- [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
- public string? Status { get; set; }
- [SugarColumn(ColumnName = "Descr", Length = 256, IsNullable = true)]
- public string? Descr { get; set; }
- [SugarColumn(ColumnName = "QtyOrded", IsNullable = true)]
- public decimal? QtyOrded { get; set; }
- [SugarColumn(ColumnName = "QtyComplete", IsNullable = true)]
- public decimal? QtyComplete { get; set; }
- [SugarColumn(ColumnName = "CumRejected", IsNullable = true)]
- public decimal? CumRejected { get; set; }
- [SugarColumn(ColumnName = "QtyReject", IsNullable = true)]
- public decimal? QtyReject { get; set; }
- [SugarColumn(ColumnName = "QtyRework", IsNullable = true)]
- public decimal? QtyRework { get; set; }
- [SugarColumn(ColumnName = "QtyScrap", IsNullable = true)]
- public decimal? QtyScrap { get; set; }
- [SugarColumn(ColumnName = "QtyWIP", IsNullable = true)]
- public decimal? QtyWIP { get; set; }
- [SugarColumn(ColumnName = "StdRunTime", IsNullable = true)]
- public decimal? StdRunTime { get; set; }
- [SugarColumn(ColumnName = "ActRunTime", IsNullable = true)]
- public decimal? ActRunTime { get; set; }
- [SugarColumn(ColumnName = "StdSetupTime", IsNullable = true)]
- public decimal? StdSetupTime { get; set; }
- [SugarColumn(ColumnName = "ActSetupTime", IsNullable = true)]
- public decimal? ActSetupTime { get; set; }
- [SugarColumn(ColumnName = "RunCrew", IsNullable = true)]
- public int? RunCrew { get; set; }
- [SugarColumn(ColumnName = "SetupCrew", IsNullable = true)]
- public int? SetupCrew { get; set; }
- [SugarColumn(ColumnName = "StartDate", IsNullable = true)]
- public DateTime? StartDate { get; set; }
- [SugarColumn(ColumnName = "EndDate", IsNullable = true)]
- public DateTime? EndDate { get; set; }
- [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
- public DateTime? DueDate { get; set; }
- [SugarColumn(ColumnName = "Priority", IsNullable = true)]
- public int? Priority { get; set; }
- [SugarColumn(ColumnName = "Machine", Length = 8, IsNullable = true)]
- public string? Machine { get; set; }
- [SugarColumn(ColumnName = "Labor", IsNullable = true)]
- public decimal? Labor { get; set; }
- [SugarColumn(ColumnName = "Burden", IsNullable = true)]
- public decimal? Burden { get; set; }
- [SugarColumn(ColumnName = "Overhead1", IsNullable = true)]
- public decimal? Overhead1 { get; set; }
- [SugarColumn(ColumnName = "Overhead2", IsNullable = true)]
- public decimal? Overhead2 { get; set; }
- [SugarColumn(ColumnName = "Remark", Length = 512, IsNullable = true)]
- public string? Remark { get; set; }
- [SugarColumn(ColumnName = "NextOp1", Length = 6, IsNullable = true)]
- public string? NextOp1 { get; set; }
- [SugarColumn(ColumnName = "ParentOp", Length = 6, IsNullable = true)]
- public string? ParentOp { get; set; }
- [SugarColumn(ColumnName = "IsCheckOp", IsNullable = true)]
- public int? IsCheckOp { get; set; }
- [SugarColumn(ColumnName = "ProcessOut", IsNullable = true)]
- public int? ProcessOut { get; set; }
- [SugarColumn(ColumnName = "Ufld1", Length = 64, IsNullable = true)]
- public string? Ufld1 { get; set; }
- [SugarColumn(ColumnName = "Ufld2", Length = 64, IsNullable = true)]
- public string? Ufld2 { get; set; }
- [SugarColumn(ColumnName = "Ufld3", Length = 64, IsNullable = true)]
- public string? Ufld3 { get; set; }
- [SugarColumn(ColumnName = "BusinessID", IsNullable = true)]
- public long? BusinessID { get; set; }
- [SugarColumn(ColumnName = "CreateUser", Length = 8, IsNullable = true)]
- public string? CreateUser { get; set; }
- [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
- public DateTime? CreateTime { get; set; }
- [SugarColumn(ColumnName = "UpdateUser", Length = 8, IsNullable = true)]
- public string? UpdateUser { get; set; }
- [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
- public DateTime? UpdateTime { get; set; }
- [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
- public int? IsActive { get; set; }
- [SugarColumn(ColumnName = "IsConfirm", IsNullable = true)]
- public int? IsConfirm { get; set; }
- [SugarColumn(ColumnName = "ERPfld1", Length = 128, IsNullable = true)]
- public string? ERPfld1 { get; set; }
- [SugarColumn(ColumnName = "ERPfld2", Length = 128, IsNullable = true)]
- public string? ERPfld2 { get; set; }
- /// <summary>租户ID(多租户隔离)</summary>
- [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
- public long? TenantId { get; set; }
- }
|