回味手写三层--分页

上回写了 增删改查 没有分页的

想了一下，现在又很多 分页模式 就找到了aspnetpager 

感觉这个东西用着挺方便的

用的 还是上回的代码（(*^__^*) 嘻嘻……）

先照 个全家福：

同样还是model→ SqlHelper→Dal→BLL

先看下model ：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ClassModel
{
    public class ClassModels
    {
        private int cId;
        public int CId
        {
            get { return cId; }
            set { cId = value; }
        }
        private string cName;

        public string CName
        {
            get { return cName; }
            set { cName = value; }
        }
        private int cCount;

        public int CCount
        {
            get { return cCount; }
            set { cCount = value; }
        }
        private string cImage;

        public string CImage
        {
            get { return cImage; }
            set { cImage = value; }
        }
        private bool cIsDel;

        public bool CIsDel
        {
            get { return cIsDel; }
            set { cIsDel = value; }
        }
        private DateTime cAddTime;

        public DateTime CAddTime
        {
            get { return cAddTime; }
            set { cAddTime = value; }
        }


    }
}

然后 sqlhelper：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace ClassDal
{
    class SqlHelper
    {
        public static string connstr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
        public static SqlDataReader ExcuteReader(string sql, params SqlParameter[] pams)
        {
            SqlConnection conn = new SqlConnection(connstr);
            using (SqlCommand cmd=new SqlCommand(sql,conn))
            {
                if (pams!=null)
                {
                    cmd.Parameters.AddRange(pams);
                }
                if (conn.State==System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                }
                return cmd.ExecuteReader();
            }

        }

        public static DataTable ExcuteDataTable(string sql,params SqlParameter[] pams)
        {
            using (SqlDataAdapter adapter=new SqlDataAdapter(sql,connstr))
            {
                if (pams!=null)
                {
                    adapter.SelectCommand.Parameters.AddRange(pams);
                }
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                return dt;
            }
        }
        //增删改
        public static int ExcuteNonQuery(string sql, params SqlParameter[] pams)
        {
            using (SqlConnection conn=new SqlConnection(connstr))
            {
                using (SqlCommand cmd=new SqlCommand(sql,conn))
                {
                    if (pams!=null)
                    {
                        cmd.Parameters.AddRange(pams);
                    }
                    if (conn.State==ConnectionState.Closed)
                    {
                        conn.Open();
                    }
                    return cmd.ExecuteNonQuery();
                }
            }
        }

        public static object ExcuteScalar(string sql, params SqlParameter[] pams)
        {
            using (SqlConnection conn=new SqlConnection(connstr))
            {
                using (SqlCommand cmd=new SqlCommand(sql,conn))
                {
                    if (pams!=null)
                    {
                        cmd.Parameters.AddRange(pams);
                    }
                    if (conn.State==ConnectionState.Closed)
                    {
                        conn.Open();
                    }
                    return cmd.ExecuteScalar();
                }
            }
        }
        
        #region 分页（由SocanCode 生成）

        
        /// <summary>
        /// 通用分页存储过程
        /// </summary>
        /// <param name="connectionString">连接</param>
        /// <param name="tblName">要显示的表或多个表的连接</param>
        /// <param name="fldName">要显示的字段列表,可为Null,表示*</param>
        /// <param name="pageSize">每页显示的记录个数</param>
        /// <param name="pageIndex">要显示那一页的记录</param>
        /// <param name="fldSort">排序字段列表或条件</param>
        /// <param name="Sort">排序方法，False为升序，True为降序(如果是多字段排列Sort指代最后一个排序字段的排列顺序(最后一个排序字段不加排序标记)--程序传参如：' SortA Asc,SortB Desc,SortC ')</param>
        /// <param name="strCondition">查询条件,不需where,以And开始,可为Null,表示""</param>
        /// <param name="ID">主表的主键</param>
        /// <param name="Disk">是否添加查询字段的 DISTINCT 默认False不添加/True添加</param>
        /// <param name="pageCount">查询结果分页后的总页数</param>
        /// <param name="Counts">查询到的记录数</param>
        /// <param name="strSql">最后返回的SQL语句</param>
        /// <returns>查询当前页的数据集</returns>
        public static DataSet PageList(string connectionString, string tblName, string fldName, int pageSize, int pageIndex,
            string fldSort, bool Sort, string strCondition, string ID, bool Dist,
            out int pageCount, out int Counts, out string strSql)
        {
            SqlParameter[] parameters ={ new SqlParameter("@tblName",SqlDbType.NVarChar,200),
                new SqlParameter("@fldName",SqlDbType.NVarChar,500),
                new SqlParameter("@pageSize",SqlDbType.Int),
                new SqlParameter("@page",SqlDbType.Int),
                new SqlParameter("@fldSort",SqlDbType.NVarChar,200),
                new SqlParameter("@Sort",SqlDbType.Bit),
                new SqlParameter("@strCondition",SqlDbType.NVarChar,1000),
                new SqlParameter("@ID",SqlDbType.NVarChar,150),
                new SqlParameter("@Dist",SqlDbType.Bit),
                new SqlParameter("@pageCount",SqlDbType.Int),
                new SqlParameter("@Counts",SqlDbType.Int),
                new SqlParameter("@strSql",SqlDbType.NVarChar,1000)};

            parameters[0].Value = tblName;
            parameters[1].Value = (fldName == null) ? "*" : fldName;
            parameters[2].Value = (pageSize == 0) ? int.Parse(ConfigurationManager.AppSettings["PageSize"]) : pageSize;
            parameters[3].Value = pageIndex;
            parameters[4].Value = fldSort;
            parameters[5].Value = Sort;
            parameters[6].Value = strCondition == null ? "" : strCondition;
            parameters[7].Value = ID;
            parameters[8].Value = Dist;
            parameters[9].Direction = ParameterDirection.Output;
            parameters[10].Direction = ParameterDirection.Output;
            parameters[11].Direction = ParameterDirection.Output;

            //调用存储过程
            DataSet ds = RunProcedure(connectionString, "PageList", parameters, "ds");

            pageCount = (int)parameters[9].Value;
            Counts = (int)parameters[10].Value;
            strSql = parameters[11].Value.ToString();
            return ds;
        }
        /// <summary>
        /// 执行存储过程
        /// </summary>
        /// <param name="storedProcName">存储过程名</param>
        /// <param name="parameters">存储过程参数</param>
        /// <param name="tableName">DataSet结果中的表名</param>
        /// <returns>DataSet</returns>
        public static DataSet RunProcedure(string connectionString, string storedProcName, IDataParameter[] parameters, string tableName)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                DataSet dataSet = new DataSet();
                connection.Open();
                SqlDataAdapter sqlDA = new SqlDataAdapter();
                sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
                sqlDA.Fill(dataSet, tableName);
                connection.Close();
                return dataSet;
            }
        }
        /// <summary>
        /// 构建 SqlCommand 对象(用来返回一个结果集，而不是一个整数值)
        /// </summary>
        /// <param name="connection">数据库连接</param>
        /// <param name="storedProcName">存储过程名</param>
        /// <param name="parameters">存储过程参数</param>
        /// <returns>SqlCommand</returns>
        private static SqlCommand BuildQueryCommand(SqlConnection connection, string storedProcName, IDataParameter[] parameters)
        {
            SqlCommand command = new SqlCommand(storedProcName, connection);
            command.CommandType = CommandType.StoredProcedure;
            if (parameters != null)
            {
                foreach (SqlParameter parameter in parameters)
                {
                    //if (parameter.SqlDbType == SqlDbType.DateTime)
                    //{
                    //    if ((DateTime )parameter.Value == DateTime.MinValue)
                    //        parameter.Value = System.DBNull.Value;
                    //}
                    if (parameter.SqlDbType == SqlDbType.DateTime)
                    {
                        if (parameter.Value == DBNull.Value)
                        {
                            parameter.Value = DBNull.Value;
                        }

                    }
                    command.Parameters.Add(parameter);
                }
            }
            return command;
        }
        #endregion
    }
        

}

