发个自己写的 廖勇军Socansoft代码生成器分页重写类

在model项目下直接添加RewritePageList.cs类文件

using System.Collections.Generic;

/// <summary>
/// [重写]分页数据类
/// </summary>
/// <typeparam name="TModel">结果集中实体的类型</typeparam>

public class RewritePageList<TModel> where TModel : class
{
    public RewritePageList()
    {
        _rewritePageInfo = new RewritePageInfo();
    }

    public RewritePageList(RewritePageInfo rewritePageInfo)
    {
        _rewritePageInfo = rewritePageInfo;
    }

    public RewritePageList(int pageSize, int pageIndex, string fldSort, string strSort, string condition)
    {
        _rewritePageInfo = new RewritePageInfo(pageSize, pageIndex, fldSort, strSort, condition);
    }

    private List<TModel> _list;
    private RewritePageInfo _rewritePageInfo;

    /// <summary>
    /// 分页结果集
    /// </summary>
    public List<TModel> List
    {
        get { return _list; }
        set { _list = value; }
    }

    /// <summary>
    /// 分页信息
    /// </summary>
    public RewritePageInfo RewritePageInfo
    {
        get { return _rewritePageInfo; }
        set { _rewritePageInfo = value; }
    }
}

/// <summary>
/// 分页信息
/// </summary>
public class RewritePageInfo
{
    public RewritePageInfo()
    { }

    public RewritePageInfo(int pageSize, int pageIndex, string fldSort, string strSort, string condition)
    {
        _pageSize = pageSize;
        _pageIndex = pageIndex;
        _fldSort = fldSort;
        _strSort = strSort;
        _condition = condition;
    }

    private int _recordCount;
    private int _pageSize;
    private int _pageIndex;
    private int _pageCount;
    private int _firstIndex;

    private string _fldSort;
    private string _strSort;
    private string _condition;


    /// <summary>
    /// 总记录数
    /// </summary>
    public int RecordCount
    {
        get { return _recordCount; }
        set { _recordCount = value; }
    }

    /// <summary>
    /// 每页大小
    /// </summary>
    public int PageSize
    {
        get { return _pageSize; }
        set { _pageSize = value; }
    }

    /// <summary>
    /// 页索引
    /// </summary>
    public int PageIndex
    {
        get { return _pageIndex; }
        set { _pageIndex = value; }
    }

    /// <summary>
    /// 总页数
    /// </summary>
    public int PageCount
    {
        get { return _pageCount; }
        set { _pageCount = value; }
    }

    /// <summary>
    /// 该页在所有结果中的起始索引。比如每页10条，第1页起始索引为0，第2页起始索引为10，以此类推
    /// </summary>
    public int FirstIndex
    {
        get { return _firstIndex; }
        set { _firstIndex = value; }
    }

    /// <summary>
    /// 排序字段
    /// </summary>
    public string fldSort
    {
        get { return _fldSort; }
        set { _fldSort = value; }
    }

    /// <summary>
    /// 排序方向
    /// </summary>
    public string strSort
    {
        get { return _strSort; }
        set { _strSort = value; }
    }

    /// <summary>
    /// 筛选条件字符
    /// </summary>
    public string condition
    {
        get { return _condition; }
        set { _condition = value; }
    }

    /// <summary>
    /// 开始计算页数及第一条记录的索引。
    /// 请在赋值PageSize,PageIndex,RecoundCount完毕后调用此方法。
    /// </summary>
    public void Compute()
    {
        //计算页数
        if (RecordCount % PageSize == 0)
            PageCount = RecordCount / PageSize;
        else
            PageCount = RecordCount / PageSize + 1;

        //检查页索引与页大小是否正确，并自动修正
        if (PageIndex < 1)
            PageIndex = 1;
        else if (PageCount >= 1 && PageIndex > PageCount)
            PageIndex = PageCount;

        //计算第一条记录和最后一条记录的索引
        _firstIndex = PageSize * (PageIndex - 1);
    }
}

