//发表评论
protected void pinglun_Click(object sender, EventArgs e)
{
if (Session["username"] != null)
{
try
{
int id = Convert.ToInt32(Request.QueryString["bbsid"].ToString());
BBS_Comment bc = new BBS_Comment();
bc.BC_BBS_ID1 = id;
bc.BC_Users_Name1 = Session["username"].ToString();
bc.BC_Content1 = txtContent.Text;
bc.BC_Time1 = DateTime.Now;
if (BBS_CommentBll.addbc(bc) == 1)
{
txtContent.Text = "";
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('评论成功！');", true);
BingBC();
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('评论失败！');", true);
}
}
catch (Exception ex)
{
Response.Write("错误原因：" + ex.Message);
}
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "alert('对不起，请先登录！');", true);
}
}
//增加评论
public static int addbc(BBS_Comment bc)
{
string sql = "insert into BBS_Comment values(@BC_Content,@BC_Time,@BC_Users_Name,@BC_BBS_ID)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@BC_Content", bc.BC_Content1),
new SqlParameter("@BC_Time", bc.BC_Time1),
new SqlParameter("@BC_Users_Name", bc.BC_Users_Name1),
new SqlParameter("@BC_BBS_ID", bc.BC_BBS_ID1)
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
//增加评论
public static int addbc(BBS_Comment bc)
{
return(BBS_CommentDal.addbc(bc));
}