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); }