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