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

namespace MES.Service.Modes;

/// <summary>
///     巡检子表
/// </summary>
[Table("QS_QA_ITEM_XJ01")]
[SugarTable("QS_QA_ITEM_XJ01")] //用于SqlSugar
public class QsQaItemXj01
{
    /// <summary>
    ///     接收水平
    /// </summary>
    [Column("FAC_LEVEL")]
    [SugarColumn(ColumnName = "FAC_LEVEL")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "接收水平长度不能超出100")]
    public string? FacLevel { get; set; }

    /// <summary>
    ///     检验水平
    /// </summary>
    [Column("FCHECK_LEVEL")]
    [SugarColumn(ColumnName = "FCHECK_LEVEL")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "检验水平长度不能超出100")]
    public string? FcheckLevel { get; set; }

    /// <summary>
    ///     序列SEQ_QS_XJ
    /// </summary>
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_XJ",
        ColumnName = "ID")] //用于SqlSugar
    public decimal? Id { get; set; }

    /// <summary>
    ///     检验方法
    /// </summary>
    [Column("INSPECTION_METHOD")]
    [SugarColumn(ColumnName = "INSPECTION_METHOD")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "检验方法长度不能超出50")]
    public string? InspectionMethod { get; set; }

    /// <summary>
    ///     0表示不合格,1表示合格
    /// </summary>
    [Column("IS_PASS")]
    [SugarColumn(ColumnName = "IS_PASS")] //用于SqlSugar
    public decimal? IsPass { get; set; }

    /// <summary>
    ///     质量要求
    /// </summary>
    [Column("ITEM_MOD")]
    [SugarColumn(ColumnName = "ITEM_MOD")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "质量要求长度不能超出500")]
    public string? ItemMod { get; set; }

    /// <summary>
    ///     检验个数
    /// </summary>
    [Column("LEVEL_NUM")]
    [SugarColumn(ColumnName = "LEVEL_NUM")] //用于SqlSugar
    public decimal? LevelNum { get; set; }

    /// <summary>
    ///     最大值
    /// </summary>
    [Column("MAX_VALUE")]
    [SugarColumn(ColumnName = "MAX_VALUE")] //用于SqlSugar
    public decimal? MaxValue { get; set; }

    /// <summary>
    ///     最小值
    /// </summary>
    [Column("MIN_VALUE")]
    [SugarColumn(ColumnName = "MIN_VALUE")] //用于SqlSugar
    public decimal? MinValue { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [Column("NOTES")]
    [SugarColumn(ColumnName = "NOTES")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "备注长度不能超出100")]
    public string? Notes { get; set; }

    /// <summary>
    ///     检验主表id
    /// </summary>
    [Column("PID")]
    [SugarColumn(ColumnName = "PID")] //用于SqlSugar
    public decimal? Pid { get; set; }

    /// <summary>
    ///     项目名称
    /// </summary>
    [Column("PROJ_NAME")]
    [SugarColumn(ColumnName = "PROJ_NAME")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "项目名称长度不能超出50")]
    public string? ProjName { get; set; }

    /// <summary>
    ///     检验标准编码
    /// </summary>
    [Column("QS_CODE")]
    [SugarColumn(ColumnName = "QS_CODE")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "检验标准编码长度不能超出100")]
    public string? QsCode { get; set; }

    /// <summary>
    ///     检验标准名称
    /// </summary>
    [Column("QS_NAME")]
    [SugarColumn(ColumnName = "QS_NAME")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "检验标准名称长度不能超出100")]
    public string? QsName { get; set; }

    /// <summary>
    ///     标准值
    /// </summary>
    [Column("STANDARD_VALUE")]
    [SugarColumn(ColumnName = "STANDARD_VALUE")] //用于SqlSugar
    public decimal? StandardValue { get; set; }

    /// <summary>
    ///     使用仪表
    /// </summary>
    [Column("USING_INSTRUMENTS")]
    [SugarColumn(ColumnName = "USING_INSTRUMENTS")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "使用仪表长度不能超出50")]
    public string? UsingInstruments { get; set; }

    /// <summary>
    ///     已检验个数
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public int? isCheck { get; set; }

    /// <summary>
    ///     图片地址
    /// </summary>
    [Column("PICTURE")]
    [SugarColumn(ColumnName = "PICTURE")] //用于SqlSugar
    public byte[]? Picture { get; set; }

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

    [Column("Remarks")]
    [SugarColumn(ColumnName = "Remarks")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "备注不能超出200")]
    public string? Remarks { get; set; }

    [SugarColumn(IsIgnore = true)] public string? result { get; set; }

    [SugarColumn(IsIgnore = true)] public string? imageData { get; set; }
}