WCS_TASK.cs 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. using static WCS_Client.Utility.CurrentHelper;
  8. namespace WCS_Client.Models
  9. {
  10. public class WCS_TASK
  11. {
  12. /// <summary>
  13. /// WCS任务号
  14. /// </summary>
  15. [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
  16. public int TASK_NO { get; set; }
  17. /// <summary>
  18. /// WMS任务号
  19. /// </summary>
  20. public string TASK_WMSNO { get; set; }
  21. public int TASK_COMTYPE { get; set; }
  22. [SugarColumn(IsIgnore = true)]
  23. public ComTypeEnum TASK_COMTYPECh
  24. {
  25. get
  26. {
  27. return (ComTypeEnum)TASK_COMTYPE;
  28. }
  29. }
  30. public string TASK_SYSTYPE { get; set; }
  31. public string TASK_POSIDFROM { get; set; }
  32. public string TASK_POSIDCUR { get; set; }
  33. public string TASK_POSIDNEXT { get; set; }
  34. public string TASK_POSIDTO { get; set; }
  35. public string TASK_POSIDMOVE { get; set; }
  36. public int TASK_PRIORITY { get; set; }
  37. public int TASK_WKSTATUS { get; set; }
  38. public string TASK_WHID { get; set; }
  39. public string TASK_ADDUSERNO { get; set; }
  40. public DateTime TASK_ADDDATETIME { get; set; }
  41. public string TASK_EDITUSERNO { get; set; }
  42. public DateTime TASK_EDITDATETIME { get; set; }
  43. public string TASK_NOTES { get; set; }
  44. public string TASK_SRMNO { get; set; }
  45. /// <summary>
  46. /// rgv编号
  47. /// </summary>
  48. public string TASK_RGVNO { get; set; }
  49. public int TASK_ORDERTYPE { get; set; }
  50. public string TASK_BOXBARCODE { get; set; }
  51. /// <summary>
  52. /// 起始巷道号
  53. /// </summary>
  54. public string TASK_FromTunnelNum { get; set; }
  55. /// <summary>
  56. /// 目标巷道号
  57. /// </summary>
  58. public string TASK_EndTunnelNum { get; set; }
  59. /// <summary>
  60. /// 熟化类型(0=不需熟化、1=熟化房熟化、2=小烘房熟化)
  61. /// </summary>
  62. public int TASK_MatureType { get; set; }
  63. /// <summary>
  64. /// 熟化时间(小时:10,16)
  65. /// </summary>
  66. public decimal TASK_MatureDate { get; set; }
  67. /// <summary>
  68. /// 熟化温度(小数)
  69. /// </summary>
  70. public decimal TASK_MatureTemperat { get; set; }
  71. /// <summary>
  72. /// 进入熟化房时间
  73. /// </summary>
  74. public DateTime TASK_InMatureRoomDate { get; set; }
  75. /// <summary>
  76. /// 离开熟化房时间
  77. /// </summary>
  78. public DateTime TASK_OutMatureRoomDate { get; set; }
  79. /// <summary>
  80. /// 机械手:子托盘的尺寸编码
  81. /// </summary>
  82. public string PalletizingSonTraySize { get; set; }
  83. /// <summary>
  84. /// 机械手:码垛的箱子尺寸编码
  85. /// </summary>
  86. public string PalletizingBoxSize { get; set; }
  87. /// <summary>
  88. /// 预分配堆垛机出口输送线编号
  89. /// </summary>
  90. //public string TASK_SRMOUTCONVNO { get; set; }
  91. public string TASK_ITEM1 { get; set; }
  92. public string TASK_ITEM2 { get; set; }
  93. public string TASK_ITEM3 { get; set; }
  94. public string TASK_ITEM4 { get; set; }
  95. public string TASK_ITEM5 { get; set; }
  96. public string TASK_ITEM6 { get; set; }
  97. public string TASK_ITEM7 { get; set; }
  98. public string TASK_ITEM8 { get; set; }
  99. public string TASK_ITEM9 { get; set; }
  100. public string TASK_ITEM10 { get; set; }
  101. [SugarColumn(IsIgnore = true)]
  102. public List<string> FromLocation
  103. {
  104. get
  105. {
  106. return TASK_POSIDFROM.Split('-').ToList();
  107. }
  108. }
  109. [SugarColumn(IsIgnore = true)]
  110. public int FromRow
  111. {
  112. get
  113. {
  114. return Convert.ToInt32(FromLocation[1]);
  115. }
  116. }
  117. [SugarColumn(IsIgnore = true)]
  118. public int FromCol
  119. {
  120. get
  121. {
  122. return Convert.ToInt32(FromLocation[2]);
  123. }
  124. }
  125. [SugarColumn(IsIgnore = true)]
  126. public int FromLayer
  127. {
  128. get
  129. {
  130. return Convert.ToInt32(FromLocation[3]);
  131. }
  132. }
  133. [SugarColumn(IsIgnore = true)]
  134. public int FromDepth
  135. {
  136. get
  137. {
  138. return Convert.ToInt32(FromLocation[4]);
  139. }
  140. }
  141. [SugarColumn(IsIgnore = true)]
  142. public int FromSingleDepthRow
  143. {
  144. get
  145. {
  146. return 1;
  147. }
  148. }
  149. [SugarColumn(IsIgnore = true)]
  150. public List<string> ToLocation
  151. {
  152. get
  153. {
  154. return TASK_POSIDTO.Split('-').ToList();
  155. }
  156. }
  157. [SugarColumn(IsIgnore = true)]
  158. public int ToRow
  159. {
  160. get
  161. {
  162. return Convert.ToInt32(ToLocation[1]);
  163. }
  164. }
  165. [SugarColumn(IsIgnore = true)]
  166. public int ToCol
  167. {
  168. get
  169. {
  170. return Convert.ToInt32(ToLocation[2]);
  171. }
  172. }
  173. [SugarColumn(IsIgnore = true)]
  174. public int ToLayer
  175. {
  176. get
  177. {
  178. return Convert.ToInt32(ToLocation[3]);
  179. }
  180. }
  181. [SugarColumn(IsIgnore = true)]
  182. public int ToDepth
  183. {
  184. get
  185. {
  186. return Convert.ToInt32(ToLocation[4]);
  187. }
  188. }
  189. }
  190. public class WCS_TASK_DTL
  191. {
  192. [SugarColumn(IsPrimaryKey = true, IsIdentity = false)]
  193. public string ID { get; set; }
  194. public int PARENTID { get; set; }
  195. public string TASKNO { get; set; }
  196. public string POSIDCUR { get; set; }
  197. public string POSIDNEXT { get; set; }
  198. public string DESCRIPTION { get; set; }
  199. public string NOTES { get; set; }
  200. public DateTime EXECUTEDATE { get; set; }
  201. }
  202. public class WCS_EQUIPMENTLOCK
  203. {
  204. [SugarColumn(IsPrimaryKey = true, IsIdentity = false)]
  205. public string EQUIPMENTNO { get; set; }
  206. public bool ISLOCK { get; set; }
  207. public DateTime UPDATETIME { get; set; }
  208. public string ISENABLEI_IN { get; set; }
  209. public string ISENABLE_OUT { get; set; }
  210. public string EQUTYPE { get; set; }
  211. }
  212. }