protected void Page_Load(object sender, EventArgs e) { using (var banco = new Banco()) { GridViewDepudadoFederal.PreRender += GridViewDepudadoFederal_PreRender; DataTable dt; banco.AddParameter("@ideCadastro", Request.QueryString["id"]); dt = banco.GetTable(@"SELECT ideCadastro, txNomeParlamentar, uf, partido, condicao, email, nome FROM parlamentares WHERE ideCadastro=@ideCadastro" ); frvDeputadoFederal.DataSource = dt; frvDeputadoFederal.DataBind(); Master.Page.Title = "OPS :: Dep. " + dt.Rows[0]["txNomeParlamentar"].ToString(); banco.AddParameter("@ideCadastro", Request.QueryString["id"]); dt = banco.GetTable(@"SELECT SUM(vlrLiquido) AS ValorTotal, txtDescricao AS Despesa FROM lancamentos WHERE ideCadastro=@ideCadastro GROUP BY txtDescricao ORDER BY 1 DESC" ); GridViewDepudadoFederal.DataSource = dt; GridViewDepudadoFederal.DataBind(); Session["pesquisa0"] = dt; ValorTotal.InnerText = Convert.ToDecimal(dt.Compute("Sum(ValorTotal)", "")).ToString("#,###.00"); banco.AddParameter("@ideCadastro", Request.QueryString["id"]); TotalFuncionarios.InnerText = banco.ExecuteScalar(@"SELECT count(1) FROM secretario WHERE deputado=@ideCadastro").ToString(); } }
protected void GridViewDepudadoFederal_Sorting(object sender, GridViewSortEventArgs e) { //Retrieve the table from the session object. DataTable dt = Session["pesquisa0"] as DataTable; if (dt != null) { //Sort the data. dt.DefaultView.Sort = e.SortExpression + " " + GetSortDirection(e.SortExpression); GridViewDepudadoFederal.DataSource = Session["pesquisa0"]; GridViewDepudadoFederal.DataBind(); } }