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
