public Form1() { InitializeComponent(); OrderInfoCollection orderInfoCollection = new OrderInfoCollection(); this.sfDataGrid1.DataSource = orderInfoCollection.Orders; //Creating object for a stacked header row. var stackedHeaderRow1 = new StackedHeaderRow(); //Adding stacked column to stacked columns collection available in stacked header row object. stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "OrderID", HeaderText = "Order Details" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "CustomerID,CustomerName,", HeaderText = "Customer Details" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "Country,ShipCity", HeaderText = "City Details" }); //Adding stacked header row object to stacked header row collection available in SfDataGrid. sfDataGrid1.StackedHeaderRows.Add(stackedHeaderRow1); this.sfDataGrid1.DrawCell += SfDataGrid1_DrawCell; }
/// <summary> /// Grid Settings for better Look and Feel. /// </summary> private void GridSettings() { var stackedHeaderRow = new StackedHeaderRow(); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "OrderID,CustomerID,ProductName,OrderDate,Quantity,UnitPrice,ContactNumber,ShipCountry", HeaderText = "Order Shipment Details" }); sfDataGrid.StackedHeaderRows.Add(stackedHeaderRow); var stackedHeaderRow1 = new StackedHeaderRow(); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "OrderID,OrderDate", HeaderText = "Order Details" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "CustomerID,ContactNumber,", HeaderText = "Customer Details" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "ProductName,Quantity,UnitPrice,ShipCountry", HeaderText = "Product Details" }); sfDataGrid.StackedHeaderRows.Add(stackedHeaderRow1); }
/// <summary> /// Initializes a new instance for Form1. /// </summary> public Form1() { InitializeComponent(); this.sfDataGrid1.AutoGenerateColumns = false; sfDataGrid1.DataSource = GetDataTable(); this.sfDataGrid1.CellRenderers.Add("Sparkline", new GridSparklineCellRenderer(new Syncfusion.Windows.Forms.Chart.SparkLine(), this.sfDataGrid1)); NumberFormatInfo numberFormat = Application.CurrentCulture.NumberFormat.Clone() as NumberFormatInfo; numberFormat.CurrencyDecimalDigits = 0; numberFormat.CurrencyGroupSizes = new int[] { }; numberFormat = Application.CurrentCulture.NumberFormat.Clone() as NumberFormatInfo; numberFormat.NumberDecimalDigits = 0; numberFormat.NumberGroupSizes = new int[] { }; this.sfDataGrid1.Columns.Add(new GridTextColumn { AllowEditing = true, MappingName = "Geography", HeaderText = "Geography" }); this.sfDataGrid1.Columns.Add(new GridNumericColumn { AllowEditing = true, MappingName = "Value", HeaderText = "Value", NumberFormatInfo = numberFormat }); this.sfDataGrid1.Columns.Add(new GridNumericColumn { AllowEditing = true, MappingName = "Tons", HeaderText = "Tons", NumberFormatInfo = numberFormat }); this.sfDataGrid1.Columns.Add(new GridNumericColumn { AllowEditing = true, MappingName = "Ton-miles", HeaderText = "Ton-miles", NumberFormatInfo = numberFormat }); this.sfDataGrid1.Columns.Add(new GridNumericColumn { AllowEditing = true, MappingName = "Average miles", HeaderText = "Average miles", NumberFormatInfo = numberFormat }); this.sfDataGrid1.Columns.Add(new GridSparklineColumn() { MappingName = "Sparkline", HeaderText = "Analysis Report", Width = 150, AllowFiltering = false }); StackedHeaderRow stackedHeaderRow1 = new StackedHeaderRow(); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "Geography,Value,Tons,Ton-miles,Average miles,Sparkline", HeaderText = "WHOLESALE TRADE" }); this.sfDataGrid1.StackedHeaderRows.Add(stackedHeaderRow1); //Initialize CustomSelectionController. this.sfDataGrid1.SelectionController = new CustomSelectionController(this.sfDataGrid1); }
/// <summary> /// Gets StackedColumn corresponding to the given name and index /// </summary> /// <param name="columnName"></param> /// <param name="rowIndex"></param> /// <returns></returns> /// <remarks></remarks> private static StackedColumn GetStackedColumn(this SfDataGrid sfgrid, string columnName, int rowIndex) { StackedHeaderRow header = null; StackedColumn column = null; if (rowIndex >= sfgrid.StackedHeaderRows.Count) { return(null); } header = sfgrid.StackedHeaderRows[rowIndex]; while (true) { column = header.StackedColumns.FirstOrDefault(child => child.HeaderText == columnName); if (column == null) { column = sfgrid.GetStackedColumn(columnName, rowIndex + 1); } return(column); } }
public void HeaderGrid() { StackedHeaderRow stackedHeaderRow = new StackedHeaderRow(); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "PuntoVentaNombre,ViviendaCodigo,HabitacionCodigo,cnt_camas,CamaCodigo", HeaderText = "informacion", }); foreach (var item in columnas) { string campos = item.ColmFec; string mes = item.NameMonth; stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = campos, HeaderText = mes.Trim(), }); } dataGridOcupacion.StackedHeaderRows.Add(stackedHeaderRow); }
public Form1() { InitializeComponent(); this.sfDataGrid2.Columns.Add(new GridNumericColumn() { MappingName = "SupplierID", HeaderText = "Supplier ID", NumberFormatInfo = new System.Globalization.NumberFormatInfo() { NumberDecimalDigits = 0, NumberGroupSeparator = "" } }); this.sfDataGrid2.Columns.Add(new GridNumericColumn() { MappingName = "ProductID", HeaderText = "Product ID", NumberFormatInfo = new System.Globalization.NumberFormatInfo() { NumberDecimalDigits = 0, NumberGroupSeparator = "" } }); this.sfDataGrid2.Columns.Add(new GridTextColumn() { MappingName = "ProductName", HeaderText = "Product Name" }); this.sfDataGrid2.Columns.Add(new GridTextColumn() { MappingName = "QuantityPerUnit", HeaderText = "Quantity Per Unit" }); this.sfDataGrid2.Columns.Add(new GridNumericColumn() { MappingName = "UnitPrice", HeaderText = "Unit Price ", FormatMode = Syncfusion.WinForms.Input.Enums.FormatMode.Currency }); this.sfDataGrid2.Columns.Add(new GridNumericColumn() { MappingName = "UnitsInStock", HeaderText = "Units In Stock", NumberFormatInfo = new System.Globalization.NumberFormatInfo() { NumberDecimalDigits = 0, } }); ProductInfo = this.GetProductInfo(); this.sfDataGrid2.DataSource = ProductInfo; ///Table Summaries sfDataGrid2.TableSummaryRows.Add(new GridTableSummaryRow() { ShowSummaryInRow = true, Title = "TotalPrice: {UnitPrice}", SummaryColumns = new ObservableCollection <ISummaryColumn>() { new GridSummaryColumn() { Name = "UnitPrice", MappingName = "UnitPrice", Format = "{Sum:c}", SummaryType = SummaryType.DoubleAggregate }, } }); //Stacked header StackedHeaderRow stackedHeaderRow = new StackedHeaderRow(); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { ChildColumns = "ProductID,ProductName,QuantityPerUnit,UnitPrice", HeaderText = "Product Details" }); sfDataGrid2.StackedHeaderRows.Add(stackedHeaderRow); }
/// <summary> /// Sets the sample customization settings. /// </summary> private void SampleCustomization() { this.sfDataGrid1.AllowGrouping = true; this.sfDataGrid1.ShowGroupDropArea = true; this.sfDataGrid1.AutoGenerateColumns = false; this.sfDataGrid1.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill; NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalDigits = 0; nfi.NumberGroupSizes = new int[] { }; OrderInfoRepository orderInfo = new OrderInfoRepository(); this.sfDataGrid1.DataSource = orderInfo.GetOrdersDetails(30); this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi }); 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", CheckBoxSize = new Size(14, 14) }); #region Relation Creation GridViewDefinition viewDefinition = new GridViewDefinition(); viewDefinition.RelationalColumn = "OrderDetails"; SfDataGrid firstLevelSourceDataGrid = new SfDataGrid(); firstLevelSourceDataGrid.RowHeight = 21; firstLevelSourceDataGrid.Columns.Add(new GridNumericColumn() { MappingName = "OrderID", HeaderText = "Order ID", NumberFormatInfo = nfi }); 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, NumberFormatInfo = nfi }); 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.StackedHeaderRows.Add(stackedHeaderRow); firstLevelSourceDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill; viewDefinition.DataGrid = firstLevelSourceDataGrid; this.sfDataGrid1.DetailsViewDefinitions.Add(viewDefinition); #endregion this.sfDataGrid1.HideEmptyGridViewDefinition = true; }
/// <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 LoadGrids() { //TODO: change this SetWaitingMsg with events raised by globals functions SetWaitingMsg("A carregar ficheiro"); var audit = Globals.AuditFile; SetWaitingMsg("A carregar as linhas das faturas..."); var invoiceLines = Globals.LoadInvoiceLines(); SetWaitingMsg("A carregar impostos das faturas..."); var totals = Globals.LoadTaxEntryTotals(invoiceLines); SetWaitingMsg("A carregar faturas..."); var invoices = Globals.LoadInvoiceEntries(); SetWaitingMsg("A carregar clientes..."); var customers = Globals.LoadCustomerEntries(); SetWaitingMsg("A carregar produtos..."); var products = Globals.LoadProductEntries(); SetWaitingMsg("A carregar impostos..."); var tax = Globals.LoadTaxEntries(); SetWaitingMsg("A carregar plano de contas..."); var accounts = Globals.LoadAccountEntries(); SetWaitingMsg("A carregar outras transações..."); var trans = Globals.LoadTransactionEntries(); // set grid datasources SetWaitingMsg("A preparar listas..."); gridLines.DataSource = invoiceLines; gridTotals.DataSource = totals; gridDocuments.DataSource = invoices; gridCustomers.DataSource = customers; gridProducts.DataSource = products; gridTax.DataSource = tax; gridAccounts.DataSource = accounts; gridTransactions.DataSource = trans; // set grid summaries SetWaitingMsg("A preparar resumos..."); SetGridTotalsSummaries(); SetGridLinesGroupColumnSummaries(); SetGridLinesSummaries(); SetGridDocumentsTableSummaries(); SetGridCustomerTableSummaries(); SetGridProductTableSummaries(); SetGridTaxTableSummaries(); SetGridAccountsTableSummaries(); SetGridTransactionsTableSummaries(); // format gridTotals SetWaitingMsg("A acabar apresentação dos dados..."); gridTotals.Columns["TaxCode"].CellStyle.Font.Bold = true; gridTotals.Columns["TotalCredit"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTotals.Columns["TotalCredit"].CellStyle.Font.Bold = true; gridTotals.Columns["TotalDebit"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTotals.Columns["TotalDebit"].CellStyle.Font.Bold = true; // stacked headers var stackedHeaderRow1 = new StackedHeaderRow(); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "TaxCode,TaxDescription,TaxPercentage", HeaderText = "Tipo de Imposto" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "DebitAmount,DebitTaxPayable,TotalDebit", HeaderText = "Débito" }); stackedHeaderRow1.StackedColumns.Add(new StackedColumn() { ChildColumns = "CreditAmount,CreditTaxPayable,TotalCredit", HeaderText = "Crédito" }); gridTotals.StackedHeaderRows.Add(stackedHeaderRow1); // format gridLines gridLines.Columns["TaxCode"].CellStyle.Font.Bold = true; gridLines.Columns["InvoiceNo"].CellStyle.Font.Bold = true; gridLines.Columns["CreditTaxPayable"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.DarkColumnColor); gridLines.Columns["CreditTaxPayable"].CellStyle.Font.Bold = true; gridLines.Columns["DebitTaxPayable"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.DarkColumnColor); gridLines.Columns["DebitTaxPayable"].CellStyle.Font.Bold = true; gridLines.Columns["CreditAmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridLines.Columns["CreditAmount"].CellStyle.Font.Bold = true; gridLines.Columns["DebitAmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridLines.Columns["DebitAmount"].CellStyle.Font.Bold = true; gridLines.Columns["ProductCode"].Width = 70; gridLines.Columns["LineNumber"].Width = 50; gridLines.Columns["InvoiceType"].Width = 50; gridLines.Columns["InvoiceStatus"].Width = 50; gridLines.Columns["TaxCode"].Width = 50; gridLines.Columns["TaxPercentage"].Width = 50; gridLines.Columns["Quantity"].Width = 50; // format gridDocuments gridDocuments.Columns["InvoiceNo"].CellStyle.Font.Bold = true; gridDocuments.Columns["NetTotal"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.DarkColumnColor); gridDocuments.Columns["NetTotal"].CellStyle.Font.Bold = true; gridDocuments.Columns["TaxPayable"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridDocuments.Columns["TaxPayable"].CellStyle.Font.Bold = true; gridDocuments.Columns["GrossTotal"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.DarkColumnColor); gridDocuments.Columns["GrossTotal"].CellStyle.Font.Bold = true; // format gridCustomers gridCustomers.Columns["CustomerID"].CellStyle.Font.Bold = true; gridCustomers.Columns["CompanyName"].CellStyle.Font.Bold = true; gridCustomers.Columns["TotalCreditAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridCustomers.Columns["TotalCreditAmmount"].CellStyle.Font.Bold = true; gridCustomers.Columns["TotalDebitAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridCustomers.Columns["TotalDebitAmmount"].CellStyle.Font.Bold = true; // format gridProducts gridProducts.Columns["ProductCode"].CellStyle.Font.Bold = true; gridProducts.Columns["TotalCreditAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridProducts.Columns["TotalCreditAmmount"].CellStyle.Font.Bold = true; gridProducts.Columns["TotalDebitAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridProducts.Columns["TotalDebitAmmount"].CellStyle.Font.Bold = true; // format gridTax gridTax.Columns["TaxCode"].CellStyle.Font.Bold = true; gridTax.Columns["TotalCreditAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTax.Columns["TotalCreditAmmount"].CellStyle.Font.Bold = true; gridTax.Columns["TotalDebitAmmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTax.Columns["TotalDebitAmmount"].CellStyle.Font.Bold = true; // format gridAccounts gridAccounts.Columns["AccountID"].CellStyle.Font.Bold = true; // format gridTransactions gridTransactions.Columns["TransactionID"].CellStyle.Font.Bold = true; gridTransactions.Columns["CreditAmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTransactions.Columns["CreditAmount"].CellStyle.Font.Bold = true; gridTransactions.Columns["DebitAmount"].CellStyle.BackColor = ColorTranslator.FromHtml(Globals.LightColumnColor); gridTransactions.Columns["DebitAmount"].CellStyle.Font.Bold = true; SetWaitingMsg("Pronto!"); }
/// <summary> /// Gets the common Column in the same StackedHeaderRow /// </summary> /// <param name="childColumns"></param> /// <param name="header"></param> /// <param name="column"></param> /// <returns></returns> /// <remarks></remarks> public static List <int> IntersectedChildColumn(this SfDataGrid sfGrid, List <int> childColumns, StackedHeaderRow header, StackedColumn column) { var intersectedIndex = new List <int>(); foreach (var item in header.StackedColumns) { if (item == column) { return(intersectedIndex); } if (item.ChildColumnsIndex != null) { intersectedIndex = intersectedIndex.Union(childColumns.Intersect(item.ChildColumnsIndex)).ToList(); } } return(intersectedIndex); }
/// <summary> /// Gets the childColumns for the given StackedColumn /// </summary> /// <param name="childColumns"></param> /// <param name="header"></param> /// <param name="column"></param> /// <returns></returns> /// <remarks></remarks> public static List <int> CheckChildSequence(this SfDataGrid sfgrid, List <int> childColumns, StackedHeaderRow header, StackedColumn column) { foreach (var col in header.StackedColumns) { var childs = col.ChildColumns.Split(','); childs.ForEach(child => { if (child.Equals(column.HeaderText)) { childColumns = col.ChildColumnsIndex; } }); } return(childColumns); }
private void InitializeDataGrid(SfDataGrid masterDataGrid, SfDataGrid detailDataGrid) { Appearances.DataGrid(masterDataGrid); Appearances.DataGrid(detailDataGrid); var numberFormat = new NumberFormatInfo(); numberFormat.NumberDecimalDigits = 0; numberFormat.NumberGroupSizes = new int[] { 3 }; var numberFormat2 = new NumberFormatInfo(); numberFormat2.NumberDecimalDigits = 2; numberFormat2.NumberGroupSizes = new int[] { 3 }; masterDataGrid.AutoGenerateColumns = false; masterDataGrid.Columns.Add(new GridTextColumn() { HeaderText = "진단구역", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Zone) }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "평균표고(m)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.InputAvgPressure), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "평균수압(m)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.AvgPressure), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "유입유량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.InFlow), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "사용량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Usage), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "무수수량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.AnhydrouAmount), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "배수관", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Col6), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "급수시설", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Col7), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "옥내", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Col8), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "배경누수량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Col9), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "파열누수량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.RuptureLeakage), NumberFormatInfo = numberFormat2 }); masterDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "누수량(m³/일)", AutoSizeColumnsMode = AutoSizeColumnsMode.ColumnHeader, MappingName = nameof(PipeGroup.Leakage), NumberFormatInfo = numberFormat2 }); var stackedHeaderRow = new StackedHeaderRow(); stackedHeaderRow.StackedColumns.Add(new StackedColumn() { HeaderText = "배경누수량(m³/일)", ChildColumns = $"{nameof(PipeGroup.Col6)},{nameof(PipeGroup.Col7)},{nameof(PipeGroup.Col8)}", }); masterDataGrid.StackedHeaderRows.Add(stackedHeaderRow); detailDataGrid.AutoGenerateColumns = false; _pipeTypeComboBoxColumn = new GridComboBoxColumn() { HeaderText = "관재질", MappingName = nameof(Pipe.PP_TYPE) }; detailDataGrid.Columns.Add(new GridTextColumn() { HeaderText = "관로ID", MappingName = nameof(Pipe.ID) }); detailDataGrid.Columns.Add(new GridTextColumn() { HeaderText = "관리번호", MappingName = nameof(Pipe.MGR_ID) }); detailDataGrid.Columns.Add(_pipeTypeComboBoxColumn); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "관경", MappingName = nameof(Pipe.PP_CIR), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "관로길이", MappingName = nameof(Pipe.PP_LEN), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "매설년수", MappingName = nameof(Pipe.NYEAR), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "급수관연장", MappingName = nameof(Pipe.Col1), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "급수전수", MappingName = nameof(Pipe.Col2), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "배경누수량", MappingName = nameof(Pipe.LEAK_BASE), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "파열누수량", MappingName = nameof(Pipe.LEAK_BREAK), NumberFormatInfo = numberFormat2 }); detailDataGrid.Columns.Add(new GridNumericColumn() { HeaderText = "누수량", MappingName = nameof(Pipe.LEAK_SUM), NumberFormatInfo = numberFormat2 }); var detailsView = new GridViewDefinition(); detailsView.RelationalColumn = nameof(PipeGroup.Pipes); detailsView.DataGrid = detailDataGrid; masterDataGrid.DetailsViewDefinitions.Add(detailsView); //dataGrid.SelectionChanged += OnPatternMasterDataGridSelectionChanged; }
} // end method InitialiseTab /// <summary> /// Prepare day volume data to show. /// </summary> /// <returns>A <see cref="StackedHeaderRow"/> object representing a stacked header row containing a collection of stacked columns.</returns> private StackedHeaderRow PrepareDayVolume() { var stackedHeaderRowDayVolumeChildColumns = new StringBuilder(); // Use StringBuilder here to improve string concatenating performance because of the potentially large number of strings. for (var dayVolumeColumnCount = 0; dayVolumeColumnCount < _strikePriceVolumeRowCollection[0].Length - 2; dayVolumeColumnCount++) { var dayVolumeColumnDate = _strikePriceVolumeDataProcessor.StartDate.AddDays(dayVolumeColumnCount); var dayVolumeColumnMappingName = dayVolumeColumnCount.ToString(); var dayVolumeColumnWeekday = dayVolumeColumnDate.DayOfWeek switch { DayOfWeek.Monday => Properties.Resources.Mon, DayOfWeek.Tuesday => Properties.Resources.Tue, DayOfWeek.Wednesday => Properties.Resources.Wed, DayOfWeek.Thursday => Properties.Resources.Thu, DayOfWeek.Friday => Properties.Resources.Fri, DayOfWeek.Saturday => Properties.Resources.Sat, DayOfWeek.Sunday => Properties.Resources.Sun, _ => Properties.Resources.QuestionMark, }; stackedHeaderRowDayVolumeChildColumns.Append(dayVolumeColumnMappingName + ","); // Hide weekends' unbound columns. if (dayVolumeColumnWeekday.Equals(Properties.Resources.Sat) || dayVolumeColumnWeekday.Equals(Properties.Resources.Sun)) { DataGridStrikePriceVolumeTable.Columns.Add(new GridUnBoundColumn { MappingName = dayVolumeColumnMappingName, MaximumWidth = 0, MinimumWidth = 0, Width = 0 }); continue; } // end if DataGridStrikePriceVolumeTable.Columns.Add(new GridUnBoundColumn { AllowFiltering = Properties.Settings.Default.DayVolumeFiltering, AllowSorting = Properties.Settings.Default.DayVolumeSorting, HeaderText = dayVolumeColumnDate.ToString(Properties.Settings.Default.DateDisplayFormat + "\n" + Properties.Resources.LeftBracket + dayVolumeColumnWeekday + Properties.Resources.RightBracket), MappingName = dayVolumeColumnMappingName, MaximumWidth = Properties.Settings.Default.MaxCellWidth, MinimumWidth = Properties.Settings.Default.MinCellWidth, ShowHeaderToolTip = true, TextAlignment = TextAlignment.Right }); } // end for var stackedHeaderRowDayVolume = new StackedHeaderRow(); stackedHeaderRowDayVolume.StackedColumns.Add(new StackedColumn { ChildColumns = stackedHeaderRowDayVolumeChildColumns.ToString(), HeaderText = Properties.Resources.DayVolume + Properties.Resources.LeftBracket + _volumeUnitViewModel.VolumeUnitRecords.First(item => item.Coefficient == Properties.Settings.Default.DayVolumeUnit).Name + Properties.Resources.RightBracket, MappingName = "DayVolume" }); return stackedHeaderRowDayVolume; } // end method PrepareDayVolume