public void TestIndexContains()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn();
col1.MappingName = "Column1";
sc.Add(col1);
DataGridTextBoxColumn col2 = new DataGridTextBoxColumn();
col2.MappingName = "Column2";
sc.Add(col2);
DataGridTextBoxColumn col3 = new DataGridTextBoxColumn();
col3.MappingName = "Column3";
sc.Add(col3);
ResetEventData();
IList ilist = (IList)sc;
Assert.AreEqual(1, ilist.IndexOf(col2), "A1");
Assert.AreEqual(false, sc.Contains("nothing"), "A2");
Assert.AreEqual(true, sc.Contains(col3), "A3");
}
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 void TestAdd()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
ResetEventData();
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn();
col1.MappingName = "Column1";
sc.Add(col1);
Assert.AreEqual(true, eventhandled);
Assert.AreEqual(col1, Element);
Assert.AreEqual(CollectionChangeAction.Add, Action);
// Add multiple
ResetEventData();
DataGridTextBoxColumn elem1 = new DataGridTextBoxColumn();
DataGridTextBoxColumn elem2 = new DataGridTextBoxColumn();
sc.AddRange(new DataGridTextBoxColumn [] { elem1, elem2 });
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(CollectionChangeAction.Add, Action, "A2");
Assert.AreEqual(elem2, Element, "A3");
}
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 GridColumnStylesCollection_Add_DataGridColumnStyle_Success()
{
var tableStyle = new DataGridTableStyle();
GridColumnStylesCollection collection = tableStyle.GridColumnStyles;
var style = new SubDataGridColumnStyle();
Assert.Equal(0, collection.Add(style));
Assert.Same(style, Assert.Single(collection));
Assert.Same(tableStyle, style.DataGridTableStyle);
}
public void TestRemove()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn();
col1.MappingName = "Column1";
sc.Add(col1);
DataGridTextBoxColumn col2 = new DataGridTextBoxColumn();
col2.MappingName = "Column2";
sc.Add(col2);
DataGridTextBoxColumn col3 = new DataGridTextBoxColumn();
col3.MappingName = "Column3";
sc.Add(col3);
ResetEventData();
sc.Remove(col2);
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(col2, 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(col1, Element, "A6");
Assert.AreEqual(CollectionChangeAction.Remove, Action, "A6");
Assert.AreEqual(1, sc.Count, "A7");
ResetEventData();
sc.Clear();
Assert.AreEqual(null, Element, "A8");
Assert.AreEqual(CollectionChangeAction.Refresh, Action, "A9");
}
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 static void FillDataGrid(DataGrid grid, PropertyList columns, DataContent[] rows)
{
DataTable dtab = new DataTable();
DataRow drow;
int colNumber = 0;
if (columns != null)
{
colNumber = columns.Size();
dtab.Columns.Add("_UIUTilsNo_", typeof(int));
for (IEnumerator i = columns.GetEnumerator(); i.MoveNext();)
{
DataInfo info = columns.Info();
if (info != null)
{
DataField f = columns.Info().GetField((String)i.Current);
dtab.Columns.Add(f.getFieldTitle(), typeof(Object) /*f.getFieldType().ToImplType()*/);
}
else
{
dtab.Columns.Add((String)i.Current, typeof(Object));
}
}
for (int i = 0; i < rows.Length; i++)
{
drow = dtab.NewRow();
int col = 0;
drow[col++] = i + 1;
for (IEnumerator e = columns.GetEnumerator(); e.MoveNext();)
{
Object o = rows[i].GetProperty((String)e.Current);
if (o == null)
{
o = DBNull.Value;
}
drow[col++] = o;
}
dtab.Rows.Add(drow);
}
}
else if (rows != null && rows.Length > 0)
{
ICollection cols = rows[0].KeySet();
dtab.Columns.Add("No", typeof(int));
for (IEnumerator i = cols.GetEnumerator(); i.MoveNext();)
{
dtab.Columns.Add((String)i.Current, typeof(Object));
colNumber++;
}
for (int i = 0; i < rows.Length; i++)
{
drow = dtab.NewRow();
int col = 0;
drow[col++] = i + 1;
for (IEnumerator e = cols.GetEnumerator(); e.MoveNext();)
{
Object o = rows[i].GetProperty((String)e.Current);
if (o == null)
{
o = DBNull.Value;
}
drow[col++] = o;
}
dtab.Rows.Add(drow);
}
}
int x = -1;
if (colNumber > 0)
{
x = (grid.ClientSize.Width - 40) / colNumber;
if (x > 0)
{
grid.PreferredColumnWidth = x;
}
}
grid.DataSource = dtab;
grid.TableStyles.Clear();
grid.TableStyles.Add(new DataGridTableStyle());
GridColumnStylesCollection gcsColl = grid.TableStyles[0].GridColumnStyles;
ArrayList a = new ArrayList();
for (int i = 0; i < gcsColl.Count; i++)
{
if (x > 0)
{
gcsColl[i].Width = x;
gcsColl[i].NullText = "";
}
a.Add(gcsColl[i]);
}
gcsColl.Clear();
UserTextBoxColumn u = new UserTextBoxColumn();
u.HeaderText = "";
u.MappingName = "_UIUTilsNo_";
u.Width = 30;
gcsColl.Add(u);
for (int i = 1; i < a.Count; i++)
{
gcsColl.Add((DataGridColumnStyle)a[i]);
}
/*
* for (int i = 0; i < gcsColl.Count; i++)
* {
* if (gcsColl[i].GetType() == typeof (DataGridTextBoxColumn))
* {
* DataGridTextBoxColumn textColumn = (DataGridTextBoxColumn) gcsColl[i];
* if (textColumn.HeaderText == "No")
* {
* textColumn.Width = 30;
* textColumn.TextBox.BackColor=Color.Red;
* //textColumn.HeaderText = "new header text";
* break;
* }
* }
* }*/
if (dtab.Rows.Count > 0)
{
grid.CurrentRowIndex = 0;
grid.Select(0);
}
grid.RowHeadersVisible = false;
grid.RowHeaderWidth = 1;
//grid.Focus();
}
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");
}
}
