//用户评论图书
public static int book_comment(Book_Comment bc)
{
string sql = "insert into Book_Comment(Us_User_id,Bk_Book_id,Bc_mess,Bc_time) values(@us_user_id,@bk_book_id,@bc_mess,@bc_time)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@us_user_id", bc.Us_User_id1),
new SqlParameter("@bk_book_id", bc.Bk_Book_id1),
new SqlParameter("@bc_mess", bc.Bc_mess1),
new SqlParameter("@bc_time", bc.Bc_time1),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
protected void plfabu_Click(object sender, EventArgs e)
{
Button bt = (Button)sender;
if (Session["user_name"] != null)
{
try
{
Book_Comment bc = new Book_Comment();
bc.Us_User_id1 = int.Parse(Session["user_id"].ToString());
bc.Bk_Book_id1 = Convert.ToInt32(Request.QueryString["book_id"].ToString());
bc.Bc_mess1 = plshuru.Text;
bc.Bc_time1 = DateTime.Now;
if (Book_CommentManager.book_comment(bc) == 1)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('回复成功');</script>");
BingBC();
plshuru.Text = "";
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('评论失败');</script>");
}
}
catch (Exception ex)
{
Response.Write("错误原因：" + ex.Message);
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('请先登录！');</script>");
}
}
//会员发表图书评论
public static int book_comment(Book_Comment bc)
{
return(Book_CommentService.book_comment(bc));
}
