protected override void AttachChildControls()
{
string url = this.Page.Request.QueryString["returnUrl"];
if (!string.IsNullOrWhiteSpace(this.Page.Request.QueryString["returnUrl"]))
{
this.Page.Response.Redirect(url);
}
Member member = HiContext.Current.User as Member;
if (member == null)
{
this.Page.Response.Redirect("/Vshop/Login.aspx");
}
this.rptProducts = (VshopTemplatedRepeater)this.FindControl("rptProducts");
this.litProFavCount = (System.Web.UI.WebControls.Literal) this.FindControl("litProFavCount");
this.litSuppFavCount = (System.Web.UI.WebControls.Literal) this.FindControl("litSuppFavCount");
this.txtTotal = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal");
int pageIndex;
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize;
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 8;
}
//
ProductFavoriteQuery query = new ProductFavoriteQuery();
query.PageIndex = pageIndex;
query.PageSize = pageSize;
query.UserId = member.UserId;
query.GradeId = member.GradeId;
DbQueryResult dr = ProductBrowser.GetFavorites(query);
this.rptProducts.DataSource = dr.Data;
this.rptProducts.DataBind();
this.litProFavCount.Text = dr.TotalRecords.ToString();
this.litSuppFavCount.Text = SupplierHelper.GetUserSupplierCollectCount(member.UserId).ToString();
this.txtTotal.SetWhenIsNotNull(dr.TotalRecords.ToString());
PageTitle.AddSiteNameTitle("我的收藏");
}
public DbQueryResult GetFavorites(ProductFavoriteQuery query)
{
//Member member = HiContext.Current.User as Member;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("(");
stringBuilder.Append("SELECT a.*, b.ProductName, b.ThumbnailUrl60,b.ThumbnailUrl220,b.MarketPrice,b.ShortDescription,b.TaxRate,");
int discount = new MemberGradeDao().GetMemberGrade(query.GradeId).Discount;
stringBuilder.AppendFormat(" (CASE WHEN (SELECT COUNT(*) FROM Ecshop_SKUMemberPrice WHERE SkuId = b.SkuId AND GradeId = {0}) = 1", query.GradeId);
stringBuilder.AppendFormat(" THEN (SELECT MemberSalePrice FROM Ecshop_SKUMemberPrice WHERE SkuId = b.SkuId AND GradeId = {0}) ELSE SalePrice*{1}/100 END) AS SalePrice", query.GradeId, discount);
stringBuilder.AppendFormat(" FROM Ecshop_Favorite a left join vw_Ecshop_CDisableBrowseProductList b on a.ProductId = b.ProductId WHERE a.UserId={0}", query.UserId);
stringBuilder.Append(") as FavoriteTable ");
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, stringBuilder.ToString(), "FavoriteId", "", "*"));
}
public static DbQueryResult GetFavorites(ProductFavoriteQuery query)
{
return(new FavoriteDao().GetFavorites(query));
}
