namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.Dto; /// /// S5 库存查询 列表查询入参(只读)。 /// /// 数据源:aidopdev.LocationMaster ⋈ LocationDetail(现存量),按存储过程 pr_WMS_GetMissedLocationQty /// 口径过滤 (AvailStatusQty+Assay+FreezeQty)>0,join ItemMaster(名称/单位)、富集 MissedPrint(货架/版本/供应商)。 /// Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析,默认 8010。 /// LocationDetail 无 tenant_id 列;TenantId 仅为前端 withAidopTenantParams 注入的透传参数,本查询不据其过滤。 /// public class StockQueryListInput { /// 页码(从 1 开始) public int Page { get; set; } = 1; /// 每页条数 public int PageSize { get; set; } = 10; /// 类型(LocType:VMI / O库,精确匹配,下拉选择) public string? Type { get; set; } /// 库位(LocationDetail.Location,精确匹配,下拉选择) public string? Location { get; set; } /// 物料编码(LocationDetail.ItemNum,模糊匹配) public string? MaterialCode { get; set; } /// 批次号(LocationDetail.LotSerial,模糊匹配) public string? BatchNo { get; set; } /// 库存数大于(LocationDetail.QtyOnHand > 值) public decimal? StockGt { get; set; } /// 非限制库存大于(LocationDetail.AvailStatusQty > 值) public decimal? UnrestrictedGt { get; set; } /// 质检库存大于(LocationDetail.Assay > 值) public decimal? QcStockGt { get; set; } /// 冻结库存大于(LocationDetail.FreezeQty > 值) public decimal? FrozenGt { get; set; } /// 租户 ID(前端 withAidopTenantParams 注入;LocationDetail 无租户列,本查询忽略) public long? TenantId { get; set; } } /// /// S5 库存查询 列表行(只读)。字段对齐前端列 prop(camelCase),源列见注释(存储过程 pr_WMS_GetMissedLocationQty)。 /// public class StockQueryListRow { /// 类型(LocType:VMI / O库 / 空) public string? Type { get; set; } /// 库位(LocationDetail.Location) public string? Location { get; set; } /// 库位名称(LocationMaster.Descr) public string? LocationName { get; set; } /// 物料编码(LocationDetail.ItemNum) public string? MaterialCode { get; set; } /// 物料名称(ItemMaster.Descr) public string? MaterialName { get; set; } /// 批次号(LocationDetail.LotSerial) public string? BatchNo { get; set; } /// 货架(MissedPrint.Shelf 富集,当前 MissedPrint 空则为空) public string? Shelf { get; set; } /// 版本(MissedPrint.LevelChar 富集) public string? Version { get; set; } /// 非限制库存(LocationDetail.AvailStatusQty) public decimal? UnrestrictedStock { get; set; } /// 质检库存(LocationDetail.Assay) public decimal? QcStock { get; set; } /// 冻结库存(LocationDetail.FreezeQty) public decimal? FrozenStock { get; set; } /// 库存数量(LocationDetail.QtyOnHand,用于合计,列表默认不展示) public decimal? QtyOnHand { get; set; } /// 单位(ItemMaster.UM) public string? Unit { get; set; } /// 供应商(MissedPrint.Supply 富集) public string? Supplier { get; set; } } /// 类型下拉选项(派生 LocType:VMI / O库)。 public class StockQueryTypeOption { /// 类型值 public string? Val { get; set; } } /// 库位下拉选项(LocationMaster.Location + Descr)。 public class StockQueryLocationOption { /// 库位(LocationMaster.Location) public string? Val { get; set; } /// 库位名称(LocationMaster.Descr) public string? Label { get; set; } }