private void LoadColumns() { Report.Columns.Clear(); Report.TableSummaryRows.Clear(); Report.StackedHeaderRows.Clear(); if (ReportFlag == 0) { Report.Columns.Add(new GridTextColumn { HeaderText = "Id", DisplayBinding = new Binding("REPRINTNO"), Width = 80 }); Report.Columns.Add(new GridTextColumn { HeaderText = "User", DisplayBinding = new Binding("PRINTED_BY"), Width = 90 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Date", DisplayBinding = new Binding("BILL_DATE") { StringFormat = "MM/dd/yyyy" }, Width = 90 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Time", DisplayBinding = new Binding("PRINTED_TIME"), Width = 90 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Settled Amount", DisplayBinding = new Binding("AMOUNT") { StringFormat = "#0.00" }, Width = 120, TextAlignment = TextAlignment.Right }); Report.Columns.Add(new GridTextColumn { HeaderText = "Collected Amount", DisplayBinding = new Binding("TAXABLE_AMOUNT") { StringFormat = "#0.00" }, Width = 120, TextAlignment = TextAlignment.Right }); Report.Columns.Add(new GridTextColumn { HeaderText = "Excess/Short", DisplayBinding = new Binding("TAX_AMOUNT") { StringFormat = "#0.00" }, Width = 100, TextAlignment = TextAlignment.Right }); GridSummaryRow Tgsr = new GridSummaryRow() { ShowSummaryInRow = false, Title = "Total" }; Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "AMOUNT", Name = "TCUSTOMER_NAME", SummaryType = Syncfusion.Data.SummaryType.DoubleAggregate, Format = "{Sum:#,###,#0.00}" }); Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "TAXABLE_AMOUNT", Name = "TDISCOUNT", SummaryType = Syncfusion.Data.SummaryType.DoubleAggregate, Format = "{Sum:#,###,#0.00}" }); Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "TAX_AMOUNT", Name = "TEXORT", SummaryType = Syncfusion.Data.SummaryType.DoubleAggregate, Format = "{Sum:#,###,#0.00}" }); Report.TableSummaryRows.Add(Tgsr); } }
private void SetGridLinesGroupColumnSummaries() { // Creates the GridSummaryRow. GridSummaryRow captionSummaryRow = new GridSummaryRow { Name = "CaptionSummary", ShowSummaryInRow = false, TitleColumnCount = 3, Title = "{ColumnName} = {Key} ({ItemsCount} Registos)" }; GridSummaryColumn summaryColumn1 = new GridSummaryColumn { Name = "CreditAmount", Format = "{Sum:c}", MappingName = "CreditAmount", SummaryType = SummaryType.DoubleAggregate }; GridSummaryColumn summaryColumn2 = new GridSummaryColumn { Name = "DebitAmount", Format = "{Sum:c}", MappingName = "DebitAmount", SummaryType = SummaryType.DoubleAggregate }; GridSummaryColumn summaryColumn3 = new GridSummaryColumn { Name = "CreditTaxPayable", Format = "{Sum:c}", MappingName = "CreditTaxPayable", SummaryType = SummaryType.DoubleAggregate }; GridSummaryColumn summaryColumn4 = new GridSummaryColumn { Name = "DebitTaxPayable", Format = "{Sum:c}", MappingName = "DebitTaxPayable", SummaryType = SummaryType.DoubleAggregate }; // Adds the summary column in the SummaryColumns collection. captionSummaryRow.SummaryColumns.Add(summaryColumn1); captionSummaryRow.SummaryColumns.Add(summaryColumn2); captionSummaryRow.SummaryColumns.Add(summaryColumn3); captionSummaryRow.SummaryColumns.Add(summaryColumn4); // Initializes the caption summary row. this.gridLines.CaptionSummaryRow = captionSummaryRow; }
public Form1() { InitializeComponent(); var data = new OrderInfoCollection(); sfDataGrid.DataSource = data.OrdersListDetails; GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow(); tableSummaryRow1.Name = "TableSummary"; tableSummaryRow1.ShowSummaryInRow = true; tableSummaryRow1.Title = " Total Product Count: {ProductName}"; tableSummaryRow1.Position = VerticalPosition.Bottom; GridSummaryColumn summaryColumn1 = new GridSummaryColumn(); summaryColumn1.Name = "ProductName"; summaryColumn1.SummaryType = SummaryType.CountAggregate; summaryColumn1.Format = "{Count}"; summaryColumn1.MappingName = "ProductName"; tableSummaryRow1.SummaryColumns.Add(summaryColumn1); this.sfDataGrid.TableSummaryRows.Add(tableSummaryRow1); GridSummaryRow groupSummaryRow1 = new GridSummaryRow(); groupSummaryRow1.Name = "GroupSummary"; groupSummaryRow1.ShowSummaryInRow = true; groupSummaryRow1.Title = " Total Product Count: {ProductName}"; // Adds the GridSummaryColumn in SummaryColumns collection. groupSummaryRow1.SummaryColumns.Add(summaryColumn1); // Adds the summary row in the GroupSummaryRows collection. this.sfDataGrid.GroupSummaryRows.Add(groupSummaryRow1); this.sfDataGrid.SelectionController = new CustomRowSelectionController(this.sfDataGrid); this.sfDataGrid.AutoExpandGroups = true; this.sfDataGrid.GroupColumnDescriptions.Add(new GroupColumnDescription() { ColumnName = "OrderDate" }); this.sfDataGrid.ClearSelection(); }
private static void OnTableSumClicked(object obj) { if (obj is GridRecordContextMenuInfo) { var grid = (obj as GridRecordContextMenuInfo).DataGrid; var record = (obj as GridRecordContextMenuInfo).Record as SummaryRecordEntry; if (record != null) { var summaryrow = new GridSummaryRow() { ShowSummaryInRow = true, Name = "totalgroupsummaryrow", Title = "{totalSummary}" }; summaryrow.SummaryColumns.Add(new GridSummaryColumn() { Name = "totalSummary", MappingName = "EmployeeAge", SummaryType = SummaryType.DoubleAggregate, Format = "Sum Employee Salary : {Sum}" }); grid.TableSummaryRows.Clear(); grid.TableSummaryRows.Add(summaryrow); } } }
private void SetupGroupSummary() { var groupSummaryRow1 = new GridSummaryRow { Name = "GroupSummary", ShowSummaryInRow = false }; // Creates the GridSummaryColumn. var summaryColumn1 = new GridSummaryColumn { Name = "UnitPrice", SummaryType = SummaryType.DoubleAggregate, Format = "{Sum:c}", MappingName = "Tool.Price" }; // Adds the GridSummaryColumn in SummaryColumns collection. groupSummaryRow1.SummaryColumns.Add(summaryColumn1); // Adds the summary row in the GroupSummaryRows collection. sdgOrders.GroupSummaryRows.Clear(); sdgOrders.GroupSummaryRows.Add(groupSummaryRow1); }
private void Gc1_SourceListListChangedCompleted(object sender, TableListChangedEventArgs e) { var r = this.gc1.TableModel.RowCount; var p = this.gc1.TableModel.Rows.Model.RowCount; GridSummaryRow rec = this.gc1.Table.DisplayElements[r] as GridSummaryRow; GridRecordRow row = this.gc1.Table.DisplayElements[r] as GridRecordRow; if (row is GridRecordRow) { MessageBox.Show("row"); } if (rec is GridSummaryRow) { foreach (var scd in rec.SummaryRowDescriptor.SummaryColumns) { if (scd.Name == "Machine Hours Remaining") { txtMachine.Text = GridEngine.GetSummaryText(rec.ParentGroup, scd); } else if (scd.Name == "Weld Hours Remaining") { txtWeld.Text = GridEngine.GetSummaryText(rec.ParentGroup, scd); } else if (scd.Name == "Build Hours Remaining") { txtBuild.Text = GridEngine.GetSummaryText(rec.ParentGroup, scd); } else if (scd.Name == "Tracker Hours Remaining") { txtTrackers.Text = GridEngine.GetSummaryText(rec.ParentGroup, scd); } else if (scd.Name == "Design Hours Remaining") { txtDesign.Text = GridEngine.GetSummaryText(rec.ParentGroup, scd); } } } }
/// <summary> /// Sets the sample customization settings. /// </summary> private void SampleCustomization() { #region SfDataGrid settings sfDataGrid1.ThemeName = "Office2016Colorful"; sfDataGrid1.ShowRowHeader = true; sfDataGrid1.AllowFiltering = true; this.sfDataGrid1.AllowGrouping = true; this.sfDataGrid1.ShowGroupDropArea = true; this.sfDataGrid1.AutoGenerateColumns = false; this.sfDataGrid1.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill; OrderInfoRepository orderInfo = new OrderInfoRepository(); this.sfDataGrid1.DataSource = orderInfo.GetOrdersDetails(30); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "OrderID", HeaderText = "Order ID" }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerID", HeaderText = "Customer ID" }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity", HeaderText = "Ship City" }); this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity", HeaderText = "Ship Country" }); this.sfDataGrid1.Columns.Add(new GridDateTimeColumn() { MappingName = "ShippingDate", HeaderText = "Shipping Date" }); this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "Freight", HeaderText = "Freight", FormatMode = FormatMode.Currency }); this.sfDataGrid1.Columns.Add(new GridCheckBoxColumn() { MappingName = "IsClosed", HeaderText = "Is Closed" }); sfDataGrid1.AllowResizingColumns = true; #endregion #region themComboBox settings List <ThemeTypes> theme = new List <ThemeTypes>(); theme.Add(new ThemeTypes() { ThemeName = "Office2016Black", Value = 1 }); theme.Add(new ThemeTypes() { ThemeName = "Office2016White", Value = 2 }); theme.Add(new ThemeTypes() { ThemeName = "Office2016DarkGray", Value = 3 }); theme.Add(new ThemeTypes() { ThemeName = "Office2016Colorful", Value = 4 }); comboBox1.DataSource = theme; comboBox1.DisplayMember = "ThemeName"; comboBox1.ValueMember = "ThemeName"; comboBox1.SelectedValueChanged += comboBox1_SelectedValueChanged; comboBox1.SelectedValue = "Office2016Colorful"; #endregion this.checkBox1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Office2016Colorful; checkBox1.CheckedChanged += checkBox1_CheckedChanged; #region TableSummaryRow GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow(); tableSummaryRow1.Name = "TableSummary"; tableSummaryRow1.ShowSummaryInRow = true; tableSummaryRow1.Title = " Total Count: {OrderID}"; tableSummaryRow1.Position = VerticalPosition.Bottom; GridSummaryColumn summaryColumn1 = new GridSummaryColumn(); summaryColumn1.Name = "OrderID"; summaryColumn1.SummaryType = SummaryType.DoubleAggregate; summaryColumn1.Format = "{Count}"; summaryColumn1.MappingName = "OrderID"; tableSummaryRow1.SummaryColumns.Add(summaryColumn1); this.sfDataGrid1.TableSummaryRows.Add(tableSummaryRow1); #endregion #region GroupSummaryRow // Creates the GridSummaryRow. GridSummaryRow groupSummaryRow1 = new GridSummaryRow(); groupSummaryRow1.Name = "GroupSummary"; groupSummaryRow1.ShowSummaryInRow = false; groupSummaryRow1.Title = "Total $: { OrderID }"; // Creates the GridSummaryColumn. GridSummaryColumn summaryColumn3 = new GridSummaryColumn(); summaryColumn3.Name = "OrderID"; summaryColumn3.SummaryType = SummaryType.DoubleAggregate; summaryColumn3.Format = "Total : {Sum:c}"; summaryColumn3.MappingName = "OrderID"; // Adds the GridSummaryColumn in SummaryColumns collection. groupSummaryRow1.SummaryColumns.Add(summaryColumn3); // Adds the summary row in the GroupSummaryRows collection. this.sfDataGrid1.GroupSummaryRows.Add(groupSummaryRow1); #endregion #region Relation Creation GridViewDefinition viewDefinition = new GridViewDefinition(); viewDefinition.RelationalColumn = "OrderDetails"; firstLevelSourceDataGrid = new SfDataGrid(); firstLevelSourceDataGrid.Columns.Add(new GridTextColumn() { MappingName = "OrderID", HeaderText = "Order ID" }); firstLevelSourceDataGrid.Columns.Add(new GridDateTimeColumn() { MappingName = "OrderDate", HeaderText = "Order Date" }); firstLevelSourceDataGrid.Columns.Add(new GridTextColumn() { MappingName = "CustomerID", HeaderText = "Customer ID" }); firstLevelSourceDataGrid.Columns.Add(new GridTextColumn() { MappingName = "CustomerCity", HeaderText = "Customer City" }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "ProductID", HeaderText = "Product ID", FormatMode = FormatMode.Numeric }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "UnitPrice", HeaderText = "Unit Price", FormatMode = FormatMode.Currency }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "Quantity", HeaderText = "Quantity", FormatMode = FormatMode.Numeric }); firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "Discount", HeaderText = "Discount", FormatMode = FormatMode.Percent }); StackedHeaderRow stackedHeaderRow = new StackedHeaderRow(); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "OrderID,OrderDate", HeaderText = "Order Details" }); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "CustomerID,CustomerCity", HeaderText = "Customer Details" }); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "ProductID,UnitPrice,Quantity,Discount", HeaderText = "Product Details" }); firstLevelSourceDataGrid.AllowResizingColumns = true; firstLevelSourceDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill; viewDefinition.DataGrid = firstLevelSourceDataGrid; this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition); #endregion this.sfDataGrid1.HideEmptyGridViewDefinition = true; }
private void LoadColumns() { Report.Columns.Clear(); Report.TableSummaryRows.Clear(); Report.StackedHeaderRows.Clear(); if (ReportFlag == 0) { Report.Columns.Add(new GridTextColumn { HeaderText = "Bill No", DisplayBinding = new Binding("BILL_NO"), Width = 70 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Date", DisplayBinding = new Binding("BILL_DATE") { StringFormat = "MM/dd/yyyy" }, Width = 70 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Time", DisplayBinding = new Binding("PRINTED_TIME"), Width = 70 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Voucher No", DisplayBinding = new Binding("REF_NO"), Width = 80 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Voucher Name", DisplayBinding = new Binding("REMARKS"), Width = 280 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Customer", DisplayBinding = new Binding("CUSTOMER_NAME"), Width = 250 }); Report.Columns.Add(new GridTextColumn { HeaderText = "User Name", DisplayBinding = new Binding("PRINTED_BY"), Width = 100 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Discount", DisplayBinding = new Binding("DISCOUNT") { StringFormat = "#0.00" }, Width = 100, TextAlignment = TextAlignment.Right }); GridSummaryRow Tgsr = new GridSummaryRow() { ShowSummaryInRow = false }; Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "CUSTOMER_NAME", Name = "TCUSTOMER_NAME", SummaryType = Syncfusion.Data.SummaryType.CountAggregate, Format = "{Count}" }); Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "DISCOUNT", Name = "TDISCOUNT", SummaryType = Syncfusion.Data.SummaryType.DoubleAggregate, Format = "{Sum:#,###,#0.00}" }); Report.TableSummaryRows.Add(Tgsr); } else if (ReportFlag == 1) { string Header = (SummaryType == "REMARKS") ? "Voucher Name" : ((SummaryType == "CUSTOMER_NAME") ? "Customer" : "User Name"); Report.Columns.Add(new GridTextColumn { HeaderText = "Date", DisplayBinding = new Binding("BILL_DATE") { StringFormat = "MM/dd/yyyy" }, Width = 150 }); Report.Columns.Add(new GridTextColumn { HeaderText = Header, DisplayBinding = new Binding(SummaryType), Width = 600 }); Report.Columns.Add(new GridTextColumn { HeaderText = "No of Voucher", DisplayBinding = new Binding("REPRINTNO"), Width = 150 }); Report.Columns.Add(new GridTextColumn { HeaderText = "Discount", DisplayBinding = new Binding("DISCOUNT") { StringFormat = "#0.00" }, Width = 150, TextAlignment = TextAlignment.Right }); GridSummaryRow Tgsr = new GridSummaryRow() { ShowSummaryInRow = false }; Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "REPRINTNO", Name = "TREPRINTNO", SummaryType = Syncfusion.Data.SummaryType.Int32Aggregate, Format = "{Sum}" }); Tgsr.SummaryColumns.Add(new GridSummaryColumn() { MappingName = "DISCOUNT", Name = "TDISCOUNT", SummaryType = Syncfusion.Data.SummaryType.DoubleAggregate, Format = "{Sum:#,###,#0.00}" }); Report.TableSummaryRows.Add(Tgsr); } }