using Dapper;
using Dapper.Contrib;
using Dapper.Contrib.Extensions;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NFine.Application.Entity
{
    /// <summary>
    /// 来料检验主表
    /// </summary>
    [Table("IcsMatCheckResult")]
    public class IcsMatCheckResult
    {
        /// <summary>
        /// 非自增主键
        /// </summary>
        [ExplicitKey]
        public string ID { get; set; }
        /// <summary>
        /// 检验单号
        /// </summary>
        public string CheckNo { get; set; }
        /// <summary>
        /// 仓库代码
        /// </summary>
        public string WHCode { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        public string InvCode { get; set; }
        /// <summary>
        /// 送货单号
        /// </summary>
        public string AsnCode { get; set; }
        /// <summary>
        /// 物料批次
        /// </summary>
        public string InvBatcgNo { get; set; }
        /// <summary>
        /// 批次数量
        /// </summary>
        public decimal? InvBatcgQty { get; set; }
        /// <summary>
        /// Aql送检数量
        /// </summary>
        public decimal? AqlCheckQty { get; set; }
        /// <summary>
        /// 合格数
        /// </summary>
        public decimal? GoodQty { get; set; }
        /// <summary>
        /// 不良数
        /// </summary>
        public decimal? NgQty { get; set; }
        /// <summary>
        /// 供应商
        /// </summary>
        public string VenCode { get; set; }
        /// <summary>
        /// IQC组长
        /// </summary>
        public string IQCGroupHeaderResult { get; set; }
        /// <summary>
        /// IQC组长
        /// </summary>
        public string IQCGroupHeaderRemark { get; set; }
        /// <summary>
        /// IQC组长
        /// </summary>
        public string IQCGroupHeaderUser{ get; set; }
        /// <summary>
        /// IQC组长
        /// </summary>
        public DateTime? IQCGroupHeaderTime { get; set; }
        /// <summary>
        /// IQC主管
        /// </summary>
        public string IQCHeaderResult { get; set; }
        /// <summary>
        /// IQC主管
        /// </summary>
        public string IQCHeaderRemark { get; set; }
        /// <summary>
        /// IQC主管
        /// </summary>
        public string IQCHeaderUser { get; set; }
        /// <summary>
        /// IQC主管
        /// </summary>
        public DateTime? IQCHeaderTime { get; set; }
        /// <summary>
        /// SQE工程师
        /// </summary>
        public string SQEEngineerResult { get; set; }
        /// <summary>
        /// SQE工程师
        /// </summary>
        public string SQEEngineerRemark { get; set; }
        /// <summary>
        /// SQE工程师
        /// </summary>
        public string SQEEngineerUser { get; set; }
        /// <summary>
        /// SQE工程师
        /// </summary>
        public DateTime? SQEEngineerTime { get; set; }
        /// <summary>
        /// 检验结果
        /// </summary>
        public string Result { get; set; }
        /// <summary>
        /// 初检人员
        /// </summary>
        public string FirstCheckUser { get; set; }
        /// <summary>
        /// 初检时间
        /// </summary>
        public DateTime? FirstCheckTime { get; set; }

        /// <summary>
        /// 终判结果
        /// </summary>
        public string FinalResult { get; set; }
        /// <summary>
        /// 终判人员
        /// </summary>
        public string FinalUser { get; set; }
        /// <summary>
        /// 终判时间
        /// </summary>
        public DateTime? FinalTime { get; set; }
        /// <summary>
        /// 特采单号
        /// </summary>
        public string SpecialNo { get; set; }
        /// <summary>
        /// 让步文件
        /// </summary>
        public string SpecialFile { get; set; }
        public string BCGCode { get; set; }
        public string BRGCode { get; set; }
        public string BadReasonCode { get; set; }
        /// <summary>
        /// 是否检验完成
        /// </summary>
        public string IsCheckComplete { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        public string Remark { get; set; }
        /// <summary>
        ///仓库备注
        /// </summary>
        public string WHRemark { get; set; }
        /// <summary>
        /// 已退实物(Y/N/Null)
        /// </summary>
        public string HasReturnItem { get; set; }
        /// <summary>
        /// 退货时间
        /// </summary>
        public DateTime? HasReturnTime { get; set; }
        /// <summary>
        /// 加急
        /// </summary>
        public string Urgent { get; set; }
        /// <summary>
        /// 不良文件
        /// </summary>
        public string WgNgFile { get; set; }
        /// <summary>
        /// SQE复判文件
        /// </summary>
        public string SQEFile { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string MUSER { get; set; }
        public string MUSERName { get; set; }
        public DateTime MTIME { get; set; }
        public string WorkPoint { get; set; }


        /// <summary>
        /// 处理方案
        /// </summary>
        public string EATTRIBUTE1 { get; set; }
        /// <summary>
        /// 来源单据类型(1普通/2委外)
        /// </summary>
        public string EATTRIBUTE2 { get; set; }
        /// <summary>
        /// 初检时间
        /// </summary>
        public string EATTRIBUTE3 { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string EATTRIBUTE4 { get; set; }
        /// <summary>
        /// SQE复判邮件标识
        /// </summary>
        public string EATTRIBUTE5 { get; set; }
        /// <summary>
        /// 物料需求时间
        /// </summary>
        public string EATTRIBUTE6 { get; set; }
        /// <summary>
        /// 异常单号
        /// </summary>
        public string EATTRIBUTE7 { get; set; }
        public string EATTRIBUTE8 { get; set; }
        public string EATTRIBUTE9 { get; set; }
        public string EATTRIBUTE10 { get; set; }
    }
}