.net多表查询分页存储过程，第一页正常，第二页..都出错

 int currPage = 1;

        int PageSize =40;

        string tabeName = "TableOrders as a left join Customer as b on a.CustomerID=b.CustomerID  left join UseCompanyIp as c on a.OrderID=c.OrderID  left join Staff as e on a.StaffID=e.StaffID";

        string strFide = "(a.RenewalFee+a.ModificationCost) AS moneycount,a.PaymentCycle,a.ModificationCost,a.SerialNumber,a.state,a.Technology,a.RenewalStatus,a.RenewalFee,a.OldExpirationDate,a.RenewalDate,a.OrderID,a.OrderDate,a.ExpirationDate,a.Remarks,a.StaffID,a.CustomerID,a.PackageID,a.ProductID,b.CustomerName,b.Taofc,c.IpAddress,e.StaffName";

        string strSortKey = "a.OrderID";

        string strSortField = "a.ExpirationDate ";

        public void Bind()

        {



            int pageCount;

            int RecordCount;

         

            Repeater1.DataSource = tableorder.GetPagetable(tabeName, strFide, PageSize,currPage, out pageCount, out RecordCount, strSortField, strSortKey);



            Repeater1.DataBind();



            this.AspNetPager1.RecordCount = RecordCount;



            this.AspNetPager1.CurrentPageIndex = currPage;



            this.AspNetPager1.PageSize = PageSize;



        }

   public DataTable GetPagetable(string TableNames, string Fields, int PageSize, int page, out int pageCount, out int RecordCount, string fldSort, string ID)

       {

           pageCount = 0;



           RecordCount = 0;

           DataTable datatable = new DataTable();

           using (SqlConnection conn = new SqlConnection(SQLHelper.scon))

           {

               SqlCommand objcmd = new SqlCommand("proc_ListPage", conn);



               objcmd.CommandType = CommandType.StoredProcedure;



               SqlParameter[] para ={



       new SqlParameter("@tblName",SqlDbType.VarChar,-1),



       new SqlParameter("@fldName",SqlDbType.VarChar,-1),



       new SqlParameter("@pageSize",SqlDbType.Int),



       new SqlParameter("@page",SqlDbType.Int),



       new SqlParameter("@pageCount",SqlDbType.Int),



       new SqlParameter("@Counts",SqlDbType.Int),



       new SqlParameter("@fldSort",SqlDbType.VarChar,-1),



       new SqlParameter("@Sort",SqlDbType.Bit),



       new SqlParameter("@ID",SqlDbType.VarChar,-1),





       };



               para[0].Value = TableNames;

               para[1].Value = Fields;



               para[2].Value = PageSize;



               para[3].Value = page;



               para[4].Value = pageCount;

               para[4].Direction = ParameterDirection.Output;

               para[5].Value = RecordCount;

               para[5].Direction = ParameterDirection.Output;

               para[6].Value = fldSort;



               para[7].Value = 1;

               para[8].Value = ID;

       



               objcmd.Parameters.AddRange(para);



               conn.Open();

               SqlDataAdapter adapter = new SqlDataAdapter(objcmd);

               adapter.Fill(datatable);



               RecordCount = Convert.ToInt32(objcmd.Parameters["@Counts"].Value);

               pageCount = Convert.ToInt32(objcmd.Parameters["@pageCount"].Value);

               conn.Close();

               conn.Dispose();



           }

           return datatable;

       }