三层

web.comfg配置

<configuration>    <system.web>      <compilation debug="true" targetFramework="4.5" />      <httpRuntime targetFramework="4.5" />    </system.web>  <connectionStrings>    <add name="connstr" connectionString="Data Source=FBD-VAIO ;Initial Catalog=sales; Integrated security=true" />  </connectionStrings></configuration>

DAL层

SqlHelper

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.SqlClient;using System.Data;namespace Itcast.Cn{    public static class SqlHelper    {        private static readonly string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;        //执行增删改的        public static int ExecuteNonQuery(string sql, CommandType cmdType, params SqlParameter[] pms)        {            using (SqlConnection con = new SqlConnection(conStr))            {                using (SqlCommand cmd = new SqlCommand(sql, con))                {                    cmd.CommandType = cmdType;                    if (pms != null)                    {                        cmd.Parameters.AddRange(pms);                    }                    con.Open();                    return cmd.ExecuteNonQuery();                }            }        }        //封装一个执行返回单个值的方法        public static object ExecuteScalar(string sql, CommandType cmdType, params SqlParameter[] pms)        {            using (SqlConnection con = new SqlConnection(conStr))            {                using (SqlCommand cmd = new SqlCommand(sql, con))                {                    cmd.CommandType = cmdType;                    if (pms != null)                    {                        cmd.Parameters.AddRange(pms);                    }                    con.Open();                    return cmd.ExecuteScalar();                }            }        }        //返回SqlDataReader对象的方法        public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms)        {            SqlConnection con = new SqlConnection(conStr);            using (SqlCommand cmd = new SqlCommand(sql, con))            {                cmd.CommandType = cmdType;                if (pms != null)                {                    cmd.Parameters.AddRange(pms);                }                try                {                    con.Open();                    return cmd.ExecuteReader(CommandBehavior.CloseConnection);                }                catch (Exception)                {                    con.Close();                    con.Dispose();                    throw;                }            }        }        //封装一个返回DataTable的方法        public static DataTable ExecuteDataTable(string sql, CommandType cmdType, params SqlParameter[] pms)        {            DataTable dt = new DataTable();            using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conStr))            {                adapter.SelectCommand.CommandType = cmdType;                if (pms != null)                {                    adapter.SelectCommand.Parameters.AddRange(pms);                }                adapter.Fill(dt);            }            return dt;        }        //封装一个带事务的执行Sql语句的方法        public static void ExecuteNonQueryTran(List<SqlAndParameter> list)        {            using (SqlConnection con = new SqlConnection(conStr))            {                using (SqlCommand cmd = con.CreateCommand())                {                    con.Open();                    using (SqlTransaction trans = con.BeginTransaction())                    {                        cmd.Transaction = trans;                        try                        {                            foreach (var SqlObject in list)                            {                                cmd.CommandText = SqlObject.Sql;                                if (SqlObject.Parameters != null)                                {                                    cmd.Parameters.AddRange(SqlObject.Parameters);                                }                                cmd.CommandType = SqlObject.CmdType;                                cmd.ExecuteNonQuery();                                cmd.Parameters.Clear();                            }                            trans.Commit();                        }                        catch (Exception)                        {                            trans.Rollback();                            throw;                        }                    }                }            }        }    }    public class SqlAndParameter    {        public string Sql        {            get;            set;        }        public SqlParameter[] Parameters        {            get;            set;        }        public CommandType CmdType        {            get;            set;        }    }}

增删查改

TblCommentsDal.cs

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Ajax.CRUD.Model;using System.Data.SqlClient;namespace Ajax.CRUD.DAL{    public class TblCommentsDal    {        public List<TblComments> GetAllComments()        {            List<TblComments> list = new List<TblComments>();            string sql = "select * from TblComments";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        TblComments model = new TblComments();                        model.AutoId = reader.GetInt32(0);                        model.Title = reader.GetString(1);                        model.Content = reader.GetString(2);                        model.Email = reader.GetString(3);                        list.Add(model);                    }                }            }            return list;        }        public int Add(TblComments tblComment)        {            string sql = "INSERT INTO TblComments (title, content, email) output inserted.autoId VALUES (@title, @content, @email)";            SqlParameter[] para = new SqlParameter[]{new SqlParameter("@title", ToDBValue(tblComment.Title)),new SqlParameter("@content", ToDBValue(tblComment.Content)),new SqlParameter("@email", ToDBValue(tblComment.Email)),};            return (int)SqlHelper.ExecuteScalar(sql, System.Data.CommandType.Text, para);        }        public int Delete(int autoId)        {            string sql = "delete from TblComments where autoId=@autoid";            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, new SqlParameter("@autoid", autoId));        }        public int Update(TblComments model)        {            string sql = "update TblComments set title=@title,content=@content,email=@email where autoId=@autoId";            SqlParameter[] pms = new SqlParameter[] {             new SqlParameter("@title",model.Title),            new SqlParameter("@content",model.Content),            new SqlParameter("@email",model.Email),            new SqlParameter("@autoId",model.AutoId)            };            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, pms);        }        public object ToDBValue(object value)        {            if (value == null)            {                return DBNull.Value;            }            else            {                return value;            }        }    }}

