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

using Admin.NET.Core;

namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// S5 来料检验 SQE 处置记录。
///
/// 不合格来料检验单（qms_qcp_inspbill.pd=1）经检验主管通过后进入 N3_SQE_DISPOSITION，
/// SQE 提交处置方案落此表。disposition_type 复用 clfs 编码（0 让步接收 / 1 挑选 / 2 报废），
/// 不覆盖 qms_qcp_inspbill.clfs。本批不做仓储确认/库存/入库/附件上传（attachment_json 预留）。
/// 一单一有效处置由 service 校验（status=1 且未软删）。
/// </summary>
[SugarTable("ado_s5_iqc_sqe_disposition", "S5 来料检验SQE处置")]
[SugarIndex("idx_s5_sqe_disp_inspbill", nameof(InspbillId), OrderByType.Asc)]
[SugarIndex("idx_s5_sqe_disp_flow", nameof(FlowInstanceId), OrderByType.Asc)]
[SugarIndex("uk_s5_sqe_disp_no", nameof(DispositionNo), OrderByType.Asc, true)]
[SugarIndex("idx_s5_sqe_disp_status", nameof(Status), OrderByType.Asc)]
public class AdoS5IqcSqeDisposition : 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_qcp_inspbill.id）</summary>
    [SugarColumn(ColumnName = "inspbill_id", ColumnDescription = "检验单id")]
    public long InspbillId { get; set; }

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

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

    /// <summary>业务类型</summary>
    [SugarColumn(ColumnName = "biz_type", ColumnDescription = "业务类型", Length = 80, IsNullable = true)]
    public string? BizType { get; set; } = "S5_IQC_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>处置方式：0 让步接收 / 1 挑选 / 2 报废</summary>
    [SugarColumn(ColumnName = "disposition_type", ColumnDescription = "处置方式")]
    public int DispositionType { get; set; }

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

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

    /// <summary>挑选数量</summary>
    [SugarColumn(ColumnName = "selection_qty", ColumnDescription = "挑选数量", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? SelectionQty { get; set; }

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

    /// <summary>供应商回复</summary>
    [SugarColumn(ColumnName = "supplier_response", ColumnDescription = "供应商回复", Length = 500, IsNullable = true)]
    public string? SupplierResponse { get; set; }

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

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

    /// <summary>SQE 处理人 id</summary>
    [SugarColumn(ColumnName = "sqe_user_id", ColumnDescription = "SQE处理人id", IsNullable = true)]
    public long? SqeUserId { get; set; }

    /// <summary>SQE 处理人名</summary>
    [SugarColumn(ColumnName = "sqe_user_name", ColumnDescription = "SQE处理人名", Length = 100, IsNullable = true)]
    public string? SqeUserName { get; set; }

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

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

    /// <summary>确认人（预留）</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; }
}