C# 后台调用 分页存存过程

 public DataTable getFenYeList(FenyeM FM)

    {    

         SqlParameter[] prams ={new SqlParameter("@tblName",SqlDbType .NVarChar ),      

                         new SqlParameter ("@fldName",SqlDbType .NVarChar ),               

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

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

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

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

                       new SqlParameter("@ID",SqlDbType .NVarChar ),     

                             new SqlParameter("@fldSort",SqlDbType .NVarChar ),       

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

               new  SqlParameter("@strCondition",SqlDbType.NVarChar )        };  

      prams[0].Value = FM.Tblname;   

     prams[1].Value = FM.Fldname;  

      prams[2].Value = FM.PageSize;      

  prams[3].Value = FM.Page;   

     prams[4].Direction = ParameterDirection.Output;     

   prams[5].Direction = ParameterDirection.Output; 

       prams[6].Value = FM.Id;   

     prams[7].Value = FM.FldSort;  

      prams[8].Value = FM.Sort;  

      prams[9].Value = FM.StrCondition;    

          try      

  { 

       DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.ConnectionString, CommandType.StoredProcedure, "SP_SqlFenYe", prams);

            FM.PageCount = int.Parse(prams[4].Value.ToString());  

          FM.Counts = int.Parse(prams[5].Value.ToString());       

     return dt;       

 }    

    catch (Exception ex)  

      {      

      throw;   

     } 

   }