AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/AdoS7FqcQeDisposition.cs

using Admin.NET.Core;

namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// S7 成品检验（FQC）不合格 QE 处置记录。
///
/// 不合格成品检验单（qms_qcpp_inspbill.pd="1"）经主管 N2 通过后，GW_RESULT 网关（disposition_required==1）
/// 分流进入 N3_QE_DISPOSITION，质量工程师提交处置方案落此表。
/// 仅"记录处置结论"（disposition_type=REWORK/CONCESSION/SCRAP/OTHER）；
/// 本批不做仓储确认/库存/入库/出库/返工单/报废单/隔离单/附件上传（attachment_json 预留）。
/// 一单一有效处置由 service 校验（status=1 且未软删）+ inspbill_id 唯一约束。
/// 不覆盖 qms_qcpp_inspbill.pd/hgsl/bhgsl/clfs，不写 qms_fqcbj。
/// </summary>
[SugarTable("ado_s7_fqc_qe_disposition", "S7成品检验QE处置")]
[SugarIndex("uk_s7_fqc_disp_inspbill", nameof(InspbillId), OrderByType.Asc, true)]
[SugarIndex("idx_s7_fqc_disp_flow", nameof(FlowInstanceId), OrderByType.Asc)]
[SugarIndex("uk_s7_fqc_disp_no", nameof(DispositionNo), OrderByType.Asc, true)]
public class AdoS7FqcQeDisposition : EntityBaseDel, ITenantIdFilter
{
    /// <summary>租户</summary>
    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户", IsNullable = true)]
    public long? TenantId { get; set; }

    /// <summary>工厂/组织</summary>
    [SugarColumn(ColumnName = "org_id", ColumnDescription = "工厂/组织", IsNullable = true)]
    public long? OrgId { get; set; }

    /// <summary>检验单 id（qms_qcpp_inspbill.id，BizId）</summary>
    [SugarColumn(ColumnName = "inspbill_id", ColumnDescription = "检验单id")]
    public long InspbillId { get; set; }

    /// <summary>检验单号（FBILLNO）</summary>
    [SugarColumn(ColumnName = "inspbill_no", ColumnDescription = "检验单号", Length = 80, IsNullable = true)]
    public string? InspbillNo { get; set; }

    /// <summary>来源单号（lydjbh）</summary>
    [SugarColumn(ColumnName = "source_bill_no", ColumnDescription = "来源单号", Length = 255, IsNullable = true)]
    public string? SourceBillNo { get; set; }

    /// <summary>业务类型（S7_FQC_INSPBILL）</summary>
    [SugarColumn(ColumnName = "biz_type", ColumnDescription = "业务类型", Length = 80, IsNullable = true)]
    public string? BizType { get; set; } = "S7_FQC_INSPBILL";

    /// <summary>流程实例 id</summary>
    [SugarColumn(ColumnName = "flow_instance_id", ColumnDescription = "流程实例id", IsNullable = true)]
    public long? FlowInstanceId { get; set; }

    /// <summary>处置单号（唯一）</summary>
    [SugarColumn(ColumnName = "disposition_no", ColumnDescription = "处置单号", Length = 80)]
    public string DispositionNo { get; set; } = string.Empty;

    /// <summary>处置类型：REWORK 返工 / CONCESSION 让步放行 / SCRAP 报废 / OTHER 其它</summary>
    [SugarColumn(ColumnName = "disposition_type", ColumnDescription = "处置类型", Length = 32)]
    public string DispositionType { get; set; } = string.Empty;

    /// <summary>处置数量</summary>
    [SugarColumn(ColumnName = "disposition_qty", ColumnDescription = "处置数量", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? DispositionQty { get; set; }

    /// <summary>返工数量</summary>
    [SugarColumn(ColumnName = "rework_qty", ColumnDescription = "返工数量", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? ReworkQty { get; set; }

    /// <summary>让步数量</summary>
    [SugarColumn(ColumnName = "concession_qty", ColumnDescription = "让步数量", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? ConcessionQty { get; set; }

    /// <summary>报废数量</summary>
    [SugarColumn(ColumnName = "scrap_qty", ColumnDescription = "报废数量", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? ScrapQty { get; set; }

    /// <summary>处置意见（必填，service 校验）</summary>
    [SugarColumn(ColumnName = "disposition_opinion", ColumnDescription = "处置意见", ColumnDataType = StaticConfig.CodeFirst_BigString, IsNullable = true)]
    public string? DispositionOpinion { get; set; }

    /// <summary>责任部门</summary>
    [SugarColumn(ColumnName = "responsibility_dept", ColumnDescription = "责任部门", Length = 255, IsNullable = true)]
    public string? ResponsibilityDept { get; set; }

    /// <summary>责任人</summary>
    [SugarColumn(ColumnName = "responsible_user", ColumnDescription = "责任人", Length = 100, IsNullable = true)]
    public string? ResponsibleUser { get; set; }

    /// <summary>附件 JSON（预留，本批不做上传）</summary>
    [SugarColumn(ColumnName = "attachment_json", ColumnDescription = "附件JSON", ColumnDataType = StaticConfig.CodeFirst_BigString, IsNullable = true)]
    public string? AttachmentJson { get; set; }

    /// <summary>状态：1 已提交（本批最小）</summary>
    [SugarColumn(ColumnName = "status", ColumnDescription = "状态")]
    public int Status { get; set; }

    /// <summary>提交人 id（质量工程师）</summary>
    [SugarColumn(ColumnName = "submitted_by", ColumnDescription = "提交人id", IsNullable = true)]
    public long? SubmittedBy { get; set; }

    /// <summary>提交人姓名</summary>
    [SugarColumn(ColumnName = "submitted_by_name", ColumnDescription = "提交人姓名", Length = 100, IsNullable = true)]
    public string? SubmittedByName { get; set; }

    /// <summary>提交时间</summary>
    [SugarColumn(ColumnName = "submitted_at", ColumnDescription = "提交时间", IsNullable = true)]
    public DateTime? SubmittedAt { get; set; }

    /// <summary>确认人（预留，本批 N3 提交即完成）</summary>
    [SugarColumn(ColumnName = "confirmed_by", ColumnDescription = "确认人", IsNullable = true)]
    public long? ConfirmedBy { get; set; }

    /// <summary>确认时间（预留）</summary>
    [SugarColumn(ColumnName = "confirmed_at", ColumnDescription = "确认时间", IsNullable = true)]
    public DateTime? ConfirmedAt { get; set; }

    /// <summary>乐观锁版本</summary>
    [SugarColumn(ColumnName = "row_version", ColumnDescription = "乐观锁版本", IsNullable = true)]
    public long? RowVersion { get; set; }
}