/// <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();
}
