BillInvinit.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501
  1. using SqlSugar;
  2. using System;
  3. using wms.dto;
  4. namespace wms.sqlsugar.model.sx
  5. {
  6. /// <summary>
  7. /// 条码表
  8. /// </summary>
  9. [Tenant("sx")]
  10. [SugarTable("Bill_InvInit")]
  11. public partial class BillInvinit : BaseModel
  12. {
  13. /// <summary>
  14. /// 仓库ID 关联仓库表 ID
  15. /// </summary>
  16. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  17. public long WarehouseId { get; set; }
  18. /// <summary>
  19. /// 组盘ID
  20. /// 创建条码表时生成 同库存表组盘ID ContGrpId
  21. /// </summary>
  22. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  23. public long ContGrpId { get; set; }
  24. /// <summary>
  25. /// 容器条码 同联容器表容器条码 ContBarCode
  26. /// </summary>
  27. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  28. public string ContGrpBarCode { get; set; }
  29. /// <summary>
  30. /// 箱条码
  31. /// </summary>
  32. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  33. public string BoxBarCode { get; set; }
  34. /// <summary>
  35. /// Bom单号 关联投料单 帘线工序工单号 BillCode
  36. /// </summary>
  37. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  38. public string BomDocsNo { get; set; }
  39. /// <summary>
  40. /// Bom物料ID
  41. /// </summary>
  42. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  43. public long BomMatId { get; set; }
  44. /// <summary>
  45. /// Bom物料编号
  46. /// </summary>
  47. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  48. public string BomMatCode { get; set; }
  49. /// <summary>
  50. /// Bom物料
  51. /// </summary>
  52. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  53. public string BomMatName { get; set; }
  54. /// <summary>
  55. /// 垛形主表 ID
  56. /// </summary>
  57. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  58. public long BomSetId { get; set; }
  59. /// <summary>
  60. /// 垛型编码
  61. /// </summary>
  62. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  63. public string SetGrpCode { get; set; }
  64. /// <summary>
  65. /// 库存状态码
  66. /// </summary>
  67. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  68. public string ExecStateCode { get; set; }
  69. /// <summary>
  70. /// 单据编号 关联单据表单据编号 DocsNo
  71. /// </summary>
  72. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  73. public string ExecDocsNo { get; set; }
  74. /// <summary>
  75. /// 单据行号
  76. /// </summary>
  77. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  78. public string ExecDocsRowNo { get; set; }
  79. /// <summary>
  80. /// 单据类型编号 同单据表TypeNum
  81. /// </summary>
  82. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  83. public string ExecDocsTypeCode { get; set; }
  84. /// <summary>
  85. /// 出入库标识
  86. /// </summary>
  87. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  88. public InvInOutType InvInOut { get; set; }
  89. /// <summary>
  90. /// 执行人
  91. /// </summary>
  92. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  93. public string ExecWho { get; set; }
  94. /// <summary>
  95. /// 执行时间
  96. /// </summary>
  97. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  98. public DateTime ExecTime { get; set; }
  99. /// <summary>
  100. /// 行
  101. /// </summary>
  102. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  103. public int PutRow { get; set; }
  104. /// <summary>
  105. /// 列
  106. /// </summary>
  107. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  108. public int PutCol { get; set; }
  109. /// <summary>
  110. /// 层
  111. /// </summary>
  112. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  113. public int PutLayer { get; set; }
  114. /// <summary>
  115. /// 入库条码号 FJ材料号
  116. /// </summary>
  117. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  118. public string InvBarCode { get; set; }
  119. /// <summary>
  120. /// 库存状态
  121. /// </summary>
  122. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  123. public string InvStateCode { get; set; }
  124. /// <summary>
  125. /// 入库单号
  126. /// </summary>
  127. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  128. public string InDocsNo { get; set; }
  129. /// <summary>
  130. /// 入库单行号
  131. /// </summary>
  132. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  133. public string InDocsRowNo { get; set; }
  134. /// <summary>
  135. /// 供应编号
  136. /// </summary>
  137. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  138. public string SuppCode { get; set; }
  139. /// <summary>
  140. /// 供应商名称
  141. /// </summary>
  142. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  143. public string SuppName { get; set; }
  144. /// <summary>
  145. /// 海关编号
  146. /// </summary>
  147. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  148. public string CustCode { get; set; }
  149. /// <summary>
  150. /// 海关名称
  151. /// </summary>
  152. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  153. public string CustName { get; set; }
  154. /// <summary>
  155. /// 物料ID
  156. /// </summary>
  157. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  158. public long MatId { get; set; }
  159. /// <summary>
  160. /// 物料编号
  161. /// </summary>
  162. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  163. public string MatCode { get; set; }
  164. /// <summary>
  165. /// 物料名称
  166. /// </summary>
  167. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  168. public string MatName { get; set; }
  169. /// <summary>
  170. /// 总重量
  171. /// </summary>
  172. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  173. public decimal TolWQty { get; set; }
  174. /// <summary>
  175. /// 净重
  176. /// </summary>
  177. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  178. public decimal NetWQty { get; set; }
  179. /// <summary>
  180. /// 皮重
  181. /// </summary>
  182. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  183. public decimal TareWQty { get; set; }
  184. /// <summary>
  185. /// 总长
  186. /// </summary>
  187. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  188. public decimal LengthQty { get; set; }
  189. /// <summary>
  190. /// 碳当量
  191. /// </summary>
  192. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  193. public decimal CaQty { get; set; }
  194. /// <summary>
  195. /// 销售总量
  196. /// </summary>
  197. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  198. public decimal SolderQty { get; set; }
  199. /// <summary>
  200. /// 暂定
  201. /// </summary>
  202. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  203. public int ContUsageQty { get; set; }
  204. /// <summary>
  205. /// 批次号
  206. /// </summary>
  207. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  208. public string BatchNo { get; set; }
  209. /// <summary>
  210. /// 生产时间
  211. /// </summary>
  212. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  213. public DateTime ProductTime { get; set; }
  214. /// <summary>
  215. /// 第一次入库时间
  216. /// </summary>
  217. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  218. public DateTime OneInTime { get; set; }
  219. /// <summary>
  220. /// 盘条条码
  221. /// </summary>
  222. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  223. public string RodBarCode { get; set; }
  224. /// <summary>
  225. /// 工字轮条码
  226. /// </summary>
  227. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  228. public string HWBarCode { get; set; }
  229. /// <summary>
  230. /// RFID条码
  231. /// </summary>
  232. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  233. public string RFIDBarCode { get; set; }
  234. /// <summary>
  235. /// 材料号
  236. /// </summary>
  237. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  238. public string CLBarCode { get; set; }
  239. /// <summary>
  240. /// 工字轮条码类型
  241. /// </summary>
  242. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  243. public string HWTypeCode { get; set; }
  244. /// <summary>
  245. /// 炉号
  246. /// </summary>
  247. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  248. public string BoilerNo { get; set; }
  249. /// <summary>
  250. /// 包号
  251. /// </summary>
  252. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  253. public string PackNo { get; set; }
  254. /// <summary>
  255. /// 牌号
  256. /// </summary>
  257. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  258. public string BrandNo { get; set; }
  259. /// <summary>
  260. /// 执行标准
  261. /// </summary>
  262. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  263. public string ExecStd { get; set; }
  264. /// <summary>
  265. /// 许可证号
  266. /// </summary>
  267. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  268. public string LicenceCode { get; set; }
  269. /// <summary>
  270. /// 改手盘标记
  271. /// </summary>
  272. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  273. public bool IsSurplus { get; set; }
  274. /// <summary>
  275. /// 返工标记
  276. /// </summary>
  277. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  278. public bool IsRework { get; set; }
  279. /// <summary>
  280. /// 是否黑盘
  281. /// </summary>
  282. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  283. public bool IsBlack { get; set; }
  284. /// <summary>
  285. /// 是否芯股
  286. /// </summary>
  287. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  288. public bool IsCore { get; set; }
  289. /// <summary>
  290. /// 快投标记
  291. /// </summary>
  292. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  293. public bool IsFast { get; set; }
  294. /// <summary>
  295. /// 是否异常
  296. /// </summary>
  297. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  298. public bool IsFail { get; set; }
  299. /// <summary>
  300. /// 异常原因
  301. /// </summary>
  302. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  303. public string FailReason { get; set; }
  304. /// <summary>
  305. /// 单/双丝
  306. /// </summary>
  307. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  308. public string SilkTypeCode { get; set; }
  309. /// <summary>
  310. /// 等级
  311. /// </summary>
  312. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  313. public string Grade { get; set; }
  314. /// <summary>
  315. /// 是否退料
  316. /// </summary>
  317. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  318. public bool IsBack { get; set; }
  319. /// <summary>
  320. /// 退料原因
  321. /// </summary>
  322. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  323. public string BackReason { get; set; }
  324. /// <summary>
  325. /// 是否扭转检测
  326. /// </summary>
  327. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  328. public bool IsTorsChk { get; set; }
  329. /// <summary>
  330. /// 扭转次数
  331. /// </summary>
  332. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  333. public int TorsChkQty { get; set; }
  334. /// <summary>
  335. /// 扭转检测时间
  336. /// </summary>
  337. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  338. public DateTime TorsChkTime { get; set; }
  339. /// <summary>
  340. /// 扭转检测结果值
  341. /// </summary>
  342. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
  343. public decimal? TorsChkValue { get; set; }
  344. /// <summary>
  345. /// 扭转检测设备号
  346. /// </summary>
  347. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  348. public string TorsChkMachCode { get; set; }
  349. /// <summary>
  350. /// 工序订单号
  351. /// </summary>
  352. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  353. public string ProcessDocsCode { get; set; }
  354. /// <summary>
  355. /// 生产机台号
  356. /// </summary>
  357. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  358. public string ProductMachCode { get; set; }
  359. /// <summary>
  360. /// 帘线机台组号
  361. /// </summary>
  362. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  363. public string WbGroupCode { get; set; }
  364. /// <summary>
  365. /// 生成产线号
  366. /// </summary>
  367. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  368. public string ProductLineNo { get; set; }
  369. /// <summary>
  370. /// 货物大小
  371. /// </summary>
  372. [SugarColumn(IsNullable = false)]
  373. public int Size { get; set; }
  374. /// <summary>
  375. /// 焊点数量
  376. /// </summary>
  377. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  378. public int SolderCount { get; set; }
  379. /// <summary>
  380. /// 静置时长
  381. /// </summary>
  382. [SugarColumn(ColumnDataType = "decimal", Length = 18,DecimalDigits = 2, IsNullable = true)]
  383. public decimal? HoldDuration { get; set; }
  384. /// <summary>
  385. /// Sku编号
  386. /// </summary>
  387. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  388. public string SkuCode { get; set; }
  389. /// <summary>
  390. /// 扭转检测弓高
  391. /// </summary>
  392. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = true)]
  393. public decimal? TorsChkChord { get; set; }
  394. /// <summary>
  395. /// 扭转检测平直度
  396. /// </summary>
  397. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = true)]
  398. public decimal? TorsChkFlatness { get; set; }
  399. /// <summary>
  400. /// 扭转时长
  401. /// </summary>
  402. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 2, IsNullable = true)]
  403. public decimal HoldTime { get; set; }
  404. /// <summary>
  405. /// 装箱规则(1:层配;2:SPC)
  406. /// </summary>
  407. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  408. public string PackRule { get; set; }
  409. /// <summary>
  410. /// 是否控制盘
  411. /// </summary>
  412. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  413. public bool IsControlpanel { get; set; }
  414. /// <summary>
  415. /// 绕向
  416. /// </summary>
  417. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  418. public string Wind { get; set; }
  419. /// <summary>
  420. /// 是否重投盘
  421. /// </summary>
  422. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  423. public bool IsMulti { get; set; }
  424. }
  425. }