DataTable dt = new DAL.Views.V_UserBlogPosts().Open("", "[UserID] = (select UserID from V_UserBlogPosts where [ID] = " + hfId.Value + ") and isShow = 1", "[DateTime] desc");
if (dt != null)
{
hfPages.Value = dt.Rows.Count.ToString();
DataRow[] drs = dt.Select("id = " + hfId.Value);
if (drs != null && drs.Length > 0)
{
lblTitle.Text = drs[0]["Title"].ToString();
lblTime.Text = drs[0]["DateTime"].ToString();
lblField.Text = drs[0]["FieldName"].ToString();
lblContent.Text = drs[0]["Content"].ToString();
lblReadCount.Text = drs[0]["ShowedCount"].ToString();
lblGoodComment.Text = drs[0]["GoodCommentCount"].ToString();
int Index = dt.Rows.IndexOf(drs[0]);
hfCurrPage.Value = (Index + 1).ToString();
if (Index + 1 == dt.Rows.Count && Index != 0)
{
lblPrevOrNext.Text = "上一篇: <a href='BlogDetails.aspx?id=" + dt.Rows[Index - 1]["ID"].ToString() + "'>" + dt.Rows[Index - 1]["Title"].ToString() + "</a>";
}
else if (Index == 0 )
{
lblPrevOrNext.Text = "下一篇: <a href='BlogDetails.aspx?id=" + dt.Rows[Index + 1]["ID"].ToString() + "'>" + dt.Rows[Index + 1]["Title"].ToString() + "</a>";
}
else
{
lblPrevOrNext.Text = "上一篇: <a href='BlogDetails.aspx?id=" + dt.Rows[Index - 1]["ID"].ToString() + "'>" + dt.Rows[Index - 1]["Title"].ToString() + "</a> 下一篇: <a href='BlogDetails.aspx?id=" + dt.Rows[Index + 1]["ID"].ToString() + "'>" + dt.Rows[Index + 1]["Title"].ToString() + "</a>";
}
dt = new DAL.Tables.T_UserBlogPostComments().Open("", "[BlogPostID] = " + hfId.Value, "[DateTime] desc");
if (dt != null)
{
lblComment.Text = dt.Rows.Count.ToString();
hfCommentPages.Value = (dt.Rows.Count % 30 == 0 ? dt.Rows.Count / 30 : dt.Rows.Count / 30 + 1).ToString();
ddlPages.Items.Clear();
for (int i = 1; i <= Convert.ToInt32(hfCommentPages.Value); i++)
{
ddlPages.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
GetComments(1);
}
}
}