BillInvnow.cs 14 KB

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