fjBillInventory.cs 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. namespace wms.sqlsugar.model.fj
  6. {
  7. [Tenant("fj")]
  8. [SugarTable("bill_inventory", "库存表")]
  9. public class fjBillInventory : BaseModel
  10. {
  11. /// <summary>
  12. /// 单据号
  13. /// </summary>
  14. [SugarColumn(ColumnName = "bill_code", ColumnDataType = "nvarchar", Length = 100)]
  15. public string BillCode { get; set; }
  16. /// <summary>
  17. /// 单据明细Id
  18. /// </summary>
  19. [SugarColumn(ColumnName = "bill_row_id")]
  20. public long BillRowId { get; set; }
  21. /// <summary>
  22. /// 当前库存数量
  23. /// </summary>
  24. [SugarColumn(ColumnName = "cur_qty", Length = 18 ,DecimalDigits = 6)]
  25. public decimal CurQty { get; set; }
  26. /// <summary>
  27. /// 出入库数量
  28. /// </summary>
  29. [SugarColumn(ColumnName = "qty", Length = 18, DecimalDigits = 6)]
  30. public decimal Qty { get; set; }
  31. /// <summary>
  32. /// 炉号
  33. /// </summary>
  34. [SugarColumn(ColumnName = "boiler_no", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  35. public string BoilerNo { get; set; }
  36. /// <summary>
  37. /// 包号
  38. /// </summary>
  39. [SugarColumn(ColumnName = "pack_no", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  40. public string PackNo { get; set; }
  41. /// <summary>
  42. /// 材料号
  43. /// </summary>
  44. [SugarColumn(ColumnName = "mat_barcode", ColumnDataType = "nvarchar", Length = 50)]
  45. public string MatBarCode { get; set; }
  46. /// <summary>
  47. /// RFID
  48. /// </summary>
  49. [SugarColumn(ColumnName = "rfid", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  50. public string RFID { get; set; }
  51. /// <summary>
  52. /// 状态
  53. /// </summary>
  54. [SugarColumn(ColumnName = "state", ColumnDataType = "nvarchar", Length = 10, IsNullable = true)]
  55. public string State { get; set; }
  56. /// <summary>
  57. /// 物料编码
  58. /// </summary>
  59. [SugarColumn(ColumnName = "mat_code", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  60. public string MatCode { get; set; }
  61. /// <summary>
  62. /// 组盘明细Id
  63. /// </summary>
  64. [SugarColumn(ColumnName = "stock_row_id", IsNullable = true)]
  65. public long StockRowId { get; set; }
  66. /// <summary>
  67. /// 仓库编码
  68. /// </summary>
  69. [SugarColumn(ColumnName = "ware_code", ColumnDataType = "nvarchar", Length = 50)]
  70. public string WareCode { get; set; }
  71. /// <summary>
  72. /// 快投标记
  73. /// </summary>
  74. [SugarColumn(ColumnName = "is_fast", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  75. public string IsFast { get; set; }
  76. /// <summary>
  77. /// 等级
  78. /// </summary>
  79. [SugarColumn(ColumnName = "grade", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  80. public string Grade { get; set; }
  81. /// <summary>
  82. /// 改手盘标记
  83. /// </summary>
  84. [SugarColumn(ColumnName = "is_surplus", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  85. public string IsSurplus { get; set; }
  86. /// <summary>
  87. /// 返工标记
  88. /// </summary>
  89. [SugarColumn(ColumnName = "is_rework", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  90. public string IsRework { get; set; }
  91. /// <summary>
  92. /// 箱号
  93. /// </summary>
  94. [SugarColumn(ColumnName = "box_no", ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  95. public string BoxNo { get; set; }
  96. /// <summary>
  97. /// 预留字段1
  98. /// </summary>
  99. [SugarColumn(ColumnName = "default1", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  100. public string Default1 { get; set; }
  101. /// <summary>
  102. /// 预留字段2
  103. /// </summary>
  104. [SugarColumn(ColumnName = "default2", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  105. public string Default2 { get; set; }
  106. /// <summary>
  107. /// 预留字段3
  108. /// </summary>
  109. [SugarColumn(ColumnName = "default3", ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  110. public string Default3 { get; set; }
  111. }
  112. }