Asp.Net 调用分页存储过程

       数据库访问层：DAL

       /// <summary>
       /// 通过存储过程分页得到数据列表
       /// </summary>
       /// <param name="tableName">表名</param>
       /// <param name="column">列名</param>
       /// <param name="sort">排序</param>
       /// <param name="pageIndex">当前页码</param>
       /// <param name="pageSize">每页显示数据条数</param>
       /// <returns></returns>
        public List<BookShop_BookTypeModel> GetModelListByProc(string tableName,string column,string sort,int pageIndex,int pageSize)
        {
            List<BookShop_BookTypeModel> list = new List<BookShop_BookTypeModel>();
            string connStr = ConfigurationManager.AppSettings["DbLink"].ToString();  //连接字符串
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("procPaging", conn); //存储过程的名称和sql连接字符串
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter sp1 = new SqlParameter("@tablename", SqlDbType.NVarChar, 100);
                sp1.Value = tableName;
                cmd.Parameters.Add(sp1);
                SqlParameter sp2 = new SqlParameter("@column", SqlDbType.NVarChar, 100);
                sp2.Value = column;
                cmd.Parameters.Add(sp2);
                SqlParameter sp3 = new SqlParameter("@sort", SqlDbType.NVarChar, 10);
                sp3.Value = sort;
                cmd.Parameters.Add(sp3);
                SqlParameter sp4 = new SqlParameter("@pageIndex", SqlDbType.Int, 4);
                sp4.Value = pageIndex;
                cmd.Parameters.Add(sp4);
                SqlParameter sp5 = new SqlParameter("@pageCount", SqlDbType.Int, 4);
                sp5.Value = pageSize;
                cmd.Parameters.Add(sp5);
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        BookShop_BookTypeModel model = new BookShop_BookTypeModel();
                        model.BookType_ID = Convert.ToInt32(sdr["BookType_ID"]);
                        model.BookType_Name = sdr["BookType_Name"].ToString();
                        model.BookType_ParentID = int.Parse(sdr["BookType_ParentID"].ToString());
                        model.BookType_Guid = sdr["BookType_Guid"].ToString();
                        model.BookType_Datetime = DateTime.Parse(sdr["BookType_Datetime"].ToString());
                        model.BookType_Updatetime = DateTime.Parse(sdr["BookType_Updatetime"].ToString());
                        model.BookType_Verify = int.Parse(sdr["BookType_Verify"].ToString());
                        model.BookType_Lock = int.Parse(sdr["BookType_Lock"].ToString());
                        model.BookType_State = int.Parse(sdr["BookType_State"].ToString());
                        model.BookType_Delete = int.Parse(sdr["BookType_Delete"].ToString());
                        model.BookType_Count = int.Parse(sdr["BookType_Count"].ToString());
                        model.BookType_Order = int.Parse(sdr["BookType_Order"].ToString());
                        model.BookType_Remark = sdr["BookType_Remark"].ToString();

                        list.Add(model);
                    }
                }
                return list;
            }
        }