1 Star 1 Fork 0

messense / WebFormBlog

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
Archive.aspx.cs 2.20 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
messense 提交于 2013-07-27 15:22 . add next-prev post/archive
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebFormBlog
{
public partial class Archive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str_year = Convert.ToInt32(Request.QueryString["year"]).ToString();
PageTitleLiteral.Text = str_year;
YearLiteral.Text = str_year;
int year = Convert.ToInt32(str_year);
/* Dataset Query
BlogDataSetTableAdapters.postTableAdapter pta = new BlogDataSetTableAdapters.postTableAdapter();
PostListRepeater.DataSource = pta.GetDataByYear(str_year);
PostListRepeater.DataBind();
*/
BlogModel.BlogEntities db = new BlogModel.BlogEntities();
var posts = from post in db.posts
where post.created_at.Year == year
orderby post.id descending
select post;
PostListRepeater.DataSource = posts;
PostListRepeater.DataBind();
var prev_year = (from post in db.posts
where post.created_at.Year < year
orderby post.id descending
select post.created_at.Year).FirstOrDefault();
var next_year = (from post in db.posts
where post.created_at.Year > year
orderby post.id ascending
select post.created_at.Year).FirstOrDefault();
if (prev_year > 0)
{
prev.Attributes["href"] = "Archive.aspx?year=" + prev_year;
prev.Title = prev_year.ToString();
}
else
{
prev.Visible = false;
}
if (next_year > 0)
{
next.Attributes["href"] = "Archive.aspx?year=" + next_year;
next.Title = next_year.ToString();
}
else
{
next.Visible = false;
}
}
}
}
C#
1
https://gitee.com/messense/webformblog.git
git@gitee.com:messense/webformblog.git
messense
webformblog
WebFormBlog
master

搜索帮助

14c37bed 8189591 565d56ea 8189591