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;
}
