protected void bt_OK_Click(object sender, EventArgs e)
{
BBS_BoardBLL _bll = null;
if (bt_OK.Text == "添加")
{
_bll = new BBS_BoardBLL();
}
else
{
_bll = new BBS_BoardBLL((int)ViewState["ID"]);
}
UC_Board.GetData(_bll.Model);
if (bt_OK.Text == "添加")
{
_bll.Model.Catalog = (int)ViewState["CatalogID"];
ViewState["ID"] = _bll.Add();
}
else
{
_bll.Update();
}
MessageBox.ShowAndRedirect(this, "保存成功", "index.aspx");
}
public void BindData()
{
BBS_ForumItemBLL itembll = new BBS_ForumItemBLL(Convert.ToInt32(ViewState["ItemID"]));
this.title1 = lblTitle.Text = itembll.Model.Title.ToString();
lblForumItemName.Text = itembll.Model.Title.ToString();
lblCatalog.Text = new BBS_CatalogBLL(new BBS_BoardBLL(itembll.Model.Board).Model.Catalog).Model.Name;
lblBoardName.Text = new BBS_BoardBLL(itembll.Model.Board).Model.Name;
board = new BBS_BoardBLL(itembll.Model.Board).Model.ID;
#region 显示发布者信息
sendman.Text = DisplayFullInfo(itembll.Model.Sender);
#endregion
sendtime.Text = itembll.Model.SendTime.ToString();
browsetime.Text = itembll.Model.HitTimes.ToString();
replaytimes.Text = itembll.Model.ReplyTimes.ToString();
browsetime.Text = itembll.Model.HitTimes.ToString();
replaytimes.Text = itembll.Model.ReplyTimes.ToString();
itemcontent.InnerHtml = FormatTxt(BBS_ForumItemDAL.txtMessage(itembll.Model.Content.ToString()));
if (itembll.Model["IsTop"] == "Y")
{
cbx_Tpp.Checked = true;
}
if (itembll.Model["IsPith"] == "Y")
{
cbx_IsPith.Checked = true;
}
BindGrid();
}
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 bt_OK_Click(object sender, EventArgs e)
{
BBS_BoardBLL _bll = null;
if (bt_OK.Text == "添加")
{
_bll = new BBS_BoardBLL();
}
else
{
_bll = new BBS_BoardBLL((int)ViewState["ID"]);
}
UC_Board.GetData(_bll.Model);
if (bt_OK.Text == "添加")
{
_bll.Model.Catalog = (int)ViewState["CatalogID"];
ViewState["ID"] = _bll.Add();
}
else
{
_bll.Update();
}
MessageBox.ShowAndRedirect(this, "保存成功", "index.aspx");
}
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);
}
}
}
private void BindData()
{
BBS_BoardBLL bll = new BBS_BoardBLL((int)ViewState["ID"]);
UC_Board.BindData(bll.Model);
bt_OK.Text = "修改";
bt_OK.ForeColor = System.Drawing.Color.Red;
}
protected void BindData()
{
BBS_BoardBLL boardbll = new BBS_BoardBLL(Convert.ToInt32(ViewState["itemid"]));
ddlBoardList.DataSource = boardbll._GetModelList("");
ddlBoardList.DataTextField = "Name";
ddlBoardList.DataValueField = "ID";
ddlBoardList.DataBind();
}
private void BindData()
{
BBS_BoardBLL bll = new BBS_BoardBLL((int)ViewState["ID"]);
UC_Board.BindData(bll.Model);
bt_OK.Text = "修改";
bt_OK.ForeColor = System.Drawing.Color.Red;
}
protected void BindData()
{
BBS_BoardBLL boardbll = new BBS_BoardBLL(Convert.ToInt32(ViewState["itemid"]));
ddlBoardList.DataSource = boardbll._GetModelList("");
ddlBoardList.DataTextField = "Name";
ddlBoardList.DataValueField = "ID";
ddlBoardList.DataBind();
}
private void BindBSS()
{
string boards = ConfigHelper.GetConfigString("BBSBoard"); //获取要查询的板块
if (string.IsNullOrEmpty(boards))
{
return;
}
dl_Board.DataSource = BBS_BoardBLL.GetModelList("ID IN (" + boards + ")");
dl_Board.DataBind();
return;
}
public void DeleteBoard(object sender, System.EventArgs e)
{
BBS_BoardBLL boardbll = new BBS_BoardBLL();
try
{
boardbll.DeleteBoard(Int32.Parse(((LinkButton)sender).CommandArgument));
boardbll = null;
MessageBox.ShowAndRedirect(this, "删除成功！", "index.aspx");
}
catch (Exception ex)
{
MessageBox.ShowAndRedirect(this, "删除出错！", "index.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
ViewState["BoardID"] = (Request.QueryString["BoardID"] == null) ? 0 : Convert.ToInt32(Request.QueryString["BoardID"]);
if (ViewState["BoardID"] != null)
{
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
if (boardbll.Model.IsPublic == "1")
{
isPublic.Visible = true;
BindPublic();
}
else
{
isPublic.Visible = false;
BindView();
}
}
}
}
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();
}
private void BindGrid()
{
dll_Board.DataSource = BBS_BoardBLL.GetModelList("");
dll_Board.DataBind();
dll_Board.Items.Insert(0, new ListItem("全部", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
ViewState["BoardID"] = (Request.QueryString["BoardID"] == null) ? 0 : Convert.ToInt32(Request.QueryString["BoardID"]);
if (ViewState["BoardID"] != null)
{
BBS_BoardBLL boardbll = new BBS_BoardBLL((int)ViewState["BoardID"]);
if (boardbll.Model.IsPublic == "1")
{
isPublic.Visible = true;
BindPublic();
}
else
{
isPublic.Visible = false;
BindView();
}
}
}
}
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();
}
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;
}
/// <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();
}
}
