分页三层

最新推荐文章于 2021-12-13 02:02:22 发布

t1061169865

最新推荐文章于 2021-12-13 02:02:22 发布

阅读量444

点赞数

分类专栏：数据库文章标签：分页笔记

本文链接：https://blog.csdn.net/t1061169865/article/details/8962352

版权

数据库专栏收录该内容

10 篇文章 0 订阅

订阅专栏

前台：

<head runat="server">
    <title></title>
    <script src="js/Jquery1.7.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $('#txtPageindex').focus(function () {
                $(this).val("");
            })
        })
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="230px"
            Width="859px">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="编号" />
                <asp:BoundField DataField="NewsTitle" HeaderText="标题" />
                <asp:BoundField DataField="NewsContent" HeaderText="内容" />
                <asp:BoundField DataField="CreateTime" DataFormatString="{0:yyyy-MM-dd hh:mm:ss}"
                    HeaderText="创建时间" />
            </Columns>
        </asp:GridView>
    </div>
    <div>
        <asp:LinkButton ID="btnFirst" runat="server" οnclick="btnFirst_Click">第一页</asp:LinkButton>
        <asp:LinkButton
            ID="btnPre" runat="server" οnclick="btnPre_Click">上一页</asp:LinkButton>
        <asp:LinkButton ID="btnNext"
                runat="server" οnclick="btnNext_Click">下一页</asp:LinkButton>
        <asp:LinkButton ID="btnLast" runat="server" οnclick="btnLast_Click">最后一页</asp:LinkButton><asp:TextBox
                    ID="txtPageindex" runat="server"></asp:TextBox>
        <asp:LinkButton ID="LinkButton5" runat="server" οnclick="LinkButton5_Click">Go</asp:LinkButton>
    </div>
    </form>
</body>

后台：

namespace WebApplication1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        int pagesize = 10;
        int pageindex = 1;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["pageindex"] = 1;
                GetLastPageindex();
                LoadData();
            }
        }
        private void GetLastPageindex()
        {
            BLL.T_News1 bnews = new BLL.T_News1();
            int totalcount= bnews.GetRecordCount("");
            if (totalcount % pagesize == 0)
            {
                ViewState["lastpageindex"] = totalcount / pagesize;
            }
            else
            {
                ViewState["lastpageindex"] = totalcount / pagesize+1;
            }
        }
        private void LoadData()
        {
            BLL.T_News1 bnews = new BLL.T_News1();
            DataTable dt = bnews.GetListDataTable(pagesize, Convert.ToInt32(ViewState["pageindex"]));
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
        }

        protected void btnFirst_Click(object sender, EventArgs e)
        {
            ViewState["pageindex"] = 1;
            LoadData();
        }

        protected void btnPre_Click(object sender, EventArgs e)
        {
            int pageindex = Convert.ToInt32(ViewState["pageindex"]);
            if (pageindex>1)
            {
                pageindex--;
                ViewState["pageindex"] = pageindex;
                LoadData();
            }
        }

        protected void btnNext_Click(object sender, EventArgs e)
        {
            int pageindex = Convert.ToInt32(ViewState["pageindex"]);
            if (pageindex<Convert.ToInt32(ViewState["lastpageindex"]))
            {
                pageindex++;
                ViewState["pageindex"] = pageindex;
                LoadData();
            }
        }

        protected void btnLast_Click(object sender, EventArgs e)
        {
            ViewState["pageindex"] = ViewState["lastpageindex"];
            LoadData();
        }

        protected void LinkButton5_Click(object sender, EventArgs e)
        {
            int result;
            if (int.TryParse(txtPageindex.Text, out result) == true)
            {
                ViewState["pageindex"] = txtPageindex.Text.Trim();
                LoadData();
            }
            else
            {
                txtPageindex.Text = "请输入合法的数字";
            }

        }
    }
}

BLL

public int GetRecordCount(string strWhere)
  {
   return dal.GetRecordCount(strWhere);
  }

public DataTable GetListDataTable(int pagesize, int pageindex)
        {
            return dal.GetListDataTable(pagesize, pageindex);
        }

DAL

public int GetRecordCount(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select count(1) FROM T_News1 ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   object obj = DbHelperSQL.GetSingle(strSql.ToString());
   if (obj == null)
   {
    return 0;
   }
   else
   {
    return Convert.ToInt32(obj);
   }
  }

public DataTable GetListDataTable(int PageSize, int PageIndex)
        {
            SqlParameter[] parameters = {

     new SqlParameter("@PageSize", SqlDbType.Int),
     new SqlParameter("@PageIndex", SqlDbType.Int)
     };

            parameters[0].Value = PageSize;
            parameters[1].Value = PageIndex;
            return DbHelperSQL.RunProcedureDataTable("pro_fenye", parameters);
        }