using SqlSugar;

namespace MES.Service.Modes
{
    /// <summary>
    /// IQC抽检表头
    ///</summary>
    [SugarTable("MES_OQC_ITEMS_DETECT_02")]
    public class MesOqcItemsDetect02
    {
        /// <summary>
        ///  
        ///</summary>
        [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID",
            IsPrimaryKey = true)]
        public decimal Id { get; set; }

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

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

        /// <summary>
        /// 提交标识 
        ///</summary>
        [SugarColumn(ColumnName = "FSUBMIT")]
        public decimal? Fsubmit { get; set; }

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

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

        /// <summary>
        /// 二次判定结果 
        ///</summary>
        [SugarColumn(ColumnName = "FSECOND_RESU")]
        public string? FsecondResu { get; set; }

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

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

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

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

        /// <summary>
        /// 审核标识 
        ///</summary>
        [SugarColumn(ColumnName = "ISMODIFY1")]
        public decimal? Ismodify1 { get; set; }

        /// <summary>
        /// 审核人 
        ///</summary>
        [SugarColumn(ColumnName = "MODIFY1_BY")]
        public string? Modify1By { get; set; }

        /// <summary>
        /// 审核时间 
        ///</summary>
        [SugarColumn(ColumnName = "MODIFY1_DATE")]
        public DateTime? Modify1Date { get; set; }

        /// <summary>
        /// 作废标识 
        ///</summary>
        [SugarColumn(ColumnName = "FCANCEL")]
        public string? Fcancel { get; set; }

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

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

        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMEKE")]
        public string? Remeke { get; set; }

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

        /// <summary>
        /// 销售订单号 
        ///</summary>
        [SugarColumn(ColumnName = "SALE_ORDER_NO")]
        public string? SaleOrderNo { get; set; }

        /// <summary>
        /// 仓库id 
        ///</summary>
        [SugarColumn(ColumnName = "DEPOT_ID")]
        public decimal? DepotId { get; set; }
        
        [SugarColumn(IsIgnore = true)]
        public string? ItemName{ get; set; }
    
        [SugarColumn(IsIgnore = true)]
        public string? ItemModel { get; set; }
        
        [SugarColumn(IsIgnore = true)]
        public string? CreateUser { get; set; }
        
        //fcheckBy
        [SugarColumn(IsIgnore = true)]
        public string? FcheckUser { get; set; }
        
        [SugarColumn(IsIgnore = true)]
        public string? DepotName { get; set; }
    }
}