cpBoxItemsHty.cs 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. namespace wms.sqlsugar.model.cp
  6. {
  7. /// <summary>
  8. /// 甲方管理系统推送反馈
  9. /// </summary>
  10. [Tenant("cp")]
  11. [SugarTable(nameof(cpBoxItemsHty) + "_{year}{month}{day}", "箱号明细表")]
  12. [SplitTable(SplitType.Year)]//按年分表 (自带分表支持 年、季、月、周、日)
  13. public class cpBoxItemsHty:BaseModel
  14. {
  15. /// <summary>
  16. /// 箱号组Id(关联组表)
  17. /// </summary>
  18. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  19. public long CongBoxId { get; set; }
  20. /// <summary>
  21. /// 箱号
  22. /// </summary>
  23. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  24. public string HuNr { get; set; }
  25. /// <summary>
  26. /// 工字轮号
  27. /// </summary>
  28. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  29. public string HWBarCode { get; set; }
  30. /// <summary>
  31. /// 库存状态(锁定/正常)
  32. /// </summary>
  33. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  34. public string ExecStateCode { get; set; }
  35. /// <summary>
  36. /// 生产订单号
  37. /// </summary>
  38. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  39. public string OrderNo { get; set; }
  40. /// <summary>
  41. /// 生产订单行号
  42. /// </summary>
  43. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  44. public string OrderRowNo { get; set; }
  45. /// <summary>
  46. /// 组盘状态
  47. /// </summary>
  48. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  49. public string InvStateCode { get; set; }
  50. /// <summary>
  51. /// 入库单据号
  52. /// </summary>
  53. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  54. public string InDocsNo { get; set; }
  55. /// <summary>
  56. /// 入库单行号
  57. /// </summary>
  58. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  59. public string InDocsRowNo { get; set; }
  60. /// <summary>
  61. /// 供应商编码
  62. /// </summary>
  63. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  64. public string SuppCode { get; set; }
  65. /// <summary>
  66. /// 供应商名称
  67. /// </summary>
  68. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  69. public string SuppName { get; set; }
  70. /// <summary>
  71. /// 客户编码
  72. /// </summary>
  73. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  74. public string CustCode { get; set; }
  75. /// <summary>
  76. /// 客户名称
  77. /// </summary>
  78. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  79. public string CustName { get; set; }
  80. /// <summary>
  81. /// MatId
  82. /// </summary>
  83. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  84. public long MatId { get; set; }
  85. /// <summary>
  86. /// MatCode
  87. /// </summary>
  88. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  89. public string MaterialCode { get; set; }
  90. /// <summary>
  91. /// MatName
  92. /// </summary>
  93. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  94. public string MaterialDesc { get; set; }
  95. /// <summary>
  96. /// 总重量
  97. /// </summary>
  98. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  99. public string HuTotalWt { get; set; }
  100. /// <summary>
  101. /// 净重
  102. /// </summary>
  103. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  104. public string HuNetWt { get; set; }
  105. /// <summary>
  106. /// 皮重
  107. /// </summary>
  108. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  109. public string HuTareWt { get; set; }
  110. /// <summary>
  111. /// 焊点数量
  112. /// </summary>
  113. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  114. public decimal BadpointCount { get; set; }
  115. /// <summary>
  116. /// 批号
  117. /// </summary>
  118. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  119. public string Batch { get; set; }
  120. /// <summary>
  121. /// 钢丝质量等级A/B/C/废品
  122. /// </summary>
  123. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  124. public string GradeCode { get; set; }
  125. /// <summary>
  126. /// 绕向
  127. /// </summary>
  128. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  129. public string Winding { get; set; }
  130. /// <summary>
  131. /// 是否做扭转检测 0 不做;1 做
  132. /// </summary>
  133. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  134. public decimal OvcFlag { get; set; }
  135. /// <summary>
  136. /// 起鼓等级
  137. /// </summary>
  138. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  139. public string PlumpGrade { get; set; }
  140. /// <summary>
  141. /// 扭转检测结果值
  142. /// </summary>
  143. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  144. public string OvcValue { get; set; }
  145. /// <summary>
  146. /// 装箱时间
  147. /// </summary>
  148. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  149. public string ProduceDate { get; set; }
  150. /// <summary>
  151. /// 工序订单号
  152. /// </summary>
  153. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  154. public string OrderProcessNo { get; set; }
  155. /// <summary>
  156. /// 机器组编码
  157. /// </summary>
  158. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  159. public string MachineGroupcode { get; set; }
  160. /// <summary>
  161. /// 产线
  162. /// </summary>
  163. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  164. public string ProdLine { get; set; }
  165. /// <summary>
  166. /// 产线代码
  167. /// </summary>
  168. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  169. public string ProdLineCode { get; set; }
  170. /// <summary>
  171. /// 1 放行/ 2 冻结 ERP使用
  172. /// </summary>
  173. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  174. public string State { get; set; }
  175. /// <summary>
  176. /// 销售发货单预冻结
  177. /// </summary>
  178. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  179. public string SalesDoc { get; set; }
  180. /// <summary>
  181. /// Sku
  182. /// </summary>
  183. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  184. public string Sku { get; set; }
  185. /// <summary>
  186. /// 班次
  187. /// </summary>
  188. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  189. public string ShiftNo { get; set; }
  190. /// <summary>
  191. /// 班别
  192. /// </summary>
  193. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  194. public string ShiftGroup { get; set; }
  195. /// <summary>
  196. /// 材料号
  197. /// </summary>
  198. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  199. public string CLBarCode { get; set; }
  200. /// <summary>
  201. /// 码垛工位
  202. /// </summary>
  203. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  204. public string EquNo { get; set; }
  205. /// <summary>
  206. /// 推送状态(0未上传1上传成功 2上传失败)
  207. /// </summary>
  208. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  209. public int UpLoadFlag { get; set; }
  210. /// <summary>
  211. /// 是否需要上传
  212. /// </summary>
  213. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  214. public int IsNeedUpLoadFlag { get; set; }
  215. /// <summary>
  216. /// 码垛层
  217. /// </summary>
  218. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  219. public int Layer { get; set; }
  220. /// <summary>
  221. /// 是否黑盘
  222. /// </summary>
  223. [SugarColumn(ColumnDataType = "bit", IsNullable = true)]
  224. public bool IsBlack { get; set; }
  225. /// <summary>
  226. /// 是否控制盘
  227. /// </summary>
  228. [SugarColumn(ColumnDataType = "bit", IsNullable = true)]
  229. public bool IsControlpanel { get; set; }
  230. /// <summary>
  231. /// 单爪码垛完成时间
  232. /// </summary>
  233. [SugarColumn(ColumnDataType = "datetime", IsNullable = true)]
  234. public DateTime PalletizingDate { get; set; }
  235. /// <summary>
  236. /// 时间戳
  237. /// </summary>
  238. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  239. public string TimeStamp { get; set; }
  240. }
  241. }