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

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

/// <summary>
/// S5 盘点结果查询 列表查询入参（只读）。
///
/// 数据源：aidopdev.MissedPrint（盘点标签 IsTag=1），按证据 sql.txt 口径 join ItemMaster(名称/规格/单位)。
/// 盘点口径由 SQL 内定义：账面(标签数量)=Qty；盘点(实盘数量)=CompQty；差异数量=CompQty-Qty；
/// 盘点状态=CompQty≠Qty?'有差异':'正常'；状态=Status='Q'?'冻结':''；实际库位=FirmString2；实际货架=FirmString4。
/// Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析，默认 8010。
/// MissedPrint 无 tenant_id；TenantId 仅为前端 withAidopTenantParams 注入的透传参数，本查询不据其过滤。
/// </summary>
public class StocktakeResultListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

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

    /// <summary>盘点状态（有差异 / 正常，按 CompQty 与 Qty 是否相等过滤）</summary>
    public string? InvStatus { get; set; }

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

/// <summary>
/// S5 盘点结果查询 列表行（只读）。字段对齐前端列 prop（camelCase），源列见注释（sql.txt / MissedPrint IsTag=1）。
/// </summary>
public class StocktakeResultListRow
{
    /// <summary>物料编码（MissedPrint.ItemNum）</summary>
    public string? MaterialCode { get; set; }

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

    /// <summary>规格型号（ItemMaster.Descr1）</summary>
    public string? Spec { get; set; }

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

    /// <summary>货架（MissedPrint.Shelf）</summary>
    public string? Shelf { get; set; }

    /// <summary>实际库位（MissedPrint.FirmString2）</summary>
    public string? ActLocation { get; set; }

    /// <summary>实际货架（MissedPrint.FirmString4）</summary>
    public string? ActShelf { get; set; }

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

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

    /// <summary>标签数量（账面，MissedPrint.Qty）</summary>
    public decimal? TagQty { get; set; }

    /// <summary>实盘数量（MissedPrint.CompQty）</summary>
    public decimal? CountQty { get; set; }

    /// <summary>差异数量（CompQty-Qty）</summary>
    public decimal? QtyDiff { get; set; }

    /// <summary>状态（Status='Q'?'冻结':''）</summary>
    public string? Status { get; set; }

    /// <summary>盘点状态（CompQty≠Qty?'有差异':'正常'）</summary>
    public string? InvStatus { get; set; }

    /// <summary>盘点人（MissedPrint.UpdateUser）</summary>
    public string? CountUser { get; set; }

    /// <summary>盘点时间（MissedPrint.UpdateTime）</summary>
    public DateTime? CountTime { get; set; }
}