public void TestIndexContains()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTableStyle ts1 = new DataGridTableStyle();
ts1.MappingName = "Table1";
sc.Add(ts1);
DataGridTableStyle ts2 = new DataGridTableStyle();
ts2.MappingName = "Table2";
sc.Add(ts2);
DataGridTableStyle ts3 = new DataGridTableStyle();
ts3.MappingName = "Table3";
sc.Add(ts3);
ResetEventData();
IList ilist = (IList)sc;
Assert.AreEqual(1, ilist.IndexOf(ts2), "A1");
Assert.AreEqual(false, sc.Contains("nothing"), "A2");
Assert.AreEqual(true, sc.Contains(ts3), "A3");
}
public GridTableStylesCollectionTests()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionChanged);
Console.WriteLine("GridColumnStylesCollection default --- ");
DumpGridTableStylesCollection(sc);
Console.WriteLine("Add single item");
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = "Table1";
sc.Add(ts);
Console.WriteLine("Add multipleitems");
sc.AddRange(new DataGridTableStyle [] { new DataGridTableStyle(), new DataGridTableStyle() });
Console.WriteLine("Remove At");
sc.RemoveAt(2);
Console.WriteLine("Add single item");
ts = new DataGridTableStyle();
ts.MappingName = "Table2";
sc.Add(ts);
for (int i = 0; i < sc.Count; i++)
{
Console.WriteLine("Element {0}:{1}", i, sc[i].MappingName);
}
sc.Remove(ts);
Console.WriteLine("Contains Table1 {0}", sc.Contains("Table1"));
Console.WriteLine("Contains Table4 {0}", sc.Contains("Table4"));
}
private void Collection_Changed
(object sender, CollectionChangeEventArgs e)
{
GridTableStylesCollection gts = (GridTableStylesCollection)
sender;
Console.WriteLine(gts.Count);
}
public void GridTableStylesCollection_Add_DataGridTableStyle_Success()
{
var dataGrid = new DataGrid();
GridTableStylesCollection collection = dataGrid.TableStyles;
var style = new DataGridTableStyle();
Assert.Equal(0, collection.Add(style));
Assert.Same(style, Assert.Single(collection));
Assert.Same(dataGrid, style.DataGrid);
}
public void TestDefaultValues()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
Assert.AreEqual(false, sc.IsSynchronized, "IsSynchronized property");
Assert.AreEqual(0, sc.Count, "Count");
Assert.AreEqual(sc, sc.SyncRoot, "SyncRoot property");
Assert.AreEqual(false, ((IList)sc).IsFixedSize, "IsFixedSize property");
Assert.AreEqual(false, sc.IsReadOnly, "IsReadOnly property");
}
public void fillDataGrid()
{
try
{
DataSet dt = consulta(select);
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dt.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Codigo";
columnStyle.HeaderText = "CODIGO";
columnStyle.Width = 89;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Ubicacion";
columnStyle.HeaderText = "UBICACIÓN";
columnStyle.Width = 89;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Piezas";
columnStyle.HeaderText = "TAG";
columnStyle.Width = 38;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPC";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 38;
columnStyles.Add(columnStyle);
dataGrid1.TableStyles.Clear();//se agrego para limpiar antes de agregar
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = dt.Tables[0];
//------------------------------
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
MessageBox.Show("Hubo un asunto con la conexion. \nFavor de Reintentar en unos momentos", "Advertencia");
}
}
public void fillDataGrid()
{
try
{
DataSet dt = consulta("SELECT idInv, almacen, fecha, cveInv from InvCongelado WHERE usuario = '" + user[4] + "' AND numConteo < 4"); //CAMBIE ESTO PARA QUE LE APAREZCAN AL USUARUI TODOS LOS CONTEOS ASIGNADOS AND status = 0");
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dt.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "idInv";
columnStyle.HeaderText = "ID";
columnStyle.Width = 30;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "almacen";
columnStyle.HeaderText = "Ubicación";
columnStyle.Width = 50;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "fecha";
columnStyle.HeaderText = "Fecha";
columnStyle.Width = 100;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "cveInv";
columnStyle.HeaderText = "Clave";
columnStyle.Width = 54;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = dt.Tables[0];
//------------------------------
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
MessageBox.Show("Hubo un asunto con la conexion. \nFavor de Reintentar en unos momentos", "Advertencia");
}
}
public void fillDataGrid()
{
//el que estaba
DataSet listas = consulta("SELECT de.EPC, ca.[Descripción] as Item, de.Piezas "
+ "FROM DetEscuadras de INNER JOIN catArt ca "
+ "ON ca.Clave = de.EPC "
+ "WHERE (de.piezas > 0)");
if (listas == null)
{
return;
}
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = listas.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPC";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 80;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Item";
columnStyle.HeaderText = "Articulo";
columnStyle.Width = 80;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Piezas";
columnStyle.HeaderText = "Cantidad";
columnStyle.Width = 65;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = listas.Tables[0];
//------------------------------
}
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 llenaListas()
{
DataSet listas = consulta("SELECT IDInv, EPCArt, IDArticulo FROM detalleInvCong WHERE (Estatus = 0)");
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = listas.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPCArt";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 150;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "IDArticulo";
columnStyle.HeaderText = "Articulo";
columnStyle.Width = 100;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = listas.Tables[0];
//------------------------------
lstNum.DataSource = listas.Tables[0];
lstNum.DisplayMember = "IDDetInvCong";
lstSerie.DataSource = listas.Tables[0];
lstSerie.DisplayMember = "EPCArt";
lstDescripcion.DataSource = listas.Tables[0];
lstDescripcion.DisplayMember = "IDArticulo";
foreach (DataRow dtRow in listas.Tables[0].Rows)
{
epcs.Add(dtRow[1]);
idArts.Add(dtRow[2]);
}
}
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 TestRemove()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTableStyle ts1 = new DataGridTableStyle();
ts1.MappingName = "Table1";
sc.Add(ts1);
DataGridTableStyle ts2 = new DataGridTableStyle();
ts2.MappingName = "Table2";
sc.Add(ts2);
DataGridTableStyle ts3 = new DataGridTableStyle();
ts3.MappingName = "Table3";
sc.Add(ts3);
ResetEventData();
sc.Remove(ts2);
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(ts2, Element, "A2");
Assert.AreEqual(CollectionChangeAction.Remove, Action, "A3");
Assert.AreEqual(2, sc.Count, "A4");
ResetEventData();
sc.RemoveAt(0);
Assert.AreEqual(true, eventhandled, "A5");
Assert.AreEqual(ts1, Element, "A6");
Assert.AreEqual(CollectionChangeAction.Remove, Action, "A7");
Assert.AreEqual(1, sc.Count, "A8");
ResetEventData();
sc.Clear();
Assert.AreEqual(null, Element, "A9");
Assert.AreEqual(CollectionChangeAction.Refresh, Action, "A10");
}
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 void TestAddRange()
{
DataGrid grid = new DataGrid();
GridTableStylesCollection sc = grid.TableStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
ResetEventData();
DataGridTableStyle ts1 = new DataGridTableStyle();
ts1.MappingName = "Table1";
DataGridTableStyle ts2 = new DataGridTableStyle();
ts2.MappingName = "Table2";
sc.AddRange(new DataGridTableStyle[] { ts1, ts2 });
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(null, Element, "A2");
Assert.AreEqual(CollectionChangeAction.Refresh, Action, "A3");
Assert.AreEqual(1, times, "A4");
}
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");
}
// <Snippet1>
private void ClearAndAdd()
{
GridTableStylesCollection gts = dataGrid1.TableStyles;
gts.Clear();
}
public void DumpGridTableStylesCollection(GridTableStylesCollection ts)
{
Console.WriteLine("IsSynchronized {0} ", ts.IsSynchronized);
Console.WriteLine("SyncRoot {0} ", ts.SyncRoot);
Console.WriteLine("IsReadOnly {0} ", ts.IsReadOnly);
}
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");
}
}