UserDal

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using Ajax.CRUD.Model;namespace Ajax.CRUD.DAL{    public class Aspx_UserDal    {        public Aspx_User GetUserModelByUidPwd(string uid, string pwd)        {            Aspx_User model = null;            string sql = "select * from Aspx_Users where LoginId=@uid and LoginPwd=@pwd";            SqlParameter[] pms = new SqlParameter[]{            new SqlParameter("@uid",uid),            new SqlParameter("@pwd",pwd)            };            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text, pms))            {                if (reader.HasRows)                {                    if (reader.Read())                    {                        model = new Aspx_User();                        model.AutoId = reader.GetInt32(0);                        model.LoginId = reader.GetString(1);                    }                }            }            return model;        }        //检查用户名是否存在        public int CheckUserExists(string loginId)        {            string sql = "select count(*) from Aspx_Users where LoginId=@uid ";            return (int)SqlHelper.ExecuteScalar(sql, System.Data.CommandType.Text, new SqlParameter("@uid", loginId));        }    }}

Aspx_TypeDal

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Ajax.CRUD.Model;using System.Data.SqlClient;namespace Ajax.CRUD.DAL{    public class Aspx_TypeDal    {        public List<Aspx_Type> GetAllTypes()        {            List<Aspx_Type> list = new List<Aspx_Type>();            string sql = "select * from Aspx_Type";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        Aspx_Type model = new Aspx_Type();                        model.TypeId = reader.GetInt32(0);                        model.TypeName = reader.GetString(1);                        list.Add(model);                    }                }            }            return list;        }    }}

