BillPboxruleHty.cs 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. namespace wms.sqlsugar.model.sx
  6. {
  7. /// <summary>
  8. /// 成品装箱
  9. /// </summary>
  10. [Tenant("sx")]
  11. [SugarTable(nameof(BillPboxruleHty) + "_{year}{month}{day}", "箱号表")]
  12. [SplitTable(SplitType.Month)]//按年分表 (自带分表支持 年、季、月、周、日)
  13. public class BillPboxruleHty : BaseModel
  14. {
  15. /// <summary>
  16. /// WarehouseId
  17. /// </summary>
  18. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  19. public long WarehouseId { get; set; }
  20. /// <summary>
  21. /// IsStop
  22. /// </summary>
  23. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  24. public int IsStop { get; set; }
  25. /// <summary>
  26. /// DocsNo
  27. /// </summary>
  28. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  29. public string DocsNo { get; set; }
  30. /// <summary>
  31. /// Sku编号
  32. /// </summary>
  33. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  34. public string SkuCode { get; set; }
  35. /// <summary>
  36. /// 箱号
  37. /// </summary>
  38. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  39. public string PBoxCode { get; set; }
  40. /// <summary>
  41. /// 装箱规则(1:层配;2:SPC)
  42. /// </summary>
  43. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  44. public string PackRule { get; set; }
  45. /// <summary>
  46. /// 每箱满轮子数
  47. /// </summary>
  48. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  49. public int FullCountQty { get; set; }
  50. /// <summary>
  51. /// 每箱空轮子数
  52. /// </summary>
  53. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  54. public int EmptyCountQty { get; set; }
  55. /// <summary>
  56. /// 是否允许焊点盘
  57. /// </summary>
  58. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  59. public int IsSolder { get; set; }
  60. /// <summary>
  61. /// 每箱允许最大焊点盘数量
  62. /// </summary>
  63. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  64. public int SolderMaxCount { get; set; }
  65. /// <summary>
  66. /// 每个工字轮允许最大焊点数量
  67. /// </summary>
  68. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  69. public int PerSolderMaxCount { get; set; }
  70. /// <summary>
  71. /// 24小时目标扭转值
  72. /// </summary>
  73. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  74. public decimal Torsion24Qty { get; set; }
  75. /// <summary>
  76. /// 48小时目标扭转值
  77. /// </summary>
  78. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  79. public decimal Torsion48Qty { get; set; }
  80. /// <summary>
  81. /// 72小时目标扭转值
  82. /// </summary>
  83. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  84. public decimal Torsion72Qty { get; set; }
  85. /// <summary>
  86. /// 扭转目标范围
  87. /// </summary>
  88. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  89. public decimal TorsionErrRange { get; set; }
  90. /// <summary>
  91. /// 目标扭转值
  92. /// </summary>
  93. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = true)]
  94. public decimal TorsChkValue { get; set; }
  95. /// <summary>
  96. /// 目标扭转值偏差范围
  97. /// </summary>
  98. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = true)]
  99. public decimal TorsChkValueRange { get; set; }
  100. /// <summary>
  101. /// 子托盘编码
  102. /// </summary>
  103. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  104. public string TrayCode { get; set; }
  105. /// <summary>
  106. /// 装箱状态(0未装箱/1装箱中/2装箱完成/3控制箱预占/4非控制预占)
  107. /// </summary>
  108. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  109. public int ZXStateCode { get; set; }
  110. /// <summary>
  111. /// 每箱黑盘数量
  112. /// </summary>
  113. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  114. public int BlackCount { get; set; }
  115. /// <summary>
  116. /// 返工盘数量
  117. /// </summary>
  118. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  119. public int ReturnCount { get; set; }
  120. /// <summary>
  121. /// 扭转目标时间
  122. /// </summary>
  123. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  124. public decimal HoldTime { get; set; }
  125. /// <summary>
  126. /// 是否控制盘
  127. /// </summary>
  128. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  129. public bool IsControlpanel { get; set; }
  130. /// <summary>
  131. /// 包装信息
  132. /// </summary>
  133. [SugarColumn(ColumnDataType = "nvarchar", IsNullable = true,Length = 4000)]
  134. public string PackJsonContent { get; set; }
  135. /// <summary>
  136. /// 扭转最大数
  137. /// </summary>
  138. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  139. public decimal TorsionMaxQty { get; set; }
  140. /// <summary>
  141. /// 扭转最小数
  142. /// </summary>
  143. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = false)]
  144. public decimal TorsionMinQty { get; set; }
  145. /// <summary>
  146. /// 工字轮型号
  147. /// </summary>
  148. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  149. public string SpoolType { get; set; }
  150. /// <summary>
  151. /// 生产批号
  152. /// </summary>
  153. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  154. public string BatchNo { get; set; }
  155. /// <summary>
  156. /// 绕向
  157. /// </summary>
  158. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  159. public string Wind { get; set; }
  160. /// <summary>
  161. /// 包装编码
  162. /// </summary>
  163. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  164. public string Dryer { get; set; }
  165. /// <summary>
  166. /// 包材重量
  167. /// </summary>
  168. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  169. public decimal PackWeight { get; set; }
  170. /// <summary>
  171. /// L/R类别
  172. /// </summary>
  173. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  174. public string LR_TYPE_L { get; set; }
  175. /// <summary>
  176. /// 工字轮主色 浅蓝/灰色/橙色
  177. /// </summary>
  178. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  179. public string SPOOL_MAJOR_COLOR_L { get; set; }
  180. /// <summary>
  181. /// 收线自动扭转检测(俯视) 顺时针/逆时针
  182. /// </summary>
  183. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  184. public string TAKEUP_SIDE_L { get; set; }
  185. /// <summary>
  186. /// L/R类别
  187. /// </summary>
  188. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  189. public string LR_TYPE_R { get; set; }
  190. /// <summary>
  191. /// 工字轮主色 浅蓝/灰色/橙色
  192. /// </summary>
  193. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  194. public string SPOOL_MAJOR_COLOR_R { get; set; }
  195. /// <summary>
  196. /// 收线自动扭转检测(俯视) 顺时针/逆时针
  197. /// </summary>
  198. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  199. public string TAKEUP_SIDE_R { get; set; }
  200. }
  201. }