private int BindChildTree(TreeNodeCollection TNC, int SuperID)
{
int isExpanded = 0;
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["Board"]);
string selectName = boardbll.Model.Name.ToString();
IList <BBS_Board> _list = BBS_BoardBLL.GetModelList(" Catalog= " + SuperID.ToString());
foreach (BBS_Board _m in _list)
{
bool flag = false;
IList <BBS_BoardUserMember> userList = new BBS_BoardUserMemberBLL()._GetModelList(" Board=" + _m.ID);
foreach (BBS_BoardUserMember user in userList)
{
if (user.UserName == (string)Session["UserName"])
{
flag = true;
}
}
if (_m.IsPublic == "1" || (_m.IsPublic == "2" && flag))
{
TreeNode tn = new TreeNode();
tn.Text = _m.Name;
if (selectName.Equals(_m.Name) == true)
{
tn.Selected = true;
isExpanded = 1;
}
tn.Value = _m.ID.ToString();
TNC.Add(tn);
}
}
return(isExpanded);
}
protected void btn_in_Click(object sender, System.EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
//便历listbox得到选中的带成为板主的人员id
if (boardbll.Model.IsPublic == "2")
{
for (int i = 0; i < lbRemainStaff.Items.Count; i++)
{
if (lbRemainStaff.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbRemainStaff.Items[i].Value, (int)ViewState["BoardID"], 1);
}
}
BindView();
}
else
{
for (int i = 0; i < lbRemainStaff.Items.Count; i++)
{
if (lbRemainStaff.Items[i].Selected)
{
userMemberbll.Model.Board = (int)ViewState["BoardID"];
userMemberbll.Model.UserName = lbRemainStaff.Items[i].Value;
userMemberbll.Model.Role = 1;
userMemberbll.Add();
}
}
BindPublic();
}
}
protected void btn_in_Click(object sender, System.EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
//便历listbox得到选中的带成为板主的人员id
if (boardbll.Model.IsPublic == "2")
{
for (int i = 0; i < lbRemainStaff.Items.Count; i++)
{
if (lbRemainStaff.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbRemainStaff.Items[i].Value, (int)ViewState["BoardID"], 1);
}
}
BindView();
}
else
{
for (int i = 0; i < lbRemainStaff.Items.Count; i++)
{
if (lbRemainStaff.Items[i].Selected)
{
userMemberbll.Model.Board = (int)ViewState["BoardID"];
userMemberbll.Model.UserName = lbRemainStaff.Items[i].Value;
userMemberbll.Model.Role = 1;
userMemberbll.Add();
}
}
BindPublic();
}
}
protected void btn_out_Click(object sender, System.EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
//便历listbox得到选中的的人员id
if (boardbll.Model.IsPublic == "2")
{
for (int i = 0; i < lbBoardMasterList.Items.Count; i++)
{
if (lbBoardMasterList.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbBoardMasterList.Items[i].Value, (int)ViewState["BoardID"], 4);
}
}
BindView();
}
else
{
for (int i = 0; i < lbBoardMasterList.Items.Count; i++)
{
if (lbBoardMasterList.Items[i].Selected)
{
userMemberbll.DeleteByUserNameAndBoard(lbBoardMasterList.Items[i].Value, (int)ViewState["BoardID"]);
}
}
BindPublic();
}
}
protected void btn_out_Click(object sender, System.EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
//便历listbox得到选中的的人员id
if (boardbll.Model.IsPublic == "2")
{
for (int i = 0; i < lbBoardMasterList.Items.Count; i++)
{
if (lbBoardMasterList.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbBoardMasterList.Items[i].Value, (int)ViewState["BoardID"], 4);
}
}
BindView();
}
else
{
for (int i = 0; i < lbBoardMasterList.Items.Count; i++)
{
if (lbBoardMasterList.Items[i].Selected)
{
userMemberbll.DeleteByUserNameAndBoard(lbBoardMasterList.Items[i].Value, (int)ViewState["BoardID"]);
}
}
BindPublic();
}
}
private void BindChildTree(TreeNodeCollection TNC, int SuperID)
{
IList <BBS_Board> _list = BBS_BoardBLL.GetModelList(" Catalog= " + SuperID.ToString());
foreach (BBS_Board _m in _list)
{
bool flag = false;
IList <BBS_BoardUserMember> userList = new BBS_BoardUserMemberBLL()._GetModelList(" Board=" + _m.ID);
if (userList != null)
{
foreach (BBS_BoardUserMember user in userList)
{
if (user.UserName == (string)Session["UserName"])
{
flag = true;
}
}
}
if (_m.IsPublic == "1" || (_m.IsPublic == "2" && flag))
{
TreeNode tn = new TreeNode();
tn.Text = _m.Name;
tn.Value = _m.ID.ToString();
TNC.Add(tn);
}
}
}
protected void btn_PublicOut_Click(object sender, EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
//便历listbox得到选中的发布者id
for (int i = 0; i < lbPublicStaff.Items.Count; i++)
{
if (lbPublicStaff.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbPublicStaff.Items[i].Value, (int)ViewState["BoardID"], 3);
}
}
BindView();
}
protected void btn_out_Click(object sender, System.EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
//便历listbox得到选中的讨论者id
for (int i = 0; i < lbDiscussStaff.Items.Count; i++)
{
if (lbDiscussStaff.Items[i].Selected)
{
userMemberbll.UpdateRoleByUserNameAndBoard(lbDiscussStaff.Items[i].Value, (int)ViewState["BoardID"], 4);
}
}
BindView();
}
protected void btn_ReadIn_Click(object sender, EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
//便历listbox得到选中的讨论者id
for (int i = 0; i < listAccount.Items.Count; i++)
{
if (listAccount.Items[i].Selected)
{
userMemberbll.Model.UserName = listAccount.Items[i].Value;
userMemberbll.Model.Board=(int)ViewState["BoardID"];
userMemberbll.Model.Role = 4;
userMemberbll.Add();
}
}
BindView();
}
protected void btn_ReadIn_Click(object sender, EventArgs e)
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL();
//便历listbox得到选中的讨论者id
for (int i = 0; i < listAccount.Items.Count; i++)
{
if (listAccount.Items[i].Selected)
{
userMemberbll.Model.UserName = listAccount.Items[i].Value;
userMemberbll.Model.Board = (int)ViewState["BoardID"];
userMemberbll.Model.Role = 4;
userMemberbll.Add();
}
}
BindView();
}
private void BindPublic()
{
lbRemainStaff.Items.Clear();
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.SelectValue = "1";
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL((int)ViewState["BoardID"]);
if (userMemberbll != null && userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"]).Count > 0)
{
lbBoardMasterList.Items.Clear();
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role = 1"))
{
lbBoardMasterList.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
}
}
private void BindView()
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL((int)ViewState["BoardID"]);
if (userMemberbll != null && userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"]).Count > 0)
{
lbRemainStaff.Items.Clear();
lbBoardMasterList.Items.Clear();
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role <> 1"))
{
lbRemainStaff.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role = 1"))
{
lbBoardMasterList.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
}
}
protected void ModeratorInfo()
{
BBS_ForumItemBLL itembll = new BBS_ForumItemBLL(Convert.ToInt32(ViewState["ItemID"]));
itembll.UpdateHitTimes(Convert.ToInt32(ViewState["ItemID"]));
author = itembll.Model.Sender.ToString();
IList <BBS_BoardUserMember> memberList = BBS_BoardUserMemberBLL.GetModelList(" Board=" + (int)ViewState["BoardID"]);
bool flag = itembll.Model.Sender == Session["UserName"].ToString();
foreach (BBS_BoardUserMember member in memberList)
{
if (member.Role == 1 && member.UserName == (string)ViewState["username"])
{
flag = true;
}
}
if (Roles.IsUserInRole("论坛管理员") || flag)
{
itemcontent.InnerHtml += "<b>操 作：</b><a href=javascript:window.open('deleteitem.aspx?ItemID=" + Convert.ToInt32(ViewState["ItemID"]) + "&BoardID=" + Convert.ToInt32(ViewState["BoardID"]) + "','_self','');>删除此贴</a>|<a href='MoveItem.aspx?ItemID=" + Convert.ToInt32(ViewState["ItemID"]) + "'>移动帖子</a><br><hr color='#C0C0C0' size='1'>";
cbx_IsPith.Visible = true;
cbx_Tpp.Visible = true;
right = true;
}
}
private void BindGrid()
{
#region 列隐藏
dgrd_Result.Columns[2].Visible = false;
dgrd_Result.Columns[4].Visible = false;
dgrd_Result.Columns[7].Visible = false;
dgrd_Result.Columns[9].Visible = false;
dgrd_Result.Columns[10].Visible = false;
dgrd_Result.Columns[11].Visible = false;
dgrd_Result.Columns[13].Visible = false;
#endregion
#region 权限判断
IList <BBS_BoardUserMember> boardUserList = BBS_BoardUserMemberBLL.GetModelList("");
if (Roles.IsUserInRole("论坛管理员"))
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
}
else if (boardUserList != null)
{
foreach (BBS_BoardUserMember user in boardUserList)
{
bt_Delete.Visible = false;
if (new BBS_BoardBLL((int)ViewState["Board"]).Model.IsPublic == "1" && user.Role == 1 && (string)Session["UserName"] == user.UserName)
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
break;
}
else if ((string)Session["UserName"] == user.UserName && new BBS_BoardBLL((int)ViewState["Board"]).Model.IsPublic == "2")
{
if (user.Role == 1)
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
break;
}
else if (user.Role == 2)
{
bt_NewItem.Visible = true;
bt_Delete.Visible = false;
}
else
{
bt_Delete.Visible = false;
bt_NewItem.Visible = false;
}
}
}
}
else
{
bt_Delete.Visible = false;
}
#endregion
if (ViewState["PageIndex"] != null)
{
dgrd_Result.PageIndex = Int32.Parse(ViewState["PageIndex"].ToString());
}
dgrd_Result.ConditionString = " BBS_ForumItem.Board =" + ViewState["Board"].ToString() + " order by BBS_ForumItem.ExtPropertys desc,BBS_ForumItem.LastReplyTime desc";
dgrd_Result.BindGrid();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["Board"]);
lblCatalog.Text = new BBS_CatalogBLL(boardbll.Model.Catalog).Model.Name;
lblBoardName.Text = boardbll.Model.Name;
DataTable dataTable_boardmaster = new DataTable();
DataSet ds = new DataSet();
BBS_BoardUserMemberBLL boardUserMemberbll = new BBS_BoardUserMemberBLL();
dataTable_boardmaster = boardUserMemberbll.GetAllBoardUserMember(" Role=1 and Board=" + (int)ViewState["Board"]);
dataTable_boardmaster.TableName = "boardmasterTable";
ds.Tables.Add(dataTable_boardmaster);
rpt_boardmaster.DataSource = ds.Tables["boardmasterTable"].DefaultView;
rpt_boardmaster.DataBind();
}
/// <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();
}
}
private void BindView()
{
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL((int)ViewState["BoardID"]);
if (userMemberbll != null && userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"]).Count > 0)
{
lbRemainStaff.Items.Clear();
lbBoardMasterList.Items.Clear();
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role <> 1"))
{
lbRemainStaff.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role = 1"))
{
lbBoardMasterList.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
}
}
private void BindPublic()
{
lbRemainStaff.Items.Clear();
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.SelectValue = "1";
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL((int)ViewState["BoardID"]);
if (userMemberbll != null && userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"]).Count > 0)
{
lbBoardMasterList.Items.Clear();
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role = 1"))
{
lbBoardMasterList.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
}
}
private void BindChildTree(TreeNodeCollection TNC, int SuperID)
{
IList<BBS_Board> _list = BBS_BoardBLL.GetModelList(" Catalog= " + SuperID.ToString());
foreach (BBS_Board _m in _list)
{
bool flag = false;
IList<BBS_BoardUserMember> userList = new BBS_BoardUserMemberBLL()._GetModelList(" Board=" + _m.ID);
if (userList != null)
{
foreach (BBS_BoardUserMember user in userList)
{
if (user.UserName==(string)Session["UserName"])
flag = true;
}
}
if (_m.IsPublic == "1" || (_m.IsPublic == "2" && flag))
{
TreeNode tn = new TreeNode();
tn.Text = _m.Name;
tn.Value = _m.ID.ToString();
TNC.Add(tn);
}
}
}
private int BindChildTree(TreeNodeCollection TNC, int SuperID)
{
int isExpanded = 0;
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["Board"]);
string selectName = boardbll.Model.Name.ToString();
IList<BBS_Board> _list = BBS_BoardBLL.GetModelList(" Catalog= " + SuperID.ToString());
foreach (BBS_Board _m in _list)
{
bool flag = false;
IList<BBS_BoardUserMember> userList = new BBS_BoardUserMemberBLL()._GetModelList(" Board=" + _m.ID);
foreach (BBS_BoardUserMember user in userList)
{
if (user.UserName == (string)Session["UserName"])
flag = true;
}
if (_m.IsPublic == "1" || (_m.IsPublic == "2" && flag))
{
TreeNode tn = new TreeNode();
tn.Text = _m.Name;
if (selectName.Equals(_m.Name) == true)
{
tn.Selected = true;
isExpanded = 1;
}
tn.Value = _m.ID.ToString();
TNC.Add(tn);
}
}
return isExpanded;
}
private void BindGrid()
{
#region 列隐藏
dgrd_Result.Columns[2].Visible = false;
dgrd_Result.Columns[4].Visible = false;
dgrd_Result.Columns[7].Visible = false;
dgrd_Result.Columns[9].Visible = false;
dgrd_Result.Columns[10].Visible = false;
dgrd_Result.Columns[11].Visible = false;
dgrd_Result.Columns[13].Visible = false;
#endregion
#region 权限判断
IList<BBS_BoardUserMember> boardUserList = BBS_BoardUserMemberBLL.GetModelList("");
if (Roles.IsUserInRole("论坛管理员"))
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
}
else if (boardUserList != null)
{
foreach (BBS_BoardUserMember user in boardUserList)
{
bt_Delete.Visible = false;
if (new BBS_BoardBLL((int)ViewState["Board"]).Model.IsPublic == "1" && user.Role == 1 && (string)Session["UserName"] == user.UserName)
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
break;
}
else if ((string)Session["UserName"] == user.UserName && new BBS_BoardBLL((int)ViewState["Board"]).Model.IsPublic == "2")
{
if (user.Role == 1)
{
bt_Delete.Visible = true;
bt_NewItem.Visible = true;
dgrd_Result.Columns[13].Visible = true;
break;
}
else if (user.Role == 2)
{
bt_NewItem.Visible = true;
bt_Delete.Visible = false;
}
else
{
bt_Delete.Visible = false;
bt_NewItem.Visible = false;
}
}
}
}
else
bt_Delete.Visible = false;
#endregion
if (ViewState["PageIndex"] != null)
{
dgrd_Result.PageIndex = Int32.Parse(ViewState["PageIndex"].ToString());
}
dgrd_Result.ConditionString = " BBS_ForumItem.Board =" + ViewState["Board"].ToString() + " order by BBS_ForumItem.ExtPropertys desc,BBS_ForumItem.LastReplyTime desc";
dgrd_Result.BindGrid();
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["Board"]);
lblCatalog.Text = new BBS_CatalogBLL(boardbll.Model.Catalog).Model.Name;
lblBoardName.Text = boardbll.Model.Name;
DataTable dataTable_boardmaster = new DataTable();
DataSet ds = new DataSet();
BBS_BoardUserMemberBLL boardUserMemberbll = new BBS_BoardUserMemberBLL();
dataTable_boardmaster = boardUserMemberbll.GetAllBoardUserMember(" Role=1 and Board=" + (int)ViewState["Board"]);
dataTable_boardmaster.TableName = "boardmasterTable";
ds.Tables.Add(dataTable_boardmaster);
rpt_boardmaster.DataSource = ds.Tables["boardmasterTable"].DefaultView;
rpt_boardmaster.DataBind();
}
