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); }