private void BindGroupBuy()
{
GroupBuyQuery query = new GroupBuyQuery();
query.ProductName = productName;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.SortBy = "DisplaySequence";
query.SortOrder = SortAction.Desc;
DbQueryResult groupBuyList = SubsitePromoteHelper.GetGroupBuyList(query);
grdGroupBuyList.DataSource = groupBuyList.Data;
grdGroupBuyList.DataBind();
pager.TotalRecords = groupBuyList.TotalRecords;
pager1.TotalRecords = groupBuyList.TotalRecords;
}
public abstract DbQueryResult GetGroupBuyList(GroupBuyQuery query);
public abstract DbQueryResult GetCountDownList(GroupBuyQuery query);
public static DbQueryResult GetGroupBuyList(GroupBuyQuery query)
{
return PromotionsProvider.Instance().GetGroupBuyList(query);
}
public override DbQueryResult GetGroupBuyList(GroupBuyQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" 1=1");
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.AppendFormat(" AND ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
}
string selectFields = "GroupBuyId,ProductId,ProductName,MaxCount,NeedPrice,Status,OrderCount,ISNULL(ProdcutQuantity,0) AS ProdcutQuantity,EndDate,DisplaySequence";
return DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_GroupBuy", "GroupBuyId", builder.ToString(), selectFields);
}
public override DbQueryResult GetCountDownList(GroupBuyQuery query)
{
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.AppendFormat("ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
}
string selectFields = "CountDownId,productId,ProductName,CountDownPrice,EndDate,DisplaySequence";
return DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CountDown", "CountDownId", builder.ToString(), selectFields);
}
