public void LoadMoreProductReviews(System.Web.HttpContext context) { StringBuilder stringBuilder = new StringBuilder(); ProductReviewQuery productReviewQuery = new ProductReviewQuery(); productReviewQuery.SortBy = "ReviewDate"; productReviewQuery.SortOrder = SortAction.Desc; productReviewQuery.PageIndex = int.Parse(context.Request["pageNumber"]); productReviewQuery.PageSize = int.Parse(context.Request["size"]); productReviewQuery.productId = int.Parse(context.Request["ProductId"]); Globals.EntityCoding(productReviewQuery, true); DataTable dt = (DataTable)ProductCommentHelper.GetProductReviews(productReviewQuery).Data; stringBuilder.Append("{"); if (dt.Rows.Count > 0) { stringBuilder.Append("\"Success\":1,"); stringBuilder.Append("\"productcomments\":"); IsoDateTimeConverter convert = new IsoDateTimeConverter(); convert.DateTimeFormat = "yyyy-MM-dd"; string strReviews = Newtonsoft.Json.JsonConvert.SerializeObject(dt, Formatting.None, convert); stringBuilder.Append(strReviews); stringBuilder.Append("}"); } else { stringBuilder.Append("\"Success\":0"); stringBuilder.Append("}"); } context.Response.Write(stringBuilder.ToString()); context.Response.End(); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(ProductReviewQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult productReviews = ProductCommentHelper.GetProductReviews(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(productReviews.Data); dataGridViewModel.total = productReviews.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { ProductInfo productById = ProductHelper.GetProductById(row["ProductId"].ToInt(0)); ProductReviewInfo productReviewInfo = row.ToObject <ProductReviewInfo>(); row.Add("Type", query.havedReply); if (productById.ProductName.Trim().Length > 22) { row.Add("ProductNameStr", productById.ProductName.Trim().Substring(0, 22) + "..."); } else { row.Add("ProductNameStr", productById.ProductName.Trim()); } if (productReviewInfo.ReviewText.Trim().Length >= 50) { row.Add("ReviewTextStr", productReviewInfo.ReviewText.Trim().Substring(0, 50) + "..."); } else { row.Add("ReviewTextStr", productReviewInfo.ReviewText.Trim()); } if (query.havedReply.ToBool()) { if (productReviewInfo.ReplyText.Trim().Length >= 50) { row.Add("ReplyTextStr", productReviewInfo.ReplyText.Trim().Substring(0, 50) + "..."); } else { row.Add("ReplyTextStr", productReviewInfo.ReplyText.Trim()); } } } } return(dataGridViewModel); }
private void BindPtReview() { ProductReviewQuery productReviewQuery = new ProductReviewQuery(); productReviewQuery.Keywords = this.keywords; productReviewQuery.CategoryId = this.categoryId; productReviewQuery.ProductCode = this.productCode; productReviewQuery.PageIndex = this.pager.PageIndex; productReviewQuery.PageSize = this.pager.PageSize; productReviewQuery.SortOrder = SortAction.Desc; productReviewQuery.SortBy = "ReviewDate"; Globals.EntityCoding(productReviewQuery, true); DbQueryResult productReviews = ProductCommentHelper.GetProductReviews(productReviewQuery); this.dlstPtReviews.DataSource = productReviews.Data; this.dlstPtReviews.DataBind(); this.pager.TotalRecords = productReviews.TotalRecords; }
private void BindPtReview() { ProductReviewQuery entity = new ProductReviewQuery { Keywords = this.keywords, CategoryId = this.categoryId, ProductCode = this.productCode, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "ReviewDate" }; Globals.EntityCoding(entity, true); DbQueryResult productReviews = ProductCommentHelper.GetProductReviews(entity); this.dlstPtReviews.DataSource = productReviews.Data; this.dlstPtReviews.DataBind(); this.pager.TotalRecords = productReviews.TotalRecords; }
private void BindPtReview() { ProductReviewQuery entity = new ProductReviewQuery(); entity.Keywords = this.keywords; entity.CategoryId = this.categoryId; entity.ProductCode = this.productCode; entity.PageIndex = this.pager.PageIndex; entity.PageSize = this.pager.PageSize; entity.SortOrder = SortAction.Desc; entity.SortBy = "ReviewDate"; Globals.EntityCoding(entity, true); int total = 0; DataSet productReviews = ProductCommentHelper.GetProductReviews(out total, entity); this.dlstPtReviews.DataSource = productReviews.Tables[0].DefaultView; this.dlstPtReviews.DataBind(); this.pager.TotalRecords = total; this.pager1.TotalRecords = total; }
public void GetProductReviews(System.Web.HttpContext context) { string producId = context.Request["ProductId"]; int Id = 0; int.TryParse(producId, out Id); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("{"); if (!int.TryParse(producId, out Id)) { stringBuilder.Append("\"Success\":-1"); stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); context.Response.End(); return; } //处理平均数和总数 DataTable dt = ProductCommentHelper.GetReviewsCountAndAvg(Id); if (dt.Rows.Count > 0) { ProductReviewQuery productReviewQuery = new ProductReviewQuery(); productReviewQuery.SortBy = "ReviewDate"; productReviewQuery.SortOrder = SortAction.Desc; productReviewQuery.PageIndex = int.Parse(context.Request["pageNumber"]); productReviewQuery.PageSize = int.Parse(context.Request["size"]); productReviewQuery.productId = int.Parse(context.Request["ProductId"]); Globals.EntityCoding(productReviewQuery, true); DataTable dtcomments = (DataTable)ProductCommentHelper.GetProductReviews(productReviewQuery).Data; if (dtcomments.Rows.Count <= 0) { stringBuilder.Append("\"Success\":0"); stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); context.Response.End(); return; } else { int amount = 0; try { int.TryParse(dt.Rows[0]["Amount"].ToString(), out amount); } catch { amount = 0; } stringBuilder.Append("\"Success\":1,"); stringBuilder.AppendFormat("\"Amount\":{0},", amount); stringBuilder.Append("\"data\":"); for (int i = 0; i < dtcomments.Rows.Count; i++) { dtcomments.Rows[i]["UserName"] = ReplaceStr(dtcomments.Rows[i]["UserName"].ToString()); } IsoDateTimeConverter convert = new IsoDateTimeConverter(); convert.DateTimeFormat = "yyyy-MM-dd"; string strReviews = Newtonsoft.Json.JsonConvert.SerializeObject(dtcomments, Formatting.None, convert); stringBuilder.Append(strReviews); stringBuilder.Append(","); //stringBuilder.AppendFormat("\"Avg\":{0}", Math.Round((1.0 * count / list.Count), 1)); double avg = 0; try{ double.TryParse(dt.Rows[0]["avg"].ToString(), out avg); } catch { avg = 0; } stringBuilder.AppendFormat("\"Avg\":{0}", avg.ToString("0.0")); stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); context.Response.End(); return; } } else { stringBuilder.Append("\"Success\":0"); stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); context.Response.End(); return; } }