public void TestMappingNameChanged()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = "Table1";
sc.Add(ts);
ResetEventData();
ts.MappingName = "Table2";
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(null, Element, "A2");
Assert.AreEqual(CollectionChangeAction.Refresh, Action, "A3");
}
public void llenaDataTable()
{
dataTable.Columns.Add("EPCArt", typeof(String));
DataGridTableStyle tableStyle = new DataGridTableStyle();
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPCArt";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 200;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
dataGrid1.DataSource = dataTable;
}
public Form1()
{
InitializeComponent();
dataTable.Columns.Add("MortgageTypeName", typeof(String));
dataTable.Columns.Add("FixedRate", typeof(Int32));
dataTable.Columns.Add("ARMRate", typeof(Int32));
DataRow dr = dataTable.NewRow();
dr["MortgageTypeName"] = "Fixed";
dr["FixedRate"] = 5;
dr["ARMRate"] = 10;
dataTable.Rows.Add(dr);
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dataTable.TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "MortgageTypeName";
columnStyle.HeaderText = "Years";
columnStyle.Width = 58;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "FixedRate";
columnStyle.HeaderText = "Fixed(%)";
columnStyle.Width = 64;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "ARMRate";
columnStyle.HeaderText = "ARM(%)";
columnStyle.Width = 64;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dgRates.TableStyles;
tableStyles.Add(tableStyle); dgRates.PreferredRowHeight = 16;
dgRates.RowHeadersVisible = false;
dgRates.DataSource = dataTable;
}
public void TestAdd()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
ResetEventData();
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = "Table1";
sc.Add(ts);
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(ts, Element, "A2");
Assert.AreEqual(CollectionChangeAction.Add, Action, "A3");
// Add multiple
ResetEventData();
sc.AddRange(new DataGridTableStyle [] { new DataGridTableStyle(), new DataGridTableStyle() });
Assert.AreEqual(true, eventhandled, "A4");
Assert.AreEqual(null, Element, "A5");
Assert.AreEqual(CollectionChangeAction.Refresh, Action, "A6");
}
public void fillDataGrid()
{
try
{ //JLMQ En las siguientes dos lineas se cambia EPC por ProdSKU
DataSet dtLeidos = consulta("SELECT EPC as Codigo, ProdCB as Ubicacion, Cantidad as Piezas FROM DetalleCongelado WHERE idInvCong= " + idInv + " AND Estatus = 0");
DataSet dtNoLeidos = consulta("SELECT EPC as Codigo, ProdCB as Ubicacion, Cantidad as Piezas FROM DetalleCongelado WHERE idInvCong= " + idInv + " AND Estatus = 1");
DataGridTableStyle tableStyleLeidos = new DataGridTableStyle();
tableStyleLeidos.MappingName = dtLeidos.Tables[0].TableName;
GridColumnStylesCollection columnStylesLeidos = tableStyleLeidos.GridColumnStyles;
DataGridTextBoxColumn columnStyleLeidos = new DataGridTextBoxColumn();
columnStyleLeidos.MappingName = "Codigo";
columnStyleLeidos.HeaderText = "EPC";
columnStyleLeidos.Width = 130;
columnStylesLeidos.Add(columnStyleLeidos);
columnStyleLeidos = new DataGridTextBoxColumn();
columnStyleLeidos.MappingName = "Ubicacion";
columnStyleLeidos.HeaderText = "Ubicacion";
columnStyleLeidos.Width = 50;
columnStylesLeidos.Add(columnStyleLeidos);
columnStyleLeidos = new DataGridTextBoxColumn();
columnStyleLeidos.MappingName = "Piezas";
columnStyleLeidos.HeaderText = "Cantidad";
columnStyleLeidos.Width = 54;
columnStylesLeidos.Add(columnStyleLeidos);
GridTableStylesCollection tableStylesLeidos = dgLeidos.TableStyles;
tableStylesLeidos.Add(tableStyleLeidos);
dgLeidos.PreferredRowHeight = 16;
dgLeidos.RowHeadersVisible = false;
//------------------------------
dgLeidos.DataSource = dtLeidos.Tables[0];
//------------------------------
DataGridTableStyle tableStyleNoLeidos = new DataGridTableStyle();
tableStyleNoLeidos.MappingName = dtNoLeidos.Tables[0].TableName;
GridColumnStylesCollection columnStylesNoLeidos = tableStyleNoLeidos.GridColumnStyles;
DataGridTextBoxColumn columnStyleNoLeidos = new DataGridTextBoxColumn();
columnStyleNoLeidos.MappingName = "Codigo";
columnStyleNoLeidos.HeaderText = "EPC";
columnStyleNoLeidos.Width = 130;
columnStylesNoLeidos.Add(columnStyleNoLeidos);
columnStyleNoLeidos = new DataGridTextBoxColumn();
columnStyleNoLeidos.MappingName = "Ubicacion";
columnStyleNoLeidos.HeaderText = "Ubicacion";
columnStyleNoLeidos.Width = 50;
columnStylesNoLeidos.Add(columnStyleNoLeidos);
columnStyleNoLeidos = new DataGridTextBoxColumn();
columnStyleNoLeidos.MappingName = "Piezas";
columnStyleNoLeidos.HeaderText = "Cantidad";
columnStyleNoLeidos.Width = 54;
columnStylesNoLeidos.Add(columnStyleNoLeidos);
GridTableStylesCollection tableStylesNoLeidos = dgNoLeidos.TableStyles;
tableStylesNoLeidos.Add(tableStyleNoLeidos);
dgNoLeidos.PreferredRowHeight = 16;
dgNoLeidos.RowHeadersVisible = false;
//------------------------------
dgNoLeidos.DataSource = dtNoLeidos.Tables[0];
//------------------------------
}
catch (Exception e)
{
MessageBox.Show(e.Message);
MessageBox.Show("Hubo un asunto con la conexion. \nFavor de Reintentar en unos momentos", "Advertencia");
}
}