该Dal了：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace ClassDal
{
    public class ClassDals
    {
        //datetable 获取信息
        public DataTable GetAll()
        {
            string sql = "select *from Classes";
            return SqlHelper.ExcuteDataTable(sql);
        }
        // datereader 获取信息
        public SqlDataReader GetAllInfo()
        {
            string sql = "select *from Classes";
            return SqlHelper.ExcuteReader(sql);
        }
        public SqlDataReader GetInfoFromId(ClassModel.ClassModels model)
        {
            string sql = "select *from Classes where CID=@id";
            return SqlHelper.ExcuteReader(sql, new SqlParameter("@id", model.CId));
        }
        //删除一条信息
        public int DeleteInfo(int id)
        {
            string sql = "delete from Classes where CID=@cid";
            SqlParameter pam = new SqlParameter("@cid", id);
            return SqlHelper.ExcuteNonQuery(sql, pam);
        }
        //添加一条信息
        public int AddInfo(ClassModel.ClassModels model)
        {

            string sql = "insert into Classes(CName,CCount)values(@CName,@CCount)";
            SqlParameter[] pam = new SqlParameter[] {
            new SqlParameter("@CName",model.CName),
            new SqlParameter("@CCount",model.CCount)
            };
            return SqlHelper.ExcuteNonQuery(sql, pam);
        }
        //更新一条信息
        public int UpdateInfo(ClassModel.ClassModels model)
        {
            //update Classes set CName='123',CCount='123' where CID='43'
            string sql = "update Classes set CName=@name,CCount=@count where CID=@id";
            SqlParameter[] pams = new SqlParameter[] {
            new SqlParameter("@id",model.CId),
            new SqlParameter("@name",model.CName),
            new SqlParameter("@count",model.CCount)
            };
            return SqlHelper.ExcuteNonQuery(sql, pams);
        }
        //获得总数
        public int GetAllCount()
        {
            string sql = "  select COUNT(*) from Classes";
            return Convert.ToInt32(SqlHelper.ExcuteScalar(sql));
        }
        //分页
        public DataSet GetList(int pageSize, int pageIndex, string fldSort, bool sort, string strCondition, out int pageCount, out int count)
        {
            string strSql;
            DataSet ds = SqlHelper.PageList(SqlHelper.connstr, "[Classes]", null, pageSize, pageIndex, fldSort, sort, strCondition, "CID", false, out pageCount, out count, out strSql);
            return ds;
        }
    }
}

