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();
}
