WorkOrdRouting.cs 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. namespace Admin.NET.Plugin.AiDOP.WorkOrder;
  2. /// <summary>
  3. /// 工单工序表(WorkOrdRouting)
  4. /// </summary>
  5. [SugarTable("WorkOrdRouting", "工单工艺路线")]
  6. public class WorkOrdRouting
  7. {
  8. /// <summary>自增列</summary>
  9. [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
  10. public long RecID { get; set; }
  11. /// <summary>工单流水号</summary>
  12. [SugarColumn(ColumnName = "WorkOrdMasterRecID", IsNullable = true)]
  13. public long? WorkOrdMasterRecID { get; set; }
  14. [SugarColumn(ColumnName = "Domain", Length = 8, IsNullable = true)]
  15. public string? Domain { get; set; }
  16. [SugarColumn(ColumnName = "WorkOrd", Length = 64, IsNullable = true)]
  17. public string? WorkOrd { get; set; }
  18. [SugarColumn(ColumnName = "OP", Length = 6, IsNullable = true)]
  19. public string? OP { get; set; }
  20. [SugarColumn(ColumnName = "ItemNum", Length = 30, IsNullable = true)]
  21. public string? ItemNum { get; set; }
  22. [SugarColumn(ColumnName = "WorkCtr", Length = 8, IsNullable = true)]
  23. public string? WorkCtr { get; set; }
  24. [SugarColumn(ColumnName = "ProdLine", Length = 8, IsNullable = true)]
  25. public string? ProdLine { get; set; }
  26. [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
  27. public string? Status { get; set; }
  28. [SugarColumn(ColumnName = "Descr", Length = 256, IsNullable = true)]
  29. public string? Descr { get; set; }
  30. [SugarColumn(ColumnName = "QtyOrded", IsNullable = true)]
  31. public decimal? QtyOrded { get; set; }
  32. [SugarColumn(ColumnName = "QtyComplete", IsNullable = true)]
  33. public decimal? QtyComplete { get; set; }
  34. [SugarColumn(ColumnName = "CumRejected", IsNullable = true)]
  35. public decimal? CumRejected { get; set; }
  36. [SugarColumn(ColumnName = "QtyReject", IsNullable = true)]
  37. public decimal? QtyReject { get; set; }
  38. [SugarColumn(ColumnName = "QtyRework", IsNullable = true)]
  39. public decimal? QtyRework { get; set; }
  40. [SugarColumn(ColumnName = "QtyScrap", IsNullable = true)]
  41. public decimal? QtyScrap { get; set; }
  42. [SugarColumn(ColumnName = "QtyWIP", IsNullable = true)]
  43. public decimal? QtyWIP { get; set; }
  44. [SugarColumn(ColumnName = "StdRunTime", IsNullable = true)]
  45. public decimal? StdRunTime { get; set; }
  46. [SugarColumn(ColumnName = "ActRunTime", IsNullable = true)]
  47. public decimal? ActRunTime { get; set; }
  48. [SugarColumn(ColumnName = "StdSetupTime", IsNullable = true)]
  49. public decimal? StdSetupTime { get; set; }
  50. [SugarColumn(ColumnName = "ActSetupTime", IsNullable = true)]
  51. public decimal? ActSetupTime { get; set; }
  52. [SugarColumn(ColumnName = "RunCrew", IsNullable = true)]
  53. public int? RunCrew { get; set; }
  54. [SugarColumn(ColumnName = "SetupCrew", IsNullable = true)]
  55. public int? SetupCrew { get; set; }
  56. [SugarColumn(ColumnName = "StartDate", IsNullable = true)]
  57. public DateTime? StartDate { get; set; }
  58. [SugarColumn(ColumnName = "EndDate", IsNullable = true)]
  59. public DateTime? EndDate { get; set; }
  60. [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
  61. public DateTime? DueDate { get; set; }
  62. [SugarColumn(ColumnName = "Priority", IsNullable = true)]
  63. public int? Priority { get; set; }
  64. [SugarColumn(ColumnName = "Machine", Length = 8, IsNullable = true)]
  65. public string? Machine { get; set; }
  66. [SugarColumn(ColumnName = "Labor", IsNullable = true)]
  67. public decimal? Labor { get; set; }
  68. [SugarColumn(ColumnName = "Burden", IsNullable = true)]
  69. public decimal? Burden { get; set; }
  70. [SugarColumn(ColumnName = "Overhead1", IsNullable = true)]
  71. public decimal? Overhead1 { get; set; }
  72. [SugarColumn(ColumnName = "Overhead2", IsNullable = true)]
  73. public decimal? Overhead2 { get; set; }
  74. [SugarColumn(ColumnName = "Remark", Length = 512, IsNullable = true)]
  75. public string? Remark { get; set; }
  76. [SugarColumn(ColumnName = "NextOp1", Length = 6, IsNullable = true)]
  77. public string? NextOp1 { get; set; }
  78. [SugarColumn(ColumnName = "ParentOp", Length = 6, IsNullable = true)]
  79. public string? ParentOp { get; set; }
  80. [SugarColumn(ColumnName = "IsCheckOp", IsNullable = true)]
  81. public int? IsCheckOp { get; set; }
  82. [SugarColumn(ColumnName = "ProcessOut", IsNullable = true)]
  83. public int? ProcessOut { get; set; }
  84. [SugarColumn(ColumnName = "Ufld1", Length = 64, IsNullable = true)]
  85. public string? Ufld1 { get; set; }
  86. [SugarColumn(ColumnName = "Ufld2", Length = 64, IsNullable = true)]
  87. public string? Ufld2 { get; set; }
  88. [SugarColumn(ColumnName = "Ufld3", Length = 64, IsNullable = true)]
  89. public string? Ufld3 { get; set; }
  90. [SugarColumn(ColumnName = "BusinessID", IsNullable = true)]
  91. public long? BusinessID { get; set; }
  92. [SugarColumn(ColumnName = "CreateUser", Length = 8, IsNullable = true)]
  93. public string? CreateUser { get; set; }
  94. [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
  95. public DateTime? CreateTime { get; set; }
  96. [SugarColumn(ColumnName = "UpdateUser", Length = 8, IsNullable = true)]
  97. public string? UpdateUser { get; set; }
  98. [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
  99. public DateTime? UpdateTime { get; set; }
  100. [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
  101. public int? IsActive { get; set; }
  102. [SugarColumn(ColumnName = "IsConfirm", IsNullable = true)]
  103. public int? IsConfirm { get; set; }
  104. [SugarColumn(ColumnName = "ERPfld1", Length = 128, IsNullable = true)]
  105. public string? ERPfld1 { get; set; }
  106. [SugarColumn(ColumnName = "ERPfld2", Length = 128, IsNullable = true)]
  107. public string? ERPfld2 { get; set; }
  108. /// <summary>租户ID(多租户隔离)</summary>
  109. [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
  110. public long? TenantId { get; set; }
  111. }