///<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
//{
//}
}
