ASP.NET中使用ObjectDataSource空间运用多层架构、存储过程实现分页

Question

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace SQLServerDAL
{
    public class MyTableAccess:IDAL.IMyTable
    {
        private const string PROC_PAGEDDATA = "up_PagedData";
        private const string PROC_GETRECORDCOUNT = "up_GetRecordCount";        private const string PARM_RECORDINDEX = "recordIndex";
        private const string PARM_PAGESIZE = "pageSize";        public List<Model.MyTableInfo> GetList(int recordIndex, int pageSize)
        {
            List<Model.MyTableInfo> list =
                new List<Model.MyTableInfo>();            SqlParameter[] parms = new SqlParameter[] { 
                new SqlParameter(PARM_RECORDINDEX,recordIndex),
                new SqlParameter(PARM_PAGESIZE,pageSize)
            };            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,
                PROC_PAGEDDATA, parms))
            {
                while (dr.Read())
                {
                    Model.MyTableInfo item =
                        new Model.MyTableInfo();
                    item.RowNumber = Convert.ToInt32(dr["rowNumber"]);
                    item.C1 = Convert.ToInt32(dr["c1"]);
                    item.C2 = dr["c2"].ToString();                    list.Add(item);
                }
            }            return list;
        }        public int GetRecordCount()
        {
            SqlParameter parm = new SqlParameter("@returnValue", SqlDbType.Int, 4);
            parm.Direction = ParameterDirection.ReturnValue;            SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,
                PROC_GETRECORDCOUNT, parm);            return Convert.ToInt32(parm.Value);
        }
    }
}
     帮忙解释一下！！

Answer 1

recordIndex, int pageSize表示页码和每页显示数据数
GetRecordCount获取记录数
using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,
  PROC_PAGEDDATA, parms))
执行存储过程获取数据，遍历添加到List<T>