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("商品评价");
}
