//Turbi: metodo para cargar los datos de la bd sobrecargado
public static DataTable DatosGeneral(string tabla, string cFiltro, string cOrderBy)
{
try
{
if (cFiltro.Trim() == "")
{
cFiltro = " Where 1 = 1 ";
}
if (cOrderBy.Trim() == "")
{
cOrderBy = " Order by 1 ";
}
DataTable dt = new DataTable();
clsProcesos con = new clsProcesos();
string constring = con.conectarConta();
if (constring == null)
{
constring = DispensarioMedico.clsConexion.ConectionString;
}
MySqlConnection objCon = new MySqlConnection();
objCon.ConnectionString = constring;
objCon.Open();
string consulta = "SELECT * FROM " + tabla + " " + cFiltro + " " + cOrderBy;
VFPToolkit.strings.StrToFile(consulta, "Consulta.sql", true);
MySqlCommand comando = new MySqlCommand(consulta, objCon);
MySqlDataAdapter adap = new MySqlDataAdapter(comando);
//Turbi
//dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
adap.Fill(dt);
objCon.Close();
return(dt);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error : " + ex.Message, "Activos Fijos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "frmActivosFijos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
finally
{
}
}
public static DataTable ValidaDatos(string Tabla, string cFiltro)
{
try
{
if (cFiltro.Trim() == "")
{
cFiltro = " Where 1 = 1 ";
}
//if (cOrderBy.Trim() == "")
//{
// cOrderBy = " Order by 1 ";
//}
DataTable dt = new DataTable();
clsProcesos con = new clsProcesos();
string constring = con.conectarConta();
if (constring == null)
{
constring = DispensarioMedico.clsConexion.ConectionString;
}
MySqlConnection objCon = new MySqlConnection();
objCon.ConnectionString = constring;
objCon.Open();
string consulta = "SELECT * FROM " + Tabla + " " + cFiltro;
MySqlCommand comando = new MySqlCommand(consulta, objCon);
MySqlDataAdapter adap = new MySqlDataAdapter(comando);
//Turbi
//dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
adap.Fill(dt);
return(dt);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error : " + ex.Message, "Bancos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Bancos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
finally
{
}
}
//retornas los permisos del usuario
public static DataTable Permisos(string cusuario, string copcion)
{
try
{
DataTable dt = new DataTable();
clsProcesos con = new clsProcesos();
string constring = con.conectarConta();
if (constring == null)
{
constring = DispensarioMedico.clsConexion.ConectionString;
}
MySqlConnection objCon = new MySqlConnection();
objCon.ConnectionString = constring;
objCon.Open();
string consulta = "SELECT * FROM PermisoUsuarios where usuario=+'" + cusuario.Trim() + "' and menu='" + copcion.Trim() + "' ";
MySqlCommand comando = new MySqlCommand(consulta, objCon);
MySqlDataAdapter adap = new MySqlDataAdapter(comando);
//Turbi
//dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
adap.Fill(dt);
return(dt);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error : " + ex.Message, "Bancos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Bancos", MessageBoxButtons.OK,
MessageBoxIcon.Information);
clsExceptionLog.LogError(ex, false);
return(null);
}
finally
{
}
}