public override DbQueryResult GetBundlingProductList(BundlingInfoQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" salestatus=1 "); stringBuilder.AppendFormat(" AND DistributorUserId={0} ", HiContext.Current.SiteSettings.UserId.Value); string selectFields = "Bundlingid,Name,Num,price,SaleStatus,AddTime,ShortDescription,DisplaySequence"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "distro_BundlingProducts", "Bundlingid", stringBuilder.ToString(), selectFields)); }
public override DbQueryResult GetBundlingProductList(BundlingInfoQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" salestatus=1 "); if (!string.IsNullOrEmpty(query.ProductName)) { builder.AppendFormat(" AND Name Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName)); } string selectFields = "Bundlingid,Name,Num,price,SaleStatus,AddTime,ShortDescription,DisplaySequence"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_BundlingProducts", "Bundlingid", builder.ToString(), selectFields)); }
private void BindBundlingProducts() { BundlingInfoQuery query = new BundlingInfoQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.SortBy = "DisplaySequence"; query.SortOrder = SortAction.Desc; DbQueryResult bundlingProductList = ProductBrowser.GetBundlingProductList(query); this.rptProduct.DataSource = bundlingProductList.Data; this.rptProduct.DataBind(); this.pager.TotalRecords = bundlingProductList.TotalRecords; }
private void BindBundlingProducts() { BundlingInfoQuery query = new BundlingInfoQuery(); query.ProductName = this.productName; query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.SortBy = "DisplaySequence"; query.SortOrder = SortAction.Desc; DbQueryResult bundlingProducts = PromoteHelper.GetBundlingProducts(query); this.grdBundlingList.DataSource = bundlingProducts.Data; this.grdBundlingList.DataBind(); this.pager.TotalRecords = bundlingProducts.TotalRecords; this.pager1.TotalRecords = bundlingProducts.TotalRecords; }
public DbQueryResult GetBundlingProducts(BundlingInfoQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1"); if (!string.IsNullOrEmpty(query.ProductName)) { stringBuilder.AppendFormat(" AND Name Like '%{0}%' ", DataHelper.CleanSearchString(query.ProductName)); } if (query.SupplierId.HasValue) { stringBuilder.AppendFormat(" AND SupplierId = {0} ", query.SupplierId); } string selectFields = "Bundlingid,Name,Num,price,SaleStatus,OrderCount,AddTime,DisplaySequence,ShortDescription,SupplierId"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_BundlingProducts", "Bundlingid", stringBuilder.ToString(), selectFields)); }
public static DbQueryResult GetBundlingProducts(BundlingInfoQuery query) { return(PromotionsProvider.Instance().GetBundlingProducts(query)); }
public static DbQueryResult GetBundlingProductList(BundlingInfoQuery query) { return(ProductProvider.Instance().GetBundlingProductList(query)); }
public abstract DbQueryResult GetBundlingProducts(BundlingInfoQuery query);
public static DbQueryResult GetBundlingProducts(BundlingInfoQuery query) { return(new BundlingDao().GetBundlingProducts(query)); }