using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     首检图片信息表
/// </summary>
[Table("QS_ITEM_IPI_IMAGE")]
[SugarTable("QS_ITEM_IPI_IMAGE")]
public class QsItemIpiImage
{
    /// <summary>
    ///     主键 - 使用序列 SEQ_IPI_IMAGE
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_IPI_IMAGE",
        ColumnName = "ID")]
    public decimal? Id { get; set; }

    /// <summary>
    ///     检验项目ID（关联 QS_ITEM_IPI_ITEM 表）
    /// </summary>
    [Column("FID")]
    [SugarColumn(ColumnName = "FID")]
    public decimal? Fid { get; set; }

    /// <summary>
    ///     质检类型：1=首检，2=巡检，3=入库检，4=来料检验，5=超期检验
    /// </summary>
    [Column("QS_TYPE")]
    [SugarColumn(ColumnName = "QS_TYPE")]
    public decimal? QsType { get; set; }

    /// <summary>
    ///     图片二进制数据（LONG RAW类型）
    /// </summary>
    [Column("IMAGE_DATA")]
    [SugarColumn(ColumnName = "IMAGE_DATA")]
    public byte[]? ImageData { get; set; }

    /// <summary>
    ///     图片文件名
    /// </summary>
    [Column("PICTURENAME")]
    [SugarColumn(ColumnName = "PICTURENAME")]
    [StringLength(200, ErrorMessage = "图片名称长度不能超出200")]
    public string? Picturename { get; set; }

    /// <summary>
    ///     检验单ID（关联 QS_ITEM_IPI_REQ 表）
    /// </summary>
    [Column("GID")]
    [SugarColumn(ColumnName = "GID")]
    public decimal? Gid { get; set; }

    /// <summary>
    ///     备用字段 PID（兼容旧代码）
    /// </summary>
    [Column("PID")]
    [SugarColumn(ColumnName = "PID")]
    public decimal? Pid { get; set; }

    /// <summary>
    ///     检验项目名称（来自 QS_ITEM_IPI_ITEM.PROJ_NAME）
    /// </summary>
    [Column("JY_NAME")]
    [SugarColumn(ColumnName = "JY_NAME")]
    [StringLength(500, ErrorMessage = "检验项目名称长度不能超出500")]
    public string? JyName { get; set; }

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

    /// <summary>
    ///     创建人
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")]
    [StringLength(50, ErrorMessage = "创建人长度不能超出50")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     Base64编码的图片数据（用于前端显示，不存储到数据库）
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string? Base64Data { get; set; }
}