using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
/// SPI/AOI 检测主表实体，用于保存单块 PCB 的批次检测概览数据。
/// </summary>
[SugarTable("MES_SPI_AOI_HEADER")]
public class MesSpiAoiHeader
{
    /// <summary>
    /// 主键ID，由 Oracle 序列 SEQ_SPI_AOI_HEADER 生成。
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_HEADER")]
    public decimal Id { get; set; }

    /// <summary>
    /// 测试日期（设备上传的年月日）。
    /// </summary>
    [SugarColumn(ColumnName = "TEST_DATE")]
    public DateTime TestDate { get; set; }

    /// <summary>
    /// 测试时间（HH:mm:ss 格式，保持原始值）。
    /// </summary>
    [SugarColumn(ColumnName = "TEST_TIME")]
    public string TestTime { get; set; } = string.Empty;

    /// <summary>
    /// 测试结果原始字符串，例如 0:0:1;0、0;0;0:1、Fail。
    /// </summary>
    [SugarColumn(ColumnName = "TEST_RESULT")]
    public string TestResult { get; set; } = string.Empty;

    /// <summary>
    /// 检测面（T = Top 顶面，B = Bottom 底面）。
    /// </summary>
    [SugarColumn(ColumnName = "SURFACE")]
    public string Surface { get; set; } = string.Empty;

    /// <summary>
    /// 计划检测点数。
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_POINTS")]
    public int? TotalPoints { get; set; }

    /// <summary>
    /// 实际不良点数。
    /// </summary>
    [SugarColumn(ColumnName = "ACTUAL_DEFECTS")]
    public int? ActualDefects { get; set; }

    /// <summary>
    /// 设备型号。
    /// </summary>
    [SugarColumn(ColumnName = "EQUIPMENT_MODEL")]
    public string? EquipmentModel { get; set; }

    /// <summary>
    /// 对应生产工单或批次号。
    /// </summary>
    [SugarColumn(ColumnName = "WORK_ORDER")]
    public string? WorkOrder { get; set; }

    /// <summary>
    /// 机种名称。
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_MODEL")]
    public string? ProductModel { get; set; }

    /// <summary>
    /// 板件条码（唯一约束）。
    /// </summary>
    [SugarColumn(ColumnName = "BOARD_BARCODE")]
    public string BoardBarcode { get; set; } = string.Empty;

    /// <summary>
    /// SMT 组别。
    /// </summary>
    [SugarColumn(ColumnName = "SMT_GROUP")]
    public string? SmtGroup { get; set; }

    /// <summary>
    /// 线别名称。
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NAME")]
    public string? LineName { get; set; }

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

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