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);
}
