AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/FinishedWarehouse/Dto/ProductionInboundDto.cs

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

/// <summary>
/// S7 生产入库单列表 查询入参（只读）。
///
/// 数据源：aidopdev.NbrMaster ⋈ NbrDetail（Type='WOI' 生产入库、IsActive=1），按证据 sql.txt 口径
/// join DepartmentMaster / ItemMaster；明细粒度（一行一 NbrDetail）。
/// Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析，默认 8010。
/// NbrMaster 无 tenant_id；TenantId 仅为前端 withAidopTenantParams 注入的透传参数，本查询不据其过滤。
/// </summary>
public class ProductionInboundListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

    /// <summary>入库单号（NbrMaster.Nbr，模糊匹配）</summary>
    public string? InboundNo { get; set; }

    /// <summary>工单号（NbrDetail.WorkOrd，模糊匹配）</summary>
    public string? WorkOrderNo { get; set; }

    /// <summary>ERP工单号（NbrDetail.Address，模糊匹配）</summary>
    public string? ErpWorkOrderNo { get; set; }

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

    /// <summary>入库日期起（NbrMaster.Date，含当日，yyyy-MM-dd）</summary>
    public string? InboundDateStart { get; set; }

    /// <summary>入库日期止（NbrMaster.Date，含当日，yyyy-MM-dd）</summary>
    public string? InboundDateEnd { get; set; }

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

/// <summary>
/// S7 生产入库单列表 行（只读）。字段对齐前端列 prop（camelCase），源列见注释（sql.txt / NbrMaster+NbrDetail Type='WOI'）。
/// </summary>
public class ProductionInboundListRow
{
    /// <summary>入库单号（NbrMaster.Nbr）</summary>
    public string? InboundNo { get; set; }

    /// <summary>项次（NbrDetail.Line）</summary>
    public int? LineNo { get; set; }

    /// <summary>入库日期（NbrMaster.Date）</summary>
    public DateTime? InboundDate { get; set; }

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

    /// <summary>入库类型（NbrMaster.Remark）</summary>
    public string? InboundType { get; set; }

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

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

    /// <summary>ERP工单号（NbrDetail.Address）</summary>
    public string? ErpWorkOrderNo { get; set; }

    /// <summary>物料编码（NbrDetail.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>入库位（NbrDetail.LocationTo）</summary>
    public string? InboundLocation { get; set; }

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

    /// <summary>数量（NbrDetail.QtyRec，入库数量）</summary>
    public decimal? Qty { get; set; }

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

    /// <summary>相关单号（NbrDetail.OrdNbr）</summary>
    public string? RelatedBillNo { get; set; }

    /// <summary>创建时间（NbrDetail.CreateTime）</summary>
    public DateTime? CreateTime { get; set; }
}