//用户评论图书 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)); }