public FinanceirosType selectByAssociacao(AssociacaoType assoc, string ano, string mes) { FinanceirosType types = new FinanceirosType(); MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM financeiro " + "WHERE id_associacao = @id " + "AND YEAR(financeiro.`data`) = @ano " + "AND MONTH(financeiro.`data`) = @mes " + "ORDER BY `data`, `id_financeiro`"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", assoc.IdAssociacao); cmd.Parameters.AddWithValue("@ano", ano); cmd.Parameters.AddWithValue("@mes", mes); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { types.Add(execReader(dr)); } return(types); }
public FinanceirosType selectByAssociacao(AssociacaoType assoc, string ano, string mes) { FinanceirosType types = new FinanceirosType(); MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM financeiro " + "WHERE id_associacao = @id " + "AND YEAR(financeiro.`data`) = @ano " + "AND MONTH(financeiro.`data`) = @mes " + "ORDER BY `data`, `id_financeiro`"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", assoc.IdAssociacao); cmd.Parameters.AddWithValue("@ano", ano); cmd.Parameters.AddWithValue("@mes", mes); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { types.Add(execReader(dr)); } return types; }