实现数据记录的分页类

最近用简单的三层架构写代码，虽然代码比较通用，但不够个性化，闲来写了数据记录的分页类，使用起来相对比较通用（想来能写出通用高效的代码真是不容易）

列出代码：

 public class Pagination
    {
         //分页总数
        private int pageCount;
        public int PageCount
        {
            get
            {
                return pageCount;
            }
        }
        //分页大小
        private int pageSize;
        public int PageSize
        {
            get
            {
                return pageSize;
            }
        }
        //目前页号
        private int currentPage=1;
        public int CurrentPage
        {
            get
            {
                return currentPage;
            }
            set
            {
                currentPage = value;
            }
        }

        //前一页是否存在标识
        private bool flagPrivous;
        public bool FlagPrivous
        {
            get
            {
                if (CurrentPage < PageCount + 1 && CurrentPage != 1)
                {
                    flagPrivous = true;
                }
                else
                {
                    flagPrivous = false;
                }
                return flagPrivous;
            }
        }
        //后一页存在标识
        private bool flagNext;
        public bool FlagNext
        {
            get
            {
                if (currentPage < pageCount)
                {
                    flagNext = true;
                }
                else
                {
                    flagNext = false;
                }
                return flagNext;
            }
        }
        private string selectString;
        private string whereString;
        private string bllClass;
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="PageSize">分页的大小</param>
        /// <param name="selectString">select子句</param>
        /// <param name="orderByString"></param>
        /// <param name="table">查询的表/数据库名</param>
        public Pagination(int _PageSize,string _selectString,string _whereString,string _bllClass)
        {
            //初始化字段
            this.selectString = _selectString;
            this.whereString = _whereString;
            this.bllClass = _bllClass;
            this.pageSize=_PageSize;

            Assembly assembly = Assembly.Load("TYKY_OA.BLL");
            object bllclass = assembly.CreateInstance(bllClass, false);
            Type type = assembly.GetType(bllClass);
            string[] param = new string[]{whereString}; 
            //获取页的总数
            int count  =  (int)type.InvokeMember("getRecordCount", BindingFlags.InvokeMethod, null, bllclass, param);
            this.pageCount = count / pageSize + ((count % pageSize == 0) ? 0 : 1);         
        }
       
        //返回当前页
        public DataSet GetSet()
        {
            Assembly assembly = Assembly.Load("TYKY_OA.BLL");
            object bllclass = assembly.CreateInstance(bllClass, false);
            Type type = assembly.GetType(bllClass);
            object[] param = new object[]{currentPage,pageSize,selectString,whereString}; 
            //获取页的总数
            return  (DataSet)type.InvokeMember("GetSet", BindingFlags.InvokeMethod, null, bllclass, param);           
        }
       
    }
  

 

在每个DAL、BLL层添加相应的函数，例如：Salary表格进行分页
1.在DAL层添加：
　　　　 public int getRecordCount(string whereString)
　　　　 {
   　　  　　return dal.GetRecordCount(whereString);
 　　　　}
　　　　 public DataSet GetSet(int pageIndex, int pageSize, string selectString, string whereString)
　　　　 {
   　　　　  return dal.GetSet(pageIndex, pageSize, selectString, whereString);
　　　　 }
2.在BLL层添加
 //查询符合条件的记录条数
        public int getRecordCount(string whereString)
        {
            return dal.GetRecordCount(whereString);
        }

        public DataSet GetSet(int pageIndex, int pageSize, string selectString, string whereString)
        {
            return dal.GetSet(pageIndex, pageSize, selectString, whereString);
        }
3.初始化分页功能
        TYKY_OA.Web.Pagination page = new TYKY_OA.Web.Pagination(pageSize
                        , "salaryID,staffID,name,PrevSalary,PresSalary,salaryTime,salaryRange,salaryReason,appendix"
                        , "1=1"  //这里是个条件
                        , "TYKY_OA.BLL.SalaryRecordInfo"
                        );
        this.prev.Disabled = !page.FlagPrivous;
        this.next.Disabled = !page.FlagNext;
        this.pageIndex.Text = "当前第" + page.CurrentPage + "页" + "(共" + page.PageCount + "页)";
        this.gvSalary.DataSource = page.GetSet();
        this.gvSalary.DataBind();
        Session["ASRpagenation"] = page;
4.实现分页
        TYKY_OA.Web.Pagination page = (TYKY_OA.Web.Pagination)Session["ASRpagenation"];
        if (page != null)
        {
           page.CurrentPage = page.CurrentPage - 1;// -/+ 实现上下页
           this.prev.Disabled = !page.FlagPrivous;
           this.next.Disabled = !page.FlagNext;
           this.pageIndex.Text = "当前第" + page.CurrentPage + "页" + "(共" + page.PageCount + "页)";
           this.gvSalary.DataSource = page.GetSet();
           this.gvSalary.DataBind();
           Session["ASRpagenation"] = page;
         }

 

 

技术有限，简单记录。