DATA Archives - 46 중 46 번째 페이지

[C#/WPF/DEVEXPRESS] LinqServerModeSource 클래스 사용하기

■ LinqServerModeSource 클래스를 사용하는 방법을 보여준다. ▶ 예제 코드 (C#)


namespace DevExpress.Data.Linq

this.gridControl.ItemsSource = new LinqServerModeSource()
{
    ElementType     = typeof(Product),
    KeyExpression   = "ProductID",
    QueryableSource = new NorthwindEntities().Products
};

namespace DevExpress.Data.Linq

this.gridControl.ItemsSource = new LinqServerModeSource()

{

ElementType = typeof(Product),

KeyExpression = "ProductID",

QueryableSource = new NorthwindEntities().Products

};

※ NorthwindEntities, Product 클래스는 Entity Framework에서 정의된 것이다.

[C#/WPF/DEVEXPRESS] XPInstantFeedbackSource 클래스 사용하기

■ XPInstantFeedbackSource 클래스를 사용하는 방법을 보여준다. ▶ TestObject.cs


using System;

using DevExpress.Xpo;

namespace HowToImplementTheInstantFeedbackModeXPO
{
    /// <summary>
    /// 테스트 객체
    /// </summary>
    public class TestObject : XPObject
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 주제
        /// </summary>
        private string subject;

        /// <summary>
        /// 송신 일시
        /// </summary>
        private DateTime sendTime;

        /// <summary>
        /// 첨부 여부
        /// </summary>
        private bool hasAttachment;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 주제 - Subject

        /// <summary>
        /// 주제
        /// </summary>
        public string Subject
        {
            get
            {
                return this.subject;
            }
            set
            {
                SetPropertyValue<string>("Subject", ref this.subject, value);
            }
        }

        #endregion

        #region 송신 일시 - SendTime

        /// <summary>
        /// 송신 일시
        /// </summary>
        public DateTime SendTime
        {
            get
            {
                return this.sendTime;
            }
            set
            {
                SetPropertyValue<DateTime>("SendTime", ref this.sendTime, value);
            }
        }

        #endregion

        #region 첨부 여부 - HasAttachment

        /// <summary>
        /// 첨부 여부
        /// </summary>
        public bool HasAttachment
        {
            get
            {
                return this.hasAttachment;
            }
            set
            {
                SetPropertyValue<bool>("HasAttachment", ref this.hasAttachment, value);
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - TestObject()

        /// <summary>
        /// 생성자
        /// </summary>
        public TestObject() : base(Session.DefaultSession)
        {
        }

        #endregion

        #region 생성자 - TestObject(session)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="session">Session 객체</param>
        public TestObject(Session session) : base(session)
        {
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성 후 처리하기 - AfterConstruction()

        /// <summary>
        /// 생성 후 처리하기
        /// </summary>
        public override void AfterConstruction()
        {
            base.AfterConstruction();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

using System;

using DevExpress.Xpo;

namespace HowToImplementTheInstantFeedbackModeXPO

{

/// <summary>

/// 테스트 객체

/// </summary>

public class TestObject : XPObject

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 주제

/// </summary>

private string subject;

/// <summary>

/// 송신 일시

/// </summary>

private DateTime sendTime;

/// <summary>

/// 첨부 여부

/// </summary>

private bool hasAttachment;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 주제 - Subject

/// <summary>

/// 주제

/// </summary>

public string Subject

{

get

{

return this.subject;

}

set

{

SetPropertyValue<string>("Subject", ref this.subject, value);

}

#endregion

#region 송신 일시 - SendTime

/// <summary>

/// 송신 일시

/// </summary>

public DateTime SendTime

{

get

{

return this.sendTime;

}

set

{

SetPropertyValue<DateTime>("SendTime", ref this.sendTime, value);

}

#endregion

#region 첨부 여부 - HasAttachment

/// <summary>

/// 첨부 여부

/// </summary>

public bool HasAttachment

{

get

{

return this.hasAttachment;

}

set

{

SetPropertyValue<bool>("HasAttachment", ref this.hasAttachment, value);

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - TestObject()

/// <summary>

/// 생성자

/// </summary>

public TestObject() : base(Session.DefaultSession)

{

}

#endregion

#region 생성자 - TestObject(session)

/// <summary>

/// 생성자

/// </summary>

/// <param name="session">Session 객체</param>

public TestObject(Session session) : base(session)

{

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성 후 처리하기 - AfterConstruction()

/// <summary>

/// 생성 후 처리하기

/// </summary>

public override void AfterConstruction()

{

base.AfterConstruction();

}

#endregion

}

▶ MainPage.xaml


<Window
    x:Class="HowToImplementTheInstantFeedbackModeXPO.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="Implement The Instant Feedback Mode (XPO)">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoGenerateColumns="AddNew" />
    </Grid>
</Window>

<Window

x:Class="HowToImplementTheInstantFeedbackModeXPO.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="Implement The Instant Feedback Mode (XPO)">

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoGenerateColumns="AddNew" />

</Grid>

</Window>

▶ MainPage.xaml.cs


using System;
using System.Windows;

using DevExpress.Xpo;

namespace HowToImplementTheInstantFeedbackModeXPO
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainWindow()
        {
            InitializeDataAccessLayer();

            GenerateTestData(100000);

            InitializeComponent();

            XPInstantFeedbackSource xpInstantFeedbackSource = new XPInstantFeedbackSource(typeof(TestObject));

            xpInstantFeedbackSource.ResolveSession += xpInstantFeedbackSource_ResolveSession;
            xpInstantFeedbackSource.DismissSession += xpInstantFeedbackSource_DismissSession;

            this.gridControl.ItemsSource = xpInstantFeedbackSource;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region XP 즉시 피드백 소스 세션 Resolve 처리하기 - xpInstantFeedbackSource_ResolveSession(sender, e)

        /// <summary>
        /// XP 즉시 피드백 소스 세션 Resolve 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void xpInstantFeedbackSource_ResolveSession(object sender, ResolveSessionEventArgs e)
        {
            e.Session = new UnitOfWork();
        }

        #endregion

        #region XP 즉시 피드백 소스 세션 Dismiss 처리하기 - xpInstantFeedbackSource_DismissSession(sender, e)

        /// <summary>
        /// XP 즉시 피드백 소스 세션 Dismiss 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void pXPInstantFeedbackSource_DismissSession(object sender, ResolveSessionEventArgs e)
        {
            IDisposable disposable = e.Session as IDisposable;

            if(disposable != null)
            {
                disposable.Dispose();
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////// Function

        #region 데이터 액세스 레이어 초기화 하기 - InitializeDataAccessLayer()

        /// <summary>
        /// 데이터 액세스 레이어 초기화 하기
        /// </summary>
        private static void InitializeDataAccessLayer()
        {
            XpoDefault.Session = null;

            XpoDefault.DataLayer = XpoDefault.GetDataLayer
            (
                DevExpress.Xpo.DB.AccessConnectionProvider.GetConnectionString("test.mdb"),
                DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema
            );
        }

        #endregion

        #region 테스트 데이터 생성하기 - GenerateTestData(recordCount)

        /// <summary>
        /// 테스트 데이터 생성하기
        /// </summary>
        /// <param name="recordCount">레코드 수</param>
        private void GenerateTestData(int recordCount)
        {
            using(UnitOfWork unitOfWork = new UnitOfWork())
            {
                if(unitOfWork.FindObject<TestObject>(null) != null)
                {
                    return;
                }

                for(int i = 0; i < recordCount; i++)
                {
                    TestObject testObject = new TestObject(unitOfWork)
                    {
                        HasAttachment = false,
                        Sent          = DateTime.Now,
                        Subject       = string.Format("Subject {0}", i)
                    };
                }

                unitOfWork.CommitChanges();
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

using System;

using System.Windows;

using DevExpress.Xpo;

namespace HowToImplementTheInstantFeedbackModeXPO

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeDataAccessLayer();

GenerateTestData(100000);

InitializeComponent();

XPInstantFeedbackSource xpInstantFeedbackSource = new XPInstantFeedbackSource(typeof(TestObject));

xpInstantFeedbackSource.ResolveSession += xpInstantFeedbackSource_ResolveSession;

xpInstantFeedbackSource.DismissSession += xpInstantFeedbackSource_DismissSession;

this.gridControl.ItemsSource = xpInstantFeedbackSource;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Private

//////////////////////////////////////////////////////////////////////////////// Event

#region XP 즉시 피드백 소스 세션 Resolve 처리하기 - xpInstantFeedbackSource_ResolveSession(sender, e)

/// <summary>

/// XP 즉시 피드백 소스 세션 Resolve 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void xpInstantFeedbackSource_ResolveSession(object sender, ResolveSessionEventArgs e)

{

e.Session = new UnitOfWork();

}

#endregion

#region XP 즉시 피드백 소스 세션 Dismiss 처리하기 - xpInstantFeedbackSource_DismissSession(sender, e)

/// <summary>

/// XP 즉시 피드백 소스 세션 Dismiss 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pXPInstantFeedbackSource_DismissSession(object sender, ResolveSessionEventArgs e)

{

IDisposable disposable = e.Session as IDisposable;

if(disposable != null)

{

disposable.Dispose();

}

#endregion

//////////////////////////////////////////////////////////////////////////////// Function

#region 데이터 액세스 레이어 초기화 하기 - InitializeDataAccessLayer()

/// <summary>

/// 데이터 액세스 레이어 초기화 하기

/// </summary>

private static void InitializeDataAccessLayer()

{

XpoDefault.Session = null;

XpoDefault.DataLayer = XpoDefault.GetDataLayer

(

DevExpress.Xpo.DB.AccessConnectionProvider.GetConnectionString("test.mdb"),

DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema

);

}

#endregion

#region 테스트 데이터 생성하기 - GenerateTestData(recordCount)

/// <summary>

/// 테스트 데이터 생성하기

/// </summary>

/// <param name="recordCount">레코드 수</param>

private void GenerateTestData(int recordCount)

{

using(UnitOfWork unitOfWork = new UnitOfWork())

{

if(unitOfWork.FindObject<TestObject>(null) != null)

{

return;

}

for(int i = 0; i < recordCount; i++)

{

TestObject testObject = new TestObject(unitOfWork)

{

HasAttachment = false,

Sent = DateTime.Now,

Subject = string.Format("Subject {0}", i)

};

}

unitOfWork.CommitChanges();

}

#endregion

}

[C#/WPF/DEVEXPRESS] EntityInstantFeedbackDataSource 엘리먼트 사용하기

■ EntityInstantFeedbackDataSource 엘리먼트를 사용하는 방법을 보여준다. ▶ 예제 코드 (XAML)


<Grid
    xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid">
    <dx:EntityInstantFeedbackDataSource x:Name="entityInstantFeedbackDataSource"
        KeyExpression="ProductID" />
    <dxg:GridControl x:Name="gridControl"
        ItemsSource="{Binding ElementName=entityInstantFeedbackDataSource, Path=Data}">
        <dxg:GridControl.Columns>
            ...
        </dxg:GridControl.Columns>
        <dxg:GridControl.View>
            <dxg:TableView x:Name="tableView"
                RowAnimationKind="Opacity" />
        </dxg:GridControl.View>
    </dxg:GridControl>
</Grid>

<Grid

xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid">

<dx:EntityInstantFeedbackDataSource x:Name="entityInstantFeedbackDataSource"

KeyExpression="ProductID" />

<dxg:GridControl x:Name="gridControl"

ItemsSource="{Binding ElementName=entityInstantFeedbackDataSource, Path=Data}">

<dxg:GridControl.Columns>

...

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView"

RowAnimationKind="Opacity" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

▶ 예제 코드 (C#)


this.entityInstantFeedbackDataSource.QueryableSource = new NorthwindEntities().Products;

this.entityInstantFeedbackDataSource.QueryableSource = new NorthwindEntities().Products;

[C#/SILVERLIGHT] CollectionViewSource 엘리먼트 : 계층적 데이터 바인딩 하기

■ CollectionViewSource 엘리먼트를 사용해 계층적 데이터를 바인딩하는 방법을 보여준다. ▶ Team.cs


/// <summary>
/// 팀
/// </summary>
public class Team
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

/// <summary>

/// 팀

/// </summary>

public class Team

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Division.cs


using System;
using System.Collections.ObjectModel;

/// <summary>
/// 부문
/// </summary>
public class Division
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion

    #region 팀 컬렉션 - TeamCollection

    /// <summary>
    /// 팀 컬렉션
    /// </summary>
    public ObservableCollection<Team> TeamCollection { get; set; }

    #endregion
}

using System;

using System.Collections.ObjectModel;

/// <summary>

/// 부문

/// </summary>

public class Division

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

#region 팀 컬렉션 - TeamCollection

/// <summary>

/// 팀 컬렉션

/// </summary>

public ObservableCollection<Team> TeamCollection { get; set; }

#endregion

}

▶ League.cs


using System;
using System.Collections.ObjectModel;

/// <summary>
/// 리그
/// </summary>
public class League
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion

    #region 부문 컬렉션 - DivisionCollection

    /// <summary>
    /// 부문 컬렉션
    /// </summary>
    public ObservableCollection<Division> DivisionCollection { get; set; }

    #endregion
}

using System;

using System.Collections.ObjectModel;

/// <summary>

/// 리그

/// </summary>

public class League

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

#region 부문 컬렉션 - DivisionCollection

/// <summary>

/// 부문 컬렉션

/// </summary>

public ObservableCollection<Division> DivisionCollection { get; set; }

#endregion

}

▶ LeagueCollection.cs


using System;
using System.Collections.ObjectModel;

/// <summary>
/// 리그 컬렉션
/// </summary>
public class LeagueCollection : ObservableCollection<League>
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 생성자 - LeagueCollection()

    /// <summary>
    /// 생성자
    /// </summary>
    public LeagueCollection()
    {
        for(int x = 1; x < 3; x++)
        {
            League league = new League()
            {
                Name               = "League " + x,
                DivisionCollection = new ObservableCollection<Division>()
            };

            for(int y = 1; y < 4; y++)
            {
                Division division = new Division()
                {
                    Name           = string.Format("Division {0}-{1}", x, y),
                    TeamCollection = new ObservableCollection<Team>()
                };

                for(int z = 1; z < 5; z++)
                {
                    Team team = new Team()
                    {
                        Name = string.Format("Team {0}-{1}-{2}", x, y, z)
                    };

                    division.TeamCollection.Add(pTeam);
                }

                league.DivisionCollection.Add(pDivision);
            }

            Add(league);
        }
    }

    #endregion
}

using System;

using System.Collections.ObjectModel;

/// <summary>

/// 리그 컬렉션

/// </summary>

public class LeagueCollection : ObservableCollection<League>

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - LeagueCollection()

/// <summary>

/// 생성자

/// </summary>

public LeagueCollection()

{

for(int x = 1; x < 3; x++)

{

League league = new League()

{

Name = "League " + x,

DivisionCollection = new ObservableCollection<Division>()

};

for(int y = 1; y < 4; y++)

{

Division division = new Division()

{

Name = string.Format("Division {0}-{1}", x, y),

TeamCollection = new ObservableCollection<Team>()

};

for(int z = 1; z < 5; z++)

{

Team team = new Team()

{

Name = string.Format("Team {0}-{1}-{2}", x, y, z)

};

division.TeamCollection.Add(pTeam);

}

league.DivisionCollection.Add(pDivision);

}

Add(league);

}

#endregion

}

▶

[DATABASE/SQLSERVER] 계층적 테이블 조회하기

■ 계층적 테이블을 조회하는 방법을 보여준다. ▶ 계층적 테이블 조회하기 예제 (SQL)


SELECT * FROM GetTreeTable(18);

SELECT * FROM GetTreeTable(18);

▶ 계층적 테이블 조회하기 (SQL)


CREATE FUNCTION [dbo].[GetTreeTable]
(
    @ParentID INT -- 부모 ID
)
RETURNS @ResultTree TABLE
(
    ID           INT
   ,Name         NVARCHAR(50)
   ,ParentID     INT
   ,TreeLevel    INT
   ,TreePath     VARCHAR(2000)
) AS
BEGIN
    DECLARE @TreeLevel INT;

    SELECT @TreeLevel = 0;

    INSERT INTO @ResultTree
    SELECT
        ----------------------------------------
        ID        = A.ID       -- ID
       ,Name      = A.Name     -- 명칭
       ,ParentID  = A.ParentID -- 부모 ID
        ----------------------------------------
       ,TreeLevel = @TreeLevel
       ,TreePath  = RIGHT('00000000' + CAST(A.ID AS VARCHAR(8)), 8)
    FROM   Menu AS A WITH(NOLOCK)
    WHERE  A.ID = @ParentID;

    WHILE @@ROWCOUNT > 0
    BEGIN
        SELECT @TreeLevel = @TreeLevel + 1;

        INSERT INTO @ResultTree
        SELECT
            ----------------------------------------
            ID        = A.ID       -- ID
           ,Name      = A.Name     -- 명칭
           ,ParentID  = A.ParentID -- 부모ID
            ----------------------------------------
           ,TreeLevel = @TreeLevel
           ,TreePath  = B.TreePath + '/' + RIGHT('00000000' + CAST(A.ID AS VARCHAR(8)), 8)
        FROM       Menu        AS A WITH(NOLOCK)
        INNER JOIN @ResultTree AS B ON B.ID = A.ParentID
        WHERE EXISTS
        (
            SELECT B.*
            FROM   @ResultTree AS B
            WHERE  B.ID = A.ParentID
        )
        AND NOT EXISTS
        (
            SELECT C.*
            FROM   @ResultTree AS C
            WHERE  C.ID = A.ID
        );
    END;

    RETURN;
END
GO

CREATE FUNCTION [dbo].[GetTreeTable]

(

@ParentID INT -- 부모 ID

)

RETURNS @ResultTree TABLE

(

ID INT

,Name NVARCHAR(50)

,ParentID INT

,TreeLevel INT

,TreePath VARCHAR(2000)

) AS

BEGIN

DECLARE @TreeLevel INT;

SELECT @TreeLevel = 0;

INSERT INTO @ResultTree

SELECT

----------------------------------------

ID = A.ID -- ID

,Name = A.Name -- 명칭

,ParentID = A.ParentID -- 부모 ID

----------------------------------------

,TreeLevel = @TreeLevel

,TreePath = RIGHT('00000000' + CAST(A.ID AS VARCHAR(8)), 8)

FROM Menu AS A WITH(NOLOCK)

WHERE A.ID = @ParentID;

WHILE @@ROWCOUNT > 0

BEGIN

SELECT @TreeLevel = @TreeLevel + 1;

INSERT INTO @ResultTree

SELECT

----------------------------------------

ID = A.ID -- ID

,Name = A.Name -- 명칭

,ParentID = A.ParentID -- 부모ID

----------------------------------------

,TreeLevel = @TreeLevel

,TreePath = B.TreePath + '/' + RIGHT('00000000' + CAST(A.ID AS VARCHAR(8)), 8)

FROM Menu AS A WITH(NOLOCK)

INNER JOIN @ResultTree AS B ON B.ID = A.ParentID

WHERE EXISTS

(

SELECT B.*

FROM @ResultTree AS B

WHERE B.ID = A.ParentID

)

AND NOT EXISTS

(

SELECT C.*

FROM @ResultTree AS C

WHERE C.ID = A.ID

);

END;

RETURN;

END

[C#/WPF] CollectionViewSource 클래스 : ICollectionView 객체의 SortDescriptions 속성을 사용해 정렬 추가하기

■ CollectionViewSource 클래스에서 ICollectionView 객체의 SortDescriptions 속성을 사용해 정렬을 추가하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 정렬 추가하기 - AddSort(collectionViewSource, propertyNameArray)

/// <summary>
/// 정렬 추가하기
/// </summary>
/// <param name="collectionViewSource">컬렉션 뷰 소스</param>
/// <param name="propertyNameArray">속성명 배열</param>
public void AddSort(CollectionViewSource collectionViewSource, params string[] propertyNameArray)
{
    ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

    if(collectionView != null && collectionView.CanSort)
    {
        collectionView.SortDescriptions.Clear();

        for(int i = 0; i < propertyNameArray.Length; i++)
        {
            collectionView.SortDescriptions.Add
            (
                new SortDescription(propertyNameArray[i],
                ListSortDirection.Ascending)
            );
        }
    }
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 정렬 추가하기 - AddSort(collectionViewSource, propertyNameArray)

/// <summary>

/// 정렬 추가하기

/// </summary>

/// <param name="collectionViewSource">컬렉션 뷰 소스</param>

/// <param name="propertyNameArray">속성명 배열</param>

public void AddSort(CollectionViewSource collectionViewSource, params string[] propertyNameArray)

{

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

if(collectionView != null && collectionView.CanSort)

{

collectionView.SortDescriptions.Clear();

for(int i = 0; i < propertyNameArray.Length; i++)

{

collectionView.SortDescriptions.Add

(

new SortDescription(propertyNameArray[i],

ListSortDirection.Ascending)

);

}

#endregion

[C#/WPF] CollectionViewSource 클래스 : ICollectionView 객체의 SortDescriptions 속성을 사용해 정렬 지우기

■ CollectionViewSource 클래스에서 ICollectionView 객체의 SortDescriptions 속성을 사용해 정렬을 지우는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 정렬 지우기 - ClearSort(collectionViewSource)

/// <summary>
/// 정렬 지우기
/// </summary>
/// <param name="collectionViewSource">컬렉션 뷰 소스</param>
public void ClearSort(CollectionViewSource collectionViewSource)
{
    ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

    if(collectionView != null && collectionView.CanSort)
    {
        collectionView.SortDescriptions.Clear();
    }
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 정렬 지우기 - ClearSort(collectionViewSource)

/// <summary>

/// 정렬 지우기

/// </summary>

/// <param name="collectionViewSource">컬렉션 뷰 소스</param>

public void ClearSort(CollectionViewSource collectionViewSource)

{

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

if(collectionView != null && collectionView.CanSort)

{

collectionView.SortDescriptions.Clear();

}

#endregion

[C#/WPF] CollectionViewSource 클래스 : ICollectionView 객체의 GroupDescriptions 속성을 사용해 그룹 추가하기

■ CollectionViewSource 클래스에서 ICollectionView 객체의 GroupDescriptions 속성을 사용해 그룹을 추가하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 그룹 추가하기 - AddGroup(collectionViewSource, propertyNameArray)

/// <summary>
/// 그룹 추가하기
/// </summary>
/// <param name="collectionViewSource">컬렉션 뷰 소스</param>
/// <param name="propertyNameArray">속성명 배열</param>
public void AddGroup(CollectionViewSource collectionViewSource, params string[] propertyNameArray)
{
    ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

    if(collectionView != null && collectionView.CanGroup)
    {
        collectionView.GroupDescriptions.Clear();

        for(int i = 0; i < propertyNameArray.Length; i++)
        {
            collectionView.GroupDescriptions.Add(new PropertyGroupDescription(propertyNameArray[i]));
        }
    }
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 그룹 추가하기 - AddGroup(collectionViewSource, propertyNameArray)

/// <summary>

/// 그룹 추가하기

/// </summary>

/// <param name="collectionViewSource">컬렉션 뷰 소스</param>

/// <param name="propertyNameArray">속성명 배열</param>

public void AddGroup(CollectionViewSource collectionViewSource, params string[] propertyNameArray)

{

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

if(collectionView != null && collectionView.CanGroup)

{

collectionView.GroupDescriptions.Clear();

for(int i = 0; i < propertyNameArray.Length; i++)

{

collectionView.GroupDescriptions.Add(new PropertyGroupDescription(propertyNameArray[i]));

}

#endregion

[C#/WPF] CollectionViewSource 클래스 : ICollectionView 객체의 GroupDescriptions 속성을 사용해 그룹 지우기

■ CollectionViewSource 클래스에서 ICollectionView 객체의 GroupDescriptions 속성을 사용해 그룹을 지우는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 그룹 지우기 - ClearGroup(collectionViewSource)

/// <summary>
/// 그룹 지우기
/// </summary>
/// <param name="collectionViewSource">컬렉션 뷰 소스</param>
public void ClearGroup(CollectionViewSource collectionViewSource)
{
    ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

    if(collectionView != null && collectionView.CanGroup)
    {
        collectionView.GroupDescriptions.Clear();
    }
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 그룹 지우기 - ClearGroup(collectionViewSource)

/// <summary>

/// 그룹 지우기

/// </summary>

/// <param name="collectionViewSource">컬렉션 뷰 소스</param>

public void ClearGroup(CollectionViewSource collectionViewSource)

{

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

if(collectionView != null && collectionView.CanGroup)

{

collectionView.GroupDescriptions.Clear();

}

#endregion

[C#/WPF] CollectionViewSource 클래스 : ICollectionView 객체의 Refresh 메소드를 사용해 데이터 갱신하기

■ CollectionViewSource 클래스에서 ICollectionView 객체의 Refresh 메소드를 사용해 데이터를 갱신하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 갱신하기 - Refresh(collectionViewSource)

/// <summary>
/// 갱신하기
/// </summary>
/// <param name="collectionViewSource">컬렉션 뷰 소스</param>
public void Refresh(CollectionViewSource collectionViewSource)
{
    ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

    collectionView.Refresh();
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 갱신하기 - Refresh(collectionViewSource)

/// <summary>

/// 갱신하기

/// </summary>

/// <param name="collectionViewSource">컬렉션 뷰 소스</param>

public void Refresh(CollectionViewSource collectionViewSource)

{

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

collectionView.Refresh();

}

#endregion

[C#/WPF] CollectionViewSource 클래스 : GetDefaultView 정적 메소드를 사용해 기본 뷰 구하기

■ CollectionViewSource 클래스의 GetDefaultView 정적 메소드를 사용해 기본 뷰를 구하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

CollectionViewSource collectionViewSource;

...

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

using System.ComponentModel;

using System.Windows.Data;

CollectionViewSource collectionViewSource;

...

ICollectionView collectionView = CollectionViewSource.GetDefaultView(collectionViewSource);

[C#/WPF] CollectionViewSource 엘리먼트 사용하기

■ CollectionViewSource 엘리먼트를 사용하는 방법을 보여준다. ▶ 예제 코드 (XAML)


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:scm="clr-namespace:System.ComponentModel;assembly=WindowsBase"
    Width="800"
    Height="600"
    Title="CollectionViewSource 엘리먼트 사용하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Window.Resources>
        <local:TaskCollection x:Key="TaskCollectionKey" />
        <CollectionViewSource x:Key="CollectionViewSourceKey"
            Source="{StaticResource TaskCollectionKey}">
            <CollectionViewSource.SortDescriptions>
                <scm:SortDescription PropertyName="ProjectName" />
                <scm:SortDescription PropertyName="Completed"   />
                <scm:SortDescription PropertyName="DueDate"     />
            </CollectionViewSource.SortDescriptions>
            <CollectionViewSource.GroupDescriptions>
                <PropertyGroupDescription PropertyName="ProjectName" />
                <PropertyGroupDescription PropertyName="Completed"   />
            </CollectionViewSource.GroupDescriptions>
        </CollectionViewSource>
    </Window.Resources>
    ...
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:scm="clr-namespace:System.ComponentModel;assembly=WindowsBase"

Width="800"

Height="600"

Title="CollectionViewSource 엘리먼트 사용하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Window.Resources>

<local:TaskCollection x:Key="TaskCollectionKey" />

<CollectionViewSource x:Key="CollectionViewSourceKey"

Source="{StaticResource TaskCollectionKey}">

<CollectionViewSource.SortDescriptions>

<scm:SortDescription PropertyName="ProjectName" />

<scm:SortDescription PropertyName="Completed" />

<scm:SortDescription PropertyName="DueDate" />

</CollectionViewSource.SortDescriptions>

<CollectionViewSource.GroupDescriptions>

</CollectionViewSource.GroupDescriptions>

</CollectionViewSource>

</Window.Resources>

...

</Window>

※ TaskCollection 객체는 'DataGrid 클래스 : INotifyPropertyChanged, IEditableObject 인터페이스 구현 객체

[C#/WPF] CollectionView 클래스 : Filter 속성 설정하기

■ CollectionView 클래스의 Filter 속성을 설정하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.Collections.ObjectModel;
using System.Windows.Data;

ObservableCollection<Person> observableCollection = new ObservableCollection<Person>();

...

CollectionView collectionView = new CollectionView(observableCollection);

collectionView.Filter = LivingPersionFilter;

...

#region 생존자 필터 처리하기 - LivingPersionFilter(value)

/// <summary>
/// 생존자 필터 처리하기
/// </summary>
/// <param name="value">값</param>
/// <returns>처리 결과</returns>
private bool LivingPersionFilter(object value)
{
    return (value as Person).DeathDate == null;
}

#endregion

using System.Collections.ObjectModel;

using System.Windows.Data;

ObservableCollection<Person> observableCollection = new ObservableCollection<Person>();

...

CollectionView collectionView = new CollectionView(observableCollection);

collectionView.Filter = LivingPersionFilter;

...

#region 생존자 필터 처리하기 - LivingPersionFilter(value)

/// <summary>

/// 생존자 필터 처리하기

/// </summary>

/// <param name="value">값</param>

/// <returns>처리 결과</returns>

private bool LivingPersionFilter(object value)

{

return (value as Person).DeathDate == null;

}

#endregion

※ Person 클래스를 예제 클래스로 구체적으로 명시하지 않았다.

[C#/WPF] CollectionView 클래스 : 정렬 순서 추가하기

■ CollectionView 클래스에서 정렬 순서를 추가하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.ComponentModel;
using System.Windows.Data;

#region 정렬 순서 추가하기 - AddSortOrder(collectionView, propertyName, listSortDirection)

/// <summary>
/// 정렬 순서 추가하기
/// </summary>
/// <param name="collectionView">CollectionView 객체</param>
/// <param name="propertyName">속성명</param>
/// <param name="listSortDirection">리스트 정렬 방향</param>
public void AddSortOrder(CollectionView collectionView, string propertyName, ListSortDirection listSortDirection)
{
    collectionView.SortDescriptions.Add(new SortDescription(propertyName, listSortDirection));
}

#endregion

using System.ComponentModel;

using System.Windows.Data;

#region 정렬 순서 추가하기 - AddSortOrder(collectionView, propertyName, listSortDirection)

/// <summary>

/// 정렬 순서 추가하기

/// </summary>

/// <param name="collectionView">CollectionView 객체</param>

/// <param name="propertyName">속성명</param>

/// <param name="listSortDirection">리스트 정렬 방향</param>

public void AddSortOrder(CollectionView collectionView, string propertyName, ListSortDirection listSortDirection)

{

collectionView.SortDescriptions.Add(new SortDescription(propertyName, listSortDirection));

}

#endregion

[C#/WPF] CollectionView 클래스 : 정렬 순서 지우기

■ CollectionView 클래스에서 정렬 순서를 지우는 방법을 보여준다. ▶ 예제 코드 (C#)


using System.Windows.Data;

#region 정렬 순서 지우기 - ClearSortOrder(collectionView)

/// <summary>
/// 정렬 순서 지우기
/// </summary>
/// <param name="collectionView">CollectionView 객체</param>
public void ClearSortOrder(CollectionView collectionView)
{
    collectionView.SortDescriptions.Clear();
}

#endregion

using System.Windows.Data;

#region 정렬 순서 지우기 - ClearSortOrder(collectionView)

/// <summary>

/// 정렬 순서 지우기

/// </summary>

/// <param name="collectionView">CollectionView 객체</param>

public void ClearSortOrder(CollectionView collectionView)

{

collectionView.SortDescriptions.Clear();

}

#endregion