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; this.pager1.TotalRecords = productReviews.TotalRecords; }
private void BindPtReview() { ProductReviewQuery query2 = new ProductReviewQuery(); query2.Keywords = this.keywords; query2.CategoryId = this.categoryId; query2.ProductCode = this.productCode; query2.PageIndex = this.pager.PageIndex; query2.PageSize = this.pager.PageSize; query2.SortOrder = SortAction.Desc; query2.SortBy = "ReviewDate"; ProductReviewQuery entity = query2; int total = 0; Globals.EntityCoding(entity, true); DataSet productReviews = SubsiteCommentsHelper.GetProductReviews(out total, entity); this.dlstPtReviews.DataSource = productReviews.Tables[0].DefaultView; this.dlstPtReviews.DataBind(); this.pager.TotalRecords = total; this.pager1.TotalRecords = total; }
public DbQueryResult GetProductReviews(ProductReviewQuery reviewQuery) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(" ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(reviewQuery.Keywords)); if (!string.IsNullOrEmpty(reviewQuery.ProductCode)) { builder.AppendFormat(" AND ProductCode LIKE '%{0}%'", DataHelper.CleanSearchString(reviewQuery.ProductCode)); } if (reviewQuery.productId > 0) { builder.AppendFormat(" AND ProductId = {0}", reviewQuery.productId); } if (reviewQuery.CategoryId.HasValue) { builder.AppendFormat(" AND (CategoryId = {0}", reviewQuery.CategoryId.Value); builder.AppendFormat(" OR CategoryId IN (SELECT CategoryId FROM Hishop_Categories WHERE Path LIKE (SELECT Path FROM Hishop_Categories WHERE CategoryId = {0}) + '%'))", reviewQuery.CategoryId.Value); } return DataHelper.PagingByRownumber(reviewQuery.PageIndex, reviewQuery.PageSize, reviewQuery.SortBy, reviewQuery.SortOrder, reviewQuery.IsCount, "vw_Hishop_ProductReviews", "ProductId", builder.ToString(), "*"); }
private void BindPtReview() { ProductReviewQuery entity = new ProductReviewQuery(); entity.Keywords = keywords; entity.CategoryId = categoryId; entity.ProductCode = productCode; entity.PageIndex = pager.PageIndex; entity.PageSize = pager.PageSize; entity.SortOrder = SortAction.Desc; entity.SortBy = "ReviewDate"; Globals.EntityCoding(entity, true); int total = 0; DataSet productReviews = ProductCommentHelper.GetProductReviews(out total, entity); dlstPtReviews.DataSource = productReviews.Tables[0].DefaultView; dlstPtReviews.DataBind(); pager.TotalRecords = total; pager1.TotalRecords = total; }
public static DbQueryResult GetProductReviews(ProductReviewQuery reviewQuery) { return new ProductReviewDao().GetProductReviews(reviewQuery); }
public static DataSet GetProductReviews(out int total, ProductReviewQuery reviewQuery) { return CommentsProvider.Instance().GetProductReviews(out total, reviewQuery); }
static string BuildReviewsQuery(ProductReviewQuery reviewQuery) { HiContext current = HiContext.Current; StringBuilder builder = new StringBuilder(); builder.Append("SELECT r.ReviewId FROM Hishop_Products p inner join Hishop_ProductReviews r on r.productId=p.ProductId WHERE 0 = 0"); if (!string.IsNullOrEmpty(reviewQuery.ProductCode)) { builder.AppendFormat(" AND ProductCode LIKE '%{0}%'", DataHelper.CleanSearchString(reviewQuery.ProductCode)); } if (!string.IsNullOrEmpty(reviewQuery.Keywords)) { builder.AppendFormat(" AND p.ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(reviewQuery.Keywords)); } if (reviewQuery.CategoryId.HasValue) { builder.AppendFormat(" AND (p.CategoryId = {0}", reviewQuery.CategoryId.Value); builder.AppendFormat(" OR p.CategoryId IN (SELECT CategoryId FROM Hishop_Categories WHERE Path LIKE (SELECT Path FROM Hishop_Categories WHERE CategoryId = {0}) + '%'))", reviewQuery.CategoryId.Value); } if (!string.IsNullOrEmpty(reviewQuery.SortBy)) { builder.AppendFormat(" ORDER BY {0} {1}", DataHelper.CleanSearchString(reviewQuery.SortBy), reviewQuery.SortOrder.ToString()); } return builder.ToString(); }
public override DataSet GetProductReviews(out int total, ProductReviewQuery reviewQuery) { DbCommand storedProcCommand = database.GetStoredProcCommand("cp_ProductReviews_Get"); database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, reviewQuery.PageIndex); database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, reviewQuery.PageSize); database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, reviewQuery.IsCount); database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, BuildReviewsQuery(reviewQuery)); database.AddOutParameter(storedProcCommand, "Total", DbType.Int32, 4); if (reviewQuery.CategoryId.HasValue) { database.AddInParameter(storedProcCommand, "CategoryId", DbType.Int32, reviewQuery.CategoryId.Value); } DataSet set = database.ExecuteDataSet(storedProcCommand); total = (int)database.GetParameterValue(storedProcCommand, "Total"); return set; }
public abstract DataSet GetProductReviews(out int total, ProductReviewQuery reviewQuery);
protected override void AttachChildControls() { int num; int num2; if (!int.TryParse(this.Page.Request.QueryString["productId"], out this.productId)) { base.GotoResourceNotFound(""); } this.litProdcutName = (Literal) this.FindControl("litProdcutName"); this.litSalePrice = (Literal) this.FindControl("litSalePrice"); this.litShortDescription = (Literal) this.FindControl("litShortDescription"); this.litSoldCount = (Literal) this.FindControl("litSoldCount"); this.productImage = (HtmlImage) this.FindControl("productImage"); this.productLink = (HyperLink) this.FindControl("productLink"); this.txtTotal = (HtmlInputHidden) this.FindControl("txtTotal"); string str = this.Page.Request["OrderId"]; string str2 = ""; if (!string.IsNullOrEmpty(str)) { OrderInfo orderInfo = ShoppingProcessor.GetOrderInfo(str); if ((orderInfo != null) && (orderInfo.ReferralUserId > 0)) { str2 = "&&ReferralId=" + orderInfo.ReferralUserId; } } else if (Globals.GetCurrentDistributorId() > 0) { str2 = "&&ReferralId=" + Globals.GetCurrentDistributorId().ToString(); } ProductInfo product = ProductBrowser.GetProduct(MemberProcessor.GetCurrentMember(), this.productId); this.litProdcutName.SetWhenIsNotNull(product.ProductName); this.litSalePrice.SetWhenIsNotNull(product.MinSalePrice.ToString("F2")); this.litShortDescription.SetWhenIsNotNull(product.ShortDescription); this.litSoldCount.SetWhenIsNotNull(product.ShowSaleCounts.ToString()); this.productImage.Src = product.ThumbnailUrl180; this.productLink.NavigateUrl = "ProductDetails.aspx?ProductId=" + product.ProductId + str2; if (!int.TryParse(this.Page.Request.QueryString["page"], out num)) { num = 1; } if (!int.TryParse(this.Page.Request.QueryString["size"], out num2)) { num2 = 20; } ProductReviewQuery reviewQuery = new ProductReviewQuery { productId = this.productId, IsCount = true, PageIndex = num, PageSize = num2, SortBy = "ReviewId", SortOrder = SortAction.Desc }; this.rptProducts = (VshopTemplatedRepeater) this.FindControl("rptProducts"); DbQueryResult productReviews = ProductBrowser.GetProductReviews(reviewQuery); this.rptProducts.DataSource = productReviews.Data; this.rptProducts.DataBind(); this.txtTotal.SetWhenIsNotNull(productReviews.TotalRecords.ToString()); PageTitle.AddSiteNameTitle("商品评价"); }