public static List <T> Select(CriteriaBuilder criteria = null)
{
try
{
//identificar o nome da tabela no banco de dados usando o StxFramework
string nomeTabela = typeof(T).GetCustomAttributesData().Where(item => item.AttributeType == typeof(Table)).FirstOrDefault().ConstructorArguments[0].ToString().Replace("\"", "");
//Monta o SQL
List <T> list = new List <T>();
string CmdString = "SELECT * FROM ";
CmdString += nomeTabela;
if (criteria != null)
{
if (!string.IsNullOrWhiteSpace(criteria.GetQuery()))
{
;
CmdString += criteria.GetQuery();
}
if (!string.IsNullOrWhiteSpace(criteria.GetOrderBy()))
{
CmdString += criteria.GetOrderBy();
}
}
if (Config.DEBUG_MODE)
{
Log(CmdString);
}
MySqlCommand cmd = new MySqlCommand(CmdString, DBConfig.getConnection());
MySqlDataReader rs = cmd.ExecuteReader();
var dt = new DataTable();
dt.Load(rs);
list = ConvertToList <T>(dt);
rs.Close();
return(list);
}
catch (Exception x)
{
ErrorLog("Erro MagicSqlFramework.GenericController.Select: " + x.Message);
return(null);
}
}