接下来：业务逻辑（BLL）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using ClassDal;
using System.Data.SqlClient;

namespace ClassBll
{
    public class ClassBll
    {
        ClassDals dal = new ClassDals();
        /// <summary>
        /// 获得所有信息
        /// DataTable 版本
        /// </summary>
        /// <returns></returns>
        public List<ClassModel.ClassModels> GetAll()
        {
            DataTable da = dal.GetAll();
            List<ClassModel.ClassModels> list = new List<ClassModel.ClassModels>();
            if (da.Rows.Count > 0)
            {
                ClassModel.ClassModels mode = null;
                foreach (DataRow row in da.Rows)
                {
                    mode = new ClassModel.ClassModels();
                    mode.CId = Convert.ToInt32(row["CID"].ToString());
                    mode.CCount = Convert.ToInt32(row["CCount"].ToString());
                    mode.CName = row["CName"].ToString();
                    list.Add(mode);
                }
                return list;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得所有信息
        /// DataReader 版本
        /// </summary>
        /// <returns></returns>
        public List<ClassModel.ClassModels> GetAllInfo()
        {
            List<ClassModel.ClassModels> list = new List<ClassModel.ClassModels>();
            SqlDataReader reader = dal.GetAllInfo();
            while (reader.Read())
            {
                if (reader.HasRows)
                {
                    ClassModel.ClassModels model = new ClassModel.ClassModels();
                    model.CId = reader.GetInt32(0);
                    model.CName = reader.GetString(1);
                    model.CCount = reader.GetInt32(2);
                    list.Add(model);
                    
                }
            }
            return list;
        }
        public ClassModel.ClassModels GetInfoFromId(ClassModel.ClassModels model)
        {
           
            SqlDataReader reader = dal.GetInfoFromId(model);
            if (reader.Read())
            {
                if (reader.HasRows)
                {
                    model.CId = reader.GetInt32(0);
                    model.CName = reader.GetString(1);
                    model.CCount = reader.GetInt32(2);
                }
            }
         
            return model;
        }
        public int DeleteInfo(int id)
        {
          return  dal.DeleteInfo(id);
        }
        public int AddInfo(ClassModel.ClassModels model)
        {
            return dal.AddInfo(model);
        }
        public int UpdateInfo(ClassModel.ClassModels model)
        {
            return dal.UpdateInfo(model);
        }
        public int GetAllCount()
        {
            return dal.GetAllCount();
        }
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetList(int pageSize, int pageIndex, string fldSort, bool Sort, string strCondition, out int pageCount, out int Counts)
        {
            return dal.GetList(pageSize, pageIndex, fldSort, Sort, strCondition, out pageCount, out Counts);
        }
    }
}

这样 后台差不多 搭好了（里面有的是 socanCode生成的，本人太懒了，不想写了）

看下前台的吧 （其实没什么好看的）

Web 代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="List.aspx.cs" Inherits="List" EnableViewStateMac="false"  %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>学生成绩管理系统</title>
    <style type="text/css">
        #tbList
        {
            border: 1px solid blue;
        }
        #tbList th, td
        {
            border-bottom: 1px solid blue;
            border-right: 1px solid blue;
        }
        
