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

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

/// <summary>
/// S5 来料检验单（qms_qcp_inspbill）只读列表 查询入参。
///
/// 数据源：aidopdev.qms_qcp_inspbill 单表直读（不 join 申请主表/明细/SuppMaster/ApprovalFlow）。
/// 该表**无 tenant_id**：TenantId 仅前端 withAidopTenantParams 注入，本查询接收即忽略、不做租户过滤。
/// FORGID 当前全 NULL：ForgId 接收但本批不生效、不加 WHERE。
/// pd/clfs/FBILLSTATUS 字典未闭合，raw 展示，不做映射。仅 SELECT，无写入/详情/流程/SQE。
/// </summary>
public class IqcInspBillListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

    /// <summary>检验单号（FBILLNO，模糊）</summary>
    public string? BillNo { get; set; }

    /// <summary>来源单号（lydjbh，模糊）</summary>
    public string? SourceBillNo { get; set; }

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

    /// <summary>物料名称（wlmc，模糊）</summary>
    public string? MaterialName { get; set; }

    /// <summary>供应商（gysmc，模糊）</summary>
    public string? SupplierName { get; set; }

    /// <summary>批次（pch，模糊）</summary>
    public string? LotNo { get; set; }

    /// <summary>检验状态（FBILLSTATUS，等值，raw）</summary>
    public string? BillStatus { get; set; }

    /// <summary>判定（pd，等值，raw；前端本批不展示，后端接收）</summary>
    public long? Judgement { get; set; }

    /// <summary>处理方式（clfs，等值，raw；前端本批不展示，后端接收）</summary>
    public long? ProcessMethod { get; set; }

    /// <summary>检验员（FINSPECTORID，模糊）</summary>
    public string? Inspector { get; set; }

    /// <summary>检验开始日期起（FINSPESTARTDATE，含当日，yyyy-MM-dd）</summary>
    public string? InspectDateFrom { get; set; }

    /// <summary>检验开始日期止（FINSPESTARTDATE，含当日，yyyy-MM-dd）</summary>
    public string? InspectDateTo { get; set; }

    /// <summary>创建日期起（FCREATETIME，含当日；前端本批不展示，后端接收）</summary>
    public string? CreateDateFrom { get; set; }

    /// <summary>创建日期止（FCREATETIME，含当日；前端本批不展示，后端接收）</summary>
    public string? CreateDateTo { get; set; }

    /// <summary>组织（FORGID）——本批不生效（FORGID 全 NULL），接收不过滤</summary>
    public long? ForgId { get; set; }

    /// <summary>排序字段（白名单：billNo/sourceBillNo/materialCode/materialName/supplierName/lotNo/billStatus/judgement/inspectDate/createTime）</summary>
    public string? OrderBy { get; set; }

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

    /// <summary>租户 ID——本批不生效（表无 tenant_id），接收不过滤</summary>
    public long? TenantId { get; set; }
}

/// <summary>
/// S5 来料检验单（qms_qcp_inspbill）只读列表 行。字段对齐前端列 prop（camelCase），源列见注释。
/// </summary>
public class IqcInspBillListRow
{
    /// <summary>主键（qms_qcp_inspbill.id）</summary>
    public long? Id { get; set; }

    /// <summary>检验单号（FBILLNO）</summary>
    public string? BillNo { get; set; }

    /// <summary>来源单号（lydjbh → 申请单 FBILLNO，本批不 join，仅原值）</summary>
    public string? SourceBillNo { get; set; }

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

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

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

    /// <summary>供应商（gysmc，已内嵌）</summary>
    public string? SupplierName { get; set; }

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

    /// <summary>报检数量（FRINSQTY）</summary>
    public decimal? ReportQty { get; set; }

    /// <summary>检验数量（jysl）</summary>
    public decimal? InspectQty { get; set; }

    /// <summary>合格数量（dhsl）</summary>
    public decimal? QualifiedQty { get; set; }

    /// <summary>不合格数量（bhgsl）</summary>
    public decimal? UnqualifiedQty { get; set; }

    /// <summary>判定（pd，raw）</summary>
    public long? Judgement { get; set; }

    /// <summary>处理方式（clfs，raw）</summary>
    public long? ProcessMethod { get; set; }

    /// <summary>状态（FBILLSTATUS，raw）</summary>
    public string? BillStatus { get; set; }

    /// <summary>检验员（FINSPECTORID）</summary>
    public string? Inspector { get; set; }

    /// <summary>检验开始时间（FINSPESTARTDATE）</summary>
    public DateTime? InspectStartDate { get; set; }

    /// <summary>检验结束时间（FINSPEENDDATE）</summary>
    public DateTime? InspectEndDate { get; set; }

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

    /// <summary>组织（FORGID，当前全 NULL）</summary>
    public long? OrgId { get; set; }
}

