WCS_TaskOld.cs 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219
  1. using SqlSugar;
  2. using System;
  3. namespace WCS.Entity
  4. {
  5. /// <summary>
  6. /// 任务表
  7. /// </summary>
  8. [SugarTable(nameof(WCS_TaskOld) + "_{year}{month}{day}", "任务表")]
  9. [SplitTable(SplitType.Week)]//按年分表 (自带分表支持 年、季、月、周、日)
  10. public class WCS_TaskOld
  11. {
  12. /// <summary>
  13. /// ID
  14. /// </summary>
  15. [SugarColumn(IsPrimaryKey = true, ColumnDescription = "ID")]
  16. public int ID { get; set; }
  17. /// <summary>
  18. /// 生产编码
  19. /// </summary>
  20. [SugarColumn(ColumnDescription = "生产编码", Length = 50, IsNullable = true)]
  21. public string BarCode { get; set; }
  22. /// <summary>
  23. /// 任务类型
  24. /// </summary>
  25. [SugarColumn(ColumnDescription = "任务类型", IsNullable = true)]
  26. public TaskType Type { get; set; }
  27. /// <summary>
  28. /// 任务状态
  29. /// </summary>
  30. [SugarColumn(ColumnDescription = "任务状态", IsNullable = true)]
  31. public TaskStatus Status { get; set; }
  32. /// <summary>
  33. /// 起始地址
  34. /// </summary>
  35. [SugarColumn(ColumnDescription = "起始地址", Length = 20, IsNullable = true)]
  36. public string AddrFrom { get; set; }
  37. /// <summary>
  38. /// 目标地址
  39. /// </summary>
  40. [SugarColumn(ColumnDescription = "目标地址", Length = 20, IsNullable = true)]
  41. public string AddrTo { get; set; }
  42. /// <summary>
  43. /// 最后一个交互点
  44. /// </summary>
  45. [SugarColumn(ColumnDescription = "最后一个交互点", Length = 20, IsNullable = true)]
  46. public string LastInteractionPoint { get; set; }
  47. /// <summary>
  48. /// 下一个地址
  49. /// </summary>
  50. [SugarColumn(ColumnDescription = "下一个地址", Length = 20, IsNullable = true)]
  51. public string AddrNext { get; set; }
  52. /// <summary>
  53. /// 巷道
  54. /// </summary>
  55. [SugarColumn(ColumnDescription = "巷道", Length = 10, IsNullable = true)]
  56. public string Tunnel { get; set; }
  57. /// <summary>
  58. /// 楼层
  59. /// </summary>
  60. [SugarColumn(ColumnDescription = "楼层")]
  61. public int Floor { get; set; }
  62. /// <summary>
  63. /// 设备
  64. /// </summary>
  65. [SugarColumn(ColumnDescription = "设备", Length = 20, IsNullable = true)]
  66. public string Device { get; set; }
  67. /// <summary>
  68. /// 堆垛机放货站台
  69. /// </summary>
  70. [SugarColumn(ColumnDescription = "堆垛机放货站台", Length = 20, IsNullable = true)]
  71. public string SrmStation { get; set; }
  72. /// <summary>
  73. ///创建时间
  74. /// </summary>
  75. [SugarColumn(ColumnDescription = "创建时间")]
  76. public DateTime AddTime { get; set; }
  77. /// <summary>
  78. /// 开始时间
  79. /// </summary>
  80. [SugarColumn(ColumnDescription = "开始时间", IsNullable = true)]
  81. public DateTime? StartTime { get; set; }
  82. /// <summary>
  83. /// 结束时间
  84. /// </summary>
  85. [SugarColumn(ColumnDescription = "结束时间", IsNullable = true)]
  86. public DateTime? EndTime { get; set; }
  87. /// <summary>
  88. /// 客户现场的机台/产线编号
  89. /// </summary>
  90. [SugarColumn(ColumnDescription = "客户现场的机台/产线编号", IsNullable = true)]
  91. public string WorkBench { get; set; }
  92. /// <summary>
  93. /// 仓库编号
  94. /// </summary>
  95. [SugarColumn(ColumnDescription = "仓库编号", IsNullable = true)]
  96. public string WarehouseCode { get; set; }
  97. /// <summary>
  98. /// 码垛单号
  99. /// </summary>
  100. [SugarColumn(ColumnDescription = "单号", IsNullable = true)]
  101. public int DocID { get; set; }
  102. /// <summary>
  103. /// 码垛托盘类型
  104. /// </summary>
  105. [SugarColumn(ColumnDescription = "托盘类型", IsNullable = true)]
  106. public short PalletType { get; set; }
  107. /// <summary>
  108. /// 码垛工位
  109. /// </summary>
  110. [SugarColumn(ColumnDescription = "码垛工位", IsNullable = true)]
  111. public short ProdLine { get; set; }
  112. /// <summary>
  113. /// 满盘数量
  114. /// </summary>
  115. [SugarColumn(ColumnDescription = "满盘数量", IsNullable = true)]
  116. public short FullQty { get; set; }
  117. /// <summary>
  118. /// 高度
  119. /// </summary>
  120. [SugarColumn(ColumnDescription = "高度", IsNullable = true)]
  121. public short Height { get; set; }
  122. /// <summary>
  123. /// WMS任务号
  124. /// </summary>
  125. [SugarColumn(ColumnDescription = "WMS任务号")]
  126. public int WmsTask { get; set; }
  127. /// <summary>
  128. /// 任务组ID
  129. /// </summary>
  130. [SugarColumn(ColumnDescription = "任务组ID", IsNullable = true)]
  131. public string TaskGroupKey { get; set; }
  132. /// <summary>
  133. /// 更新状态
  134. /// </summary>
  135. [SugarColumn(ColumnDescription = "更新状态")]
  136. public TaskStatus Uploaded { get; set; }
  137. /// <summary>
  138. /// AGV任务号
  139. /// </summary>
  140. [SugarColumn(ColumnDescription = "AGV任务号", IsNullable = true)]
  141. public int AgvTaskID { get; set; }
  142. /// <summary>
  143. /// AGV任务详细信息
  144. /// </summary>
  145. [Navigate(NavigateType.OneToOne, nameof(AgvTaskID))]
  146. public WCS_AgvTaskInfo AgvTask { get; set; }
  147. /// <summary>
  148. /// 优先级
  149. /// </summary>
  150. [SugarColumn(ColumnDescription = "优先级")]
  151. public int Priority { get; set; }
  152. /// <summary>
  153. /// 手动处理备注
  154. /// </summary>
  155. [SugarColumn(ColumnDescription = "手动处理备注", IsNullable = true)]
  156. public string ManualRemarks { get; set; }
  157. /// <summary>
  158. /// 产品长度
  159. /// </summary>
  160. [SugarColumn(ColumnDescription = "产品长度", IsNullable = true)]
  161. public decimal Length { get; set; }
  162. /// <summary>
  163. /// 产品编码
  164. /// </summary>
  165. [SugarColumn(ColumnDescription = "产品编码", IsNullable = true)]
  166. public string MaterialCode { get; set; }
  167. /// <summary>
  168. /// 创建用户
  169. /// 仅记录用户ID
  170. /// </summary>
  171. [SugarColumn(ColumnDescription = "创建用户", Length = 50)]
  172. public string AddWho { get; set; }
  173. /// <summary>
  174. /// 更新用户
  175. /// 仅记录用户ID
  176. /// </summary>
  177. [SugarColumn(ColumnDescription = "更新用户", Length = 50, IsNullable = true)]
  178. public string EditWho { get; set; }
  179. /// <summary>
  180. /// 更新时间
  181. /// </summary>
  182. [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
  183. public DateTime EditTime { get; set; }
  184. }
  185. }