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

namespace MES.Service.Modes;

/// <summary>
///     首检主表
/// </summary>
[Table("QS_ITEM_IPI_REQ")]
[SugarTable("QS_ITEM_IPI_REQ")] //用于SqlSugar
public class QsItemIpiReq
{
    /// <summary>
    ///     首检单号
    /// </summary>
    [Column("BILL_NO")]
    [SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "首检单号长度不能超出50")]
    public string? BillNo { get; set; }

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

    /// <summary>
    ///     完成时间
    /// </summary>
    [Column("COMPLETE_TIME")]
    [SugarColumn(ColumnName = "COMPLETE_TIME")] //用于SqlSugar
    public DateTime? CompleteTime { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [Column("CREATE_TIME")]
    [SugarColumn(ColumnName = "CREATE_TIME")] //用于SqlSugar
    public DateTime? CreateTime { get; set; }

    /// <summary>
    ///     序列SEQ_QS_IPI
    /// </summary>
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_IPI",
        ColumnName = "ID")]
    public decimal? Id { 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(1000, ErrorMessage = "产品规格长度不能超出1000")]
    public string? ItemMod { get; set; }

    /// <summary>
    ///     产品名
    /// </summary>
    [Column("ITEM_NAME")]
    [SugarColumn(ColumnName = "ITEM_NAME")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "产品名长度不能超出200")]
    public string? ItemName { get; set; }

    /// <summary>
    ///     产品编号
    /// </summary>
    [Column("ITEM_NO")]
    [SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "产品编号长度不能超出50")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     产线
    /// </summary>
    [Column("LINE")]
    [SugarColumn(ColumnName = "LINE")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "产线长度不能超出50")]
    public string? Line { get; set; }

    /// <summary>
    ///     产线名
    /// </summary>
    [Column("LINE_NAME")]
    [SugarColumn(ColumnName = "LINE_NAME")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "产线名长度不能超出50")]
    public string? LineName { get; set; }

    /// <summary>
    ///     排产单号
    /// </summary>
    [Column("PBAID")]
    [SugarColumn(ColumnName = "PBAID")] //用于SqlSugar
    public decimal? Pbaid { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [Column("STATUS_DATE")]
    [SugarColumn(ColumnName = "STATUS_DATE")] //用于SqlSugar
    public DateTime? StatusDate { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [Column("STATUS_USER")]
    [SugarColumn(ColumnName = "STATUS_USER")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "审核人长度不能超出50")]
    public string? StatusUser { get; set; }

    /// <summary>
    ///     车间编码
    /// </summary>
    [Column("WORKSHOP_CODE")]
    [SugarColumn(ColumnName = "WORKSHOP_CODE")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "车间编码长度不能超出50")]
    public string? WorkshopCode { get; set; }

    /// <summary>
    ///     车间名
    /// </summary>
    [Column("WORKSHOP_NAME")]
    [SugarColumn(ColumnName = "WORKSHOP_NAME")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "车间名长度不能超出50")]
    public string? WorkshopName { get; set; }


    /// <summary>
    ///     模具号
    /// </summary>
    [Column("MOID_NUM")]
    [SugarColumn(ColumnName = "MOID_NUM")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "模具号长度不能超出50")]
    public string? MoidNum { get; set; }

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