/// <summary>
/// S5 来料检验单（qms_qcp_inspbill）只读详情 行。约 35 展示字段 + 流程占位（BizType/BizId/BizCode）。
/// 单表按 id 直读，不 join，不查字典（pd/clfs/FBILLSTATUS/pcsq/blwtflid/FBIZTYPE 全 raw）。流程占位由服务拼装，不查 ApprovalFlow。
/// </summary>
public class IqcInspBillDetailRow
{
    // ── A 基本信息 ──
    /// <summary>主键（id）</summary>
    public long? Id { get; set; }
    /// <summary>检验单号（FBILLNO）</summary>
    public string? BillNo { get; set; }
    /// <summary>来源单号（lydjbh）</summary>
    public string? SourceBillNo { get; set; }
    /// <summary>单据状态（FBILLSTATUS，raw）</summary>
    public string? BillStatus { get; set; }
    /// <summary>业务类型（FBIZTYPE，raw）</summary>
    public long? BizTypeRaw { get; set; }
    /// <summary>组织（FORGID）</summary>
    public long? OrgId { get; set; }
    /// <summary>创建时间（FCREATETIME）</summary>
    public DateTime? CreateTime { get; set; }
    /// <summary>创建人（FCREATORID）</summary>
    public long? CreateUserId { get; set; }
    /// <summary>更新时间（FMODIFYTIME）</summary>
    public DateTime? UpdateTime { get; set; }
    /// <summary>修改人（FMODIFIERID）</summary>
    public long? UpdateUserId { get; set; }

    // ── B 物料与供应商 ──
    /// <summary>物料编码（FMATERIALCFG）</summary>
    public string? MaterialCode { get; set; }
    /// <summary>物料名称（wlmc）</summary>
    public string? MaterialName { get; set; }
    /// <summary>规格型号（ggxh）</summary>
    public string? Spec { get; set; }
    /// <summary>供应商（gysmc）</summary>
    public string? SupplierName { get; set; }
    /// <summary>批次（pch）</summary>
    public string? LotNo { get; set; }
    /// <summary>检规编号（jgbh）</summary>
    public string? InspectionSpecNo { get; set; }
    /// <summary>检规版本（jgbb）</summary>
    public string? InspectionSpecVersion { get; set; }
    /// <summary>检规生效日期（jgsxrq）</summary>
    public string? InspectionSpecEffectiveDate { get; set; }

    // ── C 检验数量 ──
    /// <summary>报检数量（FRINSQTY）</summary>
    public decimal? ReportQty { get; set; }
    /// <summary>检验数量（jysl）</summary>
    public decimal? InspectQty { get; set; }
    /// <summary>样本数量（SampleQty）</summary>
    public decimal? SampleQty { get; set; }
    /// <summary>测试数量（TestQty）</summary>
    public decimal? TestQty { get; set; }
    /// <summary>合格数量（dhsl）</summary>
    public decimal? QualifiedQty { get; set; }
    /// <summary>不合格数量（bhgsl）</summary>
    public decimal? UnqualifiedQty { get; set; }
    /// <summary>破坏数量（phsl）</summary>
    public decimal? DestructiveQty { get; set; }
    /// <summary>留样数量（lysl）</summary>
    public decimal? RetainSampleQty { get; set; }

    // ── D 检验执行 ──
    /// <summary>检验员（FINSPECTORID）</summary>
    public string? Inspector { get; set; }
    /// <summary>检验人（jyr）</summary>
    public string? InspectorName { get; set; }
    /// <summary>检验开始时间（FINSPESTARTDATE）</summary>
    public DateTime? InspectStartDate { get; set; }
    /// <summary>检验结束时间（FINSPEENDDATE）</summary>
    public DateTime? InspectEndDate { get; set; }
    /// <summary>判定（pd，raw）</summary>
    public long? Judgement { get; set; }
    /// <summary>处理方式（clfs，raw）</summary>
    public long? ProcessMethod { get; set; }

    // ── E 不合格与偏差 ──
    /// <summary>不合格描述（UnqualifiedDescription）</summary>
    public string? UnqualifiedDescription { get; set; }
    /// <summary>退货原因（thyy）</summary>
    public string? ReturnReason { get; set; }
    /// <summary>不良分类 id（blwtflid，raw）</summary>
    public long? DefectCategoryId { get; set; }
    /// <summary>不良分类名（blwtflmc）</summary>
    public string? DefectCategoryName { get; set; }
    /// <summary>偏差申请（pcsq，raw）</summary>
    public int? DeviationApply { get; set; }
    /// <summary>偏差说明（pcsm）</summary>
    public string? DeviationDescription { get; set; }

    // ── F 审核信息（仅展示，不作流程依据）──
    /// <summary>主管候选（leader）</summary>
    public string? Leader { get; set; }
    /// <summary>审核人（FAUDITORID）</summary>
    public long? AuditorId { get; set; }
    /// <summary>审核时间（FAUDITDATE）</summary>
    public DateTime? AuditDate { get; set; }

    // ── G 流程占位（服务拼装，不查 ApprovalFlow）──
    /// <summary>流程 BizType（固定 S5_IQC_INSPBILL）</summary>
    public string? BizType { get; set; }
    /// <summary>流程 BizId（=id）</summary>
    public long? BizId { get; set; }
    /// <summary>流程 BizCode（=FBILLNO）</summary>
    public string? BizCode { get; set; }
    /// <summary>流程提示</summary>
    public string? FlowHint { get; set; }
}