来源：互联网发布：网络离婚证免费制作编辑：程序博客网时间：2024/05/16 18:31

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);
                }
            }
        }

文章上一篇,下一篇