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

namespace MES.Service.Modes;

/// <summary>
///     巡检检验表头
/// </summary>
[Table("QS_QA_ITEM_XJ")]
[SugarTable("QS_QA_ITEM_XJ")] //用于SqlSugar
public class QsQaItemXj
{
    /// <summary>
    ///     序列SEQ_QS_XJ
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_XJ",
        ColumnName = "ID")] //用于SqlSugar
    public decimal? Id { get; set; }

    /// <summary>
    /// 检验单号 
    /// </summary>
    [SugarColumn(ColumnName = "RELEASE_NO", Length = 100)]
    public string? ReleaseNo { get; set; }

    /// <summary>
    /// 检验日期
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    /// 检验人员 
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_BY", Length = 100)]
    public string? CheckBy { get; set; }

    /// <summary>
    /// 物料编码 
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO", Length = 100)]
    public string? ItemNo { get; set; }

    /// <summary>
    /// 检验结果 
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_RESU", Length = 100)]
    public string? CheckResult { get; set; }

    /// <summary>
    /// 创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY", Length = 100)]
    public string? CreateBy { get; set; }

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

    /// <summary>
    /// 更新人 
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY", Length = 100)]
    public string? LastUpdateBy { get; set; }

    /// <summary>
    /// 更新日期
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastUpdateDate { get; set; }

    /// <summary>
    /// 修改人
    /// </summary>
    [SugarColumn(ColumnName = "MODIFY1_BY", Length = 100)]
    public string? ModifyBy { get; set; }

    /// <summary>
    /// 物料单位 
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_UNIT", Length = 100)]
    public string? ItemUnit { get; set; }

    /// <summary>
    /// 工单号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO", Length = 50)]
    public string? BillNo { get; set; }

    /// <summary>
    /// 模具号 
    /// </summary>
    [SugarColumn(ColumnName = "MOID_NUM", Length = 50)]
    public string? MoldNum { get; set; }

    /// <summary>
    /// 提交人 
    /// </summary>
    [SugarColumn(ColumnName = "FSUBMIT_BY", Length = 50)]
    public string? SubmitBy { get; set; }

    /// <summary>
    /// 提交日期 
    /// </summary>
    [SugarColumn(ColumnName = "FSUBMIT_DATE")]
    public DateTime? SubmitDate { get; set; }

    /// <summary>
    /// 提交状态（0/1）
    /// </summary>
    [SugarColumn(ColumnName = "FSUBMIT")]
    public int? SubmitStatus { get; set; }

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

    /// <summary>
    /// 物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public long? ItemId { get; set; }

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

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

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