Display_D_HP/TeamAAS-VM/Models/AssemblyRecord.cs

using System;
using SqlSugar;

namespace TeamAAS_VP.Models
{
    /// <summary>
    /// 组装记录实体，表示一次组装操作的详细信息（用于持久化到数据库的 AssemblyRecord 表）
    /// </summary>
    [SugarTable("AssemblyRecord")]
    public class AssemblyRecord
    {
        /// <summary>
        /// 主键，唯一标识
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public Guid Id { get; set; } = Guid.NewGuid();

        /// <summary>
        /// 时间戳
        /// </summary>
        public DateTime Timestamp { get; set; } = DateTime.UtcNow;

        /// <summary>
        /// 配方名称
        /// </summary>
        [SugarColumn(Length = 255, IsNullable = true)]
        public string RecipeName { get; set; }

        /// <summary>
        /// 产品序列号
        /// </summary>
        [SugarColumn(Length = 255, IsNullable = true)]
        public string ProductSN { get; set; }

        /// <summary>
        /// 零件序列号
        /// </summary>
        [SugarColumn(Length = 255, IsNullable = true)]
        public string PartSN { get; set; }

        /// <summary>
        /// 是否组装成功
        /// </summary>
        public bool Success { get; set; }

        /// <summary>
        /// 组装压力
        /// </summary>
        public double AssemblyPressure { get; set; }

        /// <summary>
        /// 组装用时（秒）
        /// </summary>
        public double AssemblyDurationSeconds { get; set; }

        /// <summary>
        /// 下相机拍摄的坐标1，字符串格式（例如 "x,y,z"），用于简化数据库存储，可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string DownCameraCoord1 { get; set; }
        /// <summary>
        /// 下相机拍摄的坐标2，字符串格式（例如 "x,y,z"），用于简化数据库存储，可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string DownCameraCoord2 { get; set; }
        /// <summary>
        /// 下相机拍摄的坐标3，字符串格式（例如 "x,y,z"），用于简化数据库存储，可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string DownCameraCoord3 { get; set; }
        /// <summary>
        /// 下相机拍摄的坐标4，字符串格式（例如 "x,y,z"），用于简化数据库存储，可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string DownCameraCoord4 { get; set; }

        /// <summary>
        /// 抓取运动过程中的相机坐标，字符串格式（例如 "x,y,z"），可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PickMoveCameraCoord { get; set; }

        /// <summary>
        /// 放置运动过程的相机坐标1，字符串格式（例如 "x,y,z"），可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PlaceMoveCameraCoord1 { get; set; }
        /// <summary>
        /// 放置运动过程的相机坐标2，字符串格式（例如 "x,y,z"），可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PlaceMoveCameraCoord2 { get; set; }
        /// <summary>
        /// 放置运动过程的相机坐标3，字符串格式（例如 "x,y,z"），可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PlaceMoveCameraCoord3 { get; set; }
        /// <summary>
        /// 放置运动过程的相机坐标4，字符串格式（例如 "x,y,z"），可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PlaceMoveCameraCoord4 { get; set; }

        /// <summary>
        /// 实际放置坐标，字符串格式（例如 "x,y,z"），可用于记录放置位置的实际测量值
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string PlaceActualCoord { get; set; }

        /// <summary>
        /// 设备名称，可为空
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 255)]
        public string DeviceName { get; set; }
        /// <summary>
        /// 设备ID，关联设备的数字标识
        /// </summary>
        public int DeviceId { get; set; }

        /// <summary>
        /// 操作员名称，可为空
        /// </summary>
        [SugarColumn(Length = 255, IsNullable = true)]
        public string OperatorName { get; set; }

        /// <summary>
        /// 备注信息，可为空
        /// </summary>
        [SugarColumn(Length = 1000, IsNullable = true)]
        public string Remark { get; set; }
    }
}