BillInventoryReport.cs 2.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. using System;
  2. using System.Collections.Generic;
  3. using SqlSugar;
  4. using WMS.BZModels;
  5. namespace wms.sqlsugar.model.cp
  6. {
  7. [Tenant("cp")]
  8. [SugarTable("Bill_InventoryReport")]
  9. public class BillInventoryReport : BaseModel
  10. {
  11. /// <summary>
  12. /// 年月
  13. /// </summary>
  14. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false)]
  15. public string DateMonth { get; set; }
  16. /// <summary>
  17. /// 类别
  18. /// </summary>
  19. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = false, ColumnDescription = "类别")]
  20. public string NameType { get; set; }
  21. /// <summary>
  22. /// 期初
  23. /// </summary>
  24. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 3, IsNullable = false)]
  25. public decimal BeginQty { get; set; }
  26. /// <summary>
  27. /// 期末
  28. /// </summary>
  29. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 3, IsNullable = false)]
  30. public decimal EndQty { get; set; }
  31. /// <summary>
  32. /// 入库量
  33. /// </summary>
  34. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 3, IsNullable = false)]
  35. public decimal StockInQty { get; set; }
  36. /// <summary>
  37. /// 销售出库
  38. /// </summary>
  39. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 3, IsNullable = false)]
  40. public decimal SalesStockOutQty { get; set; }
  41. /// <summary>
  42. /// 退生产(生产出库)
  43. /// </summary>
  44. [SugarColumn(ColumnDataType = "decimal", Length = 18, DecimalDigits = 3, IsNullable = false)]
  45. public decimal ProductStockOutQty { get; set; }
  46. /// <summary>
  47. /// 手动出库
  48. /// </summary>
  49. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false, ColumnDescription = "手动出库")]
  50. public decimal ManualStockOutQty { get; set; }
  51. /// <summary>
  52. /// 开始时间(上个月最后一天的8:30)
  53. /// </summary>
  54. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  55. public DateTime StartTime { get; set; }
  56. /// <summary>
  57. /// 结束时间(当月最后一天的8:30)
  58. /// </summary>
  59. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  60. public DateTime EndTime { get; set; }
  61. }
  62. }