在SqlServerDAL项目下的表应用到的，直接在editable文件夹下的类文件添加以下代码进行调用

#region 自定义分页调用
        /// <summary>
        /// 获取数量[重写]
        /// </summary>
        private int GetCount(string _strcontidion)
        {
            object obj = dbHelper.ExecuteScalar(CommandType.Text, "SELECT count(*) FROM Announced where " + _strcontidion, null);
            return int.Parse(obj.ToString());
        }

        /// <summary>
        /// 分页获取泛型数据列表[重写]
        /// </summary>
        public RewritePageList<Model.Announced> GetRPageList(RewritePageInfo Rpi)
        {
            Rpi.RecordCount = GetCount(Rpi.condition);
            Rpi.Compute();

            RewritePageList<Model.Announced> pl = new RewritePageList<Model.Announced>(Rpi);

            using (DbDataReader dr = dbHelper.GetPageList("Announced", Rpi.fldSort, " " + Rpi.strSort, Rpi.condition, Rpi.PageIndex, Rpi.PageSize))
            {
                pl.List = GetPageList(dr, 0, Rpi.PageSize);
            }
            return pl;
        }
        #endregion

在IDAL项目添加调用接口

/// <summary>
        /// 分页获取泛型数据列表[重写]
        /// </summary>
        RewritePageList<Model.Announced> GetRPageList(RewritePageInfo Rpi);

在BLL项目添加调用方法

/// <summary>
        /// 分页获取泛型数据列表[重写]
        /// </summary>
        public RewritePageList<Model.Announced> GetRPageList(RewritePageInfo Rpi)
        {
            RewritePageList<Model.Announced> pl = dal.GetRPageList(Rpi);
            return pl;
        }

最后直接在Web项目下调用方式，以AspNetPager分页调用为例

/// <summary>
        /// 初始化数据筛选条件
        /// </summary>
        private string GetContidion()
        {
            StringBuilder strcontidion = new StringBuilder();
            strcontidion.Append(" 1=1 ");
            if (int.Parse(ddlNewSort.SelectedValue.Trim()) > 0)
                strcontidion.Append(" and SortID = " + int.Parse(ddlNewSort.SelectedValue.Trim() + " "));
            if (!string.IsNullOrEmpty(txtNewsName.Text) && !string.IsNullOrEmpty(txtNewsName.Text.Trim()))
                strcontidion.Append(" and NewsName like '%" + txtNewsName.Text.Trim() + "%'");
            return strcontidion.ToString();
        }

        /// <summary>
        /// 数据列表绑定
        /// </summary>
        void _dataBind()
        {
            int pageindex = 0;
            if (anp.CurrentPageIndex < 1)
            {
                pageindex = 1;
            }
            else
            {
                pageindex = anp.CurrentPageIndex;
            }
            RewritePageInfo PI = new RewritePageInfo(50, pageindex, "id", "DESC", GetContidion());
            RewritePageList<Model.News> pl = new News().GetRPageList(PI);
            anp.RecordCount = PI.RecordCount;

            if (pl.List.Count > 0)
            {
                rptNewsList.DataSource = pl.List;
                rptNewsList.DataBind();

                rptNewsList.Visible = true;
                emptyContent.Visible = false;
                anp.Visible = true;
                anp.CustomInfoHTML = "第<font color=\"red\"><b>" + anp.CurrentPageIndex + "</b></font>页/共" + anp.PageCount;
                anp.CustomInfoHTML += "页&nbsp;&nbsp;共" + anp.RecordCount + "条记录";
            }
            else
            {
                rptNewsList.Visible = false;
                anp.Visible = false;
                emptyContent.Visible = true;
            }
        }

        /// <summary>
        /// 分页数据
        /// </summary>
        protected void anp_PageChanged(object sender, EventArgs e)
        {
            _dataBind();
        }