HYTOS

                                document.JobLevel = value;

                                break;

                            case 11:

                                document.RevisonNo = value;

                                break;

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

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

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

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

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

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

                                     MarkupLink = doc.MarkupLink,

                                     AVEVALink = doc.AVEVALink,

                                     JobLevel = doc.JobLevel,

                                     PersonInCharge = doc.PersonInCharge,

                                     IsDeleted = doc.IsDeleted,

                                     RegisteredDate = doc.RegisteredDate,

                                     FrReviewStatus = doc.FrReviewStatus,

                                     FrRemarks = doc.FrRemarks,

                                     FrCreator = doc.FrCreator,

                                     ID2StartDate = doc.ID2StartDate,

                                     ID2EndDate = dw?.DATETIME == null ? (DateTime?)null : Convert.ToDateTime(dw?.DATETIME),

                                     ID2Status = doc.ID2Status,

                                     ID2Issues = doc.ID2Issues,

                                     AVEVAConvertDate = doc.AVEVAConvertDate,

                                     AVEVAReviewDate = doc.AVEVAReviewDate,

                                     AVEVAStatus = doc.AVEVAStatus,

    ,SubSystemCode

    ,RefProjectCode

    ,JobLevel

    ,PersonInCharge

    ,RegisteredDate

    ,RegisteredUser

    ,FrReviewStatus

    ,FrRemarks

    ,FrCreator

    ,ID2StartDate

    ,ID2EndDate

    ,ID2Status

    ,ID2Issues

    ,AVEVAConvertDate

    ,AVEVAReviewDate

    ,AVEVAStatus

    ,@SubSystemCode

    ,@RefProjectCode

    ,@JobLevel

    ,@PersonInCharge

    ,getdate()

    ,@RegisteredUser

    ,@FrReviewStatus

    ,@FrRemarks

    ,@FrCreator

    ,@ID2StartDate

    ,@ID2EndDate

    ,@ID2Status

    ,@ID2Issues

    ,@AVEVAConvertDate

    ,@AVEVAReviewDate

    ,@AVEVAStatus

      ,SubSystemCode=@SubSystemCode

      ,RefProjectCode=@RefProjectCode

      ,JobLevel=@JobLevel

      ,PersonInCharge=@PersonInCharge

      ,ModifiedDate=getdate()

      ,ModifiedUser=@ModifiedUser

      ,FrReviewStatus=@FrReviewStatus

      ,FrRemarks=@FrRemarks

      ,FrCreator=@FrCreator

      ,ID2StartDate=@ID2StartDate

      ,ID2EndDate=@ID2EndDate

      ,ID2Status=@ID2Status

      ,ID2Issues=@ID2Issues

      ,AVEVAConvertDate=@AVEVAConvertDate

      ,AVEVAReviewDate=@AVEVAReviewDate

      ,AVEVAStatus=@AVEVAStatus

        [DataMember]

        public string JobLevel { get; set; }

        [DataMember]

        public string PersonInCharge { get; set; }

        private string _Worker = string.Empty;

        [DataMember]

        public string FrCreator { get; set; }

        public int FrCapture { get; set; }

        [DataMember]

        public DateTime? ID2StartDate { get; set; }

        [DataMember]

        public DateTime? ID2EndDate { get; set; }

        [DataMember]

        public string ID2Issues { get; set; }

        [DataMember]

        public DateTime? AVEVAConvertDate { get; set; }

        [DataMember]

        public DateTime? AVEVAReviewDate { get; set; }

            bool result = other != null && this.DocumentNo == other.DocumentNo && this.RevisonNo == other.RevisonNo && this.System == other.System && this.SubSystemCode == other.SubSystemCode

                && this.RefProjectCode == other.RefProjectCode && this.IsLatest == other.IsLatest && this.AutoCADFilie == other.AutoCADFilie && this.PDFFile == other.PDFFile

                && this.PersonInCharge == other.PersonInCharge && this.IsDeleted == other.IsDeleted && this.ToIsDiscussion == other.ToIsDiscussion && this.ToRemarks == other.ToRemarks

                && this.ToCreator == other.ToCreator

                && 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.AVEVAStatus == other.AVEVAStatus && this.AVEVAIssues == other.AVEVAIssues && this.ReviewFilePath == other.ReviewFilePath && this.ReviewFileName == other.ReviewFileName

                && 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

        {

            return this.DocumentNo.GetNullableHash() + this.RevisonNo.GetNullableHash() + this.System.GetNullableHash() + this.SubSystemCode.GetNullableHash()

                + this.RefProjectCode.GetNullableHash() + this.IsLatest.GetNullableHash() + this.AutoCADFilie.GetNullableHash() + this.PDFFile.GetNullableHash()

                + this.PersonInCharge.GetNullableHash() + this.IsDeleted.GetNullableHash() + this.ToIsDiscussion.GetNullableHash() + this.ToRemarks.GetNullableHash()

                + this.ToCreator.GetNullableHash()

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

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

                + this.AVEVAStatus.GetNullableHash() + this.AVEVAIssues.GetNullableHash() + this.ReviewFilePath.GetNullableHash() + this.ReviewFileName.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 gridViewComboBoxColumn2 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

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

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

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

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

            Telerik.WinControls.UI.GridViewImageColumn gridViewImageColumn1 = new Telerik.WinControls.UI.GridViewImageColumn();

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

            Telerik.WinControls.UI.GridViewImageColumn gridViewImageColumn2 = new Telerik.WinControls.UI.GridViewImageColumn();

            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn5 = new Telerik.WinControls.UI.GridViewCommandColumn();

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

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

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

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

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

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

            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn7 = new Telerik.WinControls.UI.GridViewCommandColumn();

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

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

            Telerik.WinControls.UI.GridViewImageColumn gridViewImageColumn3 = new Telerik.WinControls.UI.GridViewImageColumn();

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

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

            Telerik.WinControls.UI.GridViewImageColumn gridViewImageColumn4 = new Telerik.WinControls.UI.GridViewImageColumn();

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

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

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

            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition1 = new Telerik.WinControls.UI.TableViewDefinition();

            Telerik.WinControls.UI.GridViewRelation gridViewRelation1 = new Telerik.WinControls.UI.GridViewRelation();

            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);

            gridViewComboBoxColumn4.Name = "JobLevel";

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

            gridViewComboBoxColumn4.Width = 60;

            gridViewTextBoxColumn4.EnableExpressionEditor = false;

            gridViewTextBoxColumn4.FieldName = "RevisonNo";

            gridViewTextBoxColumn4.HeaderText = "Rev.";

            gridViewTextBoxColumn4.Name = "RevisonNo";

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

            gridViewTextBoxColumn5.EnableExpressionEditor = false;

            gridViewTextBoxColumn5.FieldName = "ToRemarks";

            gridViewTextBoxColumn5.HeaderText = "Brief";

            gridViewTextBoxColumn5.Multiline = true;

            gridViewTextBoxColumn5.Name = "ToRemarks";

            gridViewTextBoxColumn5.Width = 150;

            gridViewImageColumn1.HeaderText = "Detail(캡쳐)";

            gridViewImageColumn1.Name = "ToCapture";

            gridViewImageColumn1.Width = 80;

            gridViewTextBoxColumn6.EnableExpressionEditor = false;

            gridViewTextBoxColumn6.FieldName = "FrRemarks";

            gridViewTextBoxColumn6.HeaderText = "Brief";

            gridViewTextBoxColumn6.Name = "FrRemarks";

            gridViewTextBoxColumn6.Width = 150;

            gridViewImageColumn2.HeaderText = "Detail(캡쳐)";

            gridViewImageColumn2.Name = "FrCapture";

            gridViewImageColumn2.Width = 80;

            gridViewCommandColumn5.EnableExpressionEditor = false;

            gridViewCommandColumn5.Name = "ID2Connection";

            gridViewCommandColumn5.Width = 70;

            gridViewDateTimeColumn1.EnableExpressionEditor = false;

            gridViewDateTimeColumn2.ReadOnly = true;

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

            gridViewDateTimeColumn2.Width = 120;

            gridViewTextBoxColumn7.EnableExpressionEditor = false;

            gridViewTextBoxColumn7.FieldName = "ID2Issues";

            gridViewTextBoxColumn7.HeaderText = "이슈사항";

            gridViewTextBoxColumn7.Name = "ID2Issues";

            gridViewTextBoxColumn7.Width = 150;

            gridViewDateTimeColumn3.EnableExpressionEditor = false;

            gridViewDateTimeColumn3.FieldName = "AVEVAConvertDate";

            gridViewDateTimeColumn3.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

            gridViewDateTimeColumn4.Name = "AVEVAReviewDate";

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

            gridViewDateTimeColumn4.Width = 70;

            gridViewTextBoxColumn8.EnableExpressionEditor = false;

            gridViewTextBoxColumn8.FieldName = "AVEVAIssues";

            gridViewTextBoxColumn8.HeaderText = "이슈사항";

            gridViewTextBoxColumn8.Name = "AVEVAIssues";

            gridViewTextBoxColumn8.Width = 150;

            gridViewCommandColumn7.EnableExpressionEditor = false;

            gridViewCommandColumn7.Width = 70;

            gridViewComboBoxColumn12.EnableExpressionEditor = false;

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

            gridViewTextBoxColumn9.EnableExpressionEditor = false;

            gridViewTextBoxColumn9.FieldName = "ProdRemarks";

            gridViewTextBoxColumn9.HeaderText = "비고";

            gridViewTextBoxColumn9.Width = 150;

            gridViewImageColumn3.HeaderText = "캡쳐";

            gridViewImageColumn3.Name = "ProdCapture";

            gridViewComboBoxColumn14.EnableExpressionEditor = false;

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

            gridViewTextBoxColumn10.EnableExpressionEditor = false;

            gridViewTextBoxColumn10.FieldName = "ClientRemarks";

            gridViewTextBoxColumn10.HeaderText = "비고";

            gridViewTextBoxColumn10.Width = 150;

            gridViewImageColumn4.HeaderText = "캡쳐";

            gridViewImageColumn4.Name = "ClientCapture";

            gridViewComboBoxColumn16.EnableExpressionEditor = false;

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

            gridViewComboBoxColumn16.Width = 80;

            gridViewComboBoxColumn17.EnableExpressionEditor = false;

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

            gridViewComboBoxColumn17.Width = 80;

            gridViewTextBoxColumn11.EnableExpressionEditor = false;

            gridViewTextBoxColumn11.FieldName = "DTRemarks";

            gridViewTextBoxColumn11.HeaderText = "비고";

            gridViewComboBoxColumn2,

            gridViewComboBoxColumn3,

            gridViewComboBoxColumn4,

            gridViewTextBoxColumn4,

            gridViewTextBoxColumn5,

            gridViewImageColumn1,

            gridViewTextBoxColumn6,

            gridViewImageColumn2,

            gridViewCommandColumn5,

            gridViewDateTimeColumn1,

            gridViewDateTimeColumn2,

            gridViewTextBoxColumn7,

            gridViewDateTimeColumn3,

            gridViewDateTimeColumn4,

            gridViewTextBoxColumn8,

            gridViewCommandColumn7,

            gridViewComboBoxColumn12,

            gridViewTextBoxColumn9,

            gridViewImageColumn3,

            gridViewComboBoxColumn14,

            gridViewTextBoxColumn10,

            gridViewImageColumn4,

            gridViewComboBoxColumn16,

            gridViewComboBoxColumn17,

            gridViewTextBoxColumn11});

            this.radGridViewDocuments.MasterTemplate.EnableAlternatingRowColor = true;

            this.radGridViewDocuments.MasterTemplate.EnableFiltering = true;

            // 

            // radPageViewPageAutoCAD

            // 

            this.radPageViewPageAutoCAD.Location = new System.Drawing.Point(10, 37);

            this.radPageViewPageAutoCAD.Name = "radPageViewPageAutoCAD";

            this.radPageViewPageAutoCAD.Size = new System.Drawing.Size(258, 146);

                        }

                        break;

                    case "AVEVALink":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "ReviewFileName"://일단주석

                        GridViewComboBoxColumn colJobLevel = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        colJobLevel.DataSource = informations.JobLevel;

                        break;

                    case "ToIsDiscussion":

                    case "DTIsImport":

                    case "DTIsGateWay":

                            case "PDFLink":

                            case "MarkupLink":

                            case "AVEVALink":

                            case "ReviewFileName"://일단주석

                            case "SystemLink":

                            case "ID2Connection":

                    bitmap = new Bitmap(Properties.Resources.markus18);

                    break;

                case "AVEVALink":

                    bitmap = new Bitmap(Properties.Resources.aveva_net18);

                    break;

                case "ReviewFileName"://일단주석

                case "PDFLink":

                case "MarkupLink":

                case "AVEVALink":

                case "ReviewFileName"://일단주석

                case "SystemLink":

                case "ID2Connection":

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

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

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

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

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

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

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

                            templateWorksheet.Cells[rowIndex, 7].Value = this.GetUser(doc.PersonInCharge).Name;

                            templateWorksheet.Cells[rowIndex, 8].Value = doc.JobLevel;

                            templateWorksheet.Cells[rowIndex, 10].Value = doc.RevisonNo;

                            templateWorksheet.Cells[rowIndex, 11].Value = doc.ToIsDiscussion;

                            templateWorksheet.Cells[rowIndex, 12].Value = doc.ToRemarks;

                            //templateWorksheet.Cells[rowIndex, 19].Value = doc.FrCapture;

                            //templateWorksheet.Cells[rowIndex, 20].Value = doc.FrIsMarkup;

                            //templateWorksheet.Cells[rowIndex, 21].Value = doc.IsID2Work;

                            templateWorksheet.Cells[rowIndex, 23].Value = $"{doc.ID2StartDate:yyyy/MM/dd hh:mm:ss}";

                            templateWorksheet.Cells[rowIndex, 24].Value = $"{doc.ID2EndDate:yyyy/MM/dd hh:mm:ss}";

                            //templateWorksheet.Cells[rowIndex, 25].Value = doc.ID2JobTime;

                            templateWorksheet.Cells[rowIndex, 26].Value = doc.ID2Status;

                            templateWorksheet.Cells[rowIndex, 27].Value = doc.ID2Issues;

                            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;

        {

            ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition();

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

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

            List<string> valLinkColNames = new List<string>() { "ReviewFileName", "SystemLink" };

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

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