LinkagePlan.cs 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. namespace Admin.NET.Plugin.AiDOP.Order;
  2. /// <summary>计划联动看板</summary>
  3. [SugarTable("LinkagePlan", "计划联动看板")]
  4. [IgnoreTable]
  5. public class LinkagePlan
  6. {
  7. [SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = false)]
  8. public long Id { get; set; }
  9. /// <summary>订单编号</summary>
  10. [SugarColumn(ColumnName = "bill_no", Length = 64, IsNullable = true)]
  11. public string? BillNo { get; set; }
  12. /// <summary>客户编码</summary>
  13. [SugarColumn(ColumnName = "custom_no", Length = 64, IsNullable = true)]
  14. public string? CustomNo { get; set; }
  15. /// <summary>订单类型</summary>
  16. [SugarColumn(ColumnName = "order_type", Length = 32, IsNullable = true)]
  17. public string? OrderType { get; set; }
  18. /// <summary>物料代码</summary>
  19. [SugarColumn(ColumnName = "item_number", Length = 64, IsNullable = true)]
  20. public string? ItemNumber { get; set; }
  21. /// <summary>物料名称</summary>
  22. [SugarColumn(ColumnName = "Descr", Length = 256, IsNullable = true)]
  23. public string? Descr { get; set; }
  24. /// <summary>规格型号</summary>
  25. [SugarColumn(ColumnName = "Descr1", Length = 256, IsNullable = true)]
  26. public string? Descr1 { get; set; }
  27. /// <summary>产品类型</summary>
  28. [SugarColumn(ColumnName = "ItemType", Length = 64, IsNullable = true)]
  29. public string? ItemType { get; set; }
  30. /// <summary>数量</summary>
  31. [SugarColumn(ColumnName = "qty", IsNullable = true)]
  32. public decimal? Qty { get; set; }
  33. /// <summary>生产通知</summary>
  34. [SugarColumn(ColumnName = "update_time", IsNullable = true)]
  35. public DateTime? UpdateTime { get; set; }
  36. /// <summary>合同交期</summary>
  37. [SugarColumn(ColumnName = "sys_capacity_date", IsNullable = true)]
  38. public DateTime? SysCapacityDate { get; set; }
  39. /// <summary>计划管控</summary>
  40. [SugarColumn(ColumnName = "type", Length = 32, IsNullable = true)]
  41. public string? Type { get; set; }
  42. /// <summary>Bom设计开始</summary>
  43. [SugarColumn(ColumnName = "bomstart", Length = 80, IsNullable = true)]
  44. public string? BomStart { get; set; }
  45. /// <summary>Bom设计结束</summary>
  46. [SugarColumn(ColumnName = "bomend", Length = 80, IsNullable = true)]
  47. public string? BomEnd { get; set; }
  48. /// <summary>工艺设计开始</summary>
  49. [SugarColumn(ColumnName = "linestart", Length = 80, IsNullable = true)]
  50. public string? LineStart { get; set; }
  51. /// <summary>工艺设计结束</summary>
  52. [SugarColumn(ColumnName = "lineend", Length = 80, IsNullable = true)]
  53. public string? LineEnd { get; set; }
  54. /// <summary>生产开始</summary>
  55. [SugarColumn(ColumnName = "productstart", Length = 80, IsNullable = true)]
  56. public string? ProductStart { get; set; }
  57. /// <summary>生产结束</summary>
  58. [SugarColumn(ColumnName = "productend", Length = 80, IsNullable = true)]
  59. public string? ProductEnd { get; set; }
  60. /// <summary>物料需求</summary>
  61. [SugarColumn(ColumnName = "needtime", Length = 80, IsNullable = true)]
  62. public string? NeedTime { get; set; }
  63. /// <summary>物料满足</summary>
  64. [SugarColumn(ColumnName = "sys_material_date", Length = 80, IsNullable = true)]
  65. public string? SysMaterialDate { get; set; }
  66. /// <summary>采购下单</summary>
  67. [SugarColumn(ColumnName = "cgneedtime", Length = 80, IsNullable = true)]
  68. public string? CgNeedTime { get; set; }
  69. /// <summary>采购到货</summary>
  70. [SugarColumn(ColumnName = "cgend", Length = 80, IsNullable = true)]
  71. public string? CgEnd { get; set; }
  72. /// <summary>备料开始</summary>
  73. [SugarColumn(ColumnName = "blstart", Length = 80, IsNullable = true)]
  74. public string? BlStart { get; set; }
  75. /// <summary>备料结束</summary>
  76. [SugarColumn(ColumnName = "blend", Length = 80, IsNullable = true)]
  77. public string? BlEnd { get; set; }
  78. /// <summary>报工开始</summary>
  79. [SugarColumn(ColumnName = "starttime", Length = 80, IsNullable = true)]
  80. public string? StartTime { get; set; }
  81. /// <summary>报工结束</summary>
  82. [SugarColumn(ColumnName = "endtime", Length = 80, IsNullable = true)]
  83. public string? EndTime { get; set; }
  84. /// <summary>IQC检验开始</summary>
  85. [SugarColumn(ColumnName = "ipqcjystart", Length = 80, IsNullable = true)]
  86. public string? IpqcJyStart { get; set; }
  87. /// <summary>IQC检验结束</summary>
  88. [SugarColumn(ColumnName = "ipqcjyend", Length = 80, IsNullable = true)]
  89. public string? IpqcJyEnd { get; set; }
  90. /// <summary>FQC检验开始</summary>
  91. [SugarColumn(ColumnName = "fqcjystart", Length = 80, IsNullable = true)]
  92. public string? FqcJyStart { get; set; }
  93. /// <summary>FQC检验结束</summary>
  94. [SugarColumn(ColumnName = "fqcjyend", Length = 80, IsNullable = true)]
  95. public string? FqcJyEnd { get; set; }
  96. /// <summary>入库开始</summary>
  97. [SugarColumn(ColumnName = "rkstart", Length = 80, IsNullable = true)]
  98. public string? RkStart { get; set; }
  99. /// <summary>入库结束</summary>
  100. [SugarColumn(ColumnName = "rkend", Length = 80, IsNullable = true)]
  101. public string? RkEnd { get; set; }
  102. /// <summary>发运开始</summary>
  103. [SugarColumn(ColumnName = "fystarttime", Length = 80, IsNullable = true)]
  104. public string? FyStartTime { get; set; }
  105. /// <summary>发运结束</summary>
  106. [SugarColumn(ColumnName = "fyendtime", Length = 80, IsNullable = true)]
  107. public string? FyEndTime { get; set; }
  108. /// <summary>排序</summary>
  109. [SugarColumn(ColumnName = "levelnum", IsNullable = true)]
  110. public int? LevelNum { get; set; }
  111. /// <summary>背景色</summary>
  112. [SugarColumn(ColumnName = "background", Length = 32, IsNullable = true)]
  113. public string? Background { get; set; }
  114. }