/// <summary>
/// Add column values to Grid
/// </summary>
/// <param name="enumDataList">enumerable collection</param>
public SfDataGrid AddColumnToGrid(IEnumerable <BusinessObject> enumDataList, SfDataGrid sfDataGrid, Table inputTable)
{
int index = 0;
sfDataGrid.Columns.Clear();
var firstRow = (BusinessObject)enumDataList.FirstOrDefault();
if (firstRow != null)
{
foreach (KeyValuePair <string, object> item in firstRow.DictValueProperty)
{
var cellValue = item.Value.ToString();
double result = 0.0;
// Aligns columns with numeric values on "right" and text variables on "left"
if (double.TryParse(cellValue, out result))
{
var column = new Syncfusion.UI.Xaml.Grid.GridNumericColumn();
column.HeaderText = item.Key;
column.TextAlignment = TextAlignment.Right;
column.MappingName = "DictValueProperty[" + item.Key.ToString() + "]";
if (index >= inputTable.ColumnNames.Length)
{
// Applies style "predictedColumnColor" for predicted result columns
if (PredictedColumnStyle != null)
{
column.CellStyle = PredictedColumnStyle;
}
}
sfDataGrid.Columns.Add(column);
}
else
{
var textColumn = new Syncfusion.UI.Xaml.Grid.GridTextColumn();
textColumn.HeaderText = item.Key;
textColumn.MappingName = "DictValueProperty[" + item.Key.ToString() + "]";
if (index >= inputTable.ColumnNames.Length)
{
// Applies style "predictedColumnColor" for predicted result columns
if (PredictedColumnStyle != null)
{
textColumn.CellStyle = PredictedColumnStyle;
}
}
sfDataGrid.Columns.Add(textColumn);
}
index++;
}
}
return(sfDataGrid);
}
void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
{
switch (connectionId)
{
case 1:
#line 53 "..\..\Panel_In_Importacion_XLS.xaml"
((System.Windows.Controls.Button)(target)).Click += new System.Windows.RoutedEventHandler(this.Button_Click);
#line default
#line hidden
return;
case 2:
this.txtFilePath = ((System.Windows.Controls.TextBox)(target));
return;
case 3:
#line 56 "..\..\Panel_In_Importacion_XLS.xaml"
((System.Windows.Controls.Button)(target)).Click += new System.Windows.RoutedEventHandler(this.Generar_Click);
#line default
#line hidden
return;
case 4:
this.dtGrid = ((Syncfusion.UI.Xaml.Grid.SfDataGrid)(target));
#line 59 "..\..\Panel_In_Importacion_XLS.xaml"
this.dtGrid.CurrentCellValidated += new Syncfusion.UI.Xaml.Grid.CurrentCellValidatedEventHandler(this.dtGrid_CurrentCellValidated);
#line default
#line hidden
#line 59 "..\..\Panel_In_Importacion_XLS.xaml"
this.dtGrid.CurrentCellEndEdit += new Syncfusion.UI.Xaml.Grid.CurrentCellEndEditEventHandler(this.dtGrid_CurrentCellEndEdit);
#line default
#line hidden
#line 59 "..\..\Panel_In_Importacion_XLS.xaml"
this.dtGrid.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.dtGrid_PreviewKeyDown);
#line default
#line hidden
return;
case 5:
this.A1 = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 6:
this.A2 = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 7:
this.A3 = ((Syncfusion.UI.Xaml.Grid.GridNumericColumn)(target));
return;
case 8:
this.A4 = ((Syncfusion.UI.Xaml.Grid.GridCurrencyColumn)(target));
return;
case 9:
this.A5 = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 10:
this.A6 = ((Syncfusion.UI.Xaml.Grid.GridCurrencyColumn)(target));
return;
case 11:
this.A7 = ((Syncfusion.UI.Xaml.Grid.GridCurrencyColumn)(target));
return;
case 12:
this.A8 = ((Syncfusion.UI.Xaml.Grid.GridCurrencyColumn)(target));
return;
case 13:
this.TotalReg = ((System.Windows.Controls.TextBlock)(target));
return;
case 14:
this.BTNvalidar = ((System.Windows.Controls.Button)(target));
#line 89 "..\..\Panel_In_Importacion_XLS.xaml"
this.BTNvalidar.Click += new System.Windows.RoutedEventHandler(this.BTNvalidar_Click);
#line default
#line hidden
return;
case 15:
#line 90 "..\..\Panel_In_Importacion_XLS.xaml"
((System.Windows.Controls.Button)(target)).Click += new System.Windows.RoutedEventHandler(this.Cancel_Click);
#line default
#line hidden
return;
}
this._contentLoaded = true;
}
void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
{
switch (connectionId)
{
case 1:
#line 9 "..\..\PvTrasladosBodega.xaml"
((SiasoftAppExt.PvTrasladosBodega)(target)).Closing += new System.ComponentModel.CancelEventHandler(this.Window_Closing);
#line default
#line hidden
#line 9 "..\..\PvTrasladosBodega.xaml"
((SiasoftAppExt.PvTrasladosBodega)(target)).Loaded += new System.Windows.RoutedEventHandler(this.Window_Loaded);
#line default
#line hidden
return;
case 2:
this.TabControl1 = ((Syncfusion.Windows.Tools.Controls.TabControlExt)(target));
return;
case 3:
this.tabItemExt1 = ((Syncfusion.Windows.Tools.Controls.TabItemExt)(target));
return;
case 4:
#line 58 "..\..\PvTrasladosBodega.xaml"
((System.Windows.Controls.Grid)(target)).PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.Grid_PreviewKeyDown);
#line default
#line hidden
return;
case 5:
this.LabelBodegaOrigen = ((System.Windows.Controls.TextBlock)(target));
return;
case 6:
this.LabelBodegaDestino = ((System.Windows.Controls.TextBlock)(target));
return;
case 7:
this.TextFecha = ((System.Windows.Controls.TextBox)(target));
return;
case 8:
this.CmbTipoDoc = ((System.Windows.Controls.ComboBox)(target));
#line 90 "..\..\PvTrasladosBodega.xaml"
this.CmbTipoDoc.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.CmbTipoDoc_PreviewKeyDown);
#line default
#line hidden
#line 90 "..\..\PvTrasladosBodega.xaml"
this.CmbTipoDoc.SelectionChanged += new System.Windows.Controls.SelectionChangedEventHandler(this.CmbTipoDoc_SelectionChanged);
#line default
#line hidden
return;
case 9:
this.TextNumeroDoc = ((System.Windows.Controls.TextBox)(target));
return;
case 10:
this.CmbBodOrigen = ((System.Windows.Controls.ComboBox)(target));
#line 97 "..\..\PvTrasladosBodega.xaml"
this.CmbBodOrigen.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.CmbTipoDoc_PreviewKeyDown);
#line default
#line hidden
return;
case 11:
this.CmbBodDestino = ((System.Windows.Controls.ComboBox)(target));
#line 99 "..\..\PvTrasladosBodega.xaml"
this.CmbBodDestino.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.CmbTipoDoc_PreviewKeyDown);
#line default
#line hidden
#line 99 "..\..\PvTrasladosBodega.xaml"
this.CmbBodDestino.SelectionChanged += new System.Windows.Controls.SelectionChangedEventHandler(this.CmbBodDestino_SelectionChanged);
#line default
#line hidden
return;
case 12:
this.TextNota = ((System.Windows.Controls.TextBox)(target));
return;
case 13:
this.CmbTipoTraslado = ((System.Windows.Controls.ComboBox)(target));
#line 102 "..\..\PvTrasladosBodega.xaml"
this.CmbTipoTraslado.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.CmbTipoDoc_PreviewKeyDown);
#line default
#line hidden
return;
case 14:
this.TextKey = ((System.Windows.Controls.TextBlock)(target));
return;
case 15:
this.TextKey1 = ((System.Windows.Controls.TextBlock)(target));
return;
case 16:
this.TxtEmpresa = ((System.Windows.Controls.TextBlock)(target));
return;
case 17:
this.TxtPVenta = ((System.Windows.Controls.TextBlock)(target));
return;
case 18:
this.TxtBod = ((System.Windows.Controls.TextBlock)(target));
return;
case 19:
this.TxtUser = ((System.Windows.Controls.TextBlock)(target));
return;
case 20:
this.TxtCND = ((System.Windows.Controls.TextBlock)(target));
return;
case 21:
this.dataGrid = ((System.Windows.Controls.DataGrid)(target));
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.GotFocus += new System.Windows.RoutedEventHandler(this.dataGrid_GotFocus);
#line default
#line hidden
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.SelectionChanged += new System.Windows.Controls.SelectionChangedEventHandler(this.dataGrid_SelectionChanged);
#line default
#line hidden
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.CellEditEnding += new System.EventHandler <System.Windows.Controls.DataGridCellEditEndingEventArgs>(this.DataGrid_CellEditEnding);
#line default
#line hidden
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.CurrentCellChanged += new System.EventHandler <System.EventArgs>(this.DataGrid_CurrentCellChanged);
#line default
#line hidden
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.PreviewKeyDown += new System.Windows.Input.KeyEventHandler(this.dataGrid_PreviewKeyDown);
#line default
#line hidden
#line 148 "..\..\PvTrasladosBodega.xaml"
this.dataGrid.BeginningEdit += new System.EventHandler <System.Windows.Controls.DataGridBeginningEditEventArgs>(this.dataGrid_BeginningEdit);
#line default
#line hidden
return;
case 22:
this.col_cantidad = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 23:
this.ColValRef = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 24:
this.ColProDesc = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 25:
this.ColSubtotal = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 26:
this.ColValIva = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 27:
this.ColIva = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 28:
this.ColTotal = ((System.Windows.Controls.DataGridTextColumn)(target));
return;
case 29:
this.TextCantidades = ((System.Windows.Controls.TextBlock)(target));
return;
case 30:
this.TextItem = ((System.Windows.Controls.TextBlock)(target));
return;
case 31:
this.TextSaldoU = ((System.Windows.Controls.TextBlock)(target));
return;
case 32:
this.BtbGrabar = ((System.Windows.Controls.Button)(target));
#line 270 "..\..\PvTrasladosBodega.xaml"
this.BtbGrabar.Click += new System.Windows.RoutedEventHandler(this.BtbGrabar_Click);
#line default
#line hidden
return;
case 33:
this.BtbCancelar = ((System.Windows.Controls.Button)(target));
#line 271 "..\..\PvTrasladosBodega.xaml"
this.BtbCancelar.Click += new System.Windows.RoutedEventHandler(this.BtbCancelar_Click);
#line default
#line hidden
return;
case 34:
this.tabItemExt2 = ((Syncfusion.Windows.Tools.Controls.TabItemExt)(target));
return;
case 35:
this.FechaIni = ((System.Windows.Controls.DatePicker)(target));
return;
case 36:
this.FechaFin = ((System.Windows.Controls.DatePicker)(target));
return;
case 37:
this.CmbTipoCons = ((System.Windows.Controls.ComboBox)(target));
#line 304 "..\..\PvTrasladosBodega.xaml"
this.CmbTipoCons.SelectionChanged += new System.Windows.Controls.SelectionChangedEventHandler(this.CmbTipoCons_SelectionChanged);
#line default
#line hidden
return;
case 38:
this.Ejecutar = ((System.Windows.Controls.Button)(target));
#line 310 "..\..\PvTrasladosBodega.xaml"
this.Ejecutar.Click += new System.Windows.RoutedEventHandler(this.Ejecutar_Click);
#line default
#line hidden
return;
case 39:
this.ExportaXLS = ((System.Windows.Controls.Button)(target));
#line 311 "..\..\PvTrasladosBodega.xaml"
this.ExportaXLS.Click += new System.Windows.RoutedEventHandler(this.ExportaXLS_Click);
#line default
#line hidden
return;
case 40:
this.ReImprimir = ((System.Windows.Controls.Button)(target));
#line 312 "..\..\PvTrasladosBodega.xaml"
this.ReImprimir.Click += new System.Windows.RoutedEventHandler(this.ReImprimir_Click);
#line default
#line hidden
return;
case 41:
this.dataGridSF = ((Syncfusion.UI.Xaml.Grid.SfDataGrid)(target));
return;
case 42:
this.COLMval_uni = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 43:
this.COLMsubtotal = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 44:
this.COLMpor_des = ((Syncfusion.UI.Xaml.Grid.GridNumericColumn)(target));
return;
case 45:
this.COLMtot_tot = ((Syncfusion.UI.Xaml.Grid.GridTextColumn)(target));
return;
case 46:
this.TX_Total = ((System.Windows.Controls.TextBlock)(target));
return;
}
this._contentLoaded = true;
}
