private void BindList() { gvList.DataSource = CommDataHelper.GetDataFromSingleTableByPage(SearPageInfo); gvList.DataBind(); pageNav.CurrentPageIndex = SearPageInfo.PageIndex; pageNav.PageSize = SearPageInfo.PageSize; pageNav.RecordCount = SearPageInfo.TotalItem; }
private void BindList() { DataSet ds = CommDataHelper.GetDataFromSingleTableByPage(SearPageInfo); rpProducts.DataSource = ds.Tables[0]; rpProducts.DataBind(); //panNoResult.Visible = ds.Tables[0].Rows.Count == 0; pageNav.CurrentPageIndex = SearPageInfo.PageIndex; pageNav.PageSize = SearPageInfo.PageSize; pageNav.RecordCount = SearPageInfo.TotalItem; }
public DataTable GetProductList(int CategoryID, int PageIndex, int BrandID, decimal[] PriceRange, int OrderType, out int RecordCount, out int PageCount) { SearchPageInfo pageinfo = new SearchPageInfo(); string CategoryPath = Convert.ToString(GetCategoryInfo(CategoryID)["catepath"]); string where = String.Format(" catepath like '{0}%'", CategoryPath); where += " and status = " + (int)ProductStatus.架; if (BrandID != 0) { where += " and pdproduct.brandid=" + BrandID; } if (PriceRange != null && PriceRange.Length == 2) { if (PriceRange[1] == 0) { where += String.Format(" and pdproduct.merchantprice >= {0} ", PriceRange[0]); } else { where += String.Format(" and pdproduct.merchantprice >= {0} and pdproduct.merchantprice <= {1}", PriceRange[0], PriceRange[1] + 0.99M); } } pageinfo.FieldNames = "[ProductId],[ProductName],[ProductCode],[CatePath],[CateId],[TradePrice],[MerchantPrice],[ReducePrice],[Stock],[SmallImage],[MediumImage],[LargeImage],[Keywords],[Brief],[PageView],[InsertTime],[ChangeTime],[Status],[SortValue],[Score]"; pageinfo.OrderType = "SortValue asc"; pageinfo.PageIndex = PageIndex; pageinfo.PageSize = Config.ListPageSize; pageinfo.PriKeyName = "ProductId"; pageinfo.StrWhere = where; pageinfo.TableName = "pdproduct"; pageinfo.OrderType = GetOrderString(OrderType); pageinfo.TotalFieldStr = ""; pageinfo.TotalItem = 0; pageinfo.TotalPage = 0; DataTable dt = CommDataHelper.GetDataFromSingleTableByPage(pageinfo).Tables[0]; RecordCount = pageinfo.TotalItem; PageCount = pageinfo.TotalPage; return(dt); }
public DataTable GetList(int PageIndex, int PageSize, string Condition, out int RecordCount) { SearchPageInfo info = new SearchPageInfo(); info.FieldNames = "*"; info.OrderType = " newsid desc"; info.PageIndex = PageIndex; info.PageSize = PageSize; info.PriKeyName = "newsid"; info.StrJoin = ""; info.StrWhere = " 1=1 " + Condition; info.TableName = "nenews"; info.TotalFieldStr = ""; DataTable dt = CommDataHelper.GetDataFromSingleTableByPage(info).Tables[0]; RecordCount = info.TotalItem; return(dt); }
public DataSet GetList(int PageIndex, int PageSize, string Condition, out int RecordCount) { SearchPageInfo info = new SearchPageInfo(); info.FieldNames = "*"; info.OrderType = " showorder desc"; info.PageIndex = PageIndex; info.PageSize = PageSize; info.PriKeyName = "brandid"; info.StrJoin = ""; info.StrWhere = " 1=1 " + Condition; info.TableName = "pdbrand"; info.TotalFieldStr = ""; DataSet ds = CommDataHelper.GetDataFromSingleTableByPage(info); RecordCount = info.TotalItem; return ds; }
public DataTable GetNewsList(int PageIndex, int PageSize, int CategoryID, out int RecordCount, out int PageCount) { SearchPageInfo pageinfo = new SearchPageInfo(); string where = String.Format(" dbo.GetNewsCategoryPath(cateid)+'/' like dbo.GetNewsCategoryPath({0})+'/%'", CategoryID); pageinfo.FieldNames = "*"; pageinfo.OrderType = "newsid desc"; pageinfo.PageIndex = PageIndex; pageinfo.PageSize = PageSize; pageinfo.PriKeyName = "newsid"; pageinfo.StrWhere = where; pageinfo.TableName = "nenews"; pageinfo.TotalFieldStr = ""; pageinfo.TotalItem = 0; pageinfo.TotalPage = 0; DataTable dt = CommDataHelper.GetDataFromSingleTableByPage(pageinfo).Tables[0]; RecordCount = pageinfo.TotalItem; PageCount = pageinfo.TotalPage; return(dt); }