ptBillInvFlow.cs 14 KB

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