using Admin.NET.Core; using System.Security.AccessControl; namespace Admin.NET.Application.Entity; /// /// --物料汇总库存 ///可用库存、总库存、锁定库存、库位、库区、物料、跟踪码等 ///查询条件: 库存状态=3(已上架)且库存质检状态=2(合格)【add by liuwq, 2024/06/14】 /// [MySugarTableViewAttribute("v_wms_stock_quan_group", "物料汇总库存")] public class v_wms_stock_quan_group { /// /// 物料编码 /// [Required] [SugarColumn(ColumnName = "MaterialCode", ColumnDescription = "物料编码", Length = 50)] public string MaterialCode { get; set; } /// /// 物料名称 /// [SugarColumn(ColumnName = "MaterialName", ColumnDescription = "物料名称", Length = 50)] public string? MaterialName { get; set; } /// /// 库存单位 /// [SugarColumn(ColumnName = "MaterialUnit", ColumnDescription = "库存单位", Length = 50)] public string? MaterialUnit { get; set; } ///// ///// 采购单位 ///// //[SugarColumn(ColumnName = "POUnit", ColumnDescription = "采购单位", Length = 50)] //public string? POUnit { get; set; } /// ///全部库存 /// [SugarColumn(ColumnName = "Quantity", ColumnDescription = "全部库存", Length = 10, DecimalDigits = 3)] public decimal Quantity { get; set; } /// ///预配数 /// [SugarColumn(ColumnName = "PredetermineLockedQty", ColumnDescription = "预配数", Length = 10, DecimalDigits = 3)] public decimal PredetermineLockedQty { get; set; } /// ///理论可用库存(包含了预配数) /// [SugarColumn(ColumnName = "TheoryUseQty", ColumnDescription = "理论可用库存(包含了预配数)", Length = 10, DecimalDigits = 3)] public decimal TheoryUseQty { get; set; } /// ///可用库存 /// [SugarColumn(ColumnName = "UseQty", ColumnDescription = "可用库存", Length = 10, DecimalDigits = 3)] public decimal UseQty { get; set; } /// ///其他不可用库存 /// [SugarColumn(ColumnName = "OtherLockQty", ColumnDescription = "其他不可用库存", Length = 10, DecimalDigits = 3)] public decimal OtherLockQty { get; set; } }