当前位置: 首页>>代码示例>>C#>>正文


C# DataLayer.GetBlogCommentCount方法代码示例

本文整理汇总了C#中DataLayer.GetBlogCommentCount方法的典型用法代码示例。如果您正苦于以下问题:C# DataLayer.GetBlogCommentCount方法的具体用法?C# DataLayer.GetBlogCommentCount怎么用?C# DataLayer.GetBlogCommentCount使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DataLayer的用法示例。


在下文中一共展示了DataLayer.GetBlogCommentCount方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            Session["CaptchaImageText"] = CaptchaImage.GenerateRandomCode(random);
        }

        if (!User.Identity.IsAuthenticated)
        {
            anonymousbox.Visible = true;
            anonymousbox2.Visible = true;
            cbxThumbsUp.Visible = false;
        }
        else
        {
            anonymousbox.Visible = false;
            anonymousbox2.Visible = false;
        }

        int iPageNumber = 0;
        if (Request.QueryString["p"] != null)
        {
            iPageNumber = Convert.ToInt32(Request.QueryString["p"]);
        }

        int iBlogID = 0;
        if (Request.QueryString["bid"] == null)
        {
            Response.Redirect("Blogs.aspx", true);
        }
        else
        {
            iBlogID = Convert.ToInt32(Request.QueryString["bid"]);
        }

        DataLayer dl = new DataLayer();
        int iMaxPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(dl.GetBlogCommentCount(iBlogID)) / 15m));
        pageNav1.NumPages = iMaxPages;
        pageNav2.NumPages = iMaxPages;
        DataTable dtBlog = dl.GetBlogBy_BlogID(iBlogID);
        if (dtBlog.Rows.Count == 0)
        {
            this.Title = "No Blog Found";
            blogtitle.InnerText = "No Blog Found";
            addcomment.Visible = false;
        }
        else
        {
            if (dtBlog.Rows[0].ItemArray[5].ToString() == "Members Only")
            {
                if (!User.Identity.IsAuthenticated)
                {
                    Session["resultColor"] = "#ff0000";
                    Session["resultTitle"] = "Members Only";
                    Session["resultMessage"] = "This is a members only blog.<br />You must log in first.";
                    Session["resultReturnURL"] = "Blogs.aspx";
                    Response.Redirect("Result.aspx", true);
                }
            }

            DataTable dtComments = dl.GetFifteenBlogCommentsBy_Page(iPageNumber, iBlogID);

            if (User.Identity.IsAuthenticated)
            {
                if (dl.GaveBlogThumbsUpAlready(iBlogID, User.Identity.Name) || (User.Identity.Name.ToLower() == dtBlog.Rows[0].ItemArray[1].ToString().ToLower()))
                {
                    cbxThumbsUp.Visible = false;
                }
                else
                {
                    cbxThumbsUp.Visible = true;
                }
            }

            this.Title = dtBlog.Rows[0].ItemArray[3].ToString();
            blogtitle.InnerText = dtBlog.Rows[0].ItemArray[3].ToString();
            postedby.InnerHtml = "Posted by <a href=\"Profile.aspx?member=" + dtBlog.Rows[0].ItemArray[1].ToString() + "\">" + dl.GetFullMemberNameBy_Email(dtBlog.Rows[0].ItemArray[1].ToString()) + "</a>&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;" + Convert.ToDateTime(dtBlog.Rows[0].ItemArray[2]).ToString("D") + "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;" + dl.GetBlogCommentCount(Convert.ToInt32(dtBlog.Rows[0].ItemArray[0])) + " Comment(s)&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;<!-- AddThis Button BEGIN --><script type=\"text/javascript\">var addthis_pub=\"chevex\"; var addthis_hide_embed = true;</script><a href=\"http://www.addthis.com/bookmark.php?v=20\" onmouseover=\"return addthis_open(this, '', '[URL]', '[TITLE]')\" onmouseout=\"addthis_close()\" onclick=\"return addthis_sendto()\"><img src=\"http://s7.addthis.com/static/btn/sm-share-en.gif\" width=\"83\" height=\"16\" alt=\"Bookmark and Share\" style=\"border:0;\"/></a><script type=\"text/javascript\" src=\"http://s7.addthis.com/js/200/addthis_widget.js\"></script><!-- AddThis Button END -->";
            blogcontent.InnerHtml = dtBlog.Rows[0].ItemArray[4].ToString().Replace("~", "") + "<br /><br /><b>" + dl.GetBlogThumbsUpCount(iBlogID).ToString() + " Thumbs Up!</b>";

            bool bColored = true;
            foreach (DataRow dr in dtComments.Rows)
            {
                string sEmail = "";
                string sLink = "";
                string sAvatar = "";
                string sName = "";
                string sSignature = "";

                if (dr.ItemArray[1].ToString().StartsWith("ANON"))
                {
                    string[] sSplit = dr.ItemArray[1].ToString().Split('|');
                    sLink = sSplit[2];
                    sAvatar = "images/MemberAvatars/no_avatar.gif";
                    sName = sSplit[1];
                }
                else
                {
                    DataTable dtMember = dl.GetMemberBy_Email(dr.ItemArray[1].ToString());

                    sEmail = dtMember.Rows[0].ItemArray[0].ToString();
//.........这里部分代码省略.........
开发者ID:chevex-archived,项目名称:ReferralNetworX,代码行数:101,代码来源:Blog.aspx.cs

示例2: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!User.Identity.IsAuthenticated)
        //{
        //    Session["resultColor"] = "#ff0000";
        //    Session["resultTitle"] = "Members Only";
        //    Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
        //    Session["resultReturnURL"] = "Blogs.aspx";
        //    Response.Redirect("Result.aspx", true);
        //}

        int iPageNumber = 0;
        if (Request.QueryString["p"] != null)
        {
            iPageNumber = Convert.ToInt32(Request.QueryString["p"]);
        }

        DataLayer dl = new DataLayer();
        int iBlogCount;

        DataTable dtBlogs;
        if (User.Identity.IsAuthenticated)
        {
            dtBlogs = dl.GetFiveBlogsBy_Page(iPageNumber, "Members Only");
            iBlogCount = dl.GetBlogCount("Members Only");
        }
        else
        {
            dtBlogs = dl.GetFiveBlogsBy_Page(iPageNumber, "Everyone");
            iBlogCount = dl.GetBlogCount("Everyone");
        }

        int iMaxPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(iBlogCount) / 5m));
        pageNav1.NumPages = iMaxPages;
        pageNav2.NumPages = iMaxPages;

        foreach (DataRow dr in dtBlogs.Rows)
        {
            if (dr.ItemArray[5].ToString() == "Members Only")
            {
                blogs.InnerHtml += "<div style=\"background-color:#ddddff; padding:5px;\"><div style=\"text-align:center;\">-= <i>Members Only Blog</i> =-</div><br />";
            }
            else
            {
                blogs.InnerHtml += "<div>";
            }
            blogs.InnerHtml += "<div style=\"text-align:left;font-size:35px;font-family:arial;\"><a class=\"navlink\" href=\"Blog.aspx?bid=" + dr.ItemArray[0].ToString() + "\">" + dr.ItemArray[3].ToString() + "</a></div>";
            blogs.InnerHtml += "<div style=\"text-align:left;\">Posted by <a href=\"Profile.aspx?member=" + dr.ItemArray[1].ToString() + "\">" + dl.GetFullMemberNameBy_Email(dr.ItemArray[1].ToString()) + "</a>&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;" + Convert.ToDateTime(dr.ItemArray[2]).ToString("D") + "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;" + dl.GetBlogCommentCount(Convert.ToInt32(dr.ItemArray[0])) + " Comment(s)</div><br />";
            string sBody = dr.ItemArray[4].ToString();
            if (sBody.Contains('~'))
            {
                sBody = sBody.Remove(sBody.IndexOf('~'));
                blogs.InnerHtml += "<div style=\"text-align:left;\"><table style=\"width:100%;\"><tr><td>" + dr.ItemArray[4].ToString().Remove(dr.ItemArray[4].ToString().IndexOf('~')) + "<br /><br /><b><a class=\"navlink\" href=\"Blog.aspx?bid=" + dr.ItemArray[0].ToString() + "\">(Read More)</a></b><br /></td></tr></table></div>";
            }
            else
            {
                blogs.InnerHtml += "<div><i>No Summary.</i><br /><br /><b><a class=\"navlink\" href=\"Blog.aspx?bid=" + dr.ItemArray[0].ToString() + "\">(Read More)</a></b><br /></div>";
            }
            blogs.InnerHtml += "</div><hr /><br />";
        }

        if (User.Identity.IsAuthenticated)
        {
            loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Featured Member</div><div class=\"contentpanel\">"));
            DataTable dtRandomMember = dl.GetRandomMember();
            loggedinpanels.Controls.Add(new LiteralControl("<table style=\"width:100%;\"><tr><td style=\"font-size:13px;text-align:center;\"><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\"><img style=\"border-width:0px;\" src=\"MakeThumbnail.aspx?size=100&image=images/MemberAvatars/" + dtRandomMember.Rows[0].ItemArray[3].ToString() + "\" /></a><br /><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\">View Profile</a></td><td style=\"padding-left:5px;font-size:13px;width:100%;\"><b>Name:</b> " + dtRandomMember.Rows[0].ItemArray[2].ToString() + "<br /><br /><b>Location:</b> " + dtRandomMember.Rows[0].ItemArray[17].ToString() + "<br /><br /><b>Business:</b> " + dtRandomMember.Rows[0].ItemArray[8].ToString() + "<br /><br />"));
            if (dtRandomMember.Rows[0].ItemArray[6].ToString() != "")
            {
                loggedinpanels.Controls.Add(new LiteralControl("<center><a href=\"" + dtRandomMember.Rows[0].ItemArray[6].ToString() + "\">Visit Website</a></center>"));
            }
            loggedinpanels.Controls.Add(new LiteralControl("</td></tr></table></div>"));
        }

        DataTable dtMemberAd = dl.GetRandomAd();
        loggedinpanels.Controls.Add(new LiteralControl("<div class=\"contenttitle\">Member Ad</div><div style=\"text-align:center;\" class=\"contentpanel\"><a href=\"" + dtMemberAd.Rows[0].ItemArray[2].ToString() + "\"><img style=\"width:230px; border-width:0px;\" src=\"" + dtMemberAd.Rows[0].ItemArray[1].ToString() + "\" /></a></div>"));

        if (User.Identity.IsAuthenticated)
        {
            loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Popular Topics</div><div style=\"font-size:15px;\" class=\"contentpanel\"><ul>"));
            DataTable dtTopics = dl.GetFiveTopics();
            foreach (DataRow dr in dtTopics.Rows)
            {
                loggedinpanels.Controls.Add(new LiteralControl("<li><a href=\"Topic.aspx?topic=" + dr.ItemArray[0].ToString() + "\">" + dr.ItemArray[4].ToString() + "</a></li>"));
            }
            loggedinpanels.Controls.Add(new LiteralControl("</ul></div>"));
        }
    }
开发者ID:chevex-archived,项目名称:ReferralNetworX,代码行数:87,代码来源:Blogs.aspx.cs


注:本文中的DataLayer.GetBlogCommentCount方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。