Example #1
0
 // 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               ")))));
 }
Example #2
0
 // 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;
     }
 }
Example #3
0
        // 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);
            }
        }
Example #4
0
 // 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               "))));
 }