代码拉取完成,页面将自动刷新
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;
}
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。