public IList<ReviewInfo> GetReview(ReviewType rt, int ID) { SqlHelper objSqlHelper = new SqlHelper(); List<ReviewInfo> reviews = new List<ReviewInfo>(); SqlParameter[] objParams = new SqlParameter[2]; objParams[0] = new SqlParameter("@reviewType", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@ID", SqlDbType.Int, 4); objParams[0].Value = (int)rt; objParams[1].Value = ID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Reviews_GetReview", objParams); while (reader.Read()) { ReviewInfo item = new ReviewInfo(); item.ReviewID = reader.GetInt32(reader.GetOrdinal("ReviewID")); item.BookID = reader.GetInt32(reader.GetOrdinal("bookID")); item.PostIP = reader.GetString(reader.GetOrdinal("postIP")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("postTime")); item.RateID = reader.GetInt32(reader.GetOrdinal("rate")); item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.StatusID = reader.GetInt32(reader.GetOrdinal("status")); item.Content = reader.GetString(reader.GetOrdinal("content")); reviews.Add(item); } reader.Close(); return reviews; }
public void InsertReview(ReviewInfo r) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[7]; objParams[0] = new SqlParameter("@userName", r.UserName); objParams[1] = new SqlParameter("@BookID", r.BookID); objParams[2] = new SqlParameter("@PostIP", r.PostIP); objParams[3] = new SqlParameter("@StatusID", r.StatusID); objParams[4] = new SqlParameter("@RateID", r.RateID); objParams[5] = new SqlParameter("@Content", r.Content); objParams[6] = new SqlParameter("@IsAuthenticated", r.IsAuthenticated); objSqlHelper.ExecuteNonQuery("je_Reviews_InsertReview", objParams); }
public ReviewInfo GetReviewByID(int reviewID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@reviewID", SqlDbType.Int, 4); objParams[0].Value = reviewID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Reviews_GetReviewByID", objParams); ReviewInfo item = new ReviewInfo(); while (reader.Read()) { item.ReviewID = reader.GetInt32(reader.GetOrdinal("ReviewID")); item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.BookID = reader.GetInt32(reader.GetOrdinal("bookID")); item.PostIP = reader.GetString(reader.GetOrdinal("postIP")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("postTime")); item.RateID = reader.GetInt32(reader.GetOrdinal("rate")); item.StatusID = reader.GetInt32(reader.GetOrdinal("status")); item.Content = reader.GetString(reader.GetOrdinal("content")); } reader.Close(); return item; }
protected void addBtn_Click(object sender, EventArgs e) { if (validateNum.Text == Session["CheckCode"].ToString()) { string bookID = Request.QueryString["bookID"]; Jiaen.Components.ReviewInfo review = new Jiaen.Components.ReviewInfo(); review.UserName = reviewName.Text; review.StatusID = int.Parse(statusList.SelectedValue); review.RateID = int.Parse(rateList.SelectedValue); review.Content = contentTxt.Text; review.IsAuthenticated = Request.IsAuthenticated; review.BookID = int.Parse(bookID); review.PostIP = Globals.IPAddress; Review.InsertReview(review); Book.UpdateCount(CountType.ReviewCount, int.Parse(bookID)); Book.UpdateCount(CountType.Rate, int.Parse(bookID)); Response.Redirect("ReviewInfo.aspx?bookID=" + review.BookID); } else { validateNumTxt.Text = "验证码输入有误,请重新输入验证码"; } }
public int UpdateReview(ReviewInfo r) { throw new Exception("The method or operation is not implemented."); }
/// <summary> ///修改特定ID评论信息 /// </summary> /// <param name="AuthorID"></param> /// <returns></returns> public static int UpdateReview(ReviewInfo r) { return reviews.UpdateReview(r); }
/// <summary> /// 添加评论信息 /// </summary> /// <param name="r"></param> public static void InsertReview(ReviewInfo r) { reviews.InsertReview(r); }