当前文件路径：OfficeOnline/BBS/BBS_Info.aspx.cs

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11
 12public partial class BBS_BBS_Info : System.Web.UI.Page
 13...{
 14    WebService webService = new WebService();
 15    PagedDataSource objPDS;
 16    string strSql;
 17    protected void Page_Load(object sender, EventArgs e)
 18    ...{
 19        if (Session["UserID"] == null || Session["UserLevel"] == null)
 20        ...{
 21            Response.Redirect("~/Error.aspx");
 22        }
 23        if (!Page.IsPostBack)
 24        ...{
 25            strSql = "SELECT z_BbsMessage.BM_ID,BM_AddPersonID, z_BbsMessage.BM_Title,z_BbsMessage.BM_Content, z_BbsMessage.BM_AddDate,z_BbsMessage.BM_ModifyDate,z_BbsMessage.BM_Replies, z_Person.Person_UserName FROM z_BbsMessage INNER JOIN z_Person ON z_BbsMessage.BM_AddPersonID = z_Person.Person_ID WHERE z_BbsMessage.BM_ID='" + Request.QueryString["bid"] + "';";
 26            DataTable table = webService.ExcuteSelect(strSql);
 27            this.lblTitle.Text = table.Rows[0]["BM_Title"].ToString();
 28            this.lblAddDate.Text = table.Rows[0]["BM_AddDate"].ToString();
 29            this.lblAuthor.Text = table.Rows[0]["Person_UserName"].ToString();
 30            this.TextBox1.Text = table.Rows[0]["BM_Content"].ToString();
 31            if (table.Rows[0]["BM_ModifyDate"].ToString() != "")
 32                this.lblModifyDate.Text = "此帖最后于" + table.Rows[0]["BM_ModifyDate"].ToString() + "被楼主修改。";
 33            if (table.Rows[0]["BM_AddPersonID"].ToString() != Session["UserID"].ToString())
 34            ...{
 35                this.lbtnEdit.Visible = false;
 36            }
 37            if (Session["UserLevel"].ToString() != "总经理" && Session["UserLevel"].ToString() != "副总经理")
 38                this.lbtnDel.Visible = false;
 39            else
 40                this.lbtnDel.Visible = true;
 41        }
 42
 43        strSql = "SELECT z_Person.Person_UserName, z_Reply.Reply_AddDate, z_Reply.Reply_ModifyDate, z_Reply.Reply_Content, z_Reply.Reply_ID, z_Reply.BBS_ID, z_BbsMessage.BM_ID, z_BbsMessage.BM_Title FROM z_Reply INNER JOIN z_Person ON z_Reply.Reply_AddPersonID = z_Person.Person_ID INNER JOIN z_BbsMessage ON z_Reply.BBS_ID = z_BbsMessage.BM_ID WHERE (z_BbsMessage.BM_ID = '" + Request.QueryString["bid"] + "')";
 44        DataTable dtTable = webService.ExcuteSelect(strSql);
 45        DataColumn column = new DataColumn("Modify");
 46        dtTable.Columns.Add(column);
 47        DataColumn column2 = new DataColumn("Num");
 48        dtTable.Columns.Add(column2);
 49        int i = 1;
 50        foreach (DataRow row in dtTable.Rows)
 51        ...{
 52            if (row["Reply_ModifyDate"].ToString() != "")
 53            ...{
 54                row["Modify"] = "此帖最后于" + row["Reply_ModifyDate"].ToString() + "被作者修改。";
 55            }
 56            else
 57                row["Modify"] = "";
 58            row["Num"] = i.ToString();
 59            i++;
 60        }
 61        objPDS = new PagedDataSource();
 62        objPDS.DataSource = dtTable.DefaultView;
 63        objPDS.AllowPaging = true;
 64        objPDS.PageSize = 10;
 65        int curPage;
 66        if (Request.QueryString["Page"] != null)
 67        ...{
 68            curPage = Int32.Parse(Request.QueryString["Page"]);
 69        }
 70        else
 71            curPage = 1;
 72        objPDS.CurrentPageIndex = curPage - 1;
 73        this.lblPageNum.Text = curPage.ToString();
 74        this.lblTotalPage.Text = objPDS.PageCount.ToString();
 75
 76        if (!objPDS.IsFirstPage)
 77        ...{
 78            linkPre.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage - 1)+"&&bid="+Request.QueryString["bid"];
 79        }
 80        if (!objPDS.IsLastPage)
 81        ...{
 82            linkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage + 1) + "&&bid=" + Request.QueryString["bid"];
 83        }
 84        linkFirstPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&&bid=" + Request.QueryString["bid"];
 85        linkEndPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + objPDS.PageCount.ToString() + "&&bid=" + Request.QueryString["bid"];
 86
 87        this.DataList1.DataSource = objPDS;
 88        this.DataList1.DataBind();
 89        foreach (DataListItem item in this.DataList1.Items)//逐行检查每个DataList项
 90        ...{
 91            LinkButton edit = (LinkButton)item.FindControl("lbtnEditReply");//得到其中的编辑按钮
 92            Label lblName = (Label)item.FindControl("lblAuthor");//得到其中的显示用户名的Label控件
 93            strSql = "Select Person_ID from z_Person where Person_UserName='" + lblName.Text + "';";//根据用户名找到发表该回复的用户的ID
 94            DataTable table1 = webService.ExcuteSelect(strSql);
 95            if (table1.Rows[0]["Person_ID"].ToString() != Session["UserID"].ToString())//比较当前用户是否是回复撰写人
 96            ...{
 97                edit.Visible = false;
 98            }
 99            else
100            ...{
101                edit.Visible = true;
102            }
103            LinkButton del = (LinkButton)item.FindControl("lbtnDelReply");//得到其中的删除按钮
104            if (Session["UserLevel"].ToString() != "总经理" && Session["UserLevel"].ToString() != "副总经理")//判断是否是管理层
105            ...{   
106                del.Visible = false;
107            }
108            else
109            ...{
110                del.Visible = true;
111            }
112        }
113    }
114    protected void lbtnGoPage_Click(object sender, EventArgs e)
115    ...{
116        int pageIndex = Int32.Parse(this.tbPageNum.Text);
117        if (pageIndex <= objPDS.PageCount && pageIndex > 0)
118        ...{
119            this.lblMsg.Text = "";
120            if (Request.QueryString["type"] != null)
121            ...{
122                Response.Redirect("BBS_Info.aspx?Page=" + pageIndex+"&&bid="+Request.QueryString["bid"]);
123            }
124            else
125                Response.Redirect("BBS_Info.aspx?Page=" + pageIndex+"&&bid="+Request.QueryString["bid"]);
126        }
127        else
128        ...{
129            this.lblMsg.Text = "输入页数错误";
130        }
131    }
132    protected void LinkButton1_Click(object sender, EventArgs e)
133    ...{
134        Response.Redirect("BBS_AddReply.aspx?bid=" + Request.QueryString["bid"]);
135    }
136    protected void LinkButton2_Click(object sender, EventArgs e)
137    ...{
138        Response.Redirect("BBS_List.aspx");
139    }
140    protected void lbtnDel_Click(object sender, EventArgs e)
141    ...{
142        if (Session["UserLevel"].ToString() == "总经理" || Session["UserID"].ToString() == "副总经理")
143        ...{
144            strSql = "Delete from z_BbsMessage where BM_ID='" + Request.QueryString["bid"] + "';";
145            webService.ExcuteSql(strSql);
146            strSql = "Delete from z_Reply where BBS_ID='" + Request.QueryString["bid"] + "';";
147            webService.ExcuteSql(strSql);
148            Response.Redirect("BBS_List.aspx");
149        }
150    }
151    protected void lbtnEdit_Click(object sender, EventArgs e)
152    ...{
153        Response.Redirect("BBS_Edit.aspx?bid="+Request.QueryString["bid"]);
154    }
155    protected void lbtnDelReply_Command(object sender, CommandEventArgs e)
156    ...{
157        if (Session["UserLevel"].ToString() == "总经理" || Session["UserID"].ToString() == "副总经理")
158        ...{
159            strSql = "Update z_Reply set Reply_Content='该楼已被管理员删除!' where Reply_ID='" + e.CommandArgument + "';";
160            webService.ExcuteSql(strSql);
161            Response.Redirect("BBS_Info.aspx?bid="+Request.QueryString["bid"]);
162        }
163    }
164    protected void lbtnEditReply_Command(object sender, CommandEventArgs e)
165    ...{
166        Response.Redirect("BBS_EditReply.aspx?rid=" + e.CommandArgument + "&&bid=" + Request.QueryString["bid"]);
167    }
168}
169