///<summary> /// 帮定分页数据 ///</summary> /// void BindData(string key = null) { // try // { IQueryable <书名表> ListSource = null; string 分类标识 = string.Empty; key = GetKeyWord(); if (key == null) { if (GetBooksType() != "-3") { decimal lx = 0; if (decimal.TryParse(GetBooksType(), out lx)) { //如果是分类 if (lx > 0) { ListSource = Tygdb.书名表.Where(p => p.分类表ID == lx && p.最新章节 != null && p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); TypeName = ListSource.Count() > 0 ? ListSource.FirstOrDefault().分类标识 : string.Empty; } //完本 if (lx == -1) { TypeName = "完本"; ListSource = Tygdb.书名表.Where(p => p.完本 && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } //连载 if (lx == -2) { TypeName = "连载"; ListSource = Tygdb.书名表.Where(p => !p.完本 && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } } } else { ListSource = Tygdb.书名表.Where(p => p.最新章节 != null && p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } } else { ListSource = Tygdb.书名表.Where(p => p.书名.Contains(key) || p.作者名称.Contains(key)).OrderByDescending(p => p.最后更新时间); //AspNetPager1.CurrentPageIndex = 1; } list = ListSource.Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)).Take(AspNetPager1.PageSize); bookList = (from p in list select new BookListItem() { 书名 = p.书名 }).ToList(); //foreach (var book in list) //{ // string url = book.GetHTMLFilePath(); // book.首发地址 = System.IO.File.Exists(System.IO.Path.GetFullPath(AppDomain.CurrentDomain.BaseDirectory + url)) ? url : "BookIndex.aspx?guid=" + book.GUID; //} ShowNews.DataSource = list; ShowNews.DataBind(); AspNetPager1.RecordCount = ListSource.Count(); // AspNetPager1.UrlRewritePattern = "/aspnet/testPargrameDir/site/NewsList.aspx?CloumnID=" + CloumnID + "&SendentID=" + SendentID + "&page={0}"; //AspNetPager1.UrlRewritePattern = "tow/List" + CloumnID + "-" + SendentID + "-{0}.aspx"; #region AspNetPager1 实现静态页面分页 //如果没有搜索的时候 if (string.IsNullOrEmpty(GetKeyWord())) { AspNetPager1.UrlRewritePattern = "/Book/" + TypeName.ToPingYing() + "/" + GetBooksType() + "/{0}.aspx"; } else { //有搜索关键字的时候 AspNetPager1.UrlRewritePattern = "/Search/" + key.ToPingYing() + "/" + Server.UrlEncode(key) + "/{0}.aspx"; } ///以下代码开始给 AspNetPager1 实现静态页面分页 //Tong.ThisSiteUse.CreateSitePageList TextPageList = new Tong.ThisSiteUse.CreateSitePageList(SendentID, AspNetPager1.PageCount); //TextPageList.Start(); #endregion //} //catch //{ //} }
///<summary> /// 帮定分页数据 ///</summary> /// void BindData(string key = null) { // try // { IEnumerable <书名表> ListSource = new List <书名表>(); if (key == null) { if (Request.QueryString["lx"] != null) { decimal lx = 0; if (decimal.TryParse(Request.QueryString["lx"], out lx)) { //如果是分类 if (lx > 0) { ListSource = Tygdb.书名表.Where(p => p.分类表ID == lx && p.最新章节 != null && p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } //完本 if (lx == -1) { ListSource = Tygdb.书名表.Where(p => p.完本 && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } //连载 if (lx == -2) { ListSource = Tygdb.书名表.Where(p => !p.完本 && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } } } else { ListSource = Tygdb.书名表.Where(p => p.最新章节 != null && p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); } } else { ListSource = Tygdb.书名表.Where(p => p.书名.Contains(key) || p.作者名称.Contains(key)).OrderByDescending(p => p.最后更新时间).ToList(); AspNetPager1.CurrentPageIndex = 1; } list = ListSource.Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1)).Take(AspNetPager1.PageSize).ToList(); //foreach (var book in list) //{ // string url = book.GetHTMLFilePath(); // book.首发地址 = System.IO.File.Exists(System.IO.Path.GetFullPath(AppDomain.CurrentDomain.BaseDirectory + url)) ? url : "BookIndex.aspx?guid=" + book.GUID; //} ShowNews.DataSource = list; ShowNews.DataBind(); AspNetPager1.RecordCount = ListSource.Count(); // AspNetPager1.UrlRewritePattern = "/aspnet/testPargrameDir/site/NewsList.aspx?CloumnID=" + CloumnID + "&SendentID=" + SendentID + "&page={0}"; //AspNetPager1.UrlRewritePattern = "tow/List" + CloumnID + "-" + SendentID + "-{0}.aspx"; #region AspNetPager1 实现静态页面分页 //AspNetPager1.UrlRewritePattern = TextThisSite.SiteGetColumnDirLink(SendentID) + "{0}.html"; ///以下代码开始给 AspNetPager1 实现静态页面分页 //Tong.ThisSiteUse.CreateSitePageList TextPageList = new Tong.ThisSiteUse.CreateSitePageList(SendentID, AspNetPager1.PageCount); //TextPageList.Start(); #endregion //} //catch //{ //} }