protected void btnComments_Click(object sender, EventArgs e)
{
if (Session ["user_name"] != null)
{
if (Page.IsValid)
{
discussion_comt comt = new discussion_comt();
comt.user_id = int.Parse(Session["user_id"].ToString());
comt.discussion_id = int.Parse(Request.QueryString["id"]);
comt.comt_cont = txtComments.Text;
comt.comt_time = DateTime.Now;
int result = Discussion_comtManager.InsertDiscussion_comt(comt);
if (result >= 1)
{
ScriptManager.RegisterClientScriptBlock(updatecomment, this.GetType(), "click", "alert('评论成功')", true);
BindDisComment();
txtComments.Text = "";
}
else
{
ScriptManager.RegisterClientScriptBlock(updatecomment, this.GetType(), "click", "alert('评论失败！')", true);
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(updatecomment, this.GetType(), "click", "alert('您必须先登录才能评论！')", true);
ScriptManager.RegisterStartupScript(updatecomment, updatecomment.GetType(), "updateScript", "window.location.href='login1.aspx'", true);
}
}
public int InsertDiscussion_comt(discussion_comt discussion_comt)
{
string sql = "insert into discussion_comt(comt_time,user_id,comt_cont,discussion_id) values(@comt_time,@user_id,@comt_cont,@discussion_id)";
SqlParameter[] sp =
{
new SqlParameter("@comt_time", discussion_comt.comt_time),
new SqlParameter("@user_id", discussion_comt.user_id),
new SqlParameter("@comt_cont", discussion_comt.comt_cont),
new SqlParameter("@discussion_id", discussion_comt.discussion_id),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
public static int InsertDiscussion_comt(discussion_comt discussion_comt)
{
return(idiscussion_comt.InsertDiscussion_comt(discussion_comt));
}
