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