WCS_TASK.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
  1. using SqlSugar;
  2. using System;
  3. namespace WCS.Entity
  4. {
  5. /// <summary>
  6. /// 任务表
  7. /// </summary>
  8. [SugarTable(nameof(WCS_TASK), "任务表")]
  9. public class WCS_TASK : OBJ
  10. {
  11. /// <summary>
  12. /// 生产编码
  13. /// </summary>
  14. [SugarColumn(ColumnDescription = "生产编码", Length = 50)]
  15. public string BARCODE { get; set; }
  16. /// <summary>
  17. /// 任务类型
  18. /// </summary>
  19. [SugarColumn(ColumnDescription = "任务类型")]
  20. public TaskType TYPE { get; set; }
  21. /// <summary>
  22. /// 任务状态
  23. /// </summary>
  24. [SugarColumn(ColumnDescription = "任务状态")]
  25. public TaskStatus STATUS { get; set; }
  26. /// <summary>
  27. /// 起始地址
  28. /// </summary>
  29. [SugarColumn(ColumnDescription = "起始地址", Length = 20)]
  30. public string ADDRFROM { get; set; }
  31. /// <summary>
  32. /// 目标地址
  33. /// </summary>
  34. [SugarColumn(ColumnDescription = "目标地址", Length = 20)]
  35. public string ADDRTO { get; set; }
  36. /// <summary>
  37. /// 下一个地址
  38. /// </summary>
  39. [SugarColumn(ColumnDescription = "下一个地址", Length = 20)]
  40. public string ADDRNEXT { get; set; }
  41. /// <summary>
  42. /// 巷道
  43. /// </summary>
  44. [SugarColumn(ColumnDescription = "巷道", Length = 10, IsNullable = true)]
  45. public string TUNNEL { get; set; }
  46. /// <summary>
  47. /// 楼层
  48. /// </summary>
  49. [SugarColumn(ColumnDescription = "楼层")]
  50. public int FLOOR { get; set; }
  51. /// <summary>
  52. /// 设备
  53. /// </summary>
  54. [SugarColumn(ColumnDescription = "设备", Length = 20, IsNullable = true)]
  55. public string DEVICE { get; set; }
  56. /// <summary>
  57. /// 堆垛机放货站台
  58. /// </summary>
  59. [SugarColumn(ColumnDescription = "堆垛机放货站台", Length = 20, IsNullable = true)]
  60. public string SRMSTATION { get; set; }
  61. /// <summary>
  62. ///创建时间
  63. /// </summary>
  64. [SugarColumn(ColumnDescription = "创建时间")]
  65. public DateTime CREATETIME { get; set; } = DateTime.Now;
  66. /// <summary>
  67. /// 开始时间
  68. /// </summary>
  69. [SugarColumn(ColumnDescription = "开始时间")]
  70. public DateTime? STARTTIME { get; set; }
  71. /// <summary>
  72. /// 结束时间
  73. /// </summary>
  74. [SugarColumn(ColumnDescription = "结束时间", IsNullable = true)]
  75. public DateTime? ENDTIME { get; set; }
  76. /// <summary>
  77. /// 单号
  78. /// </summary>
  79. [SugarColumn(ColumnDescription = "单号", IsNullable = true)]
  80. public int DOCID { get; set; }
  81. /// <summary>
  82. /// 托盘类型
  83. /// </summary>
  84. [SugarColumn(ColumnDescription = "托盘类型", IsNullable = true)]
  85. public short PALLETTYPE { get; set; }
  86. /// <summary>
  87. /// 产线
  88. /// </summary>
  89. [SugarColumn(ColumnDescription = "产线", IsNullable = true)]
  90. public short PRODLINE { get; set; }
  91. /// <summary>
  92. /// 满盘数量
  93. /// </summary>
  94. [SugarColumn(ColumnDescription = "满盘数量", IsNullable = true)]
  95. public short FULLQTY { get; set; }
  96. /// <summary>
  97. /// 高度
  98. /// </summary>
  99. [SugarColumn(ColumnDescription = "高度", IsNullable = true)]
  100. public short HEIGHT { get; set; }
  101. /// <summary>
  102. /// WMS任务号
  103. /// </summary>
  104. [SugarColumn(ColumnDescription = "WMS任务号")]
  105. public int WMSTASK { get; set; }
  106. /// <summary>
  107. /// 任务组ID
  108. /// </summary>
  109. [SugarColumn(ColumnDescription = "任务组ID", IsNullable = true)]
  110. public string TaskGroupKey { get; set; }
  111. /// <summary>
  112. /// 更新状态
  113. /// </summary>
  114. [SugarColumn(ColumnDescription = "更新状态")]
  115. public TaskStatus UPLOADED { get; set; }
  116. /// <summary>
  117. /// AGV任务号
  118. /// </summary>
  119. [SugarColumn(ColumnDescription = "AGV任务号", IsNullable = true)]
  120. public int AGVTASKID { get; set; }
  121. /// <summary>
  122. /// AGV任务详细信息
  123. /// </summary>
  124. [Navigate(NavigateType.OneToOne, nameof(AGVTASKID))]
  125. public WCS_AGVTask AGVTASK { get; set; }
  126. /// <summary>
  127. /// 优先级
  128. /// </summary>
  129. [SugarColumn(ColumnDescription = "优先级")]
  130. public int Priority { get; set; }
  131. /// <summary>
  132. /// 手动处理备注
  133. /// </summary>
  134. [SugarColumn(ColumnDescription = "手动处理备注", IsNullable = true)]
  135. public string ManualRemarks { get; set; }
  136. /// <summary>
  137. /// 产品长度
  138. /// </summary>
  139. [SugarColumn(ColumnDescription = "产品长度", IsNullable = true)]
  140. public decimal Length { get; set; }
  141. /// <summary>
  142. /// 产品编码
  143. /// </summary>
  144. [SugarColumn(ColumnDescription = "产品编码", IsNullable = true)]
  145. public string MaterialCode { get; set; }
  146. }
  147. /// <summary>
  148. /// 任务表
  149. /// </summary>
  150. [SugarTable(nameof(WCS_TASK_OLD), "任务表")]
  151. public class WCS_TASK_OLD : OBJ
  152. {
  153. /// <summary>
  154. /// 生产编码
  155. /// </summary>
  156. [SugarColumn(ColumnDescription = "生产编码", Length = 50)]
  157. public string BARCODE { get; set; }
  158. /// <summary>
  159. /// 任务类型
  160. /// </summary>
  161. [SugarColumn(ColumnDescription = "任务类型")]
  162. public TaskType TYPE { get; set; }
  163. /// <summary>
  164. /// 任务状态
  165. /// </summary>
  166. [SugarColumn(ColumnDescription = "任务状态")]
  167. public TaskStatus STATUS { get; set; }
  168. /// <summary>
  169. /// 起始地址
  170. /// </summary>
  171. [SugarColumn(ColumnDescription = "起始地址", Length = 20)]
  172. public string ADDRFROM { get; set; }
  173. /// <summary>
  174. /// 目标地址
  175. /// </summary>
  176. [SugarColumn(ColumnDescription = "目标地址", Length = 20)]
  177. public string ADDRTO { get; set; }
  178. /// <summary>
  179. /// 下一个地址
  180. /// </summary>
  181. [SugarColumn(ColumnDescription = "下一个地址", Length = 20)]
  182. public string ADDRNEXT { get; set; }
  183. /// <summary>
  184. /// 巷道
  185. /// </summary>
  186. [SugarColumn(ColumnDescription = "巷道", Length = 10)]
  187. public string TUNNEL { get; set; }
  188. /// <summary>
  189. /// 楼层
  190. /// </summary>
  191. [SugarColumn(ColumnDescription = "楼层")]
  192. public int FLOOR { get; set; }
  193. /// <summary>
  194. /// 设备
  195. /// </summary>
  196. [SugarColumn(ColumnDescription = "设备", Length = 20)]
  197. public string DEVICE { get; set; }
  198. /// <summary>
  199. /// 堆垛机放货站台
  200. /// </summary>
  201. [SugarColumn(ColumnDescription = "堆垛机放货站台", Length = 20)]
  202. public string SRMSTATION { get; set; }
  203. /// <summary>
  204. ///创建时间
  205. /// </summary>
  206. [SugarColumn(ColumnDescription = "创建时间")]
  207. public DateTime CREATETIME { get; set; } = DateTime.Now;
  208. /// <summary>
  209. /// 开始时间
  210. /// </summary>
  211. [SugarColumn(ColumnDescription = "开始时间")]
  212. public DateTime? STARTTIME { get; set; }
  213. /// <summary>
  214. /// 结束时间
  215. /// </summary>
  216. [SugarColumn(ColumnDescription = "结束时间")]
  217. public DateTime? ENDTIME { get; set; }
  218. /// <summary>
  219. /// 单号
  220. /// </summary>
  221. [SugarColumn(ColumnDescription = "单号")]
  222. public int DOCID { get; set; }
  223. /// <summary>
  224. /// 托盘类型
  225. /// </summary>
  226. [SugarColumn(ColumnDescription = "托盘类型")]
  227. public short PALLETTYPE { get; set; }
  228. /// <summary>
  229. /// 产线
  230. /// </summary>
  231. [SugarColumn(ColumnDescription = "产线")]
  232. public short PRODLINE { get; set; }
  233. /// <summary>
  234. /// 满盘数量
  235. /// </summary>
  236. [SugarColumn(ColumnDescription = "满盘数量")]
  237. public short FULLQTY { get; set; }
  238. /// <summary>
  239. /// 高度
  240. /// </summary>
  241. [SugarColumn(ColumnDescription = "高度")]
  242. public short HEIGHT { get; set; }
  243. /// <summary>
  244. /// WMS任务号
  245. /// </summary>
  246. [SugarColumn(ColumnDescription = "WMS任务号")]
  247. public int WMSTASK { get; set; }
  248. /// <summary>
  249. /// 任务组ID
  250. /// </summary>
  251. [SugarColumn(ColumnDescription = "任务组ID")]
  252. public string TaskGroupKey { get; set; }
  253. /// <summary>
  254. /// 更新状态
  255. /// </summary>
  256. [SugarColumn(ColumnDescription = "更新状态")]
  257. public TaskStatus UPLOADED { get; set; }
  258. /// <summary>
  259. /// AGV任务号
  260. /// </summary>
  261. [SugarColumn(ColumnDescription = "AGV任务号")]
  262. public int AGVTASKID { get; set; }
  263. /// <summary>
  264. /// AGV任务详细信息
  265. /// </summary>
  266. [Navigate(NavigateType.OneToOne, nameof(AGVTASKID))]
  267. public WCS_AGVTask AGVTASK { get; set; }
  268. /// <summary>
  269. /// 优先级
  270. /// </summary>
  271. [SugarColumn(ColumnDescription = "优先级")]
  272. public int Priority { get; set; }
  273. /// <summary>
  274. /// 手动处理备注
  275. /// </summary>
  276. [SugarColumn(ColumnDescription = "手动处理备注")]
  277. public string ManualRemarks { get; set; }
  278. /// <summary>
  279. /// 产品长度
  280. /// </summary>
  281. [SugarColumn(ColumnDescription = "产品长度")]
  282. public decimal Length { get; set; }
  283. /// <summary>
  284. /// 产品编码
  285. /// </summary>
  286. [SugarColumn(ColumnDescription = "产品编码")]
  287. public string MaterialCode { get; set; }
  288. }
  289. /// <summary>
  290. /// 任务类型
  291. /// </summary>
  292. public enum TaskType
  293. {
  294. /// <summary>
  295. /// 组盘
  296. /// </summary>
  297. SetPlate = 0,
  298. /// <summary>
  299. /// 入库
  300. /// </summary>
  301. EnterDepot = 1,
  302. /// <summary>
  303. /// 出库
  304. /// </summary>
  305. OutDepot = 2,
  306. /// <summary>
  307. /// 移库
  308. /// </summary>
  309. TransferDepot = 3,
  310. /// <summary>
  311. /// 输送
  312. /// </summary>
  313. Delivery = 5,
  314. }
  315. /// <summary>
  316. /// 任务状态
  317. /// </summary>
  318. public enum TaskStatus
  319. {
  320. /// <summary>
  321. /// 新建
  322. /// </summary>
  323. 新建 = 0,
  324. /// <summary>
  325. /// 执行中
  326. /// </summary>
  327. 执行中 = 2,
  328. /// <summary>
  329. /// 入库交管结束
  330. /// </summary>
  331. 入库交管结束 = 3,
  332. /// <summary>
  333. /// 堆垛机执行
  334. /// </summary>
  335. 堆垛机执行 = 5,
  336. /// <summary>
  337. /// 堆垛机完成
  338. /// </summary>
  339. 堆垛机完成 = 6,
  340. /// <summary>
  341. /// 出库RGV执行
  342. /// </summary>
  343. 出库RGV执行 = 9,
  344. /// <summary>
  345. /// 已完成
  346. /// </summary>
  347. 已完成 = 99,
  348. /// <summary>
  349. /// 已取消
  350. /// </summary>
  351. 已取消 = 106
  352. }
  353. }