AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Manufacturing/Dto/IpqcInspectionDto.cs

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

/// <summary>
/// S6 过程检验单（IPQC）列表 查询入参（只读）。读 mdp_std_ipqc_inspection。
/// 查询条件对齐旧系统「过程检验单列表」页：单据编号 + 生产批号。
/// </summary>
public class IpqcInspectionListInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

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

    /// <summary>单据编号（bill_no，模糊匹配）</summary>
    public string? BillNo { get; set; }

    /// <summary>生产批号（production_batch_no，模糊匹配）</summary>
    public string? ProductionBatchNo { get; set; }

    /// <summary>排序字段（前端列 prop：billNo / effectiveDate）</summary>
    public string? SortField { get; set; }

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

    /// <summary>租户 ID（前端 withAidopTenantParams 注入；为空则不按租户过滤）</summary>
    public long? TenantId { get; set; }
}

/// <summary>
/// S6 过程检验单（IPQC）列表 行（只读）。字段对齐前端骨架列 prop（camelCase）。
/// 全部来自过程检验单头表 qms_gcjyd（归口后 mdp_std_ipqc_inspection）。
/// </summary>
public class IpqcInspectionListRow
{
    /// <summary>主键 id（mdp_std_ipqc_inspection.id）</summary>
    public long Id { get; set; }

    /// <summary>单据编号（bill_no ← qms_gcjyd.djbh）</summary>
    public string? BillNo { get; set; }

    /// <summary>产品型号（product_model ← cplx）</summary>
    public string? ProductModel { get; set; }

    /// <summary>生产批号（production_batch_no ← scph）</summary>
    public string? ProductionBatchNo { get; set; }

    /// <summary>生产工单（production_work_order ← lydjbh 来源单据编号）</summary>
    public string? ProductionWorkOrder { get; set; }

    /// <summary>结果判定（result_judgement ← jgpd，字典码原样透出，语义解码后置）</summary>
    public string? ResultJudgement { get; set; }

    /// <summary>附件（attachment ← fj）</summary>
    public string? Attachment { get; set; }

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

    /// <summary>检验人（inspector ← jyr）</summary>
    public string? Inspector { get; set; }

    /// <summary>工序编码（process_code ← gxbm）</summary>
    public string? ProcessCode { get; set; }

    /// <summary>工序名称（process_name ← gxmc）</summary>
    public string? ProcessName { get; set; }

    /// <summary>生产人员（production_person ← sczyry）</summary>
    public string? ProductionPerson { get; set; }

    /// <summary>样本量（sample_qty ← ybl）</summary>
    public decimal? SampleQty { get; set; }

    /// <summary>表单编号（form_no ← bdbh）</summary>
    public string? FormNo { get; set; }

    /// <summary>版本号（version_no ← bbh）</summary>
    public string? VersionNo { get; set; }

    /// <summary>生效日期（effective_date ← sxrq）</summary>
    public DateTime? EffectiveDate { get; set; }

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

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

    /// <summary>检规版本（inspec_standard_version ← jgbb）</summary>
    public string? InspecStandardVersion { get; set; }

    /// <summary>检规编号（inspec_standard_code ← jgbh）</summary>
    public string? InspecStandardCode { get; set; }

    /// <summary>源检验单 id（qms_gcjyd.id = mdp_std.source_row_id；流程 BizId 用此）</summary>
    public long SourceRowId { get; set; }
}

/// <summary>
/// S6 过程检验单（IPQC）详情（只读）：头（mdp_std_ipqc_inspection）+ 明细（mdp_std_ipqc_inspection_detail 确定子集列）。
/// 查不到返回 null。明细为空返回空数组（前端"暂无明细"）。
/// </summary>
public class IpqcInspectionDetailDto
{
    /// <summary>主键 id（mdp_std_ipqc_inspection.id）</summary>
    public long Id { get; set; }
    public string? BillNo { get; set; }
    public string? ProductModel { get; set; }
    public string? ProductionBatchNo { get; set; }
    public string? ProductionWorkOrder { get; set; }
    public string? ResultJudgement { get; set; }
    public string? Attachment { get; set; }
    public string? Remark { get; set; }
    public string? Inspector { get; set; }
    public string? ProcessCode { get; set; }
    public string? ProcessName { get; set; }
    public string? ProductionPerson { get; set; }
    public decimal? SampleQty { get; set; }
    public string? FormNo { get; set; }
    public string? VersionNo { get; set; }
    public DateTime? EffectiveDate { get; set; }
    public string? MaterialCode { get; set; }
    public string? MaterialName { get; set; }
    public string? InspecStandardVersion { get; set; }
    public string? InspecStandardCode { get; set; }
    /// <summary>检验状态（inspection_status ← status）</summary>
    public string? InspectionStatus { get; set; }

    /// <summary>源检验单 id（qms_gcjyd.id = mdp_std.source_row_id；流程 BizId 用此）</summary>
    public long SourceRowId { get; set; }

    /// <summary>明细行（确定子集列；j1~j70 动态检验值列后置不返回）</summary>
    public List<IpqcInspectionDetailLineDto> Lines { get; set; } = new();
}

/// <summary>
/// S6 过程检验单明细行（只读，确定子集列）。源自 qms_gcjydzb → mdp_std_ipqc_inspection_detail。
/// </summary>
public class IpqcInspectionDetailLineDto
{
    public long Id { get; set; }
    /// <summary>检验项目（inspection_item ← jyxm）</summary>
    public string? InspectionItem { get; set; }
    /// <summary>检验依据（inspection_basis ← jyyj）</summary>
    public string? InspectionBasis { get; set; }
    /// <summary>技术标准（technical_standard ← jsbz）</summary>
    public string? TechnicalStandard { get; set; }
    /// <summary>检验方法（inspection_method ← jyff）</summary>
    public string? InspectionMethod { get; set; }
    /// <summary>上限（upper_limit ← sx）</summary>
    public string? UpperLimit { get; set; }
    /// <summary>下限（lower_limit ← xx）</summary>
    public string? LowerLimit { get; set; }
    /// <summary>工序编码（process_code ← ProcessCode）</summary>
    public string? ProcessCode { get; set; }
    /// <summary>工序名称（process_name ← ProcessName）</summary>
    public string? ProcessName { get; set; }
    /// <summary>测量仪器（measurement_instrument ← MeasurementInstrument）</summary>
    public string? MeasurementInstrument { get; set; }
    /// <summary>检验人（inspector ← Inspector）</summary>
    public string? Inspector { get; set; }
    /// <summary>检验时间（inspection_time ← InspectionTime）</summary>
    public DateTime? InspectionTime { get; set; }
    /// <summary>样本量（sample_qty ← ybl）</summary>
    public int? SampleQty { get; set; }
    /// <summary>检验数量（inspection_qty ← jysl）</summary>
    public decimal? InspectionQty { get; set; }
    /// <summary>不合格数量（unqualified_qty ← bhgsl）</summary>
    public decimal? UnqualifiedQty { get; set; }
    /// <summary>结果判定（result_judgement ← pd，字典码原样透出）</summary>
    public string? ResultJudgement { get; set; }
    /// <summary>非数值型OK（non_numeric_ok ← NonNumericalTypeOK）</summary>
    public int? NonNumericOk { get; set; }
    /// <summary>非数值型NG（non_numeric_ng ← NonNumericalTypeNG）</summary>
    public int? NonNumericNg { get; set; }
    /// <summary>备注（remark ← bz）</summary>
    public string? Remark { get; set; }
    /// <summary>附件（attachment ← fj）</summary>
    public string? Attachment { get; set; }
}