private void comboModelo_SelectedIndexChanged(object sender, EventArgs e) { comboLote.Items.Clear(); Combo modelo = comboModelo.Items[comboModelo.SelectedIndex] as Combo; Ingenieria.combo_Lotes(modelo.Valor.ToString(), comboLote); btGuardar.Enabled = true; }
public static bool combo_Placas(DataTable dt, ComboBox combo) { combo.Items.Clear(); // List<Componentes> pcb = new List<Componentes>(); List <string> pcblist = new List <string>(); pcblist = Ingenieria.getPCB(dt); foreach (string panel in pcblist) { combo.Items.Add(panel); } /* * foreach (DataRow row in dt.Rows) * { * string panel = row.ItemArray[4].ToString(); * string pos = row.ItemArray[5].ToString(); * string desc = row.ItemArray[6].ToString(); * string asig = row.ItemArray[7].ToString(); * * if (pos.Contains("PCB")) * { * Componentes nc = new Componentes(panel, pos, desc, asig); * pcb.Add(nc); * } * } * * foreach (Componentes comp in pcb) * { * combo.Items.Add(comp.panel); * }*/ return(true); }
private void loadsql(object sender, DoWorkEventArgs e) { Mysql sql = new Mysql(); DataTable dt = sql.Select(@" SELECT fecha, modelo, lote, placa FROM `datos` GROUP BY modelo, lote, placa ORDER BY modelo DESC "); foreach (DataRow row in dt.Rows) { string fechaz = row["fecha"].ToString(); string modelo = row["modelo"].ToString(); string lote = row["lote"].ToString(); string placa = row["placa"].ToString(); DataTable info = Ingenieria.getInfo(modelo, lote); List <string> pcblist = new List <string>(); bool done = false; if (info.Rows.Count > 0) // si existe Modelo, Lote { pcblist.Clear(); pcblist = Ingenieria.getPCB(info); // Obtener paneles foreach (string lpcb in pcblist) // verificar con cada panel del lote { if (placa == lpcb) { done = true; } else { if (!lpcb.Equals("") && placa.Contains(lpcb)) { done = true; if (InvokeRequired) { Invoke(new dlg_addRow(dlg_dt_addRow), fechaz, modelo, lote, placa, lpcb); } } } } if (!done) { List <string> lsls = pcblist.FindAll(p => p.StartsWith(placa.Substring(0, 1))); if (InvokeRequired) { Invoke(new dlg_addRow(dlg_dt_addRow), fechaz, modelo, lote, placa, String.Join("-", lsls)); done = true; } } } else { if (InvokeRequired) { Invoke(new dlg_addRow(dlg_dt_addRow), fechaz, modelo, lote, placa, "ERROR"); } } } }
private void formLotes_Load(object sender, EventArgs e) { Aplicacion.formLotes = this; Ingenieria.combo_Modelos(comboModelo); reloadMainGrid(); }