public static List <Menu> carregarLista(double pCodigo)
{
List <Menu> lista = new List <Menu>();
String sc = Properties.Settings.Default.CN;
String logPath = Properties.Settings.Default.PathErrorLog;
try
{
MySqlConnection conexao = new MySqlConnection(sc);
conexao.Open();
String sql = "select * from Menu where codigo=" + pCodigo.ToString();
MySqlCommand comando = new MySqlCommand(sql, conexao);
MySqlDataReader registros = comando.ExecuteReader();
while (registros.Read())
{
Menu obj = new Menu();
obj.Codigo = Convert.ToInt64(registros["codigo"]);
obj.Nome = registros["nome"].ToString();
obj.Tipo = (Menu.Tipos)registros["tipo"];
obj.Status = (Menu.TipoStatus)registros["status"];
obj.Items = MenuItemDAO.carregarLista(obj.Codigo);
lista.Add(obj);
}
conexao.Close();
}
catch (Exception err)
{
}
return(lista);
}
public Menu carregar(double pCodigo)
{
Menu obj = new Menu();
try
{
//cria a conexao com o bd
MySqlConnection conexao = new MySqlConnection(sc);
conexao.Open();
String sql = "select * from Menu where codigo=" + pCodigo;
MySqlCommand comando = new MySqlCommand(sql, conexao);
MySqlDataReader registros = comando.ExecuteReader();
if (registros.Read())
{
obj.Codigo = Convert.ToInt64(registros["codigo"]);
obj.Nome = registros["nome"].ToString();
obj.Tipo = (Menu.Tipos)registros["tipo"];
obj.Status = (Menu.TipoStatus)registros["status"];
obj.Items = MenuItemDAO.carregarLista(obj.Codigo);
}
conexao.Close();
}
catch (Exception err)
{
String log = "Erro=>" + DateTime.Now + err.Message + Environment.NewLine;
File.AppendAllText(logPath, log);
}
return(obj);
}
public List <Menu> carregarLista(String[] pFiltros, String pOrdena)
{
List <Menu> lista = new List <Menu>();
String sc = Properties.Settings.Default.CN;
String logPath = Properties.Settings.Default.PathErrorLog;
try
{
MySqlConnection conexao = new MySqlConnection(sc);
conexao.Open();
String sql = "select * from Menu where ";
for (int i = 0; i < pFiltros.Length; i++)
{
sql = sql + pFiltros[i];
if (i < pFiltros.Length - 1)
{
sql = sql + " and ";
}
}
sql = sql + " order by " + pOrdena;
MySqlCommand comando = new MySqlCommand(sql, conexao);
MySqlDataReader registros = comando.ExecuteReader();
while (registros.Read())
{
Menu obj = new Menu();
obj.Codigo = Convert.ToInt64(registros["codigo"]);
obj.Nome = registros["nome"].ToString();
obj.Tipo = (Menu.Tipos)registros["tipo"];
obj.Status = (Menu.TipoStatus)Convert.ToUInt64(registros["status"]);
obj.Items = MenuItemDAO.carregarLista(obj.Codigo);
lista.Add(obj);
}
conexao.Close();
}
catch (Exception err)
{
}
return(lista);
}
