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

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

/// <summary>
/// S5 进出存查询 列表查询入参（只读）。
///
/// 数据源：aidopdev.InvTransHist（库存交易流水），按证据 sql.txt 口径 join
/// GeneralizedCodeMaster(交易类型名)/LocationMaster(货位名)/ItemMaster(物料名/单位)。
/// 进出存口径由 SQL 内定义：期初=BeginBalance；入库=QtyChange&gt;0?QtyChange:0；
/// 出库=QtyChange&lt;0?abs(QtyChange):0；期末=BeginBalance+QtyChange。
/// Domain 由 GeneralizedCodeMaster(SystemConfig/CompanyCode) 解析，默认 8010。
/// InvTransHist 无 tenant_id；TenantId 仅为前端 withAidopTenantParams 注入的透传参数，本查询不据其过滤。
/// </summary>
public class InoutQueryListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

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

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

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

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

    /// <summary>交易类型（InvTransHist.TransType 代码，精确匹配，下拉选择）</summary>
    public string? TransType { get; set; }

    /// <summary>创建时间（InvTransHist.CreateTime 当日，yyyy-MM-dd）</summary>
    public string? CreateTime { get; set; }

    /// <summary>创建用户（InvTransHist.CreateUser，模糊匹配）</summary>
    public string? CreateUser { get; set; }

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

/// <summary>
/// S5 进出存查询 列表行（只读）。字段对齐前端列 prop（camelCase），源列见注释（sql.txt / InvTransHist）。
/// </summary>
public class InoutQueryListRow
{
    /// <summary>交易时间（InvTransHist.CreateTime）</summary>
    public DateTime? TransTime { get; set; }

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

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

    /// <summary>货位（InvTransHist.Loc）</summary>
    public string? Location { get; set; }

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

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

    /// <summary>期初数（InvTransHist.BeginBalance）</summary>
    public decimal? BeginQty { get; set; }

    /// <summary>入库数（QtyChange&gt;0?QtyChange:0）</summary>
    public decimal? InQty { get; set; }

    /// <summary>出库数（QtyChange&lt;0?abs(QtyChange):0）</summary>
    public decimal? OutQty { get; set; }

    /// <summary>期末数（BeginBalance+QtyChange）</summary>
    public decimal? EndQty { get; set; }

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

    /// <summary>交易类型（GeneralizedCodeMaster TransType.Comments 名称，无解码回落代码）</summary>
    public string? TransType { get; set; }

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

    /// <summary>发货单号（InvTransHist.ShipperNum）</summary>
    public string? DeliveryNo { get; set; }

    /// <summary>发货类型（InvTransHist.ShipType）</summary>
    public string? DeliveryType { get; set; }

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

    /// <summary>创建用户（InvTransHist.CreateUser）</summary>
    public string? CreateUser { get; set; }
}

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

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

/// <summary>交易类型下拉选项（GeneralizedCodeMaster TransType：Val 代码 + Comments 名称）。</summary>
public class InoutQueryTransTypeOption
{
    /// <summary>交易类型代码（GeneralizedCodeMaster.Val）</summary>
    public string? Val { get; set; }

    /// <summary>交易类型名称（GeneralizedCodeMaster.Comments）</summary>
    public string? Label { get; set; }
}