protected void Page_Load(object sender, EventArgs e) { AccountingBO accountBO = new AccountingBO(); //accountBO.InitBalanceForward(session, AccountingPeriodBO.getCurrentAccountingPeriod(session)); var datasource1 = accountBO.getLedgerListByAccountCategory(session, "ASSET"); var datasource2 = accountBO.getLedgerListByAccountCategory(session, "LIABILITY"); var datasource3 = accountBO.getLedgerListByAccountCategory(session, "EQUITY"); ASPxTreeList1.DataSource = datasource1; ASPxTreeList2.DataSource = datasource2; ASPxTreeList3.DataSource = datasource3; ASPxTreeList1.DataBind(); ASPxTreeList2.DataBind(); ASPxTreeList3.DataBind(); XPQuery <AccountCategory> AccCateQuery = session.Query <AccountCategory>(); General gen = new General(); AccountCategory AccCate = AccCateQuery.Where(r => r.Code == "ASSET").FirstOrDefault(); totalAsset = gen.TotalBalance(session, AccCate); AccCate = AccCateQuery.Where(r => r.Code == "LIABILITY").FirstOrDefault(); totalLiability = gen.TotalBalance(session, AccCate); AccCate = AccCateQuery.Where(r => r.Code == "EQUITY").FirstOrDefault(); totalEquity = gen.TotalBalance(session, AccCate); ASPxTextBox tb1 = ASPxTreeList1.FindFooterTemplateControl(ASPxTreeList1.Columns[2], "AssetTotal") as ASPxTextBox; tb1.Value = ParseStringNumber(totalAsset.ToString()); tb1.Text = ParseStringNumber(totalAsset.ToString()); ASPxTextBox tb2 = ASPxTreeList2.FindFooterTemplateControl(ASPxTreeList2.Columns[2], "LiabilityTotal") as ASPxTextBox; tb2.Value = ParseStringNumber(totalLiability.ToString()); tb2.Text = ParseStringNumber(totalLiability.ToString()); ASPxTextBox tb3 = ASPxTreeList3.FindFooterTemplateControl(ASPxTreeList3.Columns[2], "EquityTotal") as ASPxTextBox; tb3.Value = ParseStringNumber(totalEquity.ToString()); tb3.Text = ParseStringNumber(totalEquity.ToString()); ASPxTextBox tb4 = ASPxTreeList3.FindFooterTemplateControl(ASPxTreeList3.Columns[2], "DebitTotal") as ASPxTextBox; tb4.Value = ParseStringNumber((totalLiability + totalEquity).ToString()); tb4.Text = ParseStringNumber((totalLiability + totalEquity).ToString()); }