/// <summary> /// ��ʾ���� /// </summary> private void PopulateData() { #region ��ʼ������ DataTable dataTable_catalog = new DataTable(); DataTable dataTable_board = new DataTable(); DataTable dataTable_boardmaster = new DataTable(); DataSet ds = new DataSet(); SqlDataReader dr_catalog = null; SqlDataReader dr_board = null; SqlDataReader dr_boardmaster = null; BBSClass bbsclass = new BBSClass(); BBSCatalog catalog = new BBSCatalog();//���� BBSBoard board = new BBSBoard();//��� BBSForumItem item = new BBSForumItem();//���ӵ���Ϣ BBSBoardmaster master = new BBSBoardmaster();//������Ϣ BBSReplay replay = new BBSReplay();//�ظ���Ϣ #endregion try { //try //�ж�Ȩ�� Admin = bbsclass.AdminBBS(Username, Int32.Parse(classid)); ViewState["Admin"] = Admin; Bulletin = bbsclass.AdminSysBulletin(Username, Int32.Parse(classid)); ViewState["Bulletin"] = Bulletin; A1.Visible = Admin; //�õ������Ϣ dr_catalog = bbsclass.GetBBSCatalog(); if (Admin) { HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "1"); Response.Cookies.Add(cookie); } else { HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "0"); Response.Cookies.Add(cookie); } if (Bulletin) { HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "1"); Response.Cookies.Add(cookie1); } else { HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "0"); Response.Cookies.Add(cookie1); } dataTable_catalog = Tools.ConvertDataReaderToDataTable(dr_catalog); dataTable_catalog.TableName = "catalogTable"; ds.Tables.Add(dataTable_catalog); //�õ������Ϣ if (Admin) dr_board = bbsclass.GetAllBBSBoard(); else dr_board = bbsclass.GetBBSBoard((string)Username); dataTable_board = Tools.ConvertDataReaderToDataTable(dr_board); dataTable_board.TableName = "boardTable"; ds.Tables.Add(dataTable_board); //�õ�������Ϣ dr_boardmaster = bbsclass.GetBoardMaster(); dataTable_boardmaster = Tools.ConvertDataReaderToDataTable(dr_boardmaster); dataTable_boardmaster.TableName = "boardmasterTable"; ds.Tables.Add(dataTable_boardmaster); //���ӱ�������ݰ� ds.Relations.Add("catolog_board", ds.Tables["catalogTable"].Columns["catalog_id"], ds.Tables["boardTable"].Columns["catalog_id"], false); ds.Relations.Add("board_boardmaster", ds.Tables["boardTable"].Columns["board_id"], ds.Tables["boardmasterTable"].Columns["board_id"], false); rpt_catalog.DataSource = ds.Tables["catalogTable"].DefaultView; Page.DataBind(); } finally { dr_board.Close(); dr_boardmaster.Close(); dr_catalog.Close(); } }
private void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� if(!Page.IsPostBack) { string staffids = ""; boardid = (Request.QueryString["BoardID"]==null)?0:Convert.ToInt32(Request.QueryString["BoardID"]); classid = (Request.QueryString["classID"]==null)?0:Int32.Parse(Request.QueryString["classID"]); ViewState["boardid"] = boardid; ViewState["classid"] = classid; UDS.Components.Staff staff = new UDS.Components.Staff(); BBSClass bbs = new BBSClass(); SqlDataReader dr = null; SqlDataReader dr1 = null; DataTable dt = new DataTable(); try { dr = bbs.GetBoardMaster(); dt = Tools.ConvertDataReaderToDataTable(dr); dt.DefaultView.RowFilter = "board_id=" + boardid; lbBoardMasterList.DataSource = dt.DefaultView; lbBoardMasterList.DataValueField = "staff_id"; lbBoardMasterList.DataTextField = "realname"; lbBoardMasterList.DataBind(); for (int i = 0; i < lbBoardMasterList.Items.Count; i++) { staffids += lbBoardMasterList.Items[i].Value + ","; } if (staffids.Length != 0) staffids = staffids.Substring(0, staffids.Length - 1); dr1 = staff.GetRemainStaff(staffids); lbRemainStaff.DataSource = dr1; lbRemainStaff.DataValueField = "staff_id"; lbRemainStaff.DataTextField = "realname"; lbRemainStaff.DataBind(); dr1.Close(); } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../../Error.aspx"); } finally { if (dr1 != null) { dr1.Close(); } if (dr != null) { dr.Close(); } } } else { boardid = Int32.Parse(ViewState["boardid"].ToString()); classid = Int32.Parse(ViewState["classid"].ToString()); } hlk_Back.DataBind(); }