HYTOS

        private readonly List<string> _JobLevel = new List<string>() { "1", "2", "3", "4", "5" };

        public List<string> JobLevel

        {

            get { return _JobLevel; }

        }

        private readonly List<string> _IsYesNo = new List<string>() { "Yes", "No" };

        public List<string> IsYesNo

        {

            get { return _IsYesNo; }

        }

        private readonly List<string> _ClientStatus = new List<string>() { "검토중", "회신완료" };

        public List<string> ClientStatus

        {

            get { return _ClientStatus; }

        }

        private readonly List<string> _ValidationResult = new List<string>() { "Ｏ", "Ｘ" };

        public List<string> ValidationResult

        {

            get { return _ValidationResult; }

        }

        private readonly List<string> _JobStatus = new List<string>() { "시작전", "진행중", "완료", "기타" };

        public List<string> JobStatus

        {

            get { return _JobStatus; }

        }

        public string IsTypical { get; set; }

        public string ToIsDiscussion { get; set; }

        public string ToIsMarkup { get; set; }

        public string FrIsMarkup { get; set; }

        public string IsID2Work { get; set; }

        public string DTIsGateWay { get; set; }

        public string DTIsImport { get; set; }

        public string DTIsRegSystem { get; set; }

    <Compile Include="Settings.cs" />

    <None Include="Template\Samsung Elec Task Management.xlsx">

      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>

    </None>

  <ItemGroup>

    <None Include="Resources\pdf20.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\pdf18.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\link18_green.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\cad18.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\link18_blue.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\link18_yellow.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\files18.png" />

  </ItemGroup>

  <ItemGroup>

    <None Include="Resources\link18_purple.png" />

  </ItemGroup>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.radRibbonBarGroup1 = new Telerik.WinControls.UI.RadRibbonBarGroup();

            this.radButtonElementExcelImport = new Telerik.WinControls.UI.RadButtonElement();

            this.radButtonElementExcelExport = new Telerik.WinControls.UI.RadButtonElement();

            // radRibbonBarGroup1

            // 

            this.radRibbonBarGroup1.Items.AddRange(new Telerik.WinControls.RadItem[] {

            this.radButtonElementExcelImport,

            this.radButtonElementExcelExport});

            this.radRibbonBarGroup1.Name = "radRibbonBarGroup1";

            this.radRibbonBarGroup1.Text = "Excel";

            // 

            // radButtonElementExcelImport

            // 

            this.radButtonElementExcelImport.Image = global::ID2.Manager.Properties.Resources.Import;

            this.radButtonElementExcelImport.Name = "radButtonElementExcelImport";

            this.radButtonElementExcelImport.Text = "Import";

            this.radButtonElementExcelImport.TextAlignment = System.Drawing.ContentAlignment.BottomCenter;

            this.radButtonElementExcelImport.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;

            // 

            // radButtonElementExcelExport

            // 

            this.radButtonElementExcelExport.Image = global::ID2.Manager.Properties.Resources.Export;

            this.radButtonElementExcelExport.Name = "radButtonElementExcelExport";

            this.radButtonElementExcelExport.Text = "Export";

            this.radButtonElementExcelExport.TextAlignment = System.Drawing.ContentAlignment.BottomCenter;

            this.radButtonElementExcelExport.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;

            // 

            this.radGridViewDocuments.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.radGridViewDocuments.MasterTemplate.AllowDeleteRow = false;

            this.radGridViewDocuments.MasterTemplate.ChildViewTabsPosition = Telerik.WinControls.UI.TabPositions.Left;

            gridViewCommandColumn1.HeaderText = "AutoCAD";

            gridViewCommandColumn1.Name = "AutoCADLink";

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

            gridViewCommandColumn1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;

            gridViewCommandColumn1.Width = 70;

            gridViewCommandColumn2.HeaderText = "PDF";

            gridViewCommandColumn2.ImageLayout = System.Windows.Forms.ImageLayout.Center;

            gridViewCommandColumn2.MaxWidth = 50;

            gridViewCommandColumn2.MinWidth = 18;

            gridViewCommandColumn2.Name = "PDFLink";

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

            gridViewCommandColumn2.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;

            gridViewCommandColumn3.HeaderText = "Markus";

            gridViewCommandColumn3.Name = "MarkupLink";

            gridViewCommandColumn3.Width = 70;

            gridViewCommandColumn4.HeaderText = "AVEVA";

            gridViewCommandColumn4.Name = "AVEVALink";

            gridViewCommandColumn4.Width = 70;

            gridViewTextBoxColumn1.FieldName = "Place";

            gridViewTextBoxColumn1.HeaderText = "위치";

            gridViewTextBoxColumn1.Multiline = true;

            gridViewTextBoxColumn1.Name = "Place";

            gridViewTextBoxColumn1.Width = 150;

            gridViewTextBoxColumn2.FieldName = "DocumentNo";

            gridViewTextBoxColumn2.HeaderText = "이름";

            gridViewTextBoxColumn2.Name = "DocumentNo";

            gridViewTextBoxColumn2.Width = 150;

            gridViewTextBoxColumn3.FieldName = "PersonInCharge";

            gridViewTextBoxColumn3.HeaderText = "담당자";

            gridViewTextBoxColumn3.Name = "PersonInCharge";

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

            gridViewTextBoxColumn3.Width = 70;

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

            gridViewComboBoxColumn1.Width = 60;

            gridViewComboBoxColumn2.FieldName = "IsTypical";

            gridViewComboBoxColumn2.Name = "IsTypical";

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

            gridViewComboBoxColumn2.Width = 60;

            gridViewTextBoxColumn4.FieldName = "RevisonNo";

            gridViewTextBoxColumn4.HeaderText = "Rev.";

            gridViewTextBoxColumn4.Name = "RevisonNo";

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

            gridViewComboBoxColumn3.Width = 80;

            gridViewTextBoxColumn5.FieldName = "ToRemarks";

            gridViewTextBoxColumn5.HeaderText = "Brief";

            gridViewTextBoxColumn5.Multiline = true;

            gridViewTextBoxColumn5.Name = "ToRemarks";

            gridViewTextBoxColumn5.Width = 150;

            gridViewTextBoxColumn6.FieldName = "ToModifier";

            gridViewTextBoxColumn6.HeaderText = "작성자";

            gridViewTextBoxColumn6.Name = "ToModifier";

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

            gridViewTextBoxColumn6.Width = 70;

            gridViewCommandColumn5.FieldName = "ToCapturePath";

            gridViewCommandColumn5.HeaderText = "캡쳐";

            gridViewCommandColumn5.Name = "ToCapturePath";

            gridViewCommandColumn5.Width = 70;

            gridViewComboBoxColumn4.HeaderText = "마크업여부";

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

            gridViewComboBoxColumn4.Width = 80;

            gridViewComboBoxColumn5.HeaderText = "의견Status";

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

            gridViewComboBoxColumn5.Width = 80;

            gridViewTextBoxColumn7.FieldName = "FrRemarks";

            gridViewTextBoxColumn7.HeaderText = "Brief";

            gridViewTextBoxColumn7.Name = "FrRemarks";

            gridViewTextBoxColumn7.Width = 150;

            gridViewTextBoxColumn8.FieldName = "FrModifier";

            gridViewTextBoxColumn8.HeaderText = "검토자";

            gridViewTextBoxColumn8.Name = "FrModifier";

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

            gridViewTextBoxColumn8.Width = 70;

            gridViewCommandColumn6.FieldName = "FrCapturePath";

            gridViewCommandColumn6.HeaderText = "캡쳐";

            gridViewCommandColumn6.Name = "FrCapturePath";

            gridViewCommandColumn6.Width = 70;

            gridViewComboBoxColumn6.HeaderText = "마크업여부";

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

            gridViewComboBoxColumn6.Width = 80;

            gridViewComboBoxColumn7.Width = 90;

            gridViewCommandColumn7.FieldName = "ID2Connection";

            gridViewCommandColumn7.HeaderText = "연결";

            gridViewCommandColumn7.Name = "ID2Connection";

            gridViewCommandColumn7.Width = 70;

            gridViewDateTimeColumn1.HeaderText = "시작일";

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

            gridViewDateTimeColumn1.Width = 80;

            gridViewDateTimeColumn2.FieldName = "ID2EndDate";

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

            gridViewDateTimeColumn2.FormatString = "{0: yyyy/MM/dd hh:mm:ss}";

            gridViewDateTimeColumn2.HeaderText = "완료일";

            gridViewDateTimeColumn2.Name = "ID2EndDate";

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

            gridViewDateTimeColumn2.Width = 80;

            gridViewTextBoxColumn9.FieldName = "ID2JobTime";

            gridViewTextBoxColumn9.HeaderText = "작업시간";

            gridViewTextBoxColumn9.Name = "ID2JobTime";

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

            gridViewTextBoxColumn9.Width = 80;

            gridViewComboBoxColumn8.HeaderText = "Status";

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

            gridViewComboBoxColumn8.Width = 70;

            gridViewTextBoxColumn10.FieldName = "ID2Issues";

            gridViewTextBoxColumn10.HeaderText = "이슈사항";

            gridViewTextBoxColumn10.Name = "ID2Issues";

            gridViewTextBoxColumn10.Width = 150;

            gridViewCommandColumn8.FieldName = "AVEVAConnection";

            gridViewCommandColumn8.HeaderText = "연결";

            gridViewCommandColumn8.Name = "AVEVAConnection";

            gridViewCommandColumn8.Width = 70;

            gridViewDateTimeColumn3.FieldName = "AVEVAConvertDate";

            gridViewDateTimeColumn3.HeaderText = "변환일";

            gridViewDateTimeColumn3.Name = "AVEVAConvertDate";

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

            gridViewDateTimeColumn3.Width = 70;

            gridViewDateTimeColumn4.FieldName = "AVEVAReviewDate";

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

            gridViewDateTimeColumn4.FormatString = "{0: yyyy/MM/dd}";

            gridViewDateTimeColumn4.HeaderText = "검토일";

            gridViewDateTimeColumn4.Name = "AVEVAReviewDate";

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

            gridViewDateTimeColumn4.Width = 70;

            gridViewComboBoxColumn9.HeaderText = "Status";

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

            gridViewComboBoxColumn9.Width = 70;

            gridViewTextBoxColumn11.FieldName = "AVEVAIssues";

            gridViewTextBoxColumn11.HeaderText = "이슈사항";

            gridViewTextBoxColumn11.Name = "AVEVAIssues";

            gridViewTextBoxColumn11.Width = 150;

            gridViewCommandColumn9.FieldName = "ReviewFileName";

            gridViewCommandColumn9.HeaderText = "PDF";

            gridViewCommandColumn9.Name = "ReviewFileName";

            gridViewCommandColumn9.Width = 70;

            gridViewCommandColumn10.HeaderText = "시스템";

            gridViewCommandColumn10.Name = "SystemLink";

            gridViewCommandColumn10.Width = 70;

            gridViewTextBoxColumn12.FieldName = "ProdReviewer";

            gridViewTextBoxColumn12.HeaderText = "검토자";

            gridViewTextBoxColumn12.Name = "ProdReviewer";

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

            gridViewTextBoxColumn12.Width = 70;

            gridViewComboBoxColumn10.HeaderText = "결과";

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

            gridViewComboBoxColumn10.Width = 70;

            gridViewTextBoxColumn13.FieldName = "ProdRemarks";

            gridViewTextBoxColumn13.HeaderText = "비고";

            gridViewTextBoxColumn13.Name = "ProdRemarks";

            gridViewTextBoxColumn13.Width = 150;

            gridViewTextBoxColumn14.FieldName = "ClientReviewer";

            gridViewTextBoxColumn14.HeaderText = "검토자";

            gridViewTextBoxColumn14.Name = "ClientReviewer";

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

            gridViewTextBoxColumn14.Width = 70;

            gridViewComboBoxColumn11.HeaderText = "결과";

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

            gridViewComboBoxColumn11.Width = 70;

            gridViewTextBoxColumn15.FieldName = "ClientRemarks";

            gridViewTextBoxColumn15.HeaderText = "비고";

            gridViewTextBoxColumn15.Name = "ClientRemarks";

            gridViewTextBoxColumn15.Width = 150;

            gridViewComboBoxColumn12.HeaderText = "GateWay";

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

            gridViewComboBoxColumn12.Width = 80;

            gridViewComboBoxColumn13.HeaderText = "Import 성공여부";

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

            gridViewComboBoxColumn13.Width = 80;

            gridViewComboBoxColumn14.HeaderText = "시스템등록";

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

            gridViewComboBoxColumn14.Width = 80;

            gridViewTextBoxColumn16.FieldName = "DTRemarks";

            gridViewTextBoxColumn16.HeaderText = "비고";

            gridViewTextBoxColumn16.Name = "DTRemarks";

            gridViewTextBoxColumn16.Width = 150;

            gridViewCommandColumn1,

            gridViewCommandColumn2,

            gridViewCommandColumn3,

            gridViewCommandColumn4,

            gridViewTextBoxColumn3,

            gridViewComboBoxColumn3,

            gridViewTextBoxColumn6,

            gridViewCommandColumn5,

            gridViewTextBoxColumn8,

            gridViewCommandColumn6,

            gridViewCommandColumn7,

            gridViewTextBoxColumn9,

            gridViewComboBoxColumn8,

            gridViewTextBoxColumn10,

            gridViewCommandColumn8,

            gridViewDateTimeColumn4,

            gridViewCommandColumn9,

            gridViewCommandColumn10,

            gridViewComboBoxColumn10,

            gridViewComboBoxColumn11,

            gridViewTextBoxColumn15,

            gridViewTextBoxColumn16});

