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


C# DBFunctions.getQuestion_Count方法代码示例

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


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

示例1: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        string pagename = Path.GetFileName(Request.PhysicalPath);
        DBFunctions db = new DBFunctions();
        bool LoggedStatus = false;
        if (System.Web.HttpContext.Current.User != null)
        {
            LoggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
            if (LoggedStatus)
            {
                UserID = Membership.GetUser().ProviderUserKey.ToString();
                int pageStart = 1;
                int pageEnd = 5;
                if (Request.QueryString.ToString().Contains("page"))
                {
                    page = Convert.ToInt32(Request.QueryString["page"].ToString());
                    pageEnd = pageSize * page;
                    pageStart = (pageEnd - pageSize) + 1;
                }


                List<Support_tbl> ds = new List<Support_tbl>();
                DatabaseFunctions d = new DatabaseFunctions();
                int userid = d.GetCandidateID(UserID);
                ds = db.getQuestionlist(userid, page - 1, pageSize);


                literalStart.Text = pageStart.ToString();
                literalEnd.Text = pageEnd.ToString();

                int tmpPageEnd = 0;
                tmpPageEnd = pageEnd;

                pageEnd = db.getQuestion_Count(userid);



                if (pageEnd > 5)
                {
                    literalTotal.Text = pageEnd.ToString();

                    int pagett = 0;
                    pagett = Convert.ToInt16(literalEnd.Text);

                    if (pagett > pageEnd)
                    {
                        literalEnd.Text = pageEnd.ToString();
                    }

                }
                else
                {
                    if (pageEnd == 0)
                    {
                        literalStart.Text = "";
                    }
                    literalTotal.Text = pageEnd.ToString();
                    literalEnd.Text = pageEnd.ToString();
                }


                string tmpUrl = string.Empty;
                tmpUrl = "AddDateSheet.aspx?" + Request.QueryString.ToString();
                if (tmpUrl.Contains("?page"))
                {
                    tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page"));
                }

                StringBuilder listingString = new StringBuilder();

                if (ds != null)
                {
                    loadQuestion(ds);
                }


                if (pageEnd > 5)
                {
                    StringBuilder paging = new StringBuilder();
                    int counterPage = 1;
                    int totalPages = 1;

                    totalPages = (pageEnd / 5) + 1;
                    string urlMain = string.Empty;
                    urlMain = Request.Url.ToString();
                    if (urlMain.Contains("?page"))
                    {
                        urlMain = urlMain.Remove(urlMain.IndexOf("?page"));
                    }

                    for (int i = 1; i <= totalPages; i++)
                    {
                        string newPageString = string.Empty;


                        if (i == 1)
                        {

                            newPageString = "<li><a aria-label=\"First\"  href=\"" + urlMain + "\" >&lt;&lt;</a></li>";
                            if (page == i)
//.........这里部分代码省略.........
开发者ID:EezeSolutions,项目名称:Higher_Erp,代码行数:101,代码来源:AskQuestion.aspx.cs

示例2: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
         string pagename = Path.GetFileName(Request.PhysicalPath);
         if (Session["admin"] != null)
         {
             DBFunctions db = new DBFunctions();

             int pageStart = 1;
             int pageEnd = 10;
             if (Request.QueryString.ToString().Contains("page"))
             {
                 page = Convert.ToInt32(Request.QueryString["page"].ToString());
                 pageEnd = pageSize * page;
                 pageStart = (pageEnd - pageSize) + 1;
             }


             List<Support_tbl> ds = new List<Support_tbl>();

             //pass user id as paremeter
             ds = db.getQuestionlist(pageSize, page - 1);


             literalStart.Text = pageStart.ToString();
             literalEnd.Text = pageEnd.ToString();

             int tmpPageEnd = 0;
             tmpPageEnd = pageEnd;

             pageEnd = db.getQuestion_Count();



             if (pageEnd > 10)
             {
                 literalTotal.Text = pageEnd.ToString();

                 int pagett = 0;
                 pagett = Convert.ToInt16(literalEnd.Text);

                 if (pagett > pageEnd)
                 {
                     literalEnd.Text = pageEnd.ToString();
                 }

             }
             else
             {
                 if (pageEnd == 0)
                 {
                     literalStart.Text = "";
                 }
                 literalTotal.Text = pageEnd.ToString();
                 literalEnd.Text = pageEnd.ToString();
             }


             string tmpUrl = string.Empty;
             tmpUrl = "AskedQuestions.aspx?" + Request.QueryString.ToString();
             if (tmpUrl.Contains("?page"))
             {
                 tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page"));
             }

             StringBuilder listingString = new StringBuilder();

             if (ds != null)
             {
                 loadQuestion(ds);
             }


             if (pageEnd > 10)
             {
                 StringBuilder paging = new StringBuilder();
                 int counterPage = 1;
                 int totalPages = 1;

                 totalPages = (pageEnd / 10) + 1;
                 string urlMain = string.Empty;
                 urlMain = Request.Url.ToString();
                 if (urlMain.Contains("?page"))
                 {
                     urlMain = urlMain.Remove(urlMain.IndexOf("?page"));
                 }

                 for (int i = 1; i <= totalPages; i++)
                 {
                     string newPageString = string.Empty;


                     if (i == 1)
                     {

                         newPageString = "<li><a aria-label=\"First\"  href=\"" + urlMain + "\" >&lt;&lt;</a></li>";
                         if (page == i)
                         {
                             newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
                         }
                         else
//.........这里部分代码省略.........
开发者ID:EezeSolutions,项目名称:Higher_Erp,代码行数:101,代码来源:AskedQuestions.aspx.cs


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