BillInvflowHty.cs 17 KB

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