Пример #1
0
    /// <summary>
    /// 显示数据
    /// </summary>
    private void PopulateData()
    {
        if (Roles.IsUserInRole("论坛管理员"))
            Admin = true;
        else
            Admin = false;

        bt_Insert.Visible = Admin;

        #region 初始化数据
        DataTable dataTable_catalog = new DataTable();
        DataTable dataTable_board = new DataTable();
        DataTable dataTable_boardmaster = new DataTable();
        DataTable dataTable_boardmember = new DataTable();
        DataSet ds = new DataSet();
        BBS_CatalogBLL catalogbll = new BBS_CatalogBLL();//分类
        BBS_BoardBLL boardbll = new BBS_BoardBLL();//板块
        BBS_BoardUserMemberBLL boardUserMemberbll = new BBS_BoardUserMemberBLL();//斑竹信息
        #endregion

        //得到分类信息
        dataTable_catalog = catalogbll.GetAllCatalog("");
        dataTable_catalog.TableName = "catalogTable";
        ds.Tables.Add(dataTable_catalog);

        if (dataTable_catalog.Rows.Count > 0)
        {
            //得到板块信息
            dataTable_board = boardbll.GetIndexInfo();
            dataTable_board.TableName = "boardTable";
            ds.Tables.Add(dataTable_board);

            //得到斑竹信息
            dataTable_boardmaster = boardUserMemberbll.GetAllBoardUserMember(" Role=1");
            dataTable_boardmaster.TableName = "boardmasterTable";
            ds.Tables.Add(dataTable_boardmaster);

            //得到成员信息
            dataTable_boardmember = UserBLL.GetOnlineUserList();
            dataTable_boardmember.TableName = "boardmemberTable";
            ds.Tables.Add(dataTable_boardmember);

            //对子表进行数据绑定
            ds.Relations.Add("catalog_board", ds.Tables["catalogTable"].Columns["ID"], ds.Tables["boardTable"].Columns["Catalog"], false);
            ds.Relations.Add("board_boardmaster", ds.Tables["boardTable"].Columns["ID"], ds.Tables["boardmasterTable"].Columns["Board"], false);

            if (!string.IsNullOrEmpty(Request.QueryString["Catalog"]))
                ds.Tables["catalogTable"].DefaultView.RowFilter = "ID=" + Request.QueryString["Catalog"];

            rpt_catalog.DataSource = ds.Tables["catalogTable"].DefaultView;
            rpt_catalog.DataBind();
            rpt_boardmember.DataSource = ds.Tables["boardmemberTable"].DefaultView;
            rpt_boardmember.DataBind();
            Page.DataBind();
        }
    }