using System.IO;

        readonly Informations informations = Informations.Instance;

            SpreadsheetInfo.SetLicense(Properties.Settings.Default.GemBoxLicense);

            this.radGridViewDocuments.ViewCellFormatting += RadGridViewDocuments_ViewCellFormatting;

            this.radGridViewDocuments.CellBeginEdit += RadGridViewDocuments_CellBeginEdit;

            this.radGridViewDocuments.CommandCellClick += RadGridViewDocuments_CommandCellClick;

            this.InitColumnGroupsViewDefinition(this.radGridViewDocuments);

        }

        private void RadGridViewDocuments_CommandCellClick(object sender, GridViewCellEventArgs e)

        {

            switch (e.Column.Name)

            {

                case "AutoCADLink":

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

                    break;

                case "PDFLink":

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

                    break;

                case "MarkupLink":

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

                    break;

                case "AVEVALink":

                case "AVEVAConnection":

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

                    break;

                case "ReviewFileName"://일단주석

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

                    break;

                case "SystemLink":

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

                    break;

                case "ToCapturePath":

                case "FrCapturePath":

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

                    break;

                case "ID2Connection":

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

                    break;

            }

        private void RadGridViewDocuments_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)

        {

            if (e.ActiveEditor is RadDropDownListEditor)

            {

                switch (e.Column.Name)

                {

                    case "JobLevel":

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

                        ColJobLevel.DataSource = informations.JobLevel;

                        break;

                    case "IsTypical":

                    case "ToIsDiscussion":

                    case "ToIsMarkup":

                    case "FrIsMarkup":

                    case "IsID2Work":

                    case "DTIsGateWay":

                    case "DTIsImport":

                    case "DTIsRegSystem":

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

                        ColYesNo.DataSource = (new string[] { string.Empty }).Union<string>(informations.IsYesNo);

                        break;

                    case "ID2Status":

                    case "AVEVAStatus":

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

                        ColJobStatus.DataSource = (new string[] { string.Empty }).Union<string>(informations.JobStatus);

                        break;

                    case "FrReviewStatus"://삼성의견status

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

                        ColClientStatus.DataSource = (new string[] { string.Empty }).Union<string>(informations.ClientStatus);

                        break;

                    case "ProdIsResult":

                    case "ClientIsResult":

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

                        //ColResult.DataSource = informations.ValidationResult;

                        break;

                }

            }

        }

        private void RadGridViewDocuments_ViewCellFormatting(object sender, CellFormattingEventArgs e)

        {

            RadButtonElement GetBtnElement(RadElement elem,  string colName)

            {

                RadButtonElement btnElem = null;

                Bitmap bitmap = null; ;

                switch (colName)

                {

                    case "AutoCADLink":

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

                        break;

                    case "PDFLink":

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

                        break;

                    case "MarkupLink":

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

                        break;

                    case "AVEVALink":

                    case "AVEVAConnection":

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

                        break;

                    case "ReviewFileName"://일단주석

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

                        break;

                    case "SystemLink":

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

                        break;

                    case "ToCapturePath":

                    case "FrCapturePath":

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

                        break;

                    case "ID2Connection":

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

                        break;

                }

                switch (colName)

                {

                    case "AutoCADLink":

                    case "PDFLink":

                    case "MarkupLink":

                    case "AVEVALink":

                    case "AVEVAConnection":

                    case "ReviewFileName"://일단주석

                    case "SystemLink":

                    case "ToCapturePath":

                    case "FrCapturePath":

                    case "ID2Connection":

                        btnElem = (RadButtonElement)elem;

                        btnElem.Margin = new Padding(0);

                        btnElem.Padding = new Padding(0);

                        btnElem.BorderElement.Opacity = 0;

                        btnElem.Alignment = ContentAlignment.MiddleCenter;

                        btnElem.DisplayStyle = DisplayStyle.Image;

                        btnElem.Image = bitmap;

                        btnElem.ImageAlignment = ContentAlignment.MiddleCenter;

                        btnElem.MaxSize = bitmap.Size;

                        break;

                }

                return btnElem;

            }

            if (e.CellElement is GridRowHeaderCellElement)

            {

                e.CellElement.Text = (e.CellElement.RowIndex + 1).ToString();

            }

            else

            {

                var result = e.Row.DataBoundItem as Documents;

                if (result != null)

                {

                    switch (e.CellElement.ColumnInfo.Name)

                    {

                        case "AutoCADLink":

                        case "PDFLink":

                        case "MarkupLink":

                        case "AVEVALink":

                        case "AVEVAConnection":

                        case "ReviewFileName"://일단주석

                        case "SystemLink":

                        case "ToCapturePath":

                        case "FrCapturePath":

                        case "ID2Connection":

                            GetBtnElement(e.CellElement.Children[0], e.CellElement.ColumnInfo.Name);

                            break;

                    }

                }

            }

        }

        #region Excel

            string sPrefixName = "Samsung Elec Task Management";

                FileName = $"{sPrefixName}_{DateTime.Now:yyyyMMddhhmmss}{extension}",

                    string fileName = $"{sPrefixName}{extension}";

                    string templateFolder = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "Template");

                    string templateFilePath = Path.Combine(templateFolder, fileName);

                    if (!File.Exists(templateFilePath))

                    {

                        RadMessageBox.Show(this, $"There is no {fileName} in {templateFolder}", "Error", MessageBoxButtons.OK, RadMessageIcon.Error);

                        return;

                    }

                    if (this.radGridViewDocuments.Rows.Count > 0)

                    {

                        var templateExcelFile = ExcelFile.Load(templateFilePath);

                        var templateWorksheets = templateExcelFile.Worksheets;

                        var templateWorksheet = templateWorksheets[0];

                        int rowIndex = 9;

                        //int colIndex = 1;

                        foreach (var row in this.radGridViewDocuments.Rows)

                        {

                            var doc = row.DataBoundItem as Documents;

                            templateWorksheet.Cells[rowIndex, 0].Value = doc.Seq;

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

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

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

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

                            templateWorksheet.Cells[rowIndex, 5].Value = doc.Place;

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

                            templateWorksheet.Cells[rowIndex, 7].Value = doc.PersonInCharge;

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

                            templateWorksheet.Cells[rowIndex, 9].Value = doc.IsTypical;

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

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

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

                            templateWorksheet.Cells[rowIndex, 13].Value = doc.ToCreator;

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

                            templateWorksheet.Cells[rowIndex, 15].Value = doc.ToIsMarkup;

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

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

                            templateWorksheet.Cells[rowIndex, 18].Value = doc.FrCreator;

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

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

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

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

                            templateWorksheet.Cells[rowIndex, 23].Value = doc.ID2StartDate;

                            templateWorksheet.Cells[rowIndex, 24].Value = doc.ID2EndDate;

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

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

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

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

                            templateWorksheet.Cells[rowIndex, 29].Value = doc.AVEVAConvertDate;

                            templateWorksheet.Cells[rowIndex, 30].Value = doc.AVEVAReviewDate;

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

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

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

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

                            templateWorksheet.Cells[rowIndex, 35].Value = doc.ProdReviewer;

                            templateWorksheet.Cells[rowIndex, 36].Value = doc.ProdIsResult;

                            templateWorksheet.Cells[rowIndex, 37].Value = doc.ProdRemarks;

                            templateWorksheet.Cells[rowIndex, 38].Value = doc.ClientReviewer;

                            templateWorksheet.Cells[rowIndex, 39].Value = doc.ClientIsResult ;

                            templateWorksheet.Cells[rowIndex, 40].Value = doc.ClientRemarks;

                            templateWorksheet.Cells[rowIndex, 41].Value = doc.DTIsGateWay;

                            templateWorksheet.Cells[rowIndex, 42].Value = doc.DTIsImport;

                            templateWorksheet.Cells[rowIndex, 43].Value = doc.DTIsRegSystem;

                            templateWorksheet.Cells[rowIndex, 44].Value = doc.DTRemarks;

                            rowIndex++;

                        }

                        templateExcelFile.Save(sfd.FileName);

                        RadMessageBox.Show("Exporting 'ID2 Document List' is complete", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                    }

        #endregion

            this.GetDocList();

        }

        public void GetDocList()

        {

            IEnumerable<Documents> docList = new DocumentController().GetAllDocuments();

            BeginInvoke(new Action(() =>

            {

                this.radGridViewDocuments.DataSource = null;

                this.radGridViewDocuments.DataSource = docList;

            }));

    }

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

            List<string> docInfoColNames = new List<string>() { "Place", "DocumentNo", "PersonInCharge", "JobLevel", "IsTypical", "RevisonNo" };

            List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToModifier", "ToCapturePath", "ToIsMarkup" };

            List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrModifier", "FrCapturePath", "FrIsMarkup" };

            List<string> rvEtcColNames = new List<string>() { "IsID2Work" };

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

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

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

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

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

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

            //도면

            GridViewColumnGroup docColGrp = new GridViewColumnGroup("도면");

            GridViewColumnGroup docLinkColGrp = new GridViewColumnGroup("파일링크");

            GridViewColumnGroup docInfoColGrp = new GridViewColumnGroup("도면정보");

            GridViewColumnGroupRow docLinkColGrpRow = new GridViewColumnGroupRow();

            docLinkColGrpRow.ColumnNames.AddRange(docLinkColNames);

            GridViewColumnGroupRow docInfoColGrpRow = new GridViewColumnGroupRow();

            docInfoColGrpRow.ColumnNames.AddRange(docInfoColNames);

            docLinkColGrp.Rows.Add(docLinkColGrpRow);

            docColGrp.Groups.Add(docLinkColGrp);

            docInfoColGrp.Rows.Add(docInfoColGrpRow);

            docColGrp.Groups.Add(docInfoColGrp);

            //검토

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

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

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

            GridViewColumnGroup rvEtcColGrp = new GridViewColumnGroup("기타");

            GridViewColumnGroupRow rvToColGrpRow = new GridViewColumnGroupRow();

            rvToColGrpRow.ColumnNames.AddRange(rvToColNames);

            GridViewColumnGroupRow rvFrColGrpRow = new GridViewColumnGroupRow();

            rvFrColGrpRow.ColumnNames.AddRange(rvFrColNames);

            GridViewColumnGroupRow rvEtcColGrpRow = new GridViewColumnGroupRow();

            rvEtcColGrpRow.ColumnNames.AddRange(rvEtcColNames);

            rvToColGrp.Rows.Add(rvToColGrpRow);

            rvFrColGrp.Rows.Add(rvFrColGrpRow);

            rvEtcColGrp.Rows.Add(rvEtcColGrpRow);

            rvColGrp.Groups.Add(rvToColGrp);

            rvColGrp.Groups.Add(rvFrColGrp);

            rvColGrp.Groups.Add(rvEtcColGrp);

            //작업

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

            GridViewColumnGroup wkID2ColGrp = new GridViewColumnGroup("ID2");

            GridViewColumnGroup wkAVEVAColGrp = new GridViewColumnGroup("AVEVA");

            GridViewColumnGroupRow wkID2ColGrpRow = new GridViewColumnGroupRow();

            wkID2ColGrpRow.ColumnNames.AddRange(wkID2ColNames);

            GridViewColumnGroupRow wkAVEVAColGrpRow = new GridViewColumnGroupRow();

            wkAVEVAColGrpRow.ColumnNames.AddRange(wkAVEVAColNames);

            wkID2ColGrp.Rows.Add(wkID2ColGrpRow);

            wkAVEVAColGrp.Rows.Add(wkAVEVAColGrpRow);

            wkColGrp.Groups.Add(wkID2ColGrp);

            wkColGrp.Groups.Add(wkAVEVAColGrp);

            //Validation

            GridViewColumnGroup valColGrp = new GridViewColumnGroup("Validation");

            GridViewColumnGroup valLinkColGrp = new GridViewColumnGroup("파일링크");

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

            GridViewColumnGroup valCntColGrp = new GridViewColumnGroup("삼성전자");

            GridViewColumnGroupRow valLinkColGrpRow = new GridViewColumnGroupRow();

            valLinkColGrpRow.ColumnNames.AddRange(valLinkColNames);

            GridViewColumnGroupRow valProdColGrpRow = new GridViewColumnGroupRow();

            valProdColGrpRow.ColumnNames.AddRange(valProdColNames);

            GridViewColumnGroupRow valCntColGrpRow = new GridViewColumnGroupRow();

            valCntColGrpRow.ColumnNames.AddRange(valCntColNames);

            valLinkColGrp.Rows.Add(valLinkColGrpRow);

            valProdColGrp.Rows.Add(valProdColGrpRow);

            valCntColGrp.Rows.Add(valCntColGrpRow);

            valColGrp.Groups.Add(valLinkColGrp);

            valColGrp.Groups.Add(valProdColGrp);

            valColGrp.Groups.Add(valCntColGrp);

            //AVEVA Net

            GridViewColumnGroup dtColGrp = new GridViewColumnGroup("AVEVA Net\n(Digital Twin)");

            GridViewColumnGroupRow dtColGrpRow = new GridViewColumnGroupRow();

            dtColGrpRow.ColumnNames.AddRange(dtColNames);

            dtColGrp.Rows.Add(dtColGrpRow);

            //Group 추가

            columnGroupsView.ColumnGroups.Add(docColGrp);

            columnGroupsView.ColumnGroups.Add(rvColGrp);

            columnGroupsView.ColumnGroups.Add(wkColGrp);

            columnGroupsView.ColumnGroups.Add(valColGrp);

            columnGroupsView.ColumnGroups.Add(dtColGrp);

        internal static System.Drawing.Bitmap cad18 {

            get {

                object obj = ResourceManager.GetObject("cad18", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap files18 {

            get {

                object obj = ResourceManager.GetObject("files18", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap link18_blue {

            get {

                object obj = ResourceManager.GetObject("link18_blue", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap link18_green {

            get {

                object obj = ResourceManager.GetObject("link18_green", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap link18_purple {

            get {

                object obj = ResourceManager.GetObject("link18_purple", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap link18_yellow {

            get {

                object obj = ResourceManager.GetObject("link18_yellow", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

        /// <summary>

        ///   System.Drawing.Bitmap 형식의 지역화된 리소스를 찾습니다.

        /// </summary>

        internal static System.Drawing.Bitmap pdf18 {

            get {

                object obj = ResourceManager.GetObject("pdf18", resourceCulture);

                return ((System.Drawing.Bitmap)(obj));

            }

        }

  <data name="cad18" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\cad18.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="files18" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\files18.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="link18_blue" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\link18_blue.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="link18_green" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\link18_green.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="link18_purple" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\link18_purple.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="link18_yellow" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\link18_yellow.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

  <data name="pdf18" type="System.Resources.ResXFileRef, System.Windows.Forms">

    <value>..\Resources\pdf18.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value>

  </data>

//     이 코드는 도구를 사용하여 생성되었습니다.

//     런타임 버전:4.0.30319.42000

//     파일 내용을 변경하면 잘못된 동작이 발생할 수 있으며, 코드를 다시 생성하면

//     이러한 변경 내용이 손실됩니다.

namespace ID2.Manager.Properties {

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "16.10.0.0")]

    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        public static Settings Default {

            get {

        [global::System.Configuration.UserScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("SN-2021May25-IPYYaC5T2J/LIzFImndeajkkMS/Fn1fLWGfjRRxTNu/uan2hm9KrTK/v9hdsQfLCOuUe" +

            "MZXrEHCPsmS7Pnp4YGIGsOw==A")]

        public string GemBoxLicense {

            get {

                return ((string)(this["GemBoxLicense"]));

            }

            set {

                this["GemBoxLicense"] = value;

            }

        }

<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="ID2.Manager.Properties" GeneratedClassName="Settings">

  <Profiles />

  <Settings>

    <Setting Name="GemBoxLicense" Type="System.String" Scope="User">

      <Value Profile="(Default)">SN-2021May25-IPYYaC5T2J/LIzFImndeajkkMS/Fn1fLWGfjRRxTNu/uan2hm9KrTK/v9hdsQfLCOuUeMZXrEHCPsmS7Pnp4YGIGsOw==A</Value>

    </Setting>

  </Settings>

</SettingsFile>

namespace ID2.Manager.Properties {

    // 이 클래스를 사용하여 설정 클래스에 대한 특정 이벤트를 처리할 수 있습니다.

    //  SettingChanging 이벤트는 설정 값이 변경되기 전에 발생합니다.

    //  PropertyChanged 이벤트는 설정 값이 변경된 후에 발생합니다.

    //  SettingsLoaded 이벤트는 설정 값이 로드된 후에 발생합니다.

    //  SettingsSaving 이벤트는 설정 값이 저장되기 전에 발생합니다.

    internal sealed partial class Settings {

        public Settings() {

            // // 설정을 저장 및 변경하기 위한 이벤트 처리기를 추가하려면 아래 줄에서 주석 처리를 제거하세요.

            //

            // this.SettingChanging += this.SettingChangingEventHandler;

            //

            // this.SettingsSaving += this.SettingsSavingEventHandler;

            //

        }

        private void SettingChangingEventHandler(object sender, System.Configuration.SettingChangingEventArgs e) {

            // SettingChangingEvent 이벤트를 처리하는 코드를 여기에 추가하세요.

        }

        private void SettingsSavingEventHandler(object sender, System.ComponentModel.CancelEventArgs e) {

            // SettingsSaving 이벤트를 처리하는 코드를 여기에 추가하세요.

        }

    }

}