protected void BindSearch()
{
ProductBrowseQuery productBrowseQuery = this.GetProductBrowseQuery();
productBrowseQuery.ProductType = ProductType.PhysicalProduct;
DbQueryResult dbQueryResult = null;
dbQueryResult = ProductBrowser.GetBrowseProductList(productBrowseQuery);
this.rptProducts.DataSource = dbQueryResult.Data;
this.rptProducts.DataBind();
this.pager.TotalRecords = dbQueryResult.TotalRecords;
int num = 0;
num = ((!(Convert.ToDouble(dbQueryResult.TotalRecords) % (double)this.pager.PageSize > 0.0)) ? (dbQueryResult.TotalRecords / this.pager.PageSize) : (dbQueryResult.TotalRecords / this.pager.PageSize + 1));
if (dbQueryResult.TotalRecords > 0)
{
this.litSearchResultPage.Text = $"总共有{dbQueryResult.TotalRecords}件商品,{this.pager.PageSize}件商品为一页,共{num}页第 {this.pager.PageIndex}页";
}
else if (string.IsNullOrEmpty(this.Page.Request.QueryString["keywords"].ToNullString()))
{
this.litSearchResult.Text = string.Format("<p style=\"font-size:14px;font-weight:bold; text-align:center\">{0}</p>", "没有相关商品...");
}
else
{
this.litSearchResult.Text = string.Format("<p style=\"font-size:14px;font-weight:bold; text-align:center;display:block;\">{0}</p>", "<br>暂未搜索到相关商品...<br>换个搜索词再试一下");
}
}
private void BindBrandProduct()
{
ProductBrowseQuery productBrowseQuery = this.GetProductBrowseQuery();
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
this.rptProduct.DataSource = browseProductList.Data;
this.rptProduct.DataBind();
this.pager.TotalRecords = browseProductList.TotalRecords;
int num;
if (System.Convert.ToDouble(browseProductList.TotalRecords) % (double)this.pager.PageSize > 0.0)
{
num = browseProductList.TotalRecords / this.pager.PageSize + 1;
}
else
{
num = browseProductList.TotalRecords / this.pager.PageSize;
}
this.litBrandProductResult.Text = string.Format("总共有{0}件商品,{1}件商品为一页,共{2}页第 {3}页", new object[]
{
browseProductList.TotalRecords,
this.pager.PageSize,
num,
this.pager.PageIndex
});
}
private void BindBrandProduct()
{
ProductBrowseQuery productBrowseQuery = this.GetProductBrowseQuery();
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
this.rptProduct.DataSource = browseProductList.Data;
this.rptProduct.DataBind();
this.pager.TotalRecords = browseProductList.TotalRecords;
int num = 0;
num = ((!(Convert.ToDouble(browseProductList.TotalRecords) % (double)this.pager.PageSize > 0.0)) ? (browseProductList.TotalRecords / this.pager.PageSize) : (browseProductList.TotalRecords / this.pager.PageSize + 1));
this.litBrandProductResult.Text = $"总共有{browseProductList.TotalRecords}件商品,{this.pager.PageSize}件商品为一页,共{num}页第 {this.pager.PageIndex}页";
}
void BindBrandProduct()
{
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(this.GetProductBrowseQuery());
this.rptProduct.DataSource = browseProductList.Data;
this.rptProduct.DataBind();
this.pager.TotalRecords = (int)(browseProductList.TotalRecords * (Convert.ToDouble(this.pager.PageSize) / 20.0));
int num = 0;
if ((Convert.ToDouble(browseProductList.TotalRecords) % 20.0) > 0.0)
{
num = (browseProductList.TotalRecords / 20) + 1;
}
else
{
num = browseProductList.TotalRecords / 20;
}
this.litBrandProductResult.Text = string.Format("总共有{0}件商品,{1}件商品为一页,共{2}页第 {3}页", new object[] { browseProductList.TotalRecords, 20, num, this.pager.PageIndex });
}
protected void BindSearch()
{
ProductBrowseQuery productBrowseQuery = this.GetProductBrowseQuery();
DbQueryResult browseProductList = null;
browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
this.rptProducts.DataSource = browseProductList.Data;
this.rptProducts.DataBind();
this.pager.TotalRecords = browseProductList.TotalRecords;
int num = 0;
if ((Convert.ToDouble(browseProductList.TotalRecords) % ((double)this.pager.PageSize)) > 0.0)
{
num = (browseProductList.TotalRecords / this.pager.PageSize) + 1;
}
else
{
num = browseProductList.TotalRecords / this.pager.PageSize;
}
this.litSearchResultPage.Text = string.Format("总共有{0}件商品,{1}件商品为一页,共{2}页第 {3}页", new object[] { browseProductList.TotalRecords, this.pager.PageSize, num, this.pager.PageIndex });
}
private void GetProducts(System.Web.HttpContext context)
{
int pageIndex = 1;
int pageSize = 10;
if (!string.IsNullOrEmpty(context.Request["pageIndex"]))
{
int.TryParse(context.Request["pageIndex"], out pageIndex);
}
if (!string.IsNullOrEmpty(context.Request["pageSize"]))
{
int.TryParse(context.Request["pageSize"], out pageSize);
}
ProductBrowseQuery productBrowseQuery = new ProductBrowseQuery();
productBrowseQuery.PageIndex = pageIndex;
productBrowseQuery.PageSize = pageSize;
if (!string.IsNullOrEmpty(context.Request["cId"]))
{
int num = 0;
int.TryParse(context.Request["cId"], out num);
if (num != 0)
{
productBrowseQuery.CategoryId = new int?(num);
}
}
productBrowseQuery.Keywords = context.Request["keyword"];
productBrowseQuery.SortBy = "DisplaySequence";
productBrowseQuery.SortOrder = SortAction.Desc;
if (!string.IsNullOrEmpty(context.Request["sortBy"]))
{
productBrowseQuery.SortBy = context.Request["sortBy"];
}
if (!string.IsNullOrEmpty(context.Request["sortOrder"]) && context.Request["sortOrder"] == "asc")
{
productBrowseQuery.SortOrder = SortAction.Asc;
}
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
System.Data.DataTable dataTable = (System.Data.DataTable)browseProductList.Data;
if (dataTable == null || dataTable.Rows.Count == 0)
{
context.Response.Write(this.GetErrorJosn(103, "没获取到相应的商品"));
return;
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{\"result\":{");
stringBuilder.AppendFormat("\"totals\":{0},", browseProductList.TotalRecords);
stringBuilder.Append("\"products\":[");
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"pid\":{0},", dataRow["ProductId"]);
stringBuilder.AppendFormat("\"name\":\"{0}\",", dataRow["ProductName"]);
stringBuilder.AppendFormat("\"pic\":\"{0}\",", (dataRow["ThumbnailUrl60"] == System.DBNull.Value) ? Globals.FullPath(this.siteSettings.DefaultProductThumbnail4) : Globals.FullPath((string)dataRow["ThumbnailUrl60"]));
stringBuilder.AppendFormat("\"price\":\"{0}\",", ((decimal)dataRow["SalePrice"]).ToString("F2"));
stringBuilder.AppendFormat("\"saleCounts\":\"{0}\",", ((int)dataRow["SaleCounts"]).ToString());
stringBuilder.AppendFormat("\"url\":\"{0}\"", Globals.FullPath(string.Format("/AppShop/ProductDetails.aspx?productId={0}", dataRow["ProductId"])));
stringBuilder.Append("},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("]}}");
context.Response.Write(stringBuilder.ToString());
}
private void BindBrandProduct()
{
ProductBrowseQuery productBrowseQuery = this.GetProductBrowseQuery();
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
this.rptProducts.DataSource = browseProductList.Data;
this.rptProducts.DataBind();
this.pager.TotalRecords = browseProductList.TotalRecords;
int pageCount = browseProductList.TotalRecords / this.pager.PageSize;
if (browseProductList.TotalRecords % this.pager.PageSize > 0)
{
pageCount++;
}
if (pageCount <= 1)
{
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span class=\"total-count\">{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{1}</span>/<span class=\"total-page\">{1}页</span></span>", browseProductList.TotalRecords, pageCount);
return;
}
#region 分页控件代码
int pageIndex = 1;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["pageindex"]))
{
int.TryParse(this.Page.Request.QueryString["pageindex"], out pageIndex);
}
if (browseProductList.TotalRecords <= 0)
{
pageIndex = 0;
}
string previousPager = "";
string nextPager = "";
Regex regex = new Regex(@"(pageindex=\d+)");
MatchCollection tempMatches = regex.Matches(this.Page.Request.RawUrl);
if (tempMatches.Count == 0)
{
previousPager = this.Page.Request.RawUrl + (this.Page.Request.RawUrl.Contains("?") ? "&" : "?") + "pageindex=1";
if (pageCount > 1)
{
nextPager = this.Page.Request.RawUrl + (this.Page.Request.RawUrl.Contains("?") ? "&" : "?") + "pageindex=2";
}
else
{
nextPager = previousPager;
}
}
if (tempMatches.Count == 1)
{
foreach (Match item in tempMatches)
{
string pagerInfo = item.Value;
if (pageIndex <= pageCount)
{
if ((pageIndex - 1) > 0)
{
previousPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + (pageIndex - 1);
}
else
{
previousPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=1";
}
if ((pageIndex + 1) <= pageCount)
{
nextPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + (pageIndex + 1);
}
else
{
nextPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + pageCount;
}
}
}
}
#endregion
if (pageCount > 1 && pageIndex == 1)
{
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span>{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{2}</span>/<span class=\"total-page\">{3}页</span><a class=\"prev-page disabled\" href=\"{1}\">上一页</a><a class=\"next-page\" href=\"{4}\">下一页</a></span>", new object[]
{
browseProductList.TotalRecords,
previousPager,
pageIndex,
pageCount,
nextPager
});
}
else
{
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span>{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{2}</span>/<span class=\"total-page\">{3}页</span><a class=\"prev-page\" href=\"{1}\">上一页</a><a class=\"next-page\" href=\"{4}\">下一页</a></span>", new object[]
{
browseProductList.TotalRecords,
previousPager,
pageIndex,
pageCount,
nextPager
});
}
}
