using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
/// SPI/AOI 检测明细实体，记录缺陷分类统计及产线效率指标。
/// </summary>
[SugarTable("MES_SPI_AOI_DETAIL")]
public class MesSpiAoiDetail
{
    /// <summary>
    /// 主键ID，由 Oracle 序列 SEQ_SPI_AOI_DETAIL 生成。
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_DETAIL")]
    public decimal Id { get; set; }

    /// <summary>
    /// 主表 ID（外键），关联 <see cref="MesSpiAoiHeader" />。
    /// </summary>
    [SugarColumn(ColumnName = "HEADER_ID")]
    public decimal HeaderId { get; set; }

    /// <summary>
    /// 面积超出数量。
    /// </summary>
    [SugarColumn(ColumnName = "AREA_OVERFLOW_COUNT")]
    public int AreaOverflowCount { get; set; }

    /// <summary>
    /// 面积不足数量。
    /// </summary>
    [SugarColumn(ColumnName = "AREA_UNDERFLOW_COUNT")]
    public int AreaUnderflowCount { get; set; }

    /// <summary>
    /// 高度超出数量。
    /// </summary>
    [SugarColumn(ColumnName = "EXCEEDING_HEIGHT_COUNT")]
    public int ExceedingHeightCount { get; set; }

    /// <summary>
    /// 高度不足数量。
    /// </summary>
    [SugarColumn(ColumnName = "INSUFFICIENT_HEIGHT_COUNT")]
    public int InsufficientHeightCount { get; set; }

    /// <summary>
    /// X偏移数量。
    /// </summary>
    [SugarColumn(ColumnName = "X_DEVIATION_COUNT")]
    public int XDeviationCount { get; set; }

    /// <summary>
    /// Y偏移数量。
    /// </summary>
    [SugarColumn(ColumnName = "Y_DEVIATION_COUNT")]
    public int YDeviationCount { get; set; }

    /// <summary>
    /// 塌陷数量。
    /// </summary>
    [SugarColumn(ColumnName = "COLLAPSE_COUNT")]
    public int CollapseCount { get; set; }

    /// <summary>
    /// 拉尖数量（焊锡拉尖）。
    /// </summary>
    [SugarColumn(ColumnName = "SOLDER_PULL_TIP_COUNT")]
    public int SolderPullTipCount { get; set; }

    /// <summary>
    /// 异形数量。
    /// </summary>
    [SugarColumn(ColumnName = "ABNORMALITY_COUNT")]
    public int AbnormalityCount { get; set; }

    /// <summary>
    /// 产线显示名称。
    /// </summary>
    [SugarColumn(ColumnName = "LINE_DISPLAY_NAME")]
    public string? LineDisplayName { get; set; }

    /// <summary>
    /// 检测机台名称。
    /// </summary>
    [SugarColumn(ColumnName = "MACHINE_NAME")]
    public string? MachineName { get; set; }

    /// <summary>
    /// 投入板数量。
    /// </summary>
    [SugarColumn(ColumnName = "INPUT_BOARDS")]
    public int InputBoards { get; set; }

    /// <summary>
    /// OK 板数量。
    /// </summary>
    [SugarColumn(ColumnName = "OK_BOARDS")]
    public int OkBoards { get; set; }

    /// <summary>
    /// 通过板数量。
    /// </summary>
    [SugarColumn(ColumnName = "PASS_BOARDS")]
    public int PassBoards { get; set; }

    /// <summary>
    /// 合格率（单位：%）。
    /// </summary>
    [SugarColumn(ColumnName = "PASS_RATE")]
    public decimal? PassRate { get; set; }

    /// <summary>
    /// 不良板数量。
    /// </summary>
    [SugarColumn(ColumnName = "DEFECT_BOARDS")]
    public int DefectBoards { get; set; }

    /// <summary>
    /// 不良率（单位：%）。
    /// </summary>
    [SugarColumn(ColumnName = "DEFECT_RATE")]
    public decimal? DefectRate { get; set; }

    /// <summary>
    /// 不良数（单位：PPM）。
    /// </summary>
    [SugarColumn(ColumnName = "DEFECT_PPM")]
    public int? DefectPpm { get; set; }

    /// <summary>
    /// 不良点数。
    /// </summary>
    [SugarColumn(ColumnName = "DEFECT_POINTS")]
    public int DefectPoints { get; set; }

    /// <summary>
    /// 实测点数。
    /// </summary>
    [SugarColumn(ColumnName = "MEASURED_POINTS")]
    public int MeasuredPoints { get; set; }

    /// <summary>
    /// 待测点数。
    /// </summary>
    [SugarColumn(ColumnName = "PENDING_POINTS")]
    public int PendingPoints { get; set; }

    /// <summary>
    /// 创建时间，默认写入数据库时间戳。
    /// </summary>
    [SugarColumn(ColumnName = "CREATED_AT")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// 更新时间，默认写入数据库时间戳。
    /// </summary>
    [SugarColumn(ColumnName = "UPDATED_AT")]
    public DateTime UpdatedAt { get; set; }
}