WorkOrdDetail.cs 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. namespace Admin.NET.Plugin.AiDOP.WorkOrder;
  2. /// <summary>
  3. /// 工单物料明细(WorkOrdDetail)
  4. /// </summary>
  5. [SugarTable("WorkOrdDetail", "工单明细")]
  6. public class WorkOrdDetail
  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 = "LineNum", IsNullable = true)]
  19. public int? LineNum { get; set; }
  20. [SugarColumn(ColumnName = "ItemNum", Length = 30, IsNullable = true)]
  21. public string? ItemNum { get; set; }
  22. [SugarColumn(ColumnName = "Op", Length = 6, IsNullable = true)]
  23. public string? Op { get; set; }
  24. [SugarColumn(ColumnName = "Location", Length = 10, IsNullable = true)]
  25. public string? Location { get; set; }
  26. [SugarColumn(ColumnName = "Site", Length = 8, IsNullable = true)]
  27. public string? Site { get; set; }
  28. [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
  29. public string? Status { get; set; }
  30. [SugarColumn(ColumnName = "Typed", Length = 1, IsNullable = true)]
  31. public string? Typed { get; set; }
  32. [SugarColumn(ColumnName = "QtyRequired", IsNullable = true)]
  33. public decimal? QtyRequired { get; set; }
  34. [SugarColumn(ColumnName = "QtyIssued", IsNullable = true)]
  35. public decimal? QtyIssued { get; set; }
  36. [SugarColumn(ColumnName = "QtyPicked", IsNullable = true)]
  37. public decimal? QtyPicked { get; set; }
  38. [SugarColumn(ColumnName = "QtyPosted", IsNullable = true)]
  39. public decimal? QtyPosted { get; set; }
  40. [SugarColumn(ColumnName = "QtyReturned", IsNullable = true)]
  41. public decimal? QtyReturned { get; set; }
  42. [SugarColumn(ColumnName = "QtyReject", IsNullable = true)]
  43. public decimal? QtyReject { get; set; }
  44. [SugarColumn(ColumnName = "UnitCost", IsNullable = true)]
  45. public decimal? UnitCost { get; set; }
  46. [SugarColumn(ColumnName = "StdCost", IsNullable = true)]
  47. public decimal? StdCost { get; set; }
  48. [SugarColumn(ColumnName = "Price", IsNullable = true)]
  49. public decimal? Price { get; set; }
  50. [SugarColumn(ColumnName = "UM", Length = 8, IsNullable = true)]
  51. public string? UM { get; set; }
  52. [SugarColumn(ColumnName = "LotSerial", Length = 25, IsNullable = true)]
  53. public string? LotSerial { get; set; }
  54. [SugarColumn(ColumnName = "Material", Length = 1, IsNullable = true)]
  55. public string? Material { get; set; }
  56. [SugarColumn(ColumnName = "IsMainMas", IsNullable = true)]
  57. public int? IsMainMas { get; set; }
  58. [SugarColumn(ColumnName = "ModelItem", Length = 64, IsNullable = true)]
  59. public string? ModelItem { get; set; }
  60. [SugarColumn(ColumnName = "Ufld1", Length = 64, IsNullable = true)]
  61. public string? Ufld1 { get; set; }
  62. [SugarColumn(ColumnName = "Ufld2", Length = 64, IsNullable = true)]
  63. public string? Ufld2 { get; set; }
  64. [SugarColumn(ColumnName = "BusinessID", IsNullable = true)]
  65. public long? BusinessID { get; set; }
  66. [SugarColumn(ColumnName = "CreateUser", Length = 8, IsNullable = true)]
  67. public string? CreateUser { get; set; }
  68. [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
  69. public DateTime? CreateTime { get; set; }
  70. [SugarColumn(ColumnName = "UpdateUser", Length = 8, IsNullable = true)]
  71. public string? UpdateUser { get; set; }
  72. [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
  73. public DateTime? UpdateTime { get; set; }
  74. [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
  75. public int? IsActive { get; set; }
  76. [SugarColumn(ColumnName = "IsConfirm", IsNullable = true)]
  77. public int? IsConfirm { get; set; }
  78. [SugarColumn(ColumnName = "ERPfld1", Length = 128, IsNullable = true)]
  79. public string? ERPfld1 { get; set; }
  80. [SugarColumn(ColumnName = "ERPfld2", Length = 128, IsNullable = true)]
  81. public string? ERPfld2 { get; set; }
  82. /// <summary>租户ID(多租户隔离)</summary>
  83. [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
  84. public long? TenantId { get; set; }
  85. }