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


C# DBFunctions.getBook_Count方法代码示例

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


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

示例1: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        bool loggedStatus = false;
        DBFunctions db = new DBFunctions();
        string pagename = Path.GetFileName(Request.PhysicalPath);

        if (System.Web.HttpContext.Current.User == null)
        {
            Response.Redirect("Login.aspx?Redirecturl=" + pagename);
        }
        else
        {
            loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
            if (loggedStatus)
            {
                DatabaseFunctions d = new DatabaseFunctions();

                UserID = Membership.GetUser().ProviderUserKey.ToString();
                int stid = d.GetCandidateID(UserID);
                if (stid != -1)
                {
                    var chk = db.getLirarymember(stid);
                    backlink.Text = "<a href='#0' class='btn btn-primary' onclick='history.back()'>Back</a>";

                    if (chk == null)
                    {
                        searchcontrols.Visible = false;
                        pagingdiv.Visible = false;
                        tblbooks.Visible = false;
                        membermsg.Visible = true;
                        linkmemebrship.Visible = true;
                        membermsg.InnerText = "Your Do Not Have The Library Membership..!!";

                        //var stdent = db.getstdentinfo(stid);
                        //nametxt.Text = stdent.Candidate_tbl.Name;
                        //metricno.Text = stdent.Candidate_tbl.AddmissionList_tbl.FirstOrDefault().MetricNo;
                        //programme.Text = stdent.Program_tbl.ProgramName;
                        return;
                    }
                    else if (chk.Status == 0)
                    {
                        tblbooks.Visible = false;
                        searchcontrols.Visible = false;
                        pagingdiv.Visible = false;

                        membermsg.Visible = true;
                        //membershipform.Visible = false;
                        //membermsg.Visible = true;
                        membermsg.InnerText = "Your Request For Library Membership is Pending..!!";
                        return;
                    }

                    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<Book> ds = new List<Book>();



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

                    int tmpPageEnd = 0;
                    tmpPageEnd = pageEnd;

                    pageEnd = db.getBook_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();
                    }


//.........这里部分代码省略.........
开发者ID:EezeSolutions,项目名称:Higher_Erp,代码行数:101,代码来源:AvailableBooks.aspx.cs

示例2: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        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<Book> ds = new List<Book>();
        ds = db.getbooklist(page-1, pageSize);


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

        int tmpPageEnd = 0;
        tmpPageEnd = pageEnd;

        pageEnd = db.getBook_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 = "ManageCourses.aspx?" + Request.QueryString.ToString();
        if (tmpUrl.Contains("?page"))
        {
            tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page"));
        }

        StringBuilder listingString = new StringBuilder();

        if (ds != null)
        {
            loadBooks(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
                    {
                        newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
//.........这里部分代码省略.........
开发者ID:EezeSolutions,项目名称:Higher_Erp,代码行数:101,代码来源:AddBooks.aspx.cs


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