public Form1()
{
InitializeComponent();
sfDataGrid = new SfDataGrid();
order = new OrderInfoCollection();
sfDataGrid.Dock = DockStyle.Fill;
this.Controls.Add(sfDataGrid);
sfDataGrid.ShowGroupDropArea = true;
sfDataGrid.AllowGrouping = true;
sfDataGrid.DataSource = order.Orders;
GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow();
tableSummaryRow1.Name = "TableSummary";
tableSummaryRow1.ShowSummaryInRow = false;
tableSummaryRow1.Position = VerticalPosition.Bottom;
GridSummaryColumn summaryColumn1 = new GridSummaryColumn();
summaryColumn1.Name = "PriceAmount";
summaryColumn1.Format = "{Sum:c}";
summaryColumn1.MappingName = "UnitPrice";
summaryColumn1.SummaryType = SummaryType.DoubleAggregate;
tableSummaryRow1.SummaryColumns.Add(summaryColumn1);
this.sfDataGrid.TableSummaryRows.Add(tableSummaryRow1);
this.sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowSummaryUpdate;
this.sfDataGrid.CellRenderers.Remove("Numeric");
this.sfDataGrid.CellRenderers.Add("Numeric", new GridNumericCellRendererExt(this.sfDataGrid));
}
public Form1()
{
InitializeComponent();
var data = new OrderInfoCollection();
sfDataGrid.DataSource = data.OrdersListDetails;
GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow();
tableSummaryRow1.Name = "TableSummary";
tableSummaryRow1.ShowSummaryInRow = false;
tableSummaryRow1.Title = " Total Product Count: {OrderID}";
tableSummaryRow1.Position = VerticalPosition.Bottom;
GridSummaryColumn summaryColumn1 = new GridSummaryColumn();
summaryColumn1.Name = "OrderID";
summaryColumn1.SummaryType = SummaryType.CountAggregate;
summaryColumn1.Format = "{Count}";
summaryColumn1.MappingName = "OrderID";
GridSummaryColumn summaryColumn2 = new GridSummaryColumn();
summaryColumn2.Name = "Quantity";
summaryColumn2.SummaryType = SummaryType.Int32Aggregate;
summaryColumn2.Format = "{Sum}";
summaryColumn2.MappingName = "Quantity";
tableSummaryRow1.SummaryColumns.Add(summaryColumn1);
tableSummaryRow1.SummaryColumns.Add(summaryColumn2);
this.sfDataGrid.TableSummaryRows.Add(tableSummaryRow1);
}
public override Android.Views.View GetSampleContent(Android.Content.Context context)
{
sfGrid = new SfDataGrid(context);
viewModel = new GroupingViewModel();
sfGrid.ItemsSource = viewModel.ProductDetails;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.AllowGroupExpandCollapse = true;
sfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "Product"
});
sfGrid.AutoGeneratingColumn += OnAutoGenerateColumn;
sfGrid.QueryRowHeight += SfGrid_QueryRowHeight;
sfGrid.AllowResizingColumn = true;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
sfGrid.ColumnSizer = ColumnSizer.Auto;
//TableSummary codes
GridTableSummaryRow summaryRow = new GridTableSummaryRow();
summaryRow.Title = "Total items:{Total} items";
summaryRow.ShowSummaryInRow = true;
summaryRow.Position = Position.Bottom;
GridSummaryColumn summaryColumn = new GridSummaryColumn();
summaryColumn.Name = "Total";
summaryColumn.MappingName = "OrderID";
summaryColumn.Format = "{Count}";
summaryColumn.SummaryType = Syncfusion.Data.SummaryType.CountAggregate;
summaryRow.SummaryColumns.Add(summaryColumn);
sfGrid.TableSummaryRows.Add(summaryRow);
return(sfGrid);
}
private void SetGridTransactionsTableSummaries()
{
GridTableSummaryRow sum = new GridTableSummaryRow
{
ShowSummaryInRow = false,
TitleColumnCount = 1,
Position = VerticalPosition.Bottom,
Title = "Totais"
};
GridSummaryColumn cre = new GridSummaryColumn
{
Name = "CreditAmmount",
Format = "{Sum:c}",
MappingName = "CreditAmount",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn deb = new GridSummaryColumn
{
Name = "DebitAmmount",
Format = "{Sum:c}",
MappingName = "DebitAmount",
SummaryType = SummaryType.DoubleAggregate
};
sum.SummaryColumns.Add(cre);
sum.SummaryColumns.Add(deb);
this.gridTransactions.TableSummaryRows.Add(sum);
}
public ScadenzeDetails(ScadenzeInfo info)
{
info_ = info;
InitializeComponent();
dbcon_ = DependencyService.Get <ISQLiteDb>().GetConnection();
Title = info.CliDesc;
GridTableSummaryRow summaryRow1 = new GridTableSummaryRow();
summaryRow1.Title = "Totale {Totale} - Num. : {ScaCount}";
summaryRow1.ShowSummaryInRow = true;
summaryRow1.Position = Position.Bottom;
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Totale",
MappingName = "sca_importo",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "ScaCount",
MappingName = "sca_num",
Format = "{Count:#,#}",
SummaryType = SummaryType.CountAggregate
});
dataGrid.TableSummaryRows.Add(summaryRow1);
}
public Incassi(Clienti cli, Destinazioni dst)
{
_dbcon = DependencyService.Get <ISQLiteDb>().GetConnection();
_cli = cli;
_dst = dst;
_on_edit = false;
InitializeComponent();
if (Device.Idiom != TargetIdiom.Phone)
{
m_cli_cod.WidthRequest = 110;
m_dst_cod.WidthRequest = 110;
}
m_cli_cod.Text = _cli != null?_cli.cli_codice.ToString() : "";
m_cli_des.Text = _cli != null ? _cli.cli_desc : "";
m_dst_cod.Text = _dst != null?_dst.dst_codice.ToString() : "";
m_dst_des.Text = _dst != null ? _dst.dst_desc : "";
GridTableSummaryRow summaryRow1 = new GridTableSummaryRow();
summaryRow1.Title = "Totale da Incassare {Totale} - Incasso : {Incasso}";
summaryRow1.ShowSummaryInRow = true;
summaryRow1.Position = Position.Bottom;
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Totale",
MappingName = "sca_importo",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Incasso",
MappingName = "sca_incasso",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
dataGrid.TableSummaryRows.Add(summaryRow1);
dataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowSummaryUpdate;
/*
* dataGrid.AllowEditing = true;
* GridNumericColumn column = new GridNumericColumn();
* column.MappingName = "Incasso";
* column.AllowEditing = true;
* dataGrid.EditTapAction = TapAction.OnTap;
*/
_cli_changed = false;
_dst_changed = false;
}
public Grouping()
{
this.SfGrid = new SfDataGrid();
this.SfGrid.SelectionMode = SelectionMode.Single;
this.SfGrid.ItemsSource = new GroupingViewModel().ProductDetails;
this.SfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
this.SfGrid.HeaderRowHeight = 45;
this.SfGrid.RowHeight = 45;
this.SfGrid.AllowGroupExpandCollapse = true;
this.SfGrid.AllowResizingColumn = true;
// Multi-Grouping
this.SfGrid.GroupingMode = GroupingMode.Multiple;
this.SfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "Product"
});
this.SfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "ProductModel"
});
// GroupSummary codes
GridGroupSummaryRow groupSummaryRow = new GridGroupSummaryRow();
groupSummaryRow.Title = "Total items:{Total} items";
groupSummaryRow.ShowSummaryInRow = true;
GridSummaryColumn groupSummaryColumn = new GridSummaryColumn();
groupSummaryColumn.Name = "Total";
groupSummaryColumn.MappingName = "Product";
groupSummaryColumn.Format = "{Count}";
groupSummaryColumn.SummaryType = Syncfusion.Data.SummaryType.CountAggregate;
groupSummaryRow.SummaryColumns.Add(groupSummaryColumn);
SfGrid.GroupSummaryRows.Add(groupSummaryRow);
//TableSummary codes
GridTableSummaryRow summaryRow = new GridTableSummaryRow();
summaryRow.Title = "Total items:{Total} items";
summaryRow.ShowSummaryInRow = true;
summaryRow.Position = Position.Bottom;
GridSummaryColumn summaryColumn = new GridSummaryColumn();
summaryColumn.Name = "Total";
summaryColumn.MappingName = "ProductID";
summaryColumn.Format = "{Count}";
summaryColumn.SummaryType = Syncfusion.Data.SummaryType.CountAggregate;
summaryRow.SummaryColumns.Add(summaryColumn);
this.SfGrid.TableSummaryRows.Add(summaryRow);
this.AddSubview(SfGrid);
}
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 void SetGridLinesSummaries()
{
GridTableSummaryRow sum = new GridTableSummaryRow
{
ShowSummaryInRow = false,
TitleColumnCount = 1,
Position = VerticalPosition.Bottom,
Title = "Totais"
};
GridSummaryColumn ca = new GridSummaryColumn
{
Name = "CreditAmount",
Format = "{Sum:c}",
MappingName = "CreditAmount",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn da = new GridSummaryColumn
{
Name = "DebitAmount",
Format = "{Sum:c}",
MappingName = "DebitAmount",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn ctp = new GridSummaryColumn
{
Name = "CreditTaxPayable",
Format = "{Sum:c}",
MappingName = "CreditTaxPayable",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn dtp = new GridSummaryColumn
{
Name = "DebitTaxPayable",
Format = "{Sum:c}",
MappingName = "DebitTaxPayable",
SummaryType = SummaryType.DoubleAggregate
};
sum.SummaryColumns.Add(ca);
sum.SummaryColumns.Add(da);
sum.SummaryColumns.Add(ctp);
sum.SummaryColumns.Add(dtp);
this.gridLines.TableSummaryRows.Add(sum);
}
private void SetGridAccountsTableSummaries()
{
GridTableSummaryRow sum = new GridTableSummaryRow
{
ShowSummaryInRow = false,
TitleColumnCount = 1,
Position = VerticalPosition.Bottom,
Title = "Totais"
};
GridSummaryColumn odb = new GridSummaryColumn
{
Name = "OpeningDebitBalance",
Format = "{Sum:c}",
MappingName = "OpeningDebitBalance",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn ocb = new GridSummaryColumn
{
Name = "OpeningCreditBalance",
Format = "{Sum:c}",
MappingName = "OpeningCreditBalance",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn cdb = new GridSummaryColumn
{
Name = "ClosingDebitBalance",
Format = "{Sum:c}",
MappingName = "ClosingDebitBalance",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn ccb = new GridSummaryColumn
{
Name = "ClosingCreditBalance",
Format = "{Sum:c}",
MappingName = "ClosingCreditBalance",
SummaryType = SummaryType.DoubleAggregate
};
sum.SummaryColumns.Add(odb);
sum.SummaryColumns.Add(ocb);
sum.SummaryColumns.Add(cdb);
sum.SummaryColumns.Add(ccb);
this.gridAccounts.TableSummaryRows.Add(sum);
}
public IncassiGrid()
{
InitializeComponent();
dbcon_ = DependencyService.Get <ISQLiteDb>().GetConnection();
busyIndicator.IsBusy = true;
leftImage = null;
swipeDsp = null;
swipeIndex = 0;
//
// Inserire Massimo e minimo per le date dopo aver impostato l'anno nelle impostazioni ditta
//
dStart.Date = new DateTime(2016, 1, 1); // DateTime.Now;
dStop.Date = DateTime.Now;
query_ = "SELECT dsp_codice, dsp_clifor, dsp_data, dsp_totale, cli_desc " +
"FROM scapaghe " +
"LEFT JOIN clienti1 ON cli_codice = dsp_clifor";
dataGrid.ColumnSizer = Syncfusion.SfDataGrid.XForms.ColumnSizer.LastColumnFill;
dataGrid.GridLongPressed += DataGrid_GridLongPressed;
GridTableSummaryRow summaryRow1 = new GridTableSummaryRow();
summaryRow1.Title = "Totale {Totale} - Numero Doc. : {DocCount}";
summaryRow1.ShowSummaryInRow = true;
summaryRow1.Position = Position.Bottom;
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Totale",
MappingName = "dsp_totale",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "DocCount",
MappingName = "dsp_totale",
Format = "{Count:#,#}",
SummaryType = SummaryType.CountAggregate
});
dataGrid.TableSummaryRows.Add(summaryRow1);
}
public void SetupSummary()
{
GridTableSummaryRow tableSummaryRow1 = new GridTableSummaryRow();
tableSummaryRow1.Name = "TableSummary";
tableSummaryRow1.ShowSummaryInRow = false;
tableSummaryRow1.Position = VerticalPosition.Bottom;
GridSummaryColumn summaryColumn1 = new GridSummaryColumn();
summaryColumn1.Name = "Tool.Price";
summaryColumn1.SummaryType = SummaryType.DoubleAggregate;
summaryColumn1.Format = "Total Cost: {Sum:c}";
summaryColumn1.MappingName = "Tool.Price";
tableSummaryRow1.SummaryColumns.Add(summaryColumn1);
this.sfDataGrid1.TableSummaryRows.Add(tableSummaryRow1);
}
private void SetGridDocumentsTableSummaries()
{
GridTableSummaryRow sum = new GridTableSummaryRow
{
ShowSummaryInRow = false,
TitleColumnCount = 1,
Position = VerticalPosition.Bottom,
Title = "Totais"
};
GridSummaryColumn tp = new GridSummaryColumn
{
Name = "TaxPayable",
Format = "{Sum:c}",
MappingName = "TaxPayable",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn nt = new GridSummaryColumn
{
Name = "NetTotal",
Format = "{Sum:c}",
MappingName = "NetTotal",
SummaryType = SummaryType.DoubleAggregate
};
GridSummaryColumn gt = new GridSummaryColumn
{
Name = "GrossTotal",
Format = "{Sum:c}",
MappingName = "GrossTotal",
SummaryType = SummaryType.DoubleAggregate
};
sum.SummaryColumns.Add(tp);
sum.SummaryColumns.Add(nt);
sum.SummaryColumns.Add(gt);
this.gridDocuments.TableSummaryRows.Add(sum);
}
private static void OnDynamicSummaryColumnsChanged(DependencyObject d, DependencyPropertyChangedEventArgs args)
{
SfDataGrid grid = d as SfDataGrid;
if (grid.TableSummaryRows.Count() > 1)
{
grid.TableSummaryRows.Clear();
}
GridTableSummaryRow gsr = new GridTableSummaryRow();
gsr.ShowSummaryInRow = false;
var list = ((List <GridSummaryColumn>)args.NewValue);
foreach (var item in list)
{
gsr.SummaryColumns.Add(item);
}
grid.TableSummaryRows.Add(gsr);
}
public CustomGrouping()
{
sfGrid = new SfDataGrid();
this.sfGrid.SelectionMode = SelectionMode.Single;
viewModel = new SalesInfoViewModel();
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.DailySalesDetails;
sfGrid.AllowSorting = true;
this.sfGrid.HeaderRowHeight = 45;
this.sfGrid.RowHeight = 45;
this.sfGrid.AllowGroupExpandCollapse = true;
sfGrid.SortComparers.Add(new SortComparer()
{
Comparer = new CustomSortComparer(), PropertyName = "Total"
});
sfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "Total", Converter = new GroupDataTimeConverter()
});
//TableSummary codes
GridTableSummaryRow summaryRow = new GridTableSummaryRow();
summaryRow.Title = "Total items:{Total} items";
summaryRow.ShowSummaryInRow = true;
summaryRow.Position = Position.Bottom;
GridSummaryColumn summaryColumn = new GridSummaryColumn();
summaryColumn.Name = "Total";
summaryColumn.MappingName = "Name";
summaryColumn.Format = "{Count}";
summaryColumn.SummaryType = Syncfusion.Data.SummaryType.CountAggregate;
summaryRow.SummaryColumns.Add(summaryColumn);
sfGrid.TableSummaryRows.Add(summaryRow);
this.AddSubview(sfGrid);
}
public ScadenzeElenco()
{
InitializeComponent();
swipeIndex_ = 0;
swipeData_ = null;
leftImage = null;
first = true;
dbcon_ = DependencyService.Get <ISQLiteDb>().GetConnection();
dataGrid.ColumnSizer = Syncfusion.SfDataGrid.XForms.ColumnSizer.LastColumnFill;
dataGrid.GridLongPressed += DataGrid_GridLongPressed;
GridTableSummaryRow summaryRow1 = new GridTableSummaryRow();
summaryRow1.Title = "Totale {Totale} - Numero Cli. : {CliCount}";
summaryRow1.ShowSummaryInRow = true;
summaryRow1.Position = Position.Bottom;
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Totale",
MappingName = "CliTotale",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "CliCount",
MappingName = "CliDesc",
Format = "{Count:#,#}",
SummaryType = SummaryType.CountAggregate
});
dataGrid.TableSummaryRows.Add(summaryRow1);
if (Device.Idiom == TargetIdiom.Phone && Device.RuntimePlatform == Device.Android)
{
searchBar.HeightRequest = 40;
}
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid(context);
viewModel = new SalesInfoViewModel();
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.AutoGeneratingColumn += GridAutoGenerateColumns;
sfGrid.ItemsSource = viewModel.DailySalesDetails;
sfGrid.AllowSorting = true;
sfGrid.AllowGroupExpandCollapse = true;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
sfGrid.SortComparers.Add(new SortComparer()
{
Comparer = new CustomSortComparer(), PropertyName = "Total"
});
sfGrid.GroupColumnDescriptions.Add(new GroupColumnDescription()
{
ColumnName = "Total", Converter = new GroupDataTimeConverter()
});
//TableSummary codes
GridTableSummaryRow summaryRow = new GridTableSummaryRow();
summaryRow.Title = "Total items:{Total} items";
summaryRow.ShowSummaryInRow = true;
summaryRow.Position = Position.Bottom;
GridSummaryColumn summaryColumn = new GridSummaryColumn();
summaryColumn.Name = "Total";
summaryColumn.MappingName = "Name";
summaryColumn.Format = "{Count}";
summaryColumn.SummaryType = Syncfusion.Data.SummaryType.CountAggregate;
summaryRow.SummaryColumns.Add(summaryColumn);
sfGrid.TableSummaryRows.Add(summaryRow);
return(sfGrid);
}
/// <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;
}
public DocumentiGrid(DocTipo t_doc)
{
InitializeComponent();
tipo_ = t_doc;
cliCodice_ = 0;
dbcon_ = DependencyService.Get <ISQLiteDb>().GetConnection();
busyIndicator.IsBusy = true;
leftImage = null;
swipeDoc = null;
swipeIndex = 0;
switch (tipo_)
{
case DocTipo.TIPO_DDT:
Title = "Documenti di Trasporto";
break;
case DocTipo.TIPO_FAT:
Title = "Fatture";
break;
case DocTipo.TIPO_PRE:
Title = "Preventivi";
break;
case DocTipo.TIPO_ORD:
Title = "Ordini";
break;
default:
Title = "*** Documento Sconosciuto ***";
break;
}
//
// Inserire Massimo e minimo per le date dopo aver impostato l'anno nelle impostazioni ditta
//
dStart.Date = new DateTime(2016, 1, 1); // DateTime.Now;
dStop.Date = DateTime.Now;
query_ = "SELECT fat_tipo, fat_n_doc, fat_d_doc, fat_tot_fattura, fat_registro, cli_desc " +
"FROM fatture2 " +
"LEFT JOIN clienti1 on fat_inte = cli_codice";
filter_ = String.Format(" WHERE fat_tipo = {0}", (int)tipo_);
dataGrid.ColumnSizer = Syncfusion.SfDataGrid.XForms.ColumnSizer.LastColumnFill;
dataGrid.GridLongPressed += DataGrid_GridLongPressed;
GridTableSummaryRow summaryRow1 = new GridTableSummaryRow();
summaryRow1.Title = "Totale {Totale} - Numero Doc. : {DocCount}";
summaryRow1.ShowSummaryInRow = true;
summaryRow1.Position = Position.Bottom;
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "Totale",
MappingName = "fat_tot_fattura",
Format = "{Sum:c}",
SummaryType = SummaryType.DoubleAggregate
});
summaryRow1.SummaryColumns.Add(new GridSummaryColumn()
{
Name = "DocCount",
MappingName = "fat_tot_fattura",
Format = "{Count:#,#}",
SummaryType = SummaryType.CountAggregate
});
dataGrid.TableSummaryRows.Add(summaryRow1);
}
