WPF & DevExpress GridControl LookupEdit Dynamically change item source

LookupEdit 동적 바인드 

 

일반적인 lookupedit 바인드 

 

 

특정 그룹만 보이게 할 때 예

데이터 구조 3번째 컬럼의 상위 그룹 코드 위와 같이 구분이 되어 있다.

 

 

 

<Page xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:local="clr-namespace:WpfSample.DevTest" xmlns:dxlc="http://schemas.devexpress.com/winfx/2008/xaml/layoutcontrol" xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core" xmlns:Serialization="clr-namespace:DevExpress.Xpf.LayoutControl.Serialization;assembly=DevExpress.Xpf.LayoutControl.v17.2" xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors" xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid" x:Class="WpfSample.DevTest.Grid04LookupEditShownBind" mc:Ignorable="d" d:DesignHeight="700" d:DesignWidth="1200" Title="Grid01"> <StackPanel Margin="0,10,10,10"> <dxlc:LayoutControl HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Orientation="Vertical" > <dxlc:LayoutGroup Header="Button" View="GroupBox" HorizontalAlignment="Stretch" > <dx:SimpleButton x:Name="btnSearch" Content="Search" HorizontalAlignment="Left" Click="Button_Click" /> </dxlc:LayoutGroup> </dxlc:LayoutControl> <dxlc:LayoutControl HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Orientation="Vertical"> <dxlc:LayoutGroup Header="Grid" View="GroupBox" HorizontalAlignment="Stretch" Height="500" > <dxg:GridControl x:Name="gcGrid" HorizontalAlignment="Stretch" > <dxg:GridControl.View> <dxg:TableView x:Name="tvView" AllowPerPixelScrolling="True" ShowTotalSummary="True" ShownEditor="TableView_ShownEditor" /> </dxg:GridControl.View> <dxg:GridControl.Columns > <dxg:GridColumn FieldName="CocktailNo" Header="CocktailNo" Width="110" /> <dxg:GridColumn FieldName="CocktailMaterialNo" Header="CocktailMaterialNo" Width="100" /> <dxg:GridColumn FieldName="MaterialCode" Header="MaterialCode" Width="100" > <!--<dxg:GridColumn.EditSettings> <dxg:LookUpEditSettings x:Name="lueMaterialCode" ItemsSource="{Binding ocCommonCode}" ValueMember="Code" DisplayMember="CodeName" /> </dxg:GridColumn.EditSettings>--> <dxg:GridColumn.CellTemplate> <DataTemplate> <dxg:LookUpEdit Name="PART_Editor" ItemsSource="{Binding View.DataContext.ocCommonCode }" ValueMember="Code" DisplayMember="CodeName" AutoPopulateColumns="False" PopupWidth="500" AutoComplete="True" ImmediatePopup="True" AllowDefaultButton="true" IsTextEditable="true" IncrementalFiltering="True" IsPopupAutoWidth="False" ShowSizeGrip="True" PopupClosed="PART_Editor_PopupClosed" > <dxg:LookUpEdit.PopupContentTemplate> <ControlTemplate> <dxg:GridControl Name="PART_GridControl"> <dxg:GridControl.Columns> <dxg:GridColumn FieldName="Code" Header="Code" Width="100" /> <dxg:GridColumn FieldName="CodeName" Header="CodeName" Width="100" /> <dxg:GridColumn FieldName="HighCode" Header="HighCode" Width="100" /> <dxg:GridColumn FieldName="Etc1" Header="Etc1" Width="100" /> <dxg:GridColumn FieldName="Etc2" Header="Etc2" Width="100" /> <dxg:GridColumn FieldName="Etc3" Header="Etc3" Width="100" /> </dxg:GridControl.Columns> <dxg:GridControl.View> <dxg:TableView AutoWidth="False" /> </dxg:GridControl.View> </dxg:GridControl> </ControlTemplate> </dxg:LookUpEdit.PopupContentTemplate> </dxg:LookUpEdit> </DataTemplate> </dxg:GridColumn.CellTemplate> </dxg:GridColumn> <dxg:GridColumn FieldName="MaterialName" Header="MaterialName" Width="100" /> <dxg:GridColumn FieldName="MaterialQuantity" Header="MaterialQuantity" Width="100" /> <dxg:GridColumn FieldName="MaterialUnit" Header="MaterialUnit" Width="100" ReadOnly="false" /> <dxg:GridColumn FieldName="Remark" Header="Remark" Width="100" /> <dxg:GridColumn FieldName="UnitPrice" Header="UnitPrice" Width="100" ReadOnly="false" /> <dxg:GridColumn FieldName="CreateUser" Header="CreateUser" Width="100" /> <dxg:GridColumn FieldName="CreateDate" Header="CreateDate" Width="100" /> <dxg:GridColumn FieldName="UpdateUser" Header="UpdateUser" Width="100" /> <dxg:GridColumn FieldName="UpdateDate" Header="UpdateDate" Width="100" /> </dxg:GridControl.Columns> </dxg:GridControl> </dxlc:LayoutGroup> </dxlc:LayoutControl> </StackPanel> </Page>

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Data; using DevExpress.Xpf.Grid.LookUp; using BIZ.Common.Dac; using DevExpress.Xpf.Grid; using DTO.Common.Common; using DevExpress.Xpf.Editors; using System.Collections.ObjectModel; using DTO.Common.Cocktail; namespace WpfSample.DevTest { /// <summary> /// Grid04LookupEditShownBind.xaml에 대한 상호 작용 논리 /// </summary> public partial class Grid04LookupEditShownBind : Page { private DataSet data; public ObservableCollection<CommonCodeDTO> ocCommonCode { get; private set; } public Grid04LookupEditShownBind() { InitializeComponent(); ocCommonCode = new ObservableCollection<CommonCodeDTO>(); DataContext = this; List<CommonCodeDTO> lstData = (new CommonCodeDAO()).Z_UP_COMMON_CODE_LIST("060"); foreach (var item in lstData) ocCommonCode.Add(item); } private void Button_Click(object sender, RoutedEventArgs e) { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("param1", "111"); data = (new ADOConnect()).GetDataSet("Kaishaku", "Z_UP_COCKTAIL_MATERIAL_LIST", dic); gcGrid.ItemsSource = data.Tables[0]; } private void TableView_ShownEditor(object sender, EditorEventArgs e) { string str = gcGrid.GetFocusedRowCellValue("MaterialCode").ToString(); if (e.Column.FieldName == "MaterialCode") { var view = (TableView)sender; var activeEditor = view.ActiveEditor as LookUpEdit; activeEditor.ItemsSource = ocCommonCode.Where(x => x.HighCode.Contains(str.Substring(0, 4) + "00")).ToList(); activeEditor.DisplayMember = "CodeName"; activeEditor.ValueMember = "Code"; } e.Handled = true; /* if (e.Editor is LookUpEdit) { LookUpEditBase lookupEdit = e.Editor as LookUpEditBase; //LookUpEdit lookupEdit = (LookUpEdit)gcGrid.View.ActiveEditor; //List<CommonCodeDTO> lstData = (new CommonCodeDAO()).Z_UP_COMMON_CODE_LIST("060"); //lookupEdit.ItemsSource = lstData.Where(x => x.HighCode == str.Substring(0, 4) + "00").ToList(); lookupEdit.ItemsSource = ocCommonCode.Where(x => x.HighCode == str.Substring(0, 4) + "00").ToList(); //lookupEdit.ItemsSource = data.Tables[3].AsEnumerable().Where(row => row["HighCode"].ToString() == str.Substring(0, 4) + "00").CopyToDataTable(); } */ } private void PART_Editor_PopupClosed(object sender, ClosePopupEventArgs e) { //bug??? LookUpEditBase lookupEdit = (LookUpEdit)gcGrid.View.ActiveEditor; lookupEdit.ItemsSource = ocCommonCode; gcGrid.CurrentColumn = gcGrid.Columns["MaterialName"];//focus moves next column } } }

 

 

AutoPopulateColumns="false"

LookUpEditSetting
IsTextEditable="True"   텍스트 입력으로 검색

 

 

 

일부 버그(?)라는 것이 보이지만... 꼼수로 일단 처리함. 

업데이트 받으면 해결된다고 하는 것 같은데.. 거기까지 확인 못함.

 

 

 

Dynamically change item source for LookupEditor in Grid via code behind

Use different ItemsSource for LookupEdit causes values in other rows to disappear

Cell values disappear after opening the filter popup if cell editors use Server Mode components