using SqlSugar;
using System;

namespace MES.Service.Modes
{
    /// <summary>
    /// PCB检测数据表（整板/单板统一存储）
    /// </summary>
    [SugarTable("MES_PCB_TEST_DATA")]
    public class MesPcbTestData
    {
        /// <summary>
        /// 主键ID
        /// </summary>
        [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_PCB_TEST_DATA", IsPrimaryKey = true)]
        public decimal Id { get; set; }

        /// <summary>
        /// 数据类型：WHOLE-整板，SINGLE-单板
        /// </summary>
        [SugarColumn(ColumnName = "DATA_TYPE")]
        public string DataType { get; set; }

        /// <summary>
        /// 设备名称
        /// </summary>
        [SugarColumn(ColumnName = "DEVICE_NAME")]
        public string? DeviceName { get; set; }

        /// <summary>
        /// 整板条码
        /// </summary>
        [SugarColumn(ColumnName = "PCB_SN")]
        public string? PcbSn { get; set; }

        /// <summary>
        /// 轨道信息（1-1轨，2-2轨）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_TRACK_LINE")]
        public int? PcbTrackLine { get; set; }

        /// <summary>
        /// 板面（T-顶面，B-底面，T+B-顶面+底面）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_BOARD_SIDE")]
        public string? PcbBoardSide { get; set; }

        /// <summary>
        /// 检测时间
        /// </summary>
        [SugarColumn(ColumnName = "PCB_TEST_TIME")]
        public DateTime? PcbTestTime { get; set; }

        /// <summary>
        /// 检测耗时（秒）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_CYCLE_TIME")]
        public decimal? PcbCycleTime { get; set; }

        /// <summary>
        /// 程序名/板式名
        /// </summary>
        [SugarColumn(ColumnName = "PCB_PROJECT_NAME")]
        public string? PcbProjectName { get; set; }

        /// <summary>
        /// 整板检测结果
        /// </summary>
        [SugarColumn(ColumnName = "PCB_ROBOT_RESULT")]
        public string? PcbRobotResult { get; set; }

        /// <summary>
        /// 整板复判结果
        /// </summary>
        [SugarColumn(ColumnName = "PCB_USER_RESULT")]
        public string? PcbUserResult { get; set; }

        /// <summary>
        /// 整板最终结果
        /// </summary>
        [SugarColumn(ColumnName = "PCB_FINAL_RESULT")]
        public string? PcbFinalResult { get; set; }

        /// <summary>
        /// 维修站复判用户名
        /// </summary>
        [SugarColumn(ColumnName = "PCB_REPAIR_USER")]
        public string? PcbRepairUser { get; set; }

        /// <summary>
        /// 拼板数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_BOARD_NUMBER")]
        public int? PcbBoardNumber { get; set; }

        /// <summary>
        /// 拼板检测NG数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_BOARD_ROBOT_NG_NUMBER")]
        public int? PcbBoardRobotNgNumber { get; set; }

        /// <summary>
        /// 拼板复判NG数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_BOARD_USER_NG_NUMBER")]
        public int? PcbBoardUserNgNumber { get; set; }

        /// <summary>
        /// 拼板误报数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_BOARD_REPASS_NUMBER")]
        public int? PcbBoardRepassNumber { get; set; }

        /// <summary>
        /// 器件总数量
        /// </summary>
        [SugarColumn(ColumnName = "PCB_COMP_NUMBER")]
        public int? PcbCompNumber { get; set; }

        /// <summary>
        /// 器件检测NG数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_COMP_ROBOT_NG_NUMBER")]
        public int? PcbCompRobotNgNumber { get; set; }

        /// <summary>
        /// 器件复判NG数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_COMP_USER_NG_NUMBER")]
        public int? PcbCompUserNgNumber { get; set; }

        /// <summary>
        /// 器件误报数量（整板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "PCB_COMP_REPASS_NUMBER")]
        public int? PcbCompRepassNumber { get; set; }

        /// <summary>
        /// 拼板条码（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_SN")]
        public string? BoardSn { get; set; }

        /// <summary>
        /// 拼板序号（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_NO")]
        public string? BoardNo { get; set; }

        /// <summary>
        /// 拼板检测结果（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_ROBOT_RESULT")]
        public string? BoardRobotResult { get; set; }

        /// <summary>
        /// 拼板复判结果（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_USER_RESULT")]
        public string? BoardUserResult { get; set; }

        /// <summary>
        /// 拼板最终结果（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_FINAL_RESULT")]
        public string? BoardFinalResult { get; set; }

        /// <summary>
        /// 拼板器件数量（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_COMP_NUMBER")]
        public int? BoardCompNumber { get; set; }

        /// <summary>
        /// 拼板器件检测NG总数（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_COMP_ROBOT_NG_NUMBER")]
        public int? BoardCompRobotNgNumber { get; set; }

        /// <summary>
        /// 拼板器件复判NG总数（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_COMP_USER_NG_NUMBER")]
        public int? BoardCompUserNgNumber { get; set; }

        /// <summary>
        /// 拼板器件误报总数（单板数据使用）
        /// </summary>
        [SugarColumn(ColumnName = "BOARD_COMP_REPASS_NUMBER")]
        public int? BoardCompRepassNumber { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [SugarColumn(ColumnName = "CREATE_TIME")]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnName = "UPDATE_TIME")]
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }
    }
}