HYTOS

                                    });

                                }

                                break;

                            case 24:

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

                                break;

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

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

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

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

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

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

            }

        }

        {

            try

            {

                using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

                {

                }

            }

            catch (Exception ex)

            }

        }

        {

            try

            {

                IEnumerable<Documents> docs = dwgs;

                List<ID2Drawings> id2docs = null;

                                     ToIsDiscussion = doc.ToIsDiscussion,

                                     ToRemarks = doc.ToRemarks,

                                     ToCreator = doc.ToCreator,

                                     FrReviewStatus = doc.FrReviewStatus,

                                     FrRemarks = doc.FrRemarks,

                                     FrCreator = doc.FrCreator,

                                     ID2Connection = doc.ID2Connection,

                                     ID2StartDate = doc.ID2StartDate,

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

        }

        {

            var map = new CustomPropertyTypeMap(typeof(AttFileInfo), (type, columnName)

     => type.GetProperties().FirstOrDefault(prop => GetDescriptionFromAttribute(prop) == columnName.ToLower()));

                parameters.Add("FrReviewStatus", isFrReviewStatus);

            }

            if (!string.IsNullOrEmpty(id2Status))

            {

                sbWhere.Append(" and doc.ID2Status=@ID2Status ");

    ,ToIsDiscussion

    ,ToRemarks

    ,ToCreator

    ,FrReviewStatus

    ,FrRemarks

    ,FrCreator

    ,ID2Connection

    ,ID2StartDate

    ,ID2EndDate

    ,@ToIsDiscussion

    ,@ToRemarks

    ,@ToCreator

    ,@FrReviewStatus

    ,@FrRemarks

    ,@FrCreator

    ,@ID2Connection

    ,@ID2StartDate

    ,@ID2EndDate

      ,ToIsDiscussion=@ToIsDiscussion

      ,ToRemarks=@ToRemarks

      ,ToCreator=@ToCreator

      ,FrReviewStatus=@FrReviewStatus

      ,FrRemarks=@FrRemarks

      ,FrCreator=@FrCreator

      ,ID2Connection=@ID2Connection

      ,ID2StartDate=@ID2StartDate

      ,ID2EndDate=@ID2EndDate

        public string ToCreator { get; set; }

        public int ToCapture { get; set; }

        [DataMember]

        public string FrReviewStatus { get; set; }

        [DataMember]

        public string FrRemarks { get; set; }

        public string FrCreator { get; set; }

        public int FrCapture { get; set; }

        [DataMember]

        public string ID2Connection { get; set; }

        [DataMember]

        public DateTime? ID2StartDate { get; set; }

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

                && this.MarkupLink == other.MarkupLink && this.AVEVALink == other.AVEVALink && this.JobLevel == other.JobLevel && this.IsTypical == other.IsTypical

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

                && 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.AVEVAConnection == other.AVEVAConnection && this.AVEVAConvertDate == other.AVEVAConvertDate && this.AVEVAReviewDate == other.AVEVAReviewDate

                && this.AVEVAStatus == other.AVEVAStatus && this.AVEVAIssues == other.AVEVAIssues && this.ReviewFilePath == other.ReviewFilePath && this.ReviewFileName == other.ReviewFileName

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

                + this.MarkupLink.GetNullableHash() + this.AVEVALink.GetNullableHash() + this.JobLevel.GetNullableHash() + this.IsTypical.GetNullableHash()

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

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

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

                + this.ID2Issues.GetNullableHash() + this.AVEVAConnection.GetNullableHash() + this.AVEVAConvertDate.GetNullableHash() + this.AVEVAReviewDate.GetNullableHash()

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

        string DocumentNo { get; set; } 

        string IsToIsDiscussion { get; set; }

        string IsFrReviewStatus { get; set; }

        string Id2Issues { get; set; }

        string Id2Status { get; set; }

        string AvevaStatus { get; set; }

        string DTIsGateWay { get; set; }

        string DTIsRegSystem { get; set; }

        {

            this.DateTypes = dateTypes;

            this.FrDate = frDate;

            this.DocumentNo = documentNo;

            this.IsToIsDiscussion = isToIsDiscussion;

            this.IsFrReviewStatus = isFrReviewStatus;

            this.Id2Status = id2Status;

            this.Id2Issues = id2Issues;

            this.AvevaStatus = avevaStatus;

        {

            try

            {

                e.Result = new DocumentsResult() { Dwgs = dwgs.ToList(), TotalCount = totalCnt };

            }

            catch (Exception ex)

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

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

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

            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.GridViewCommandColumn gridViewCommandColumn6 = new Telerik.WinControls.UI.GridViewCommandColumn();

            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.GridViewCommandColumn gridViewCommandColumn8 = new Telerik.WinControls.UI.GridViewCommandColumn();

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

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

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

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

            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.radLabelToIsDiscussion = new Telerik.WinControls.UI.RadLabel();

            this.radLabel9 = new Telerik.WinControls.UI.RadLabel();

            this.radLabelAVEVAStatus = new Telerik.WinControls.UI.RadLabel();

            this.radLabelJobLevel = new Telerik.WinControls.UI.RadLabel();

            this.radLabel4 = new Telerik.WinControls.UI.RadLabel();

            this.radLabel3 = new Telerik.WinControls.UI.RadLabel();

            this.radDropDownListJobLevel = new Telerik.WinControls.UI.RadDropDownList();

            this.radLabelID2Status = new Telerik.WinControls.UI.RadLabel();

            this.radLabel10 = new Telerik.WinControls.UI.RadLabel();

            this.radDropDownListID2Status = new Telerik.WinControls.UI.RadDropDownList();

            this.radDropDownListAVEVAStatus = new Telerik.WinControls.UI.RadDropDownList();

            this.radDropDownListProdIsResult = new Telerik.WinControls.UI.RadDropDownList();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelToIsDiscussion)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel9)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelAVEVAStatus)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelJobLevel)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel4)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel3)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListJobLevel)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelID2Status)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel10)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListID2Status)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListAVEVAStatus)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListProdIsResult)).BeginInit();

            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.tableLayoutPanelCondition.Controls.Add(this.radLabelToIsDiscussion, 1, 2);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabel9, 1, 4);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelAVEVAStatus, 5, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelJobLevel, 5, 1);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabel4, 0, 4);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabel3, 0, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListJobLevel, 6, 1);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabelID2Status, 1, 3);

            this.tableLayoutPanelCondition.Controls.Add(this.radLabel10, 3, 4);

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

            this.tableLayoutPanelCondition.Controls.Add(this.radDropDownListAVEVAStatus, 6, 3);

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

            this.radLabelAVEVAStatus.TabIndex = 8;

            this.radLabelAVEVAStatus.Text = "AVEVA Status";

            // 

            // radLabelJobLevel

            // 

            this.radLabelJobLevel.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.Location = new System.Drawing.Point(693, 34);

            this.radLabelDocumentNo.Name = "radLabelDocumentNo";

            this.radLabelDocumentNo.TabIndex = 6;

            this.radLabelDocumentNo.Text = "DWG ID";

            // 

            this.radLabel10.TabIndex = 9;

            this.radLabel10.Text = "삼성결과";

            // 

            // radDropDownListID2Status

            // 

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

            gridViewImageColumn1.Name = "ToCapture";

            gridViewImageColumn1.Width = 80;

            gridViewComboBoxColumn8.EnableExpressionEditor = false;

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

            gridViewComboBoxColumn8.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.FieldName = "ID2Connection";

            gridViewCommandColumn5.HeaderText = "연결";

            gridViewDateTimeColumn2.ReadOnly = true;

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

            gridViewDateTimeColumn2.Width = 120;

            gridViewTextBoxColumn7.EnableExpressionEditor = false;

            gridViewTextBoxColumn7.FieldName = "ID2Issues";

            gridViewTextBoxColumn7.HeaderText = "이슈사항";

            gridViewDateTimeColumn4.Name = "AVEVAReviewDate";

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

            gridViewDateTimeColumn4.Width = 70;

            gridViewTextBoxColumn8.EnableExpressionEditor = false;

            gridViewTextBoxColumn8.FieldName = "AVEVAIssues";

            gridViewTextBoxColumn8.HeaderText = "이슈사항";

            gridViewCommandColumn8.HeaderText = "시스템";

            gridViewCommandColumn8.Name = "SystemLink";

            gridViewCommandColumn8.Width = 70;

            gridViewTextBoxColumn9.EnableExpressionEditor = false;

            gridViewTextBoxColumn9.FieldName = "ProdRemarks";

            gridViewTextBoxColumn9.HeaderText = "비고";

            gridViewTextBoxColumn9.Width = 150;

            gridViewImageColumn3.HeaderText = "캡쳐";

            gridViewImageColumn3.Name = "ProdCapture";

            gridViewTextBoxColumn10.EnableExpressionEditor = false;

            gridViewTextBoxColumn10.FieldName = "ClientRemarks";

            gridViewTextBoxColumn10.HeaderText = "비고";

            gridViewTextBoxColumn10.Width = 150;

            gridViewImageColumn4.HeaderText = "캡쳐";

            gridViewImageColumn4.Name = "ClientCapture";

            gridViewTextBoxColumn11.EnableExpressionEditor = false;

            gridViewTextBoxColumn11.FieldName = "DTRemarks";

            gridViewTextBoxColumn11.HeaderText = "비고";

            gridViewComboBoxColumn7,

            gridViewImageColumn1,

            gridViewComboBoxColumn8,

            gridViewTextBoxColumn6,

            gridViewImageColumn2,

            gridViewCommandColumn5,

            gridViewDateTimeColumn1,

            gridViewDateTimeColumn2,

            gridViewTextBoxColumn7,

            gridViewCommandColumn6,

            gridViewDateTimeColumn3,

            gridViewDateTimeColumn4,

            gridViewTextBoxColumn8,

            gridViewCommandColumn7,

            gridViewCommandColumn8,

            gridViewTextBoxColumn9,

            gridViewImageColumn3,

            gridViewTextBoxColumn10,

            gridViewImageColumn4,

            gridViewTextBoxColumn11});

            this.radGridViewDocuments.MasterTemplate.EnableAlternatingRowColor = true;

            this.radGridViewDocuments.MasterTemplate.EnableFiltering = true;

            ((System.ComponentModel.ISupportInitialize)(this.radLabelToIsDiscussion)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel9)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelAVEVAStatus)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelJobLevel)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel4)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel3)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListJobLevel)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabelID2Status)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radLabel10)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListID2Status)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListAVEVAStatus)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.radDropDownListProdIsResult)).EndInit();

        private Telerik.WinControls.UI.RadLabel radLabel1;

        private Telerik.WinControls.UI.RadLabel radLabelJobLevel;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListJobLevel;

        private Telerik.WinControls.UI.RadLabel radLabel9;

        private Telerik.WinControls.UI.RadLabel radLabelAVEVAStatus;

        private Telerik.WinControls.UI.RadLabel radLabelID2Status;

        private Telerik.WinControls.UI.RadLabel radLabel10;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListID2Status;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListAVEVAStatus;

        private Telerik.WinControls.UI.RadDropDownList radDropDownListProdIsResult;

                var allFrReviewStatus = new RadListDataItem("== 전체 ==", string.Empty);

                this.radDropDownListFrReviewStatus.Items.Insert(0, allFrReviewStatus);

                allFrReviewStatus.Selected = true;

                #endregion

                #region 작업

                    string isToIsDiscussion = this.radDropDownListToIsDiscussion.SelectedValue.ToString();

                    string isFrReviewStatus = this.radDropDownListFrReviewStatus.SelectedValue.ToString();

                    string id2Status = this.radDropDownListID2Status.SelectedValue.ToString();

                    string id2Issues = this.radDropDownListID2Issues.SelectedValue.ToString();

                    string isGateWay = this.radDropDownListGateway.SelectedValue.ToString();

                    string isRegSystem = this.radDropDownListRegistration.SelectedValue.ToString();

                    worker.OnWorkCompletedHandler += (e) =>

                    {

                        var docData = e.Result as DocumentsResult;

                        break;

                    case "IsTypical":

                    case "ToIsDiscussion":

                    case "DTIsImport":

                    case "DTIsGateWay":

                    case "DTIsRegSystem":

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

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

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

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

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

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

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

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

                            //templateWorksheet.Cells[rowIndex, 14].Value = doc.ToCapture;

                            templateWorksheet.Cells[rowIndex, 16].Value = doc.FrReviewStatus;

                            templateWorksheet.Cells[rowIndex, 17].Value = doc.FrRemarks;

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

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

                            templateWorksheet.Cells[rowIndex, 22].Value = doc.ID2Connection;

                            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}";

            List<string> docLinkColNames = new List<string>() { "AutoCADLink", "PDFLink", "MarkupLink", "AVEVALink" };

            List<string> docInfoColNames = new List<string>() { "RefProjectCode", "System", "SubSystemCode", "DocumentNo", "PersonInCharge", "Worker", "JobLevel", "IsTypical", "RevisonNo" };

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

            List<string> wkAVEVAColNames = new List<string>() { "AVEVAConnection", "AVEVAConvertDate", "AVEVAReviewDate", "AVEVAStatus", "AVEVAIssues" };

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

            GridViewColumnGroup rvColGrp = new GridViewColumnGroup("검토", "review");

            GridViewColumnGroup rvToColGrp = new GridViewColumnGroup("도프텍");

            GridViewColumnGroup rvFrColGrp = new GridViewColumnGroup("삼성");

            GridViewColumnGroupRow rvToColGrpRow = new GridViewColumnGroupRow();

            rvToColGrpRow.ColumnNames.AddRange(rvToColNames);

            GridViewColumnGroupRow rvFrColGrpRow = new GridViewColumnGroupRow();

            rvFrColGrpRow.ColumnNames.AddRange(rvFrColNames);

            rvToColGrp.Rows.Add(rvToColGrpRow);

            rvFrColGrp.Rows.Add(rvFrColGrpRow);

            rvColGrp.Groups.Add(rvToColGrp);

            rvColGrp.Groups.Add(rvFrColGrp);

            //작업

            GridViewColumnGroup wkColGrp = new GridViewColumnGroup("작업", "work");