BillInvnow.cs 14 KB

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