public List <Aluno> Pesquisar(int id, string banco, bool todosRegistros, string campoExtra, bool like, string campoPesquisa, string orderby)
{
string sql = "";
List <Aluno> ret = new List <Aluno>();
try
{
Aluno obj = new Aluno();
obj.ID_ALUNO = id;
sql = LeituraObjetos_SQL.GerarSQLSelectDelete(obj, true, todosRegistros, campoExtra, like, campoPesquisa, orderby);
DbDataReader rdr = null;
switch (banco)
{
case "M":
rdr = ClasseConectar.mySql.ExecuteReader(sql);
break;
case "L":
rdr = ClasseConectar.sqlLite.ExecuteReader(sql);
break;
case "F":
rdr = ClasseConectar.fb.ExecuteReader(sql);
break;
}
while (rdr.Read())
{
obj = (Aluno)LeituraObjetos_SQL.montagem(rdr, obj);
ret.Add(obj);
}
}
catch (Exception ex)
{
throw new Exception("Erro : " + ex.Message + (ex.InnerException != null ? ex.InnerException.ToString() : String.Empty));
}
return(ret);
}
public List <Aluno> PesquisarSQLIVRE(string banco, string sql)
{
List <Aluno> ret = new List <Aluno>();
try
{
Aluno obj = new Aluno();
DbDataReader rdr = null;
switch (banco)
{
case "M":
rdr = ClasseConectar.mySql.ExecuteReader(sql);
break;
case "L":
rdr = ClasseConectar.sqlLite.ExecuteReader(sql);
break;
case "F":
rdr = ClasseConectar.fb.ExecuteReader(sql);
break;
}
while (rdr.Read())
{
obj = (Aluno)LeituraObjetos_SQL.montagem(rdr, obj);
ret.Add(obj);
}
}
catch (Exception ex)
{
throw new Exception("Erro : " + ex.Message + (ex.InnerException != null ? ex.InnerException.ToString() : String.Empty));
}
return(ret);
}