使用存储过程实现万能分页后台代码示例

        

//底层代码
        public Pages DisPlay(PageParams json)
         {
             int size = json.PageSize;
             SqlParameter[] par = {
                 new SqlParameter ("@tableName",json.TableName),
                 new SqlParameter ("@indexCol ",json.IndexCol),
                 new SqlParameter ("@pageSize ",json.PageSize),
                 new SqlParameter ("@pageIndex",json.PageIndex),
                 new SqlParameter ("@orderCol ",json.OrderCol ),
                 new SqlParameter ("@where    ",json.Where    ),
                 new SqlParameter ("@columns  ",json.Columns  ),
             };
             DataSet ds = DbHelperSQL.ExecuteDataset(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, "p_paging", par);
             DataTable dt = ds.Tables[0];
             int tCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
             int tPage = tCount / size + (tCount % size > 0 ? 1 : 1);
             Pages data = new Pages();
             data.SumCount = tCount;
             data.SumPage = tPage;
             data.list = dt;
             return data;
         }

          
         //控制器代码
         static string Where = ""; //拼接条件
         static int index = 1;  // 当前页