    </style>
    <link href="Css/Content.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server" method="post" action="AddInfo.aspx">
    <div>
        <asp:Repeater ID="RepeaterInfo" runat="server">
            <HeaderTemplate>
                <table border="1" cellpadding="1" cellspacing="0">
                    <tr>
                        <th>
                            编号
                        </th>
                        <th>
                            班级名称
                        </th>
                        <th>
                            人数
                        </th>
                        <th colspan="3">
                            操作
                        </th>
                    </tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                    <td>
                        <%# Eval("CID") %>
                    </td>
                    <td>
                        <%# Eval("CName") %>
                    </td>
                    <td>
                        <%# Eval("CCount") %>
                    </td>
                    <td>
                        <a href='Update.aspx?id=" + <%# Eval("CID") %> + "'>修改</a>
                    </td>
                    <td>
                        <a href='Delete.ashx?id=" + <%# Eval("CID") %> + "'>删除</a>
                    </td>
                    <td>
                        <a href="AddInfo.aspx">添加</a>
                    </td>
                </tr>
            </ItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
        <webdiyer:AspNetPager ID="Pager" runat="server" class="paginator" CustomInfoHTML="共%PageCount%页,当前第%CurrentPageIndex%页,每页%PageSize%条,共%RecordCount%条"
            EnableTheming="true" FirstPageText="首页" LastPageText="尾页" NextPageText="后页" OnPageChanged="Pager_PageChanged"
            PageIndexBoxType="DropDownList" PageSize="3" PrevPageText="前页" ShowCustomInfoSection="Right"
            ShowPageIndexBox="Always" TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到: " UrlPaging="True"
            AlwaysShow="True" CurrentPageButtonPosition="Center" CustomInfoSectionWidth="250px"
            CustomInfoStyle=" text-align:center;" CurrentPageButtonClass="xz ">
        </webdiyer:AspNetPager>
    </div>
    </form>
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AddInfo.aspx.cs" Inherits="AddInfo" EnableViewStateMac="false" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" method="post" action="AddInfo.aspx">
    <div>
       班级名称： <input type="text" name="txtCName" value="" /><br />
       班级人数： <input type="text" name="txtCCount" value="" /><br />
        <input type="hidden" name="isPostBack" value="2" />
        <input type="submit" name="btnAdd" value="保存" />
    </div>
    </form>
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Update.aspx.cs" Inherits="Update" EnableViewStateMac="false" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" method="post" action="Update.aspx">
    <div>
        班级名称：
        <%--用方法返回一个字符串--%>
        <%-- <input type="text" name="txtCName" value="<%=CCNameInfo() %>" /><br />--%>
        <input type="text" name="txtCName" value="<%=model.CName %>" /><br />
        班级人数：
        <input type="text" name="txtCCount" value="<%=model.CCount %>" /><br />
        <input type="hidden" name="isPostBack" value="<%=model.CId %>" />
        <input type="submit" name="btnUpdate" value="保存" />
    </div>
    </form>
</body>
</html>

<%@ WebHandler Language="C#" Class="Delete" %>

using System;
using System.Web;

public class Delete : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/html";
        string id=context.Request.QueryString["id"];
        if (!string.IsNullOrEmpty(id))
        {
            int sid = 0;
            if (int.TryParse(id,out sid))
            {
                ClassBll.ClassBll bll = new ClassBll.ClassBll();
                
                if (bll.DeleteInfo(sid)>0)
                {
                    context.Response.Write("<script type='text/javascript'>alert('删除成功！');window.location='List.aspx'</script>");
                }
                else
                {
                    context.Response.Write("删除失败！");
                }
            }
        }
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}

后台的：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class List : System.Web.UI.Page
{
    public string page = "1";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //BindInfo();
            BindData();
        }
    }
    protected void Pager_PageChanged(object sender, EventArgs e)
    {
        //BindInfo();
        BindData();
    }
    /// <summary>
    /// 方法一:存储过程版
    /// </summary>
    private void BindInfo()
    {
        int pageCount=0;
        int Counts=0;
        string strWhere = "";
        if (ViewState["strWhere"] != null)
        {
            strWhere += ViewState["strWhere"].ToString();
        }
        
        DataSet l = new ClassBll.ClassBll().GetList(Pager.PageSize, Pager.CurrentPageIndex, "CID", false, strWhere, out pageCount, out Counts);
        Pager.RecordCount = Counts;
        RepeaterInfo.DataSource = l;
        RepeaterInfo.DataBind();
    }
    
    /// <summary>
    /// 方法二:非存储过程
    /// </summary>
    public void BindData()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["sql"].ConnectionString);
        string sql = "select *from Classes order by CID asc";
        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, Pager.PageSize * (Pager.CurrentPageIndex - 1), Pager.PageSize, "Classes");
        DataTable dt = ds.Tables["Classes"];
        Pager.RecordCount = new ClassBll.ClassBll().GetAllCount();
        RepeaterInfo.DataSource = dt;
        RepeaterInfo.DataBind();
    }

    /// <summary>
    /// 不带分页
    /// </summary>
    /// <returns></returns>
    public string GetAllInfo()
    {
        StringBuilder sb = new StringBuilder();
        ClassBll.ClassBll bll = new ClassBll.ClassBll();
        List<ClassModel.ClassModels> list = bll.GetAllInfo();
        foreach (ClassModel.ClassModels model in list)
        {
            sb.Append("<tr>");
            sb.Append("<td>" + model.CId + "</td>");
            sb.Append("<td>" + model.CName + "</td>");
            sb.Append("<td>" + model.CCount + "</td>");
            sb.Append("<td><a href='Update.aspx?id=" + model.CId + "'>修改</td>");
            sb.Append("<td><a href='Delete.ashx?id=" + model.CId + "'>删除</td>");
            sb.Append("</tr>");
        }
        return sb.ToString();
    }
}

 

