cpBill_InvflowHty.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. using wms.sqlsugar.model.pt;
  6. namespace wms.sqlsugar.model.cp
  7. {
  8. /// <summary>
  9. /// 流水历史表
  10. /// </summary>
  11. [Tenant("cp")]
  12. [SugarTable(nameof(cpBill_InvflowHty) + "_{year}{month}{day}", "流水历史表")]
  13. [SplitTable(SplitType.Year)]//按年分表 (自带分表支持 年、季、月、周、日)
  14. public class cpBill_InvflowHty:BaseModel
  15. {
  16. /// <summary>
  17. /// WarehouseId
  18. /// </summary>
  19. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  20. public long WarehouseId { get; set; }
  21. /// <summary>
  22. /// ContGrpId
  23. /// </summary>
  24. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  25. public long ContGrpId { get; set; }
  26. /// <summary>
  27. /// ContGrpBarCode
  28. /// </summary>
  29. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  30. public string ContGrpBarCode { get; set; }
  31. /// <summary>
  32. /// 组盘类型(1物料盘 2空托盘 3间隔板)
  33. /// </summary>
  34. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  35. public int ContGrpType { get; set; }
  36. /// <summary>
  37. /// BoxBarCode
  38. /// </summary>
  39. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  40. public string BoxBarCode { get; set; }
  41. /// <summary>
  42. /// BomDocsNo
  43. /// </summary>
  44. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  45. public string BomDocsNo { get; set; }
  46. /// <summary>
  47. /// BomMatId
  48. /// </summary>
  49. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  50. public long BomMatId { get; set; }
  51. /// <summary>
  52. /// BomMatCode
  53. /// </summary>
  54. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  55. public string BomMatCode { get; set; }
  56. /// <summary>
  57. /// BomMatName
  58. /// </summary>
  59. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  60. public string BomMatName { get; set; }
  61. /// <summary>
  62. /// BomSetId
  63. /// </summary>
  64. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  65. public long BomSetId { get; set; }
  66. /// <summary>
  67. /// ExecStateCode
  68. /// </summary>
  69. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  70. public string ExecStateCode { get; set; }
  71. /// <summary>
  72. /// ExecDocsNo
  73. /// </summary>
  74. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  75. public string ExecDocsNo { get; set; }
  76. /// <summary>
  77. /// ExecDocsRowNo
  78. /// </summary>
  79. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  80. public string ExecDocsRowNo { get; set; }
  81. /// <summary>
  82. /// ExecDocsTypeCode
  83. /// </summary>
  84. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  85. public string ExecDocsTypeCode { get; set; }
  86. /// <summary>
  87. /// InvInOut
  88. /// </summary>
  89. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  90. public int InvInOut { get; set; }
  91. /// <summary>
  92. /// ExecWho
  93. /// </summary>
  94. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  95. public string ExecWho { get; set; }
  96. /// <summary>
  97. /// ExecTime
  98. /// </summary>
  99. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  100. public DateTime ExecTime { get; set; }
  101. /// <summary>
  102. /// PutRow
  103. /// </summary>
  104. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  105. public int PutRow { get; set; }
  106. /// <summary>
  107. /// PutCol
  108. /// </summary>
  109. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  110. public int PutCol { get; set; }
  111. /// <summary>
  112. /// PutLayer
  113. /// </summary>
  114. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  115. public int PutLayer { get; set; }
  116. /// <summary>
  117. /// InvBarCode
  118. /// </summary>
  119. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  120. public string InvBarCode { get; set; }
  121. /// <summary>
  122. /// InvStateCode
  123. /// </summary>
  124. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  125. public string InvStateCode { get; set; }
  126. /// <summary>
  127. /// InDocsNo
  128. /// </summary>
  129. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  130. public string InDocsNo { get; set; }
  131. /// <summary>
  132. /// InDocsRowNo
  133. /// </summary>
  134. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  135. public string InDocsRowNo { get; set; }
  136. /// <summary>
  137. /// SuppCode
  138. /// </summary>
  139. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  140. public string SuppCode { get; set; }
  141. /// <summary>
  142. /// SuppName
  143. /// </summary>
  144. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  145. public string SuppName { get; set; }
  146. /// <summary>
  147. /// CustCode
  148. /// </summary>
  149. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  150. public string CustCode { get; set; }
  151. /// <summary>
  152. /// CustName
  153. /// </summary>
  154. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  155. public string CustName { get; set; }
  156. /// <summary>
  157. /// MatId
  158. /// </summary>
  159. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  160. public long MatId { get; set; }
  161. /// <summary>
  162. /// MatCode
  163. /// </summary>
  164. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  165. public string MatCode { get; set; }
  166. /// <summary>
  167. /// MatName
  168. /// </summary>
  169. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  170. public string MatName { get; set; }
  171. /// <summary>
  172. /// TolWQty
  173. /// </summary>
  174. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  175. public decimal TolWQty { get; set; }
  176. /// <summary>
  177. /// NetWQty
  178. /// </summary>
  179. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  180. public decimal NetWQty { get; set; }
  181. /// <summary>
  182. /// TareWQty
  183. /// </summary>
  184. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  185. public decimal TareWQty { get; set; }
  186. /// <summary>
  187. /// LengthQty
  188. /// </summary>
  189. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  190. public decimal LengthQty { get; set; }
  191. /// <summary>
  192. /// CaQty
  193. /// </summary>
  194. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  195. public decimal CaQty { get; set; }
  196. /// <summary>
  197. /// SolderQty
  198. /// </summary>
  199. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = false)]
  200. public decimal SolderQty { get; set; }
  201. /// <summary>
  202. /// ContUsageQty
  203. /// </summary>
  204. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  205. public int ContUsageQty { get; set; }
  206. /// <summary>
  207. /// BatchNo
  208. /// </summary>
  209. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  210. public string BatchNo { get; set; }
  211. /// <summary>
  212. /// ProductTime
  213. /// </summary>
  214. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  215. public DateTime ProductTime { get; set; }
  216. /// <summary>
  217. /// OneInTime
  218. /// </summary>
  219. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  220. public DateTime OneInTime { get; set; }
  221. /// <summary>
  222. /// RodBarCode
  223. /// </summary>
  224. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  225. public string RodBarCode { get; set; }
  226. /// <summary>
  227. /// HWBarCode
  228. /// </summary>
  229. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  230. public string HWBarCode { get; set; }
  231. /// <summary>
  232. /// RFIDBarCode
  233. /// </summary>
  234. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  235. public string RFIDBarCode { get; set; }
  236. /// <summary>
  237. /// CLBarCode
  238. /// </summary>
  239. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  240. public string CLBarCode { get; set; }
  241. /// <summary>
  242. /// HWTypeCode
  243. /// </summary>
  244. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  245. public string HWTypeCode { get; set; }
  246. /// <summary>
  247. /// BoilerNo
  248. /// </summary>
  249. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  250. public string BoilerNo { get; set; }
  251. /// <summary>
  252. /// PackNo
  253. /// </summary>
  254. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  255. public string PackNo { get; set; }
  256. /// <summary>
  257. /// BrandNo
  258. /// </summary>
  259. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  260. public string BrandNo { get; set; }
  261. /// <summary>
  262. /// ExecStd
  263. /// </summary>
  264. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  265. public string ExecStd { get; set; }
  266. /// <summary>
  267. /// LicenceCode
  268. /// </summary>
  269. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  270. public string LicenceCode { get; set; }
  271. /// <summary>
  272. /// IsSurplus
  273. /// </summary>
  274. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  275. public bool IsSurplus { get; set; }
  276. /// <summary>
  277. /// IsRework
  278. /// </summary>
  279. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  280. public bool IsRework { get; set; }
  281. /// <summary>
  282. /// IsBlack
  283. /// </summary>
  284. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  285. public bool IsBlack { get; set; }
  286. /// <summary>
  287. /// IsCore
  288. /// </summary>
  289. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  290. public bool IsCore { get; set; }
  291. /// <summary>
  292. /// IsFast
  293. /// </summary>
  294. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  295. public bool IsFast { get; set; }
  296. /// <summary>
  297. /// IsFail
  298. /// </summary>
  299. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  300. public bool IsFail { get; set; }
  301. /// <summary>
  302. /// FailReason
  303. /// </summary>
  304. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  305. public string FailReason { get; set; }
  306. /// <summary>
  307. /// SilkTypeCode
  308. /// </summary>
  309. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  310. public string SilkTypeCode { get; set; }
  311. /// <summary>
  312. /// Grade
  313. /// </summary>
  314. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  315. public string Grade { get; set; }
  316. /// <summary>
  317. /// IsBack
  318. /// </summary>
  319. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  320. public bool IsBack { get; set; }
  321. /// <summary>
  322. /// BackReason
  323. /// </summary>
  324. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  325. public string BackReason { get; set; }
  326. /// <summary>
  327. /// IsTorsChk
  328. /// </summary>
  329. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  330. public bool IsTorsChk { get; set; }
  331. /// <summary>
  332. /// TorsChkQty
  333. /// </summary>
  334. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  335. public int TorsChkQty { get; set; }
  336. /// <summary>
  337. /// TorsChkTime
  338. /// </summary>
  339. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  340. public DateTime TorsChkTime { get; set; }
  341. /// <summary>
  342. /// TorsChkValue
  343. /// </summary>
  344. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 6, IsNullable = true)]
  345. public decimal? TorsChkValue { get; set; }
  346. /// <summary>
  347. /// TorsChkMachCode
  348. /// </summary>
  349. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  350. public string TorsChkMachCode { get; set; }
  351. /// <summary>
  352. /// ProcessDocsCode
  353. /// </summary>
  354. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  355. public string ProcessDocsCode { get; set; }
  356. /// <summary>
  357. /// ProductMachCode
  358. /// </summary>
  359. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  360. public string ProductMachCode { get; set; }
  361. /// <summary>
  362. /// ProductLineNo
  363. /// </summary>
  364. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  365. public string ProductLineNo { get; set; }
  366. /// <summary>
  367. /// 货物大小
  368. /// </summary>
  369. [SugarColumn(IsNullable = false)]
  370. public int Size { get; set; }
  371. /// <summary>
  372. /// 1 放行/ 2 冻结 ERP使用
  373. /// </summary>
  374. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  375. public string State { get; set; }
  376. /// <summary>
  377. /// 销售发货单预冻结
  378. /// </summary>
  379. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  380. public string SalesDoc { get; set; }
  381. /// <summary>
  382. /// 箱总量
  383. /// </summary>
  384. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  385. public string HuTotalWt { get; set; }
  386. /// <summary>
  387. /// MesFlag
  388. /// </summary>
  389. [SugarColumn(ColumnDataType = "int", IsNullable = true)]
  390. public int MesFlag { get; set; }
  391. }
  392. }