当前位置: 代码迷 >> .NET组件控件 >> ext.net panel服务器分页,该如何解决
  详细解决方案

ext.net panel服务器分页,该如何解决

热度:9426   发布时间:2013-02-25 00:00:00.0
ext.net panel服务器分页
分页我用的是PagingToolbar
连接的sql
代码:
<ext:Store ID="Store1" runat="server" OnRefreshData="Store1_RefershData" AutoLoad="true">
    <Reader>
        <ext:JsonReader>
               <Fields>
                    <ext:RecordField Name="LogID" />
                    <ext:RecordField Name="Module" />
                    <ext:RecordField Name="Operate" />
                    <ext:RecordField Name="Content" />
                    <ext:RecordField Name="UserName" />
                    <ext:RecordField Name="UserRole" />
                    <ext:RecordField Name="CreateTime" Type="Date" />
                </Fields>
         </ext:JsonReader>
     </Reader>
</ext:Store>

后台
   protected void Store1_RefershData(object sender, StoreRefreshDataEventArgs e)
        {
            int PageSize = this.pagecut.PageSize; //获取当前在页面中PagingToolBar 的PageSize的值
            int Count = 0;
            int CurPage = e.Start / PageSize + 1; //获取当前的页码是多少,也就是第几页

            string strWhere = "1=1";

            var store = this.GPLog.GetStore();

            //    store.DataSource = list;
            //    store.DataBind();

            DataTable dt = m_QueryPagination("P_log", "LogID,Module,Operate,Content,UserName,UserRole,CreateTime", strWhere, PageSize, CurPage, out Count); //连接数据库
            e.Total = Count;

            this.pagecut.DisplayMsg = CurPage + " - " + PageSize + "条 共 " + e.Total + " 条";
            if (Count > 0)
            {

                store.DataSource = dt;//绑定数据