Aspx_NewsDal.cs

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using Ajax.CRUD.Model;namespace Ajax.CRUD.DAL{    public class Aspx_NewsDal    {        public int Add(Aspx_News aspx_New)        {            string sql = "insert into Aspx_News values(@title,@content,@date,@author,@bigImg,@smallImg,@typeId)";            SqlParameter[] pms = new SqlParameter[]{new SqlParameter("@title", ToDBValue(aspx_New.NewsTitle)),new SqlParameter("@content", ToDBValue(aspx_New.NewsContent)),new SqlParameter("@date", ToDBValue(aspx_New.NewsIssueDate)),new SqlParameter("@author", ToDBValue(aspx_New.NewsAuthor)),new SqlParameter("@bigImg", ToDBValue(aspx_New.NewsImage)),new SqlParameter("@smallImg", ToDBValue(aspx_New.NewsSmallImage)),new SqlParameter("@typeId", ToDBValue(aspx_New.NewsTypeId))};            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, pms);        }        public List<Aspx_News> GetAllNews()        {            List<Aspx_News> list = new List<Aspx_News>();            string sql = "select * from Aspx_news order by NewsIssueDate desc";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        //NewsId, NewsTitle, NewsContent, NewsIssueDate, NewsAuthor, NewsImage, NewsSmallImage, NewsTypeId                        Aspx_News model = new Aspx_News();                        model.NewsId = reader.GetInt32(0);                        model.NewsTitle = reader.GetString(1);                        model.NewsContent = reader.GetString(2);                        model.NewsIssueDate = reader.IsDBNull(3) ? null : (DateTime?)reader.GetDateTime(3);                        model.NewsAuthor = reader.IsDBNull(4) ? null : reader.GetString(4);                        model.NewsImage = reader.IsDBNull(5) ? null : reader.GetString(5);                        model.NewsSmallImage = reader.IsDBNull(6) ? null : reader.GetString(6);                        model.NewsTypeId = reader.GetInt32(7);                        list.Add(model);                    }                }            }            return list;        }        public List<Aspx_News> GetNewsByPage(int pageSize, int pageIndex, out int recordCount, out int pageCount)        {            List<Aspx_News> list = new List<Aspx_News>();            string sql = "usp_getNewsByPage";            SqlParameter[] pms = new SqlParameter[] {             new SqlParameter("@pageSize",pageSize),            new SqlParameter("@pageIndex",pageIndex),            new SqlParameter("@recordCount",System.Data.SqlDbType.Int),            new SqlParameter("@pagecount",System.Data.SqlDbType.Int)            };            pms[2].Direction = System.Data.ParameterDirection.Output;            pms[3].Direction = System.Data.ParameterDirection.Output;            #region MyRegion            //执行读取操作            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.StoredProcedure, pms))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        // NewsId,                         //NewsTitle,                         //NewsIssueDate,                         //NewsAuthor,                         //NewsSmallImage,                        //TypeName                        Aspx_News model = new Aspx_News();                        model.NewsId = reader.GetInt32(0);                        model.NewsTitle = reader.GetString(1);                        model.NewsIssueDate = reader.IsDBNull(2) ? null : (DateTime?)reader.GetDateTime(2);                        model.NewsAuthor = reader.IsDBNull(3) ? null : reader.GetString(3);                        model.NewsSmallImage = reader.IsDBNull(4) ? null : reader.GetString(4);                        Aspx_Type typeModel = new Aspx_Type();                        typeModel.TypeName = reader.IsDBNull(5) ? null : reader.GetString(5);                        model.Aspx_TypeObject = typeModel;                        list.Add(model);                    }                }            }            #endregion            recordCount = Convert.ToInt32(pms[2].Value);            pageCount = Convert.ToInt32(pms[3].Value);            return list;        }        public int DeleteByNewsId(int newsId)        {            string sql = "delete from Aspx_News where newsId=@nid";            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, new SqlParameter("@nid", newsId));        }        public Aspx_News GetNewsModelByNewsId(int id)        {            Aspx_News model = null;            string sql = "select * from Aspx_News where NewsId=@nid";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@nid", id)))            {                if (reader.HasRows)                {                    if (reader.Read())                    {                        model = new Aspx_News();                        model.NewsId = reader.GetInt32(0);                        model.NewsTitle = reader.GetString(1);                        model.NewsContent = reader.GetString(2);                        model.NewsIssueDate = reader.IsDBNull(3) ? null : (DateTime?)reader.GetDateTime(3);                        model.NewsAuthor = reader.IsDBNull(4) ? null : reader.GetString(4);                        model.NewsImage = reader.IsDBNull(5) ? null : reader.GetString(5);                        model.NewsSmallImage = reader.IsDBNull(6) ? null : reader.GetString(6);                        model.NewsTypeId = reader.GetInt32(7);                    }                }            }            return model;        }        private object ToDBValue(object value)        {            if (value == null)            {                return DBNull.Value;            }            else            {                return value;            }        }    }}

Aspx_StudentsDal.cs

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Ajax.CRUD.Model;using System.Data.SqlClient;namespace Ajax.CRUD.DAL{    public class Aspx_StudentsDal    {        public List<Aspx_Students> GetAllStudents()        {            List<Aspx_Students> list = new List<Aspx_Students>();            string sql = "select * from Aspx_Students";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        //stuId, stuName, stuAge, stuGender, stuEmail, stuBirthday                        Aspx_Students model = new Aspx_Students();                        model.StuId = reader.GetInt32(0);                        model.StuName = reader.GetString(1);                        model.StuAge = reader.IsDBNull(2) ? null : (int?)reader.GetInt32(2);                        model.StuGender = reader.GetString(3);                        model.StuEmail = reader.GetString(4);                        model.StuBirthday = reader.GetDateTime(5);                        list.Add(model);                    }                }            }            return list;        }        /// <summary>        /// 分页获取数据        /// </summary>        /// <param name="pagesize"></param>        /// <param name="pageindex"></param>        /// <param name="recordcount"></param>        /// <param name="pagecount"></param>        /// <returns></returns>        public List<Aspx_Students> GetStudentsByPage(int pagesize, int pageindex, out int recordcount, out int pagecount)        {            List<Aspx_Students> list = new List<Aspx_Students>();            string sql = "usp_GetSutdentsByPage";            SqlParameter[] pms = new SqlParameter[] {             new SqlParameter("@pagesize",pagesize),            new SqlParameter("@pageIndex",pageindex),            new SqlParameter("@recordCount",System.Data.SqlDbType.Int),            new SqlParameter("@pagecount",System.Data.SqlDbType.Int)            };            pms[2].Direction = System.Data.ParameterDirection.Output;            pms[3].Direction = System.Data.ParameterDirection.Output;            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.StoredProcedure, pms))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        Aspx_Students model = new Aspx_Students();                        model.StuId = reader.GetInt32(0);                        model.StuName = reader.GetString(1);                        model.StuAge = reader.IsDBNull(2) ? null : (int?)reader.GetInt32(2);                        model.StuGender = reader.GetString(3);                        model.StuEmail = reader.GetString(4);                        model.StuBirthday = reader.GetDateTime(5);                        list.Add(model);                    }                }            }            recordcount = Convert.ToInt32(pms[2].Value);            pagecount = Convert.ToInt32(pms[3].Value);            return list;        }        public List<Aspx_Students> GetStudentsBetweentAnd(int startNumber, int maxRows)        {            List<Aspx_Students> list = new List<Aspx_Students>();            string sql = "select * from (select *,rn=row_number() over(order by stuId) from Aspx_Students) as t where t.rn between @sn+1 and @sn+@en+1";            SqlParameter[] pms = new SqlParameter[] {             new SqlParameter("@sn",startNumber),            new SqlParameter("@en",maxRows)            };            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text, pms))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        Aspx_Students model = new Aspx_Students();                        model.StuId = reader.GetInt32(0);                        model.StuName = reader.GetString(1);                        model.StuAge = reader.IsDBNull(2) ? null : (int?)reader.GetInt32(2);                        model.StuGender = reader.GetString(3);                        model.StuEmail = reader.GetString(4);                        model.StuBirthday = reader.GetDateTime(5);                        list.Add(model);                    }                }            }            return list;        }        public Aspx_Students GetStudentInfoBySid(int sid)        {            Aspx_Students model = null;            string sql = "select * from Aspx_Students where StuId=@sid";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@sid", sid)))            {                if (reader.HasRows)                {                    if (reader.Read())                    {                        model = new Aspx_Students();                        model.StuId = reader.GetInt32(0);                        model.StuName = reader.GetString(1);                        model.StuAge = reader.IsDBNull(2) ? null : (int?)reader.GetInt32(2);                        model.StuGender = reader.GetString(3);                        model.StuEmail = reader.GetString(4);                        model.StuBirthday = reader.GetDateTime(5);                    }                }            }            return model;        }        /// <summary>        /// 增加一条记录        /// </summary>        /// <param name="aspx_Student"></param>        /// <returns></returns>        public int Add(Aspx_Students aspx_Student)        {            string sql = "INSERT INTO Aspx_Students (stuName, stuAge, stuGender, stuEmail, stuBirthday) VALUES (@stuName, @stuAge, @stuGender, @stuEmail, @stuBirthday)";            SqlParameter[] para = new SqlParameter[]{new SqlParameter("@stuName", ToDBValue(aspx_Student.StuName)),new SqlParameter("@stuAge", ToDBValue(aspx_Student.StuAge)),new SqlParameter("@stuGender", ToDBValue(aspx_Student.StuGender)),new SqlParameter("@stuEmail", ToDBValue(aspx_Student.StuEmail)),new SqlParameter("@stuBirthday", ToDBValue(aspx_Student.StuBirthday)),};            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, para);        }        //删除一条记录        public int DeleteByStuId(int stuId)        {            string sql = "DELETE from Aspx_Students WHERE StuId = @StuId";            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, new SqlParameter("@stuId", stuId));        }        /// <summary>        /// 更新一条记录        /// </summary>        /// <param name="aspx_Student"></param>        /// <returns></returns>        public int Update(Aspx_Students aspx_Student)        {            string sql = "UPDATE Aspx_Students SET  stuName = @stuName, StuAge = @StuAge, StuGender = @StuGender, StuEmail = @StuEmail, StuBirthday = @StuBirthday WHERE stuId = @stuId";            SqlParameter[] para = new SqlParameter[]{            new SqlParameter("@stuId", aspx_Student.StuId),            new SqlParameter("@StuName", ToDBValue(aspx_Student.StuName)),            new SqlParameter("@StuAge", ToDBValue(aspx_Student.StuAge)),            new SqlParameter("@StuGender", ToDBValue(aspx_Student.StuGender)),            new SqlParameter("@StuEmail", ToDBValue(aspx_Student.StuEmail)),            new SqlParameter("@StuBirthday", ToDBValue(aspx_Student.StuBirthday))            };            return SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, para);        }        //获取表中的总记录条数        public int GetTotalCount()        {            string sql = "select count(*) from Aspx_Students";            return (int)SqlHelper.ExecuteScalar(sql, System.Data.CommandType.Text);        }        public object ToDBValue(object value)        {            if (value == null)            {                return DBNull.Value;            }            else            {                return value;            }        }    }}

Bll层

TblCommentsBll

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Ajax.CRUD.Model;using Ajax.CRUD.DAL;namespace Ajax.CRUD.BLL{    public class TblCommentsBll    {        private TblCommentsDal dal = new TblCommentsDal();        public List<TblComments> GetAllComments()        {            return dal.GetAllComments();        }        public int Add(TblComments tblComment)        {            return dal.Add(tblComment);        }        public int Delete(int autoId)        {            return dal.Delete(autoId);        }        public int Update(TblComments model)        {            return dal.Update(model);        }        public int Delete(TblComments model)        {            return dal.Delete(model.AutoId);        }    }}

Aspx_StudentsBll

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Ajax.CRUD.DAL;using Ajax.CRUD.Model;namespace Ajax.CRUD.BLL{    public class Aspx_StudentsBll    {        private Aspx_StudentsDal dal = new Aspx_StudentsDal();        public List<Aspx_Students> GetAllStudents()        {            return dal.GetAllStudents();        }        public List<Aspx_Students> GetStudentsByPage(int pagesize, int pageindex, out int recordcount, out int pagecount)        {            List<Aspx_Students> list = dal.GetStudentsByPage(pagesize, pageindex, out recordcount, out pagecount);            return list;        }        public List<Aspx_Students> GetStudentsBetweentAnd(int startNumber, int maxRows)        {            return dal.GetStudentsBetweentAnd(startNumber, maxRows);        }        public int Add(Aspx_Students aspx_Student)        {            return dal.Add(aspx_Student);        }        //删除一条记录        public int DeleteByStuId(int stuId)        {            return dal.DeleteByStuId(stuId);        }        //删除一条记录        public int DeleteByStuId(Aspx_Students model)        {            return dal.DeleteByStuId(model.StuId);        }        public Aspx_Students GetStudentInfoBySid(int sid)        {            return dal.GetStudentInfoBySid(sid);        }        public int Update(Aspx_Students aspx_Student)        {            return dal.Update(aspx_Student);        }        //获取表中的总记录条数        public int GetTotalCount()        {            return dal.GetTotalCount();        }    }}

工具类层Utility

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Security.Cryptography;namespace Ajax.CRUD.Utility{    public static class CommonHelper    {        public static string GetMD5FromString(string input)        {            //1.创建一个md5对象            MD5 md5Obj = MD5.Create();            //1.1把字符串转换为byte[]            byte[] buffer = System.Text.Encoding.UTF8.GetBytes(input);            //2.通过md5对象计算给定值的md5            byte[] md5Buffer = md5Obj.ComputeHash(buffer);            // 把byte[]数组转换为字符串            StringBuilder sb = new StringBuilder();            for (int i = 0; i < md5Buffer.Length; i++)            {                sb.Append(md5Buffer[i].ToString("x2"));            }            //3.释放资源            md5Obj.Clear();            return sb.ToString();        }        public static string GetSHA512FromString(string input)        {            //1.创建一个md5对象            SHA512 md5Obj = SHA512.Create();            //1.1把字符串转换为byte[]            byte[] buffer = System.Text.Encoding.UTF8.GetBytes(input);            //2.通过md5对象计算给定值的md5            byte[] md5Buffer = md5Obj.ComputeHash(buffer);            // 把byte[]数组转换为字符串            StringBuilder sb = new StringBuilder();            for (int i = 0; i < md5Buffer.Length; i++)            {                sb.Append(md5Buffer[i].ToString("x2"));            }            //3.释放资源            md5Obj.Clear();            return sb.ToString();        }    }}

分页类PagerHelper.cs

调用方法：使用： this.Literal1.Text = PagerHelper.strPage(6, 3, 2, id, "WebForm3.aspx?id=") 

注意：WebForm3.aspx?id=   这个等号后面什么也不需要些。就这样就可以了。到时候它会自动把页数加上的

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace Web.BLL{    public static class PagerHelper    {        #region 数字分页类        /// <summary>        ///         /// </summary>        /// <param name="intCounts">数据总条数</param>        /// <param name="intPageSizes">页大小</param>        /// <param name="intPageCounts">总共页数</param>        /// <param name="intThisPages">当前页</param>        /// <param name="strUrl">要提交到的页面</param>        /// 使用： this.Literal1.Text = PagerHelper.strPage(6, 3, 2, id, "WebForm3.aspx?id=");        /// <returns></returns>        public static string strPage(int intCounts, int intPageSizes, int intPageCounts, int intThisPages, string strUrl)        {            int intCount = Convert.ToInt32(intCounts); //总记录数            int intPageCount = Convert.ToInt32(intPageCounts); //总共页数            int intPageSize = Convert.ToInt32(intPageSizes); //每页显示            int intPage = 7;  //数字显示            int intThisPage = Convert.ToInt32(intThisPages); //当前页数            int intBeginPage = 0; //开始页数            int intCrossPage = 0; //变换页数            int intEndPage = 0; //结束页数            string strPage = null; //返回值            intCrossPage = intPage / 2;                strPage = "共 <font color=\"#FF0000\">" + intCount.ToString() + "</font> 条记录 第 <font color=\"#FF0000\">" + intThisPage.ToString() + "/" + intPageCount.ToString() + "</font> 页 每页 <font color=\"#FF0000\">" + intPageSize.ToString() + "</font> 条     ";                if (intThisPage > 1)                {                    strPage = strPage + "<a href=\"" + strUrl + "1\">首页</a> ";                    strPage = strPage + "<a href=\"" + strUrl + Convert.ToString(intThisPage - 1) + "\">上一页</a> ";                }                if (intPageCount > intPage)                {                    if (intThisPage > intPageCount - intCrossPage)                    {                        intBeginPage = intPageCount - intPage + 1;                        intEndPage = intPageCount;                    }                else                {                    if (intThisPage <= intPage - intCrossPage)                    {                        intBeginPage = 1;                        intEndPage = intPage;                    }                    else                    {                        intBeginPage = intThisPage - intCrossPage;                        intEndPage = intThisPage + intCrossPage;                    }                }            }            else            {                intBeginPage = 1;                intEndPage = intPageCount;            }            if (intCount > 0)            {                for (int i = intBeginPage; i <= intEndPage; i++)                {                    if (i == intThisPage)                    {                        strPage = strPage + " <font color=\"#FF0000\">" + i.ToString() + "</font> ";                    }                    else                    {                        strPage = strPage + " <a href=\"" + strUrl + i.ToString() + "\" title=\"第" + i.ToString() + "页\">" + i.ToString() + "</a> ";                    }                }            }            if (intThisPage < intPageCount)            {                strPage = strPage + "<a href=\"" + strUrl + Convert.ToString(intThisPage + 1) + "\">下一页</a> ";                strPage = strPage + "<a href=\"" + strUrl + intPageCount.ToString() + "\">尾页</a> ";            }            return strPage;        }        #endregion    }}