AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/MaterialWarehouse/Dto/StockQueryDto.cs

namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.Dto;

/// <summary>
/// S5 库存查询 列表查询入参（只读）。
///
/// 数据源：aidopdev.LocationMaster ⋈ LocationDetail（现存量），按存储过程 pr_WMS_GetMissedLocationQty
/// 口径过滤 (AvailStatusQty+Assay+FreezeQty)&gt;0，join ItemMaster(名称/单位)、富集 MissedPrint(货架/版本/供应商)。
/// Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析，默认 8010。
/// LocationDetail 无 tenant_id 列；TenantId 仅为前端 withAidopTenantParams 注入的透传参数，本查询不据其过滤。
/// </summary>
public class StockQueryListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

    /// <summary>每页条数</summary>
    public int PageSize { get; set; } = 10;

    /// <summary>类型（LocType：VMI / O库，精确匹配，下拉选择）</summary>
    public string? Type { get; set; }

    /// <summary>库位（LocationDetail.Location，精确匹配，下拉选择）</summary>
    public string? Location { get; set; }

    /// <summary>物料编码（LocationDetail.ItemNum，模糊匹配）</summary>
    public string? MaterialCode { get; set; }

    /// <summary>批次号（LocationDetail.LotSerial，模糊匹配）</summary>
    public string? BatchNo { get; set; }

    /// <summary>库存数大于（LocationDetail.QtyOnHand &gt; 值）</summary>
    public decimal? StockGt { get; set; }

    /// <summary>非限制库存大于（LocationDetail.AvailStatusQty &gt; 值）</summary>
    public decimal? UnrestrictedGt { get; set; }

    /// <summary>质检库存大于（LocationDetail.Assay &gt; 值）</summary>
    public decimal? QcStockGt { get; set; }

    /// <summary>冻结库存大于（LocationDetail.FreezeQty &gt; 值）</summary>
    public decimal? FrozenGt { get; set; }

    /// <summary>租户 ID（前端 withAidopTenantParams 注入；LocationDetail 无租户列，本查询忽略）</summary>
    public long? TenantId { get; set; }
}

/// <summary>
/// S5 库存查询 列表行（只读）。字段对齐前端列 prop（camelCase），源列见注释（存储过程 pr_WMS_GetMissedLocationQty）。
/// </summary>
public class StockQueryListRow
{
    /// <summary>类型（LocType：VMI / O库 / 空）</summary>
    public string? Type { get; set; }

    /// <summary>库位（LocationDetail.Location）</summary>
    public string? Location { get; set; }

    /// <summary>库位名称（LocationMaster.Descr）</summary>
    public string? LocationName { get; set; }

    /// <summary>物料编码（LocationDetail.ItemNum）</summary>
    public string? MaterialCode { get; set; }

    /// <summary>物料名称（ItemMaster.Descr）</summary>
    public string? MaterialName { get; set; }

    /// <summary>批次号（LocationDetail.LotSerial）</summary>
    public string? BatchNo { get; set; }

    /// <summary>货架（MissedPrint.Shelf 富集，当前 MissedPrint 空则为空）</summary>
    public string? Shelf { get; set; }

    /// <summary>版本（MissedPrint.LevelChar 富集）</summary>
    public string? Version { get; set; }

    /// <summary>非限制库存（LocationDetail.AvailStatusQty）</summary>
    public decimal? UnrestrictedStock { get; set; }

    /// <summary>质检库存（LocationDetail.Assay）</summary>
    public decimal? QcStock { get; set; }

    /// <summary>冻结库存（LocationDetail.FreezeQty）</summary>
    public decimal? FrozenStock { get; set; }

    /// <summary>库存数量（LocationDetail.QtyOnHand，用于合计，列表默认不展示）</summary>
    public decimal? QtyOnHand { get; set; }

    /// <summary>单位（ItemMaster.UM）</summary>
    public string? Unit { get; set; }

    /// <summary>供应商（MissedPrint.Supply 富集）</summary>
    public string? Supplier { get; set; }
}

/// <summary>类型下拉选项（派生 LocType：VMI / O库）。</summary>
public class StockQueryTypeOption
{
    /// <summary>类型值</summary>
    public string? Val { get; set; }
}

/// <summary>库位下拉选项（LocationMaster.Location + Descr）。</summary>
public class StockQueryLocationOption
{
    /// <summary>库位（LocationMaster.Location）</summary>
    public string? Val { get; set; }

    /// <summary>库位名称（LocationMaster.Descr）</summary>
    public string? Label { get; set; }
}