public void insertarRazon(RazonesEliminacion cli) { this.configConex(); this.cnn._esSelect = true; this.cnn._sentenciaSQL = "insert into " + this.cnn._nombreTabla + " values('" + cli._Razon + "')"; this.cnn.conectar(); this.cnn.cerrarConexion(); }
public void modificarRazon(RazonesEliminacion cli) { this.configConex(); this.cnn._sentenciaSQL = "update " + cnn._nombreTabla + " set Razon='" + cli._Razon + "'" + " where Razon=" + cli._Razon; this.cnn._esSelect = false; this.cnn.conectar(); this.cnn.cerrarConexion(); }
public System.Collections.ArrayList getRazones() { System.Collections.ArrayList lista = new System.Collections.ArrayList(); this.configConex(); this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla; this.cnn._esSelect = true; this.cnn.conectar(); foreach (System.Data.DataRow dr in this.cnn._dbDataSet.Tables[this.cnn._nombreTabla].Rows) { RazonesEliminacion ca = new RazonesEliminacion(); ca._Razon = (string)dr["Razon"].ToString(); lista.Add(ca); } this.cnn.cerrarConexion(); return(lista); }
public RazonesEliminacion buscarRazon(string idCliente) { RazonesEliminacion cli = new RazonesEliminacion(); this.configConex(); this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla + " where Razon =' " + idCliente + "'"; this.cnn._esSelect = true; this.cnn.conectar(); System.Data.DataTable dt = new System.Data.DataTable(); dt = cnn._dbDataSet.Tables[0]; try { cli._Razon = (string)dt.Rows[0][0].ToString(); } catch (Exception e) { cli._Razon = ""; } this.cnn.cerrarConexion(); return(cli); }