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