上面的提供了两种方法 可以进行 分页，一种有存储过程的，一种无存储过程的

剩下的就比较少了

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AddInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string name = Request.Form["txtCName"];//txtCCount  isPostBack
        string countstr = Request.Form["txtCCount"];
        string ispostBack=Request.Form["isPostBack"];
        if (!string.IsNullOrEmpty(ispostBack))
        {
            int count = 0;
            if (int.TryParse(countstr,out count))
            {
                ClassBll.ClassBll bll = new ClassBll.ClassBll();
                ClassModel.ClassModels model = new ClassModel.ClassModels();
                model.CName = name;
                model.CCount = count;
                if (bll.AddInfo(model)>0)
                {
                    Response.Write("<script type='text/javascript'>alert('添加成功！');window.location='List.aspx'</script>");
                }
                else
                {
                    Response.Write("添加失败！");
                }

            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Update : System.Web.UI.Page
{
    ClassBll.ClassBll bll = new ClassBll.ClassBll();
    protected  ClassModel.ClassModels model = new ClassModel.ClassModels();
    protected void Page_Load(object sender, EventArgs e)
    {
        string isPostback = Request.Form["isPostBack"];
        //如果是准备提交保存
        if (!string.IsNullOrEmpty(isPostback))
        {
            int idCount = 0;
            if (int.TryParse(isPostback,out idCount))
            {
                string cName = Request.Form["txtCName"];// txtCName txtCCount
                string cCount = Request.Form["txtCCount"];
                model.CId = idCount;
                model.CName = cName;
                model.CCount =Convert.ToInt32(cCount);
                if (bll.UpdateInfo(model)>0)
                {
                    Response.Write("<script type='text/javascript'>alert('保存成功！');window.location='List.aspx'</script>");
                }
                else
                {
                    Response.Write("修改失败！");
                }
            }
        }
        else//如果是第一次访问
        {
            string id = Request.QueryString["id"];

            int idcount = 0;
            if (int.TryParse(id, out idcount))
            {
                model.CId = idcount;
                //查寻数据并存到model中
                model = bll.GetInfoFromId(model);
            }
        }



    }
    //protected string CId()
    //{
    //    return model.CId.ToString();
    //}
    //protected string CCountInfo()
    //{
    //    return model.CCount.ToString();
    //}
    //protected string CCNameInfo()
    //{
    //    return model.CName;
    //}
}

存储过程：

USE [CPS]
GO
/****** Object:  StoredProcedure [dbo].[PageList]    Script Date: 08/03/2012 13:51:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
------------------------------------------------------------
--
--通用的分页存储过程
--
-------------------------------------------------------------
Create PROCEDURE [dbo].[PageList]
(
@tblName     nvarchar(200),        ----要显示的表或多个表的连接
@fldName     nvarchar(500) = '*',    ----要显示的字段列表
@pageSize    int = 1,        ----每页显示的记录个数
@page        int = 10,        ----要显示那一页的记录
@fldSort    nvarchar(200) = null,    ----排序字段列表或条件
@Sort        bit = 0,        ----排序方法，0为升序，1为降序(如果是多字段排列Sort指代最后一个排序字段的排列顺序(最后一个排序字段不加排序标记)--程序传参如：' SortA Asc,SortB Desc,SortC ')
@strCondition    nvarchar(1000) = null,    ----查询条件,不需where,以And开始
@ID        nvarchar(150),        ----主表的主键
@Dist                 bit = 0 ,          ----是否添加查询字段的 DISTINCT 默认0不添加/1添加
@pageCount    int = 1 output,            ----查询结果分页后的总页数
@Counts    int = 1 output,                ----查询到的记录数
@strSql          nvarchar(1000) = '' output  -----最后返回的SQL语句
)
AS
SET NOCOUNT ON
Declare @sqlTmp nvarchar(1000)        ----存放动态生成的SQL语句
Declare @strTmp nvarchar(1000)        ----存放取得查询结果总数的查询语句
Declare @strID     nvarchar(1000)        ----存放取得查询开头或结尾ID的查询语句
Declare @strSortType nvarchar(10)    ----数据排序规则A
Declare @strFSortType nvarchar(10)    ----数据排序规则B
Declare @SqlSelect nvarchar(50)         ----对含有DISTINCT的查询进行SQL构造
Declare @SqlCounts nvarchar(50)          ----对含有DISTINCT的总数查询进行SQL构造
if @Dist  = 0
begin
    set @SqlSelect = 'select '
    set @SqlCounts = 'Count(*)'
end
else
begin
    set @SqlSelect = 'select distinct '
    set @SqlCounts = 'Count(DISTINCT '+@ID+')'
end
if @Sort=0
begin
    set @strFSortType=' ASC '
    set @strSortType=' DESC '
end
else
begin
    set @strFSortType=' DESC '
    set @strSortType=' ASC '
end
--------生成查询语句--------
--此处@strTmp为取得查询结果数量的语句
if @strCondition is null or @strCondition=''     --没有设置显示条件
begin
    set @sqlTmp =  @fldName + ' From ' + @tblName
    set @strTmp = @SqlSelect+' @Counts='+@SqlCounts+' FROM '+@tblName
    set @strID = ' From ' + @tblName
end
else
begin
    set @sqlTmp = + @fldName + 'From ' + @tblName + ' where (1>0) ' + @strCondition
    set @strTmp = @SqlSelect+' @Counts='+@SqlCounts+' FROM '+@tblName + ' where (1>0) ' + @strCondition
    set @strID = ' From ' + @tblName + ' where (1>0) ' + @strCondition
end
----取得查询结果总数量-----
exec sp_executesql @strTmp,N'@Counts int out ',@Counts out
declare @tmpCounts int
if @Counts = 0
    set @tmpCounts = 1
else
    set @tmpCounts = @Counts
    --取得分页总数
    set @pageCount=(@tmpCounts+@pageSize-1)/@pageSize
    /**//**当前页大于总页数 取最后一页**/
    if @page>@pageCount
        set @page=@pageCount
    --/*-----数据分页2分处理-------*/
    declare @pageIndex int --总数/页大小
    declare @lastcount int --总数%页大小 
    set @pageIndex = @tmpCounts/@pageSize
    set @lastcount = @tmpCounts%@pageSize
    if @lastcount > 0
        set @pageIndex = @pageIndex + 1
    else
        set @lastcount = @pagesize
    --//***显示分页
    if @strCondition is null or @strCondition=''     --没有设置显示条件
    begin
        if @pageIndex<2 or @page<=@pageIndex / 2 + @pageIndex % 2   --前半部分数据处理
            begin 
                set @strTmp=@SqlSelect+' top '+ CAST(@pageSize as VARCHAR(4))+' '+ @fldName+' from '+@tblName
                        +' where '+@ID+' not in('+ @SqlSelect+' top '+ CAST(@pageSize*(@page-1) as Varchar(20)) +' '+ @ID +' from '+@tblName
                        +' order by '+ @fldSort +' '+ @strFSortType+')'
                        +' order by '+ @fldSort +' '+ @strFSortType 
            end
        else
            begin
            set @page = @pageIndex-@page+1 --后半部分数据处理
                if @page <= 1 --最后一页数据显示
                    set @strTmp=@SqlSelect+' * from ('+@SqlSelect+' top '+ CAST(@lastcount as VARCHAR(4))+' '+ @fldName+' from '+@tblName
                        +' order by '+ @fldSort +' '+ @strSortType+') AS TempTB'+' order by '+ @fldSort +' '+ @strFSortType 
                else                
                    set @strTmp=@SqlSelect+' * from ('+@SqlSelect+' top '+ CAST(@pageSize as VARCHAR(4))+' '+ @fldName+' from '+@tblName
                        +' where '+@ID+' not in('+ @SqlSelect+' top '+ CAST(@pageSize*(@page-2)+@lastcount as Varchar(20)) +' '+ @ID +' from '+@tblName
                        +' order by '+ @fldSort +' '+ @strSortType+')'
                        +' order by '+ @fldSort +' '+ @strSortType+') AS TempTB'+' order by '+ @fldSort +' '+ @strFSortType 
            end
    end
    else --有查询条件
    begin
        if @pageIndex<2 or @page<=@pageIndex / 2 + @pageIndex % 2   --前半部分数据处理
        begin 
                set @strTmp=@SqlSelect+' top '+ CAST(@pageSize as VARCHAR(4))+' '+ @fldName +' from  '+@tblName
                    +' where '+@ID+' not in('+ @SqlSelect+' top '+ CAST(@pageSize*(@page-1) as Varchar(20)) +' '+ @ID +' from '+@tblName
                    +' Where (1>0) ' + @strCondition + ' order by '+ @fldSort +' '+ @strFSortType+')'
                    +' ' + @strCondition + ' order by '+ @fldSort +' '+ @strFSortType                 
        end
        else
        begin 
            set @page = @pageIndex-@page+1 --后半部分数据处理
            if @page <= 1 --最后一页数据显示
                    set @strTmp=@SqlSelect+' * from ('+@SqlSelect+' top '+ CAST(@lastcount as VARCHAR(4))+' '+ @fldName+' from '+@tblName
                        +' where (1>0) '+ @strCondition +' order by '+ @fldSort +' '+ @strSortType+') AS TempTB'+' order by '+ @fldSort +' '+ @strFSortType
            else
                    set @strTmp=@SqlSelect+' * from ('+@SqlSelect+' top '+ CAST(@pageSize as VARCHAR(4))+' '+ @fldName+' from '+@tblName
                        +' where '+@ID+' not in('+ @SqlSelect+' top '+ CAST(@pageSize*(@page-2)+@lastcount as Varchar(20)) +' '+ @ID +' from '+@tblName
                        +' where (1>0) '+ @strCondition +' order by '+ @fldSort +' '+ @strSortType+')'
                        + @strCondition +' order by '+ @fldSort +' '+ @strSortType+') AS TempTB'+' order by '+ @fldSort +' '+ @strFSortType 
        end    
    end
------返回查询结果-----
set @strSql = @strTmp
exec sp_executesql @strTmp
--print @strTmp

 

感觉那个样式挺好看的 复制展哥 的

http://www.cnblogs.com/zengxiangzhan/archive/2010/03/03/1677460.html

这里是他的代码：

/*拍拍网风格*/
.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}

/*淘宝风格*/
.paginator { font: 12px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {border:solid 1px #ccc;color:#0063dc;cursor:pointer;text-decoration:none;}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {border:1px solid #F50;font-weight:700;color:#F50;background-color:#ffeee5;}
.paginator a:hover {border:solid 1px #F50;color:#f60;text-decoration:none;}
.paginator a,.paginator a:visited,.paginator .cpb,.paginator a:hover  
{float:left;height:16px;line-height:16px;min-width:10px;_width:10px;margin-right:5px;text-align:center;
 white-space:nowrap;font-size:12px;font-family:Arial,SimSun;padding:0 3px;}

大功告成了！回家吃饭！

 

O(∩_∩)O哈哈~