using SqlSugar;
|
|
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; }
|
}
|
