private void InitProperty() { //Agrupa por Area GroupColumnDescription groupColumnDescription1 = new GroupColumnDescription(); groupColumnDescription1.ColumnName = "pregunta"; this.dtgRespuestas.GroupColumnDescriptions.Add(groupColumnDescription1); }
public static void ResetGridGrouping(SfDataGrid dataGrid, string prefab, MasterTablePage page, bool shouldReset) { if (!shouldReset) { dataGrid.GroupColumnDescriptions.Clear(); //ResetGridSorting(dataGrid, prefab, true); page.DefaultGroupingButton.IsChecked = false; page.SearchBox.IsEnabled = true; return; } dataGrid.GroupColumnDescriptions.Clear(); if (string.IsNullOrWhiteSpace(prefab)) { return; } List <int> groups = App.GetGroups(prefab); //groups.Reverse(); using (var conn = new SqlConnection(App.ConnectionString)) { conn.Open(); DataTable prefabTable = App.GetPrefabDataTable(conn, $"{App.Settings["Schema"]}_PREFABS", prefab); foreach (int i in groups) { var grouper = new GroupColumnDescription { ColumnName = prefabTable.Rows[i]["COLUMNS"].ToString() }; if (!dataGrid.GroupColumnDescriptions.Contains(grouper)) { dataGrid.GroupColumnDescriptions.Add(grouper); } } conn.Close(); } page.SearchBox.IsEnabled = false; //ResetGridSorting(dataGrid, prefab); }
public Form1() { InitializeComponent(); orderInfo = new OrderInfoCollection(); #region DataGrid Customizations this.sfDataGrid1.DataSource = orderInfo.OrdersListDetails; GroupColumnDescription groupColumnDescription = new GroupColumnDescription(); groupColumnDescription.ColumnName = "ProductName"; this.sfDataGrid1.GroupColumnDescriptions.Add(groupColumnDescription); this.sfDataGrid1.CopyOption = CopyOptions.CopyData | CopyOptions.CutData; this.sfDataGrid1.GroupColumnDescriptions.CollectionChanged += GroupColumnDescriptions_CollectionChanged; //Table Summary this.sfDataGrid1.TableSummaryRows.Add(new GridTableSummaryRow() { Position = VerticalPosition.Bottom, ShowSummaryInRow = false, SummaryColumns = new ObservableCollection <ISummaryColumn>() { new GridSummaryColumn() { Name = "UnitPrice", MappingName = "UnitPrice", Format = "Count : {Count}", SummaryType = SummaryType.Int32Aggregate }, } }); //Group Summary sfDataGrid1.GroupSummaryRows.Clear(); sfDataGrid1.GroupSummaryRows.Add(new GridSummaryRow() { ShowSummaryInRow = false, SummaryColumns = new ObservableCollection <ISummaryColumn>() { new GridSummaryColumn() { MappingName = "UnitPrice", SummaryType = SummaryType.Int32Aggregate, Format = "Sum : {Sum}", Name = "FirstColumn", } } }); #endregion #region GroupDropAreaContextMenu groupDropAreaContextMenu = new ContextMenuStrip(); groupDropAreaContextMenu.Items.Add("Hide GroupDropArea", null, OnHideGroupDropAreaClick); groupDropAreaContextMenu.Items.Add("Expand All", null, OnExpandAllClick); groupDropAreaContextMenu.Items.Add("Collapse All", null, OnCollapseAllClick); groupDropAreaContextMenu.Items.Add("Clear Groups", null, OnClearGroupsClick); groupDropAreaContextMenu.Items[1].Enabled = false; groupDropAreaContextMenu.Opening += GroupDropAreaContextMenu_Opening; this.sfDataGrid1.GroupDropAreaContextMenu = groupDropAreaContextMenu; #endregion #region GroupDropAreaItemContextMenu groupDropItemContextMenu = new ContextMenuStrip(); groupDropItemContextMenu.Items.Add("Expand All", null, OnItemExpandAllClick); groupDropItemContextMenu.Items.Add("Collapse All", null, OnItemCollapseAllClick); groupDropItemContextMenu.Items.Add("Clear Group", null, OnGroupClearClick); groupDropItemContextMenu.Items[0].Enabled = false; this.sfDataGrid1.GroupDropAreaItemContextMenu = groupDropItemContextMenu; #endregion #region ColumnHeaderContextMenu columnHeaderContextMenu = new ContextMenuStrip(); #if !NETCORE columnHeaderContextMenu.Items.Add("Sort Ascending", Image.FromFile(@"../../Images/sortasc.png"), OnSortAscendingClick); columnHeaderContextMenu.Items.Add("Sort Descending", Image.FromFile(@"../../Images/sortdesc.png"), OnSortDescendingClick); #else columnHeaderContextMenu.Items.Add("Sort Ascending", Image.FromFile("../../../Images/sortasc.png"), OnSortAscendingClick); columnHeaderContextMenu.Items.Add("Sort Descending", Image.FromFile("../../../Images/sortdesc.png"), OnSortDescendingClick); #endif columnHeaderContextMenu.Items.Add("Clear Sorting", null, OnClearSortingClick); columnHeaderContextMenu.Items.Add("Show GroupDropArea", null, OnShowGroupDropAreaClick); columnHeaderContextMenu.Opening += ColumnHeaderContextMenu_Opening; this.sfDataGrid1.ColumnHeaderContextMenu = columnHeaderContextMenu; #endregion #region GroupCaptionContextMenu groupCaptionContextMenu = new ContextMenuStrip(); groupCaptionContextMenu.Items.Add("Expand", null, OnExpandClick); groupCaptionContextMenu.Items.Add("Collapse", null, OnCollapseClick); groupCaptionContextMenu.Opening += GroupCaptionContextMenu_Opening; this.sfDataGrid1.GroupCaptionContextMenu = groupCaptionContextMenu; #endregion #region GroupSummaryContextMenu groupSummaryContextMenu = new ContextMenuStrip(); groupSummaryContextMenu.Items.Add("Sum", null, OnGroupSummarySumClick); groupSummaryContextMenu.Items.Add("Count", null, OnGroupSummaryCountClick); groupSummaryContextMenu.Items[0].Enabled = false; this.sfDataGrid1.GroupSummaryContextMenu = groupSummaryContextMenu; #endregion #region RecordContextMenu recordContextMenu = new ContextMenuStrip(); recordContextMenu.Items.Add("Cut", null, Cut_Click); recordContextMenu.Items.Add("Copy", null, Copy_Click); recordContextMenu.Items.Add("Paste", null, Paste_Click); recordContextMenu.Items[2].Enabled = false; this.sfDataGrid1.RecordContextMenu = recordContextMenu; #endregion #region TableSummaryContextMenu tableSummaryContextMenu = new ContextMenuStrip(); tableSummaryContextMenu.Items.Add("Sum", null, OnTableSummarySumClick); tableSummaryContextMenu.Items.Add("Count", null, OnTableSummaryCountClick); tableSummaryContextMenu.Items[1].Enabled = false; this.sfDataGrid1.TableSummaryContextMenu = tableSummaryContextMenu; #endregion #region RowHeaderContextMenu rowHeaderContextMenu = new ContextMenuStrip(); rowHeaderContextMenu.Items.Add("Delete", null, OnDeleteClick); this.sfDataGrid1.RowHeaderContextMenu = rowHeaderContextMenu; #endregion this.sfDataGrid1.ContextMenuOpening += SfDataGrid1_ContextMenuOpening; this.sfDataGrid1.ContextMenuOpened += SfDataGrid1_ContextMenuOpened; }