WCS_TaskOld.cs 6.2 KB

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