sxBillBarcode.cs 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. namespace wms.sqlsugar.model.sx
  6. {
  7. [Tenant("sx")]
  8. [SugarTable("bill_barcode", "条码信息表")]
  9. public class sxBillBarcode : BaseModel
  10. {
  11. /// <summary>
  12. /// 材料号,空容器为容器号
  13. /// </summary>
  14. [SugarColumn(ColumnName = "inv_barcode", ColumnDataType = "nvarchar", Length = 50)]
  15. public string InvBarCode { get; set; }
  16. /// <summary>
  17. /// 库存状态(正常/锁定:Normal/Lock)
  18. /// </summary>
  19. [SugarColumn(ColumnName = "inv_state", ColumnDataType = "nvarchar", Length = 50)]
  20. public string InvState { get; set; }
  21. /// <summary>
  22. /// 入库单据号
  23. /// </summary>
  24. [SugarColumn(ColumnName = "in_docs_no", ColumnDataType = "nvarchar", Length = 100,IsNullable = true)]
  25. public string InDocsNo { get; set; }
  26. /// <summary>
  27. /// 入库单据行号
  28. /// </summary>
  29. [SugarColumn(ColumnName = "in_docs_row_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  30. public string InDocsRowNo { get; set; }
  31. /// <summary>
  32. /// 供应商编码
  33. /// </summary>
  34. [SugarColumn(ColumnName = "supp_code", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  35. public string SuppCode { get; set; }
  36. /// <summary>
  37. /// 供应商名称
  38. /// </summary>
  39. [SugarColumn(ColumnName = "supp_name", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  40. public string SuppName { get; set; }
  41. /// <summary>
  42. /// 物料编码
  43. /// </summary>
  44. [SugarColumn(ColumnName = "mat_code", ColumnDataType = "nvarchar", Length = 50)]
  45. public string MatCode { get; set; }
  46. /// <summary>
  47. /// 物料id
  48. /// </summary>
  49. [SugarColumn(ColumnName = "mat_id")]
  50. public long MatId { get; set; }
  51. /// <summary>
  52. /// 仓库编码
  53. /// </summary>
  54. [SugarColumn(ColumnName = "warehouse_code", ColumnDataType = "nvarchar", Length = 50)]
  55. public string WarehouseCode { get; set; }
  56. /// <summary>
  57. /// 仓库id
  58. /// </summary>
  59. [SugarColumn(ColumnName = "warehouse_id")]
  60. public long WarehouseId { get; set; }
  61. /// <summary>
  62. /// 总重量
  63. /// </summary>
  64. [SugarColumn(ColumnName = "total_wt_qty", Length = 18, DecimalDigits = 6)]
  65. public decimal TotalWtQty { get; set; }
  66. /// <summary>
  67. /// 净重(重量,盘条:包重,其他:钢丝净重)
  68. /// </summary>
  69. [SugarColumn(ColumnName = "net_wt_qty", Length = 18, DecimalDigits = 6)]
  70. public decimal NetWQty { get; set; }
  71. /// <summary>
  72. /// 皮重(空工字轮重量)
  73. /// </summary>
  74. [SugarColumn(ColumnName = "tare_wt_qty", Length = 18, DecimalDigits = 6)]
  75. public decimal TareWQty { get; set; }
  76. /// <summary>
  77. /// 长度
  78. /// </summary>
  79. [SugarColumn(ColumnName = "length_qty", Length = 18, DecimalDigits = 6)]
  80. public decimal LengthQty { get; set; }
  81. /// <summary>
  82. /// 生产批号
  83. /// </summary>
  84. [SugarColumn(ColumnName = "batch", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  85. public string Batch { get; set; }
  86. /// <summary>
  87. /// 生产时间('20230214;默认值19000101)
  88. /// </summary>
  89. [SugarColumn(ColumnName = "product_time")]
  90. public DateTime ProductTime { get; set; }
  91. /// <summary>
  92. /// 第一次入库时间('20230214;默认值19000101)
  93. /// </summary>
  94. [SugarColumn(ColumnName = "one_in_time")]
  95. public DateTime OneInTime { get; set; }
  96. /// <summary>
  97. /// 碳当量
  98. /// </summary>
  99. [SugarColumn(ColumnName = "ca_qty", Length = 18, DecimalDigits = 6)]
  100. public decimal CaQty { get; set; }
  101. /// <summary>
  102. /// 盘条条码
  103. /// </summary>
  104. [SugarColumn(ColumnName = "rod_barcode", ColumnDataType = "nvarchar", Length = 100,IsNullable = true)]
  105. public string RodBarCode { get; set; }
  106. /// <summary>
  107. /// 工字轮条码
  108. /// </summary>
  109. [SugarColumn(ColumnName = "hw_barcode", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  110. public string HWBarCode { get; set; }
  111. /// <summary>
  112. /// RFID条码
  113. /// </summary>
  114. [SugarColumn(ColumnName = "rfid_barcode", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  115. public string RFIDBarCode { get; set; }
  116. /// <summary>
  117. /// 工字轮规格(WS09,WS18,等, 500,800)
  118. /// </summary>
  119. [SugarColumn(ColumnName = "hw_spec", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  120. public string HWSpec { get; set; }
  121. /// <summary>
  122. /// 炉号
  123. /// </summary>
  124. [SugarColumn(ColumnName = "boiler_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  125. public string BoilerNo { get; set; }
  126. /// <summary>
  127. /// 包号
  128. /// </summary>
  129. [SugarColumn(ColumnName = "pack_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  130. public string PackNo { get; set; }
  131. /// <summary>
  132. /// 牌号
  133. /// </summary>
  134. [SugarColumn(ColumnName = "brand_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  135. public string BrandNo { get; set; }
  136. /// <summary>
  137. /// 执行标准
  138. /// </summary>
  139. [SugarColumn(ColumnName = "exec_sd", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  140. public string ExecStd { get; set; }
  141. /// <summary>
  142. /// 许可证号
  143. /// </summary>
  144. [SugarColumn(ColumnName = "licence_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  145. public string LicenceNo { get; set; }
  146. /// <summary>
  147. /// 改手盘标记
  148. /// </summary>
  149. [SugarColumn(ColumnName = "is_surplus", IsNullable = true)]
  150. public bool IsSurplus { get; set; }
  151. /// <summary>
  152. /// 返工标记
  153. /// </summary>
  154. [SugarColumn(ColumnName = "is_rework", IsNullable = true)]
  155. public bool IsRework { get; set; }
  156. /// <summary>
  157. /// 单/双丝
  158. /// </summary>
  159. [SugarColumn(ColumnName = "silk_type", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  160. public string SilkType { get; set; }
  161. /// <summary>
  162. /// 是否黑盘
  163. /// </summary>
  164. [SugarColumn(ColumnName = "is_black")]
  165. public bool IsBlack { get; set; }
  166. /// <summary>
  167. /// 是否芯股
  168. /// </summary>
  169. [SugarColumn(ColumnName = "is_core")]
  170. public bool IsCore { get; set; }
  171. /// <summary>
  172. /// 快投标记
  173. /// </summary>
  174. [SugarColumn(ColumnName = "is_fast", IsNullable = true)]
  175. public bool IsFast { get; set; }
  176. /// <summary>
  177. /// 是否异常
  178. /// </summary>
  179. [SugarColumn(ColumnName = "is_fail", IsNullable = true)]
  180. public bool IsFail { get; set; }
  181. /// <summary>
  182. /// 异常原因
  183. /// </summary>
  184. [SugarColumn(ColumnName = "fail_reason", ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  185. public string FailReason { get; set; }
  186. /// <summary>
  187. /// 焊点数量
  188. /// </summary>
  189. [SugarColumn(ColumnName = "solder_qty")]
  190. public int SolderQty { get; set; }
  191. /// <summary>
  192. /// 等级
  193. /// </summary>
  194. [SugarColumn(ColumnName = "grade", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  195. public string Grade { get; set; }
  196. /// <summary>
  197. /// 退料原因
  198. /// </summary>
  199. [SugarColumn(ColumnName = "reason", ColumnDataType = "nvarchar", Length = 500, IsNullable = true)]
  200. public string Reason { get; set; }
  201. /// <summary>
  202. /// 是否退料
  203. /// </summary>
  204. [SugarColumn(ColumnName = "is_back")]
  205. public bool IsBack { get; set; }
  206. /// <summary>
  207. /// 是否 扭转检测
  208. /// </summary>
  209. [SugarColumn(ColumnName = "is_tors_chk")]
  210. public bool IsTorsChk { get; set; }
  211. /// <summary>
  212. /// 扭转次数
  213. /// </summary>
  214. [SugarColumn(ColumnName = "tors_chk_qty")]
  215. public int TorsChkQty { get; set; }
  216. /// <summary>
  217. /// 扭转检测时间
  218. /// </summary>
  219. [SugarColumn(ColumnName = "tors_chk_time")]
  220. public DateTime TorsChkTime { get; set; }
  221. /// <summary>
  222. /// 扭转检测结果值
  223. /// </summary>
  224. [SugarColumn(ColumnName = "tors_chk_value", Length = 18, DecimalDigits = 6)]
  225. public decimal TorsChkValue { get; set; }
  226. /// <summary>
  227. /// 扭转检测设备号
  228. /// </summary>
  229. [SugarColumn(ColumnName = "tors_chk_no", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  230. public string TorsChkMacNo { get; set; }
  231. /// <summary>
  232. /// 工序订单号
  233. /// </summary>
  234. [SugarColumn(ColumnName = "process_docs_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  235. public string ProcessDocsNo { get; set; }
  236. /// <summary>
  237. /// 生产机台号
  238. /// </summary>
  239. [SugarColumn(ColumnName = "product_wb_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  240. public string ProductWbNo { get; set; }
  241. /// <summary>
  242. /// 生产产线号
  243. /// </summary>
  244. [SugarColumn(ColumnName = "product_line_no", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  245. public string ProductLineNo { get; set; }
  246. }
  247. }