// Recupera las tablas base de la BD
public static ArrayList getTablasBase()
{
config.getConfiguraciones();
confArch = config.getConfArch();
confBD = config.getConfBD();
sqlDispatcher.getConexion(confBD.NomBD, confBD.Servidor, confBD.Us, confBD.Pwd, Int32.Parse(confBD.BD));
return(sqlDispatcher.getColConsulta(("SELECT " + ("P.* " + ("FROM " + "TABLAS_BD P ")))));
}
// Valida si el usuario ingresado es valido
public static bool esUsuario(string us, string pwd)
{
config.getConfiguraciones();
confArch = config.getConfArch();
confBD = config.getConfBD();
sqlDispatcher.getConexion(confBD.NomBD, confBD.Servidor, confBD.Us, confBD.Pwd, Int32.Parse(confBD.BD));
ArrayList colbd = new ArrayList();
colbd = sqlDispatcher.getColConsulta(("SELECT " + ("P.* " + ("FROM " + ("usuario2 P "
+ (("where P.clave = \'"
+ (us + "\' ")) + ("and P.password = \'"
+ (pwd + "\' "))))))));
if ((!(colbd == null)
&& (colbd.Count > 0)))
{
return true;
}
else
{
return false;
}
}
// Valida si el usuario ingresado es valido
public static bool esUsuario(string us, string pwd)
{
config.getConfiguraciones();
confArch = config.getConfArch();
confBD = config.getConfBD();
sqlDispatcher.getConexion(confBD.NomBD, confBD.Servidor, confBD.Us, confBD.Pwd, Int32.Parse(confBD.BD));
ArrayList colbd = new ArrayList();
colbd = sqlDispatcher.getColConsulta(("SELECT " + ("P.* " + ("FROM " + ("usuario2 P "
+ (("where P.clave = \'"
+ (us + "\' ")) + ("and P.password = \'"
+ (pwd + "\' "))))))));
if ((!(colbd == null) &&
(colbd.Count > 0)))
{
return(true);
}
else
{
return(false);
}
}
// Recupera las tablas base de la BD
public static ArrayList getTablasBase()
{
config.getConfiguraciones();
confArch = config.getConfArch();
confBD = config.getConfBD();
sqlDispatcher.getConexion(confBD.NomBD, confBD.Servidor, confBD.Us, confBD.Pwd, Int32.Parse(confBD.BD));
return sqlDispatcher.getColConsulta(("SELECT " + ("P.* " + ("FROM " + "TABLAS_BD P "))));
}