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


C# DBFunctions.getroomslist方法代码示例

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


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

示例1: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        DBFunctions db = new DBFunctions();

        string pagename = Path.GetFileName(Request.PhysicalPath);

        if (System.Web.HttpContext.Current.User != null)
        {
                UserID = Membership.GetUser().ProviderUserKey.ToString();
                bool LoggedStatus = false;
                LoggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
                if (LoggedStatus)
                {
                    if (!IsPostBack)
                    {



                        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<HostelRoom_tbl> ds = new List<HostelRoom_tbl>();
                        ds = db.getroomslist(page - 1, pageSize);


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

                        int tmpPageEnd = 0;
                        tmpPageEnd = pageEnd;

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

                        StringBuilder listingString = new StringBuilder();

                        if (ds != null)
                        {
                            loadRooms(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;


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

示例2: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        DBFunctions db = new DBFunctions();


        

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


            List<HostelRoom_tbl> ds = new List<HostelRoom_tbl>();
            ds = db.getroomslist(page - 1, pageSize);


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

            int tmpPageEnd = 0;
            tmpPageEnd = pageEnd;

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

            StringBuilder listingString = new StringBuilder();

            if (ds != null)
            {
                loadRooms(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,代码来源:RoomsList.aspx.cs


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