HYTOS

                            case 31:

                                document.AVEVAReviewDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);

                                break;

                            case 32:

                                document.AVEVAStatus = value;

                                break;

                                   //AVEVAConnection = ws.Rows[p.Index].Cells[5].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                                   AVEVAConvertDate = ws.Rows[p.Index].Cells[29].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[29].Value.ToString()),

                                   AVEVAReviewDate = ws.Rows[p.Index].Cells[30].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[30].Value.ToString()),

                                   AVEVAStatus = ws.Rows[p.Index].Cells[31].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),

                                   AVEVAIssues = ws.Rows[p.Index].Cells[32].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[32].Value.ToString(),

                                   ProdReviewer = ws.Rows[p.Index].Cells[35].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[35].Value.ToString()).ID,

                                     AVEVAWorker = doc.AVEVAWorker,

                                     AVEVAConvertDate = doc.AVEVAConvertDate,

                                     AVEVAReviewDate = doc.AVEVAReviewDate,

                                     AVEVAStatus = doc.AVEVAStatus,

                                     AVEVAIssues = doc.AVEVAIssues,

                                     ProdReviewer = doc.ProdReviewer,

    ,AVEVAWorker

    ,AVEVAConvertDate

    ,AVEVAReviewDate

    ,AVEVAStatus

    ,AVEVAIssues

    ,ProdReviewer

    ,@AVEVAWorker

    ,@AVEVAConvertDate

    ,@AVEVAReviewDate

    ,@AVEVAStatus

    ,@AVEVAIssues

    ,@ProdReviewer

      ,AVEVAWorker=@AVEVAWorker

      ,AVEVAConvertDate=@AVEVAConvertDate

      ,AVEVAReviewDate=@AVEVAReviewDate

      ,AVEVAStatus=@AVEVAStatus

      ,AVEVAIssues=@AVEVAIssues

      ,ProdReviewer=@ProdReviewer

        [DataMember]

        public DateTime? AVEVAReviewDate { get; set; }

        [DataMember]

        public string AVEVAStatus { get; set; }

        [DataMember]

        public string AVEVAIssues { get; set; }

                && this.FrReviewStatus == other.FrReviewStatus && this.FrRemarks == other.FrRemarks && this.FrCreator == other.FrCreator

                && this.ID2StartDate == other.ID2StartDate && this.ID2EndDate == other.ID2EndDate && this.ID2Status == other.ID2Status

                && this.ID2Issues == other.ID2Issues && this.ReplyModifications == other.ReplyModifications && this.ReplyRequester == other.ReplyRequester && this.IsConvert == other.IsConvert && this.AVEVAPersonInCharge == other.AVEVAPersonInCharge && this.AVEVAWorker == other.AVEVAWorker

                && this.AVEVAStatus == other.AVEVAStatus && this.AVEVAIssues == other.AVEVAIssues

                && this.ProdReviewer == other.ProdReviewer && this.ProdIsResult == other.ProdIsResult && this.ProdRemarks == other.ProdRemarks && this.ClientReviewer == other.ClientReviewer

                && this.ClientIsResult == other.ClientIsResult && this.ClientRemarks == other.ClientRemarks && this.DTIsGateWay == other.DTIsGateWay && this.DTIsImport == other.DTIsImport

                + this.FrReviewStatus.GetNullableHash() + this.FrRemarks.GetNullableHash() + this.FrCreator.GetNullableHash()

                + this.ID2StartDate.GetNullableHash() + this.ID2EndDate.GetNullableHash() + this.ID2Status.GetNullableHash()

                + this.ID2Issues.GetNullableHash() + this.ReplyModifications.GetNullableHash() + this.ReplyRequester.GetNullableHash() + this.IsConvert.GetNullableHash() + this.AVEVAPersonInCharge.GetNullableHash() + this.AVEVAWorker.GetNullableHash()

                + this.AVEVAStatus.GetNullableHash() + this.AVEVAIssues.GetNullableHash()

                + this.ProdReviewer.GetNullableHash() + this.ProdIsResult.GetNullableHash() + this.ProdRemarks.GetNullableHash() + this.ClientReviewer.GetNullableHash()

                + this.ClientIsResult.GetNullableHash() + this.ClientRemarks.GetNullableHash() + this.DTIsGateWay.GetNullableHash() + this.DTIsImport.GetNullableHash()

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn13 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn3 = new Telerik.WinControls.UI.GridViewDateTimeColumn();

            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn4 = new Telerik.WinControls.UI.GridViewDateTimeColumn();

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn14 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn9 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn15 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));

            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 85F));

            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 25F));

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListFrReviewStatus, 4, 2);

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListToIsDiscussion, 2, 2);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelFrReviewStatus, 3, 2);

            this.radDropDownListFrReviewStatus.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListFrReviewStatus.DropDownAnimationEnabled = true;

            this.radDropDownListFrReviewStatus.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListFrReviewStatus.Name = "radDropDownListFrReviewStatus";

            this.radDropDownListFrReviewStatus.TabIndex = 18;

            // 

            // radDropDownListToIsDiscussion

            this.radDropDownListToIsDiscussion.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListToIsDiscussion.Location = new System.Drawing.Point(146, 60);

            this.radDropDownListToIsDiscussion.Name = "radDropDownListToIsDiscussion";

            this.radDropDownListToIsDiscussion.TabIndex = 17;

            // 

            // radLabelFrReviewStatus

            // 

            this.radLabelFrReviewStatus.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radLabelFrReviewStatus.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelFrReviewStatus.Name = "radLabelFrReviewStatus";

            this.radLabelFrReviewStatus.Size = new System.Drawing.Size(59, 17);

            this.radLabelFrReviewStatus.TabIndex = 7;

            // 

            this.radLabelAVEVAStatus.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radLabelAVEVAStatus.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelAVEVAStatus.Name = "radLabelAVEVAStatus";

            this.radLabelAVEVAStatus.Size = new System.Drawing.Size(86, 17);

            this.radLabelAVEVAStatus.TabIndex = 8;

            // 

            this.radLabelJobLevel.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabelJobLevel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelJobLevel.Name = "radLabelJobLevel";

            this.radLabelJobLevel.Size = new System.Drawing.Size(47, 17);

            this.radLabelJobLevel.TabIndex = 7;

            this.radButtonSearch.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)));

            this.radButtonSearch.Cursor = System.Windows.Forms.Cursors.Default;

            this.radButtonSearch.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radButtonSearch.Name = "radButtonSearch";

            this.tableLayoutPanelCondition.SetRowSpan(this.radButtonSearch, 5);

            this.radButtonSearch.Size = new System.Drawing.Size(54, 138);

            this.radDropDownListProject.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListProject.Location = new System.Drawing.Point(146, 32);

            this.radDropDownListProject.Name = "radDropDownListProject";

            this.radDropDownListProject.TabIndex = 7;

            // 

            // radLabelDocumentNo

            // 

            this.radLabelDocumentNo.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabelDocumentNo.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelDocumentNo.Name = "radLabelDocumentNo";

            this.radLabelDocumentNo.Size = new System.Drawing.Size(52, 17);

            this.radLabelDocumentNo.TabIndex = 6;

            // radTextBoxDocumentNo

            // 

            this.radTextBoxDocumentNo.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radTextBoxDocumentNo.Name = "radTextBoxDocumentNo";

            this.radTextBoxDocumentNo.TabIndex = 8;

            // 

            // radLabelPersonInCharge

            // 

            this.radLabelPersonInCharge.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabelPersonInCharge.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelPersonInCharge.Name = "radLabelPersonInCharge";

            this.radLabelPersonInCharge.Size = new System.Drawing.Size(47, 17);

            this.radLabelPersonInCharge.TabIndex = 6;

            this.radDropDownListPersonInCharge.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListPersonInCharge.DropDownAnimationEnabled = true;

            this.radDropDownListPersonInCharge.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListPersonInCharge.Name = "radDropDownListPersonInCharge";

            this.radDropDownListPersonInCharge.TabIndex = 9;

            // 

            // radLabel1

            this.radDropDownListJobLevel.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListJobLevel.DropDownAnimationEnabled = true;

            this.radDropDownListJobLevel.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListJobLevel.Name = "radDropDownListJobLevel";

            this.radDropDownListJobLevel.TabIndex = 11;

            // 

            // radLabelID2Status

            // 

            this.radLabel10.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabel10.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabel10.Name = "radLabel10";

            this.radLabel10.Size = new System.Drawing.Size(61, 17);

            this.radLabel10.TabIndex = 9;

            this.radDropDownListID2Status.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListID2Status.Location = new System.Drawing.Point(146, 88);

            this.radDropDownListID2Status.Name = "radDropDownListID2Status";

            this.radDropDownListID2Status.TabIndex = 13;

            // 

            // radDropDownListAVEVAStatus

            this.radDropDownListAVEVAStatus.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListAVEVAStatus.DropDownAnimationEnabled = true;

            this.radDropDownListAVEVAStatus.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListAVEVAStatus.Name = "radDropDownListAVEVAStatus";

            this.radDropDownListAVEVAStatus.TabIndex = 14;

            // 

            // radDropDownListProdIsResult

            this.radDropDownListProdIsResult.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListProdIsResult.Location = new System.Drawing.Point(146, 116);

            this.radDropDownListProdIsResult.Name = "radDropDownListProdIsResult";

            this.radDropDownListProdIsResult.TabIndex = 15;

            // 

            // radDropDownListClientIsResult

            this.radDropDownListClientIsResult.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListClientIsResult.DropDownAnimationEnabled = true;

            this.radDropDownListClientIsResult.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListClientIsResult.Name = "radDropDownListClientIsResult";

            this.radDropDownListClientIsResult.TabIndex = 16;

            // 

            // radLabel6

            // 

            this.radLabel7.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabel7.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabel7.Name = "radLabel7";

            this.radLabel7.Size = new System.Drawing.Size(72, 17);

            this.radLabel7.TabIndex = 12;

            this.radDropDownListGateway.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListGateway.Location = new System.Drawing.Point(146, 147);

            this.radDropDownListGateway.Name = "radDropDownListGateway";

            this.radDropDownListGateway.TabIndex = 19;

            // 

            // radDropDownListRegistration

            this.radDropDownListRegistration.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListRegistration.DropDownAnimationEnabled = true;

            this.radDropDownListRegistration.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListRegistration.Name = "radDropDownListRegistration";

            this.radDropDownListRegistration.TabIndex = 20;

            // 

            // radLabel8

            // 

            this.radLabelID2Issues.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.radLabelID2Issues.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelID2Issues.Name = "radLabelID2Issues";

            this.radLabelID2Issues.Size = new System.Drawing.Size(59, 17);

            this.radLabelID2Issues.TabIndex = 23;

            // 

            this.radLabelAVEVAIssues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radLabelAVEVAIssues.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.radLabelAVEVAIssues.Name = "radLabelAVEVAIssues";

            this.radLabelAVEVAIssues.Size = new System.Drawing.Size(81, 17);

            this.radLabelAVEVAIssues.TabIndex = 24;

            this.radDropDownListID2Issues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListID2Issues.DropDownAnimationEnabled = true;

            this.radDropDownListID2Issues.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListID2Issues.Name = "radDropDownListID2Issues";

            this.radDropDownListID2Issues.TabIndex = 25;

            // 

            // radDropDownListAVEVAIssues

            this.radDropDownListAVEVAIssues.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Left | System.Windows.Forms.AnchorStyles.Right)));

            this.radDropDownListAVEVAIssues.DropDownAnimationEnabled = true;

            this.radDropDownListAVEVAIssues.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            this.radDropDownListAVEVAIssues.Name = "radDropDownListAVEVAIssues";

            this.radDropDownListAVEVAIssues.TabIndex = 26;

            // 

            // tableLayoutPanelGroup

            gridViewDateTimeColumn4.Name = "AVEVAReviewDate";

            gridViewDateTimeColumn4.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;

            gridViewDateTimeColumn4.Width = 70;

            gridViewComboBoxColumn14.EnableExpressionEditor = false;

            gridViewComboBoxColumn14.FieldName = "AVEVAStatus";

            gridViewComboBoxColumn14.HeaderText = "Status";

            gridViewComboBoxColumn13,

            gridViewDateTimeColumn3,

            gridViewDateTimeColumn4,

            gridViewComboBoxColumn14,

            gridViewTextBoxColumn9,

            gridViewComboBoxColumn15,

                               //AVEVAConnection = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               AVEVAConvertDate = ws.Rows[p.Index].Cells[29].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[29].Value.ToString()),

                               AVEVAReviewDate = ws.Rows[p.Index].Cells[30].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[30].Value.ToString()),

                               AVEVAStatus = ws.Rows[p.Index].Cells[31].Value == null ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),

                               AVEVAIssues = ws.Rows[p.Index].Cells[32].Value == null ? string.Empty : ws.Rows[p.Index].Cells[32].Value.ToString(),

                               ProdReviewer = ws.Rows[p.Index].Cells[35].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[35].Value.ToString()).ID,

                            //templateWorksheet.Cells[rowIndex, 28].Value = doc.AVEVAConnection;

                            templateWorksheet.Cells[rowIndex, 29].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";

                            templateWorksheet.Cells[rowIndex, 30].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";

                            templateWorksheet.Cells[rowIndex, 31].Value = doc.AVEVAStatus;

                            templateWorksheet.Cells[rowIndex, 32].Value = doc.AVEVAIssues;

                            //templateWorksheet.Cells[rowIndex, 33].Value = doc.DocumentNo;

            List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToCreator", "ToCapture" };

            List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrCreator", "FrCapture" };

            List<string> wkID2ColNames = new List<string>() { "ID2StartDate", "ID2EndDate", "ID2Status", "ID2Issues", "ReplyModifications", "ReplyRequester", "IsConvert" };

            List<string> valProdColNames = new List<string>() { "ProdReviewer", "ProdIsResult", "ProdRemarks", "ProdCapture" };

            List<string> valCntColNames = new List<string>() { "ClientReviewer", "ClientIsResult", "ClientRemarks", "ClientCapture" };

            List<string> dtColNames = new List<string>() { "DTIsGateWay", "DTIsImport", "DTIsRegSystem", "DTRemarks" };