HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

using ID2.Manager.Dapper.Repository;

namespace ID2.Manager.Controller.Controllers

{

    public class DocumentController : BaseController

    {

        public IEnumerable<Documents> GetAllDocuments()

        {

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

            {

                return rep.GetAllDocuments();

            }

        }

    }

}

    <Compile Include="Controllers\DocumentController.cs" />

    <Compile Include="Repository\DocumentRepository.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class DocumentRepository : BaseRepository

    {

        public DocumentRepository(string connectionStr) : base(connectionStr) { }

        public IEnumerable<Documents> GetAllDocuments()

        {

            string query = $@"

select   doc.Seq

        ,doc.DocumentNo

        ,rev.ProcNo

        ,rev.RevNo

        ,rev.PhysicalPath

        ,rev.VirtualPath

        ,doc.JobLevel

        ,doc.Typical

        ,doc.PersonInCharge

        ,rev.Created

        ,toreview.IsDiscussion

        ,toreview.Remarks ToRemarks

        ,toreview.Capture ToCapture

        ,toreview.MarkupLink ToMarkupLink

        ,isnull(toreview.ModifiedUser,toreview.CreatedUser) ToUserID

        ,frreview.ReviewStatus

        ,frreview.Remarks FrRemarks

        ,frreview.Capture FrCapture

        ,frreview.MarkupLink FrMarkupLink

        ,isnull(frreview.ModifiedUser,frreview.CreatedUser) FromUserID

from     dbo.Documents doc

             inner join dbo.DocRevisions rev on doc.Seq=rev.RefDocSeq

		     left outer join dbo.ToReview toreview on rev.ProcNo=toreview.RefProcNo

		     left outer join dbo.FromReview frreview on rev.ProcNo=frreview.RefProcNo

where    doc.IsDeleted=0 and  rev.IsLatest=1

order by doc.DocumentNo, rev.ProcNo desc";

            return Query<Documents>(query);

        }

    }

}

    <Compile Include="Models\Documents.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Runtime.Serialization;

namespace ID2.Manager.Data.Models

{

    [DataContract]

    public class Documents

    {

        [DataMember]

        public int Seq { get; set; }

        [DataMember]

        public string DocumentNo { get; set; }

        [DataMember]

        public int ProcNo { get; set; }

        [DataMember]

        public string RevNo { get; set; }

        [DataMember]

        public string PhysicalPath { get; set; }

        [DataMember]

        public string VirtualPath { get; set; }

        [DataMember]

        public string JobLevel { get; set; }

        [DataMember]

        public string Typical { get; set; }

        [DataMember]

        public string PersonInCharge { get; set; }

        [DataMember]

        public DateTime Created { get; set; }

        [DataMember]

        public bool IsDiscussion { get; set; }

        [DataMember]

        public string ToRemarks { get; set; }

        [DataMember]

        public string ToCapture { get; set; }

        [DataMember]

        public string ToMarkupLink { get; set; }

        [DataMember]

        public string ToUserID { get; set; }

        [DataMember]

        public string ReviewStatus { get; set; }

        [DataMember]

        public string FrRemarks { get; set; }

        [DataMember]

        public string FrCapture { get; set; }

        [DataMember]

        public string FrMarkupLink { get; set; }

        [DataMember]

        public string FromUserID { get; set; }

    }

}

		<add name="ID2Manager" providerName="System.Data.SqlClient" connectionString="data source=192.168.0.67;initial catalog=ID2Manager;persist security info=True;user id=sa;password=dof1073#;multipleactiveresultsets=True"/>

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

            this.radGridViewDocuments = new Telerik.WinControls.UI.RadGridView();

            this.splitPanelLeft.SuspendLayout();

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

            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments.MasterTemplate)).BeginInit();

            this.splitPanelLeft.Controls.Add(this.radGridViewDocuments);

            // radGridViewDocuments

            // 

            this.radGridViewDocuments.Dock = System.Windows.Forms.DockStyle.Fill;

            this.radGridViewDocuments.Location = new System.Drawing.Point(0, 0);

            // 

            // 

            // 

            this.radGridViewDocuments.MasterTemplate.AllowSearchRow = true;

            this.radGridViewDocuments.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;

            this.radGridViewDocuments.MasterTemplate.EnableAlternatingRowColor = true;

            this.radGridViewDocuments.MasterTemplate.EnableFiltering = true;

            this.radGridViewDocuments.MasterTemplate.ShowFilteringRow = false;

            this.radGridViewDocuments.MasterTemplate.ShowHeaderCellButtons = true;

            this.radGridViewDocuments.MasterTemplate.ViewDefinition = tableViewDefinition1;

            this.radGridViewDocuments.Name = "radGridViewDocuments";

            this.radGridViewDocuments.ShowHeaderCellButtons = true;

            this.radGridViewDocuments.Size = new System.Drawing.Size(892, 566);

            this.radGridViewDocuments.TabIndex = 0;

            // 

            this.splitPanelLeft.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments.MasterTemplate)).EndInit();

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

        private Telerik.WinControls.UI.RadGridView radGridViewDocuments;

using ID2.Manager.Data.Models;

using ID2.Manager.Controller.Controllers;

            //this.InitColumnGroupsViewDefinition(this.radGridViewDocuments);

            this.Load += Main_Load;

        }

        private void Main_Load(object sender, EventArgs e)

        {

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

            this.radGridViewDocuments.DataSource = docList;

        }

        #region ColumnGroup

        private void InitColumnGroupsViewDefinition(RadGridView gridView)

        {

            ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition();

            GridViewColumnGroupRow documentColumnList = this.GetGridViewColumnGroupRow(new List<string>

            {

                "Seq",

                "UID",

                "DocumentNo",

                "PhysicalPath",

                "VirtualPath",

                "JobLevel",

                "Role",

                "Typical",

                "PersonInCharge",

                "Created"

            });

            GridViewColumnGroup gridViewColumnGroupDocument = this.GetGridViewColumnGroup("도면", "도면", true, documentColumnList);

            columnGroupsView.ColumnGroups.Add(gridViewColumnGroupDocument);

            gridView.MasterTemplate.ViewDefinition = columnGroupsView;

        }

        private GridViewColumnGroupRow GetGridViewColumnGroupRow(List<string> columnNames)

        {

            GridViewColumnGroupRow gridViewColumnGroupRow = new GridViewColumnGroupRow();

            foreach (string columnName in columnNames)

            {

                gridViewColumnGroupRow.ColumnNames.Add(columnName);

            }

            return gridViewColumnGroupRow;

        }

        private GridViewColumnGroup GetGridViewColumnGroup(string name, string text, bool showHeader, GridViewColumnGroupRow item)

        {

            GridViewColumnGroup gridViewColumnGroup = new GridViewColumnGroup();

            gridViewColumnGroup.Name = name;

            gridViewColumnGroup.Text = text;

            gridViewColumnGroup.ShowHeader = showHeader;

            gridViewColumnGroup.Rows.Add(item);

            return gridViewColumnGroup;

        #endregion