private void btnInventario_Click(object sender, EventArgs e) { frmMenu_Inventario fmi = new frmMenu_Inventario(user); fmi.Show(); }
private void btnFinalizar_Click(object sender, EventArgs e) { limpia(); List <string> listaUpdate = new List <string>(); List <string> listaCont = new List <string>(); SqlCeDataReader rs = null; Stack st = new Stack(); int contador = 0; try { int cuenta = getIntSDF("select count(*)FROM detalleInvCong WHERE (Estatus = 1)"); if (cuenta > 0) { SqlCeCommand select = new SqlCeCommand("SELECT IDDetInvCong, Conteo1 FROM detalleInvCong WHERE (Estatus = 1)", conexion); conexion.Open(); rs = select.ExecuteReader(); while (rs.Read()) { listaUpdate.Add(rs.GetValue(0).ToString()); listaCont.Add(rs.GetValue(1).ToString()); } int registros = listaUpdate.Count; for (int z = 0; z < registros; z++) { int cosa = ws.inserta("UPDATE detalleInvCong SET Estatus = 1, Conteo1 = " + listaCont[z] + " WHERE IDDetInvCong = " + listaUpdate[z], "ConsolaAdmin"); if (cosa == 1) { contador += 1; } } conexion.Close(); if ((contador > 0)) { /////* if (ws.inserta("update InventarioCongelado SET estatus = 1 WHERE IDInv =" + IdInv, "ConsolaAdmin") == 1) { MessageBox.Show("Transferencia completa", "EXITO"); } /////* ///// solo pruebas MessageBox.Show("Transferencia completa-//Tabla InventarioCongelado omitida", "EXITO"); //this.Dispose(); this.Close(); return; } } else { MessageBox.Show("No se realizó ningun cambio", "Informacion"); frmMenu_Inventario fmi = new frmMenu_Inventario(usuario); fmi.Visible = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR"); } }