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; }
}