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

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

/// <summary>
/// S5 标签查询 列表查询入参（只读）。
///
/// 数据源：aidopdev.MissedPrint（legacy 标签/条码记录表，只读）。
/// 状态描述经 GeneralizedCodeMaster(FldName='BarcodeStatus') 解码。
/// MissedPrint 无 tenant_id 列，TenantId 仅为前端 withAidopTenantParams 注入的透传参数，本查询不据其过滤（对齐既有 MissedPrint 只读投影先例，按工厂域隔离为后续独立议题）。
/// </summary>
public class LabelQueryListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

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

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

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

    /// <summary>货架（Shelf，模糊匹配）</summary>
    public string? Shelf { get; set; }

    /// <summary>送货单号（ShipperNbr，模糊匹配）</summary>
    public string? ShipperNbr { get; set; }

    /// <summary>状态（Status，精确匹配，下拉选择）</summary>
    public string? Status { get; set; }

    /// <summary>条码（BarCode，模糊匹配）</summary>
    public string? BarCode { get; set; }

    /// <summary>排序字段（前端列 prop：barCode/itemNum/qty/status/lotSerial/location/prodDate/invDate/expireDate）</summary>
    public string? OrderBy { get; set; }

    /// <summary>排序方向（asc / desc）</summary>
    public string? OrderDir { get; set; }

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

/// <summary>
/// S5 标签查询 列表行（只读）。字段对齐前端列 prop（camelCase），源列见注释。
/// </summary>
public class LabelQueryListRow
{
    /// <summary>主键 id（MissedPrint.RecID）</summary>
    public long Id { get; set; }

    /// <summary>条码（BarCode）</summary>
    public string? BarCode { get; set; }

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

    /// <summary>描述（Descr）</summary>
    public string? Descr { get; set; }

    /// <summary>规格型号（Product）</summary>
    public string? Product { get; set; }

    /// <summary>数量（Qty）</summary>
    public decimal? Qty { get; set; }

    /// <summary>状态码（Status）</summary>
    public string? Status { get; set; }

    /// <summary>状态描述（GeneralizedCodeMaster BarcodeStatus 解码；无解码回落原码）</summary>
    public string? StatusDesc { get; set; }

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

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

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

    /// <summary>单据号（OrdNbr）</summary>
    public string? OrdNbr { get; set; }

    /// <summary>包装数量（PackingQty，默认隐藏列）</summary>
    public decimal? PackingQty { get; set; }

    /// <summary>生产日期（ProdDate）</summary>
    public DateTime? ProdDate { get; set; }

    /// <summary>工单编号（WorkOrd）</summary>
    public string? WorkOrd { get; set; }

    /// <summary>生产线（ProdLine）</summary>
    public string? ProdLine { get; set; }

    /// <summary>标签格式（LabelFormat）</summary>
    public string? LabelFormat { get; set; }

    /// <summary>位置（Position，默认隐藏列）</summary>
    public string? Position { get; set; }

    /// <summary>箱号（Carton）</summary>
    public string? Carton { get; set; }

    /// <summary>班次（Period）</summary>
    public int? Period { get; set; }

    /// <summary>供应商（Supply）</summary>
    public string? Supply { get; set; }

    /// <summary>采购单号（PurOrd）</summary>
    public string? PurOrd { get; set; }

    /// <summary>采购单项次（PurLine）</summary>
    public int? PurLine { get; set; }

    /// <summary>送货单号（ShipperNbr）</summary>
    public string? ShipperNbr { get; set; }

    /// <summary>送货单项次（ShipperLine）</summary>
    public int? ShipperLine { get; set; }

    /// <summary>入库日期（InvDate）</summary>
    public DateTime? InvDate { get; set; }

    /// <summary>过期日期（ExpireDate）</summary>
    public DateTime? ExpireDate { get; set; }

    /// <summary>备注（Remark）</summary>
    public string? Remark { get; set; }
}

/// <summary>状态下拉选项（BarcodeStatus 码表：Val=状态码，Label=中文描述）。</summary>
public class LabelQueryStatusOption
{
    /// <summary>状态码（GeneralizedCodeMaster.Val）</summary>
    public string? Val { get; set; }

    /// <summary>中文描述（GeneralizedCodeMaster.Comments）</summary>
    public string? Label { get; set; }
}

/// <summary>库位下拉选项（MissedPrint.Location distinct）。</summary>
public class LabelQueryLocationOption
{
    /// <summary>库位（MissedPrint.Location）</summary>
    public string? Val { get; set; }
}