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

namespace MES.Service.Modes;

/// <summary>
///     IQC抽检表头
/// </summary>
[Table("MES_QA_ITEMS_DETECT_02")]
[SugarTable("MES_QA_ITEMS_DETECT_02")] //用于SqlSugar
public class MesQaItemsDetect02
{
    /// <summary>
    ///     SEQ_QM_ID
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QM_ID",
        ColumnName = "ID")] //用于SqlSugar
    public decimal Id { get; set; }

    /// <summary>
    ///     入库单号
    /// </summary>
    [Column("AUFNR")]
    [SugarColumn(ColumnName = "AUFNR")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "入库单号长度不能超出100")]
    public string? Aufnr { get; set; }

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

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

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

    /// <summary>
    ///     认证要求
    /// </summary>
    [Column("CARD")]
    [SugarColumn(ColumnName = "CARD")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "认证要求长度不能超出100")]
    public string? Card { get; set; }

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

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

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

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

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

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

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

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

    /// <summary>
    ///     销售方向
    /// </summary>
    [Column("FANG")]
    [SugarColumn(ColumnName = "FANG")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "销售方向长度不能超出100")]
    public string? Fang { get; set; }

    /// <summary>
    ///     送检数量
    /// </summary>
    [Column("FBATCH_QTY")]
    [SugarColumn(ColumnName = "FBATCH_QTY")] //用于SqlSugar
    public decimal? FbatchQty { get; set; }

    /// <summary>
    ///     作废标识
    /// </summary>
    [Column("FCANCEL")]
    [SugarColumn(ColumnName = "FCANCEL")] //用于SqlSugar
    [StringLength(2, ErrorMessage = "作废标识长度不能超出2")]
    public string? Fcancel { get; set; }

    /// <summary>
    ///     产线自检员
    /// </summary>
    [Column("FCHECK_BY")]
    [SugarColumn(ColumnName = "FCHECK_BY")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "产线自检员长度不能超出100")]
    public string? FcheckBy { get; set; }

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

    /// <summary>
    ///     不合格程度
    /// </summary>
    [Column("FCHECK_LEVEL")]
    [SugarColumn(ColumnName = "FCHECK_LEVEL")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "不合格程度长度不能超出50")]
    public string? FcheckLevel { get; set; }

    /// <summary>
    ///     特记事项
    /// </summary>
    [Column("FCHECK_MEMO")]
    [SugarColumn(ColumnName = "FCHECK_MEMO")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "特记事项长度不能超出500")]
    public string? FcheckMemo { get; set; }

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

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

    /// <summary>
    ///     不良描述
    /// </summary>
    [Column("FNG_DESC")]
    [SugarColumn(ColumnName = "FNG_DESC")] //用于SqlSugar
    [StringLength(2000, ErrorMessage = "不良描述长度不能超出2000")]
    public string? FngDesc { get; set; }

    /// <summary>
    ///     处理方法
    /// </summary>
    [Column("FNG_HANDLE")]
    [SugarColumn(ColumnName = "FNG_HANDLE")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "处理方法长度不能超出100")]
    public string? FngHandle { get; set; }

    /// <summary>
    ///     生产日期
    /// </summary>
    [Column("FPROD_DATE")]
    [SugarColumn(ColumnName = "FPROD_DATE")] //用于SqlSugar
    public DateTime? FprodDate { get; set; }

    /// <summary>
    ///     生产类型
    /// </summary>
    [Column("FPROD_TYPE")]
    [SugarColumn(ColumnName = "FPROD_TYPE")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "生产类型长度不能超出200")]
    public string? FprodType { get; set; }

    /// <summary>
    ///     二次判定结果
    /// </summary>
    [Column("FSECOND_RESU")]
    [SugarColumn(ColumnName = "FSECOND_RESU")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "二次判定结果长度不能超出100")]
    public string? FsecondResu { get; set; }

    /// <summary>
    ///     1为首检，2为完工检验
    /// </summary>
    [Column("FSTATUS")]
    [SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar
    public decimal? Fstatus { get; set; }

    /// <summary>
    ///     提交标识（产线）
    /// </summary>
    [Column("FSUBMIT")]
    [SugarColumn(ColumnName = "FSUBMIT")] //用于SqlSugar
    public decimal? Fsubmit { get; set; }

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

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

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

    /// <summary>
    ///     版本
    /// </summary>
    [Column("FVERSION")]
    [SugarColumn(ColumnName = "FVERSION")] //用于SqlSugar
    public decimal? Fversion { get; set; }

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

    /// <summary>
    ///     处置日期
    /// </summary>
    [Column("IPQC_DATE")]
    [SugarColumn(ColumnName = "IPQC_DATE")] //用于SqlSugar
    public DateTime? IpqcDate { get; set; }

    /// <summary>
    ///     审核标识
    /// </summary>
    [Column("IPQC_STATUS")]
    [SugarColumn(ColumnName = "IPQC_STATUS")] //用于SqlSugar
    public decimal? IpqcStatus { get; set; }

    /// <summary>
    /// </summary>
    [Column("ISMODIFY1")]
    [SugarColumn(ColumnName = "ISMODIFY1")] //用于SqlSugar
    public decimal? Ismodify1 { get; set; }

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

    /// <summary>
    ///     更新人
    /// </summary>
    [Column("LASTUPDATE_BY")]
    [SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "更新人长度不能超出100")]
    public string? LastupdateBy { get; set; }

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

    /// <summary>
    ///     工位ID
    /// </summary>
    [Column("LINEINFO_ID")]
    [SugarColumn(ColumnName = "LINEINFO_ID")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "工位ID长度不能超出20")]
    public string? LineinfoId { get; set; }

    /// <summary>
    ///     线体编号
    /// </summary>
    [Column("LINE_NO")]
    [SugarColumn(ColumnName = "LINE_NO")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "线体编号长度不能超出100")]
    public string? LineNo { get; set; }

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

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

    /// <summary>
    ///     处置日期
    /// </summary>
    [Column("MANAGE_DATE")]
    [SugarColumn(ColumnName = "MANAGE_DATE")] //用于SqlSugar
    public DateTime? ManageDate { get; set; }

    /// <summary>
    /// </summary>
    [Column("MAX_CHECK_QTY")]
    [SugarColumn(ColumnName = "MAX_CHECK_QTY")] //用于SqlSugar
    public decimal? MaxCheckQty { get; set; }

    /// <summary>
    ///     原因分析
    /// </summary>
    [Column("MEMO_A")]
    [SugarColumn(ColumnName = "MEMO_A")] //用于SqlSugar
    [StringLength(4000, ErrorMessage = "原因分析长度不能超出4000")]
    public string? MemoA { get; set; }

    /// <summary>
    ///     临时对策
    /// </summary>
    [Column("MEMO_B")]
    [SugarColumn(ColumnName = "MEMO_B")] //用于SqlSugar
    [StringLength(4000, ErrorMessage = "临时对策长度不能超出4000")]
    public string? MemoB { get; set; }

    /// <summary>
    ///     长期对策
    /// </summary>
    [Column("MEMO_C")]
    [SugarColumn(ColumnName = "MEMO_C")] //用于SqlSugar
    [StringLength(4000, ErrorMessage = "长期对策长度不能超出4000")]
    public string? MemoC { get; set; }

    /// <summary>
    /// </summary>
    [Column("MENU_ID")]
    [SugarColumn(ColumnName = "MENU_ID")] //用于SqlSugar
    public decimal? MenuId { get; set; }

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

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

    /// <summary>
    ///     审核标识
    /// </summary>
    [Column("MODIFY1_FLAG")]
    [SugarColumn(ColumnName = "MODIFY1_FLAG")] //用于SqlSugar
    public decimal? Modify1Flag { get; set; }

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

    /// <summary>
    ///     计划数量
    /// </summary>
    [Column("PLAN_QTY")]
    [SugarColumn(ColumnName = "PLAN_QTY")] //用于SqlSugar
    public decimal? PlanQty { get; set; }

    /// <summary>
    ///     PQC类型说明
    /// </summary>
    [Column("PQC_TEXT")]
    [SugarColumn(ColumnName = "PQC_TEXT")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "PQC类型说明长度不能超出200")]
    public string? PqcText { get; set; }

    /// <summary>
    ///     PQC检验类型
    /// </summary>
    [Column("PQC_TYPE")]
    [SugarColumn(ColumnName = "PQC_TYPE")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "PQC检验类型长度不能超出30")]
    public string? PqcType { get; set; }

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

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

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

    /// <summary>
    ///     工作中心
    /// </summary>
    [Column("WORKSHOP_CENTER_CODE")]
    [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "工作中心长度不能超出100")]
    public string? WorkshopCenterCode { get; set; }

    /// <summary>
    ///     工作中心
    /// </summary>
    [Column("GID")]
    [SugarColumn(ColumnName = "GID")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "GID100")]
    public decimal? Gid { get; set; }
}