12-三层架构

三层架构将整个业务应用划分为：（1）界面UI层；（2）业务逻辑层；（3）数据访问层。

对于复杂的系统分层可以让结构更加清晰，模块更加独立，便于维护。

0077.png

各层的任务：

（1）数据访问层：负责数据库的操作。

（2）业务逻辑层：实现功能模块的业务逻辑。

（3）界面UI层：绘制界面，以及负责界面相关代码。

（4）实体类：将数据库中的表转化为面向对象思想中的类。

一、案例需求和资料准备

搜索：

0078.PNG
添加学生：
0079.PNG
编辑学生信息：
0080.PNG
统计人数：
0081.PNG
案例需求：使用三层架构实现学生信息管理，包括学生信息搜索，信息新增，信息删除，信息编辑修改等。

资料准备：

--专业分类（1）哲学；（2）经济学；（3）法学；（4）教育学；（5）文学；（6）历史学；（7）理学；（8）工学；（9）农学；（10）医学；（11）军事学；（12）管理学；（13）艺术学
create table MajorType
(
    MajorTypeId int primary key identity(1,1), --编号
    MajorTypeName varchar(50) not null --专业分类名称
)
insert into MajorType(MajorTypeName) values('工学')
insert into MajorType(MajorTypeName) values('艺术学')

--专业
create table Major
(
    MajorId int primary key identity(1,1), --编号
    MajorTypeId int not null,  --类型编号
    MajorName varchar(50) not null --专业名称
)
insert into Major(MajorTypeId,MajorName) values(1,'计算机科学与应用')
insert into Major(MajorTypeId,MajorName) values(1,'建筑学')
insert into Major(MajorTypeId,MajorName) values(2,'美术学')
insert into Major(MajorTypeId,MajorName) values(2,'戏剧与影视学')

--学生
create table Student
(
    StudentId int primary key identity(1,1), --编号
    MajorId int not null, --专业编号
    StudentName varchar(50) not null, --学生姓名
    StudentSex varchar(50) not null, --学生性别
    StudentPhone varchar(50) not null, --电话
    StudentMail varchar(50) not null --邮箱
)
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(1,'刘备','男','13554878965','liubei@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(1,'关羽','男','15389874521','guanyu@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(2,'张飞','男','18987542525','zhangfei@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(2,'赵云','男','13696896547','zhaoyun@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(3,'黄忠','男','13778777888','huangzhong@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(3,'马超','男','13221212325','machao@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(4,'魏延','男','13996147455','weiyan@qq.com')
insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail)
values(4,'周仓','男','13437522241','zhoucang@qq.com')

二、项目结构

（1）创建一个空白解决方案。

（2）在解决方案中创建类库项目MyEntity代表"实体类"。

（3）在解决方案中创建类库项目MyDAL代表"数据访问层"。

（4）在解决方案中创建类库项目MyBLL代表"业务逻辑层"。

（5）在解决方案中创建网站程序MyUI代表"界面UI层"。

0012.PNG

三、实体类编写

namespace MyEntity
{
    //专业类型
    public class MajorTypeEntity
    {
        public int MajorTypeId { get; set; } //编号
        public string MajorTypeName { get; set; }//专业分类名称
    }
}

namespace MyEntity
{
    //专业
    public class MajorEntity
    {
        public int MajorId { get; set; } //编号
        public int MajorTypeId { get; set; } //类型编号
        public string MajorName { get; set; } //专业名称
    }
}

namespace MyEntity
{
    //学生
    public class StudentEntity
    {
        public int StudentId { get; set; } //编号
        public int MajorId { get; set; } //专业编号
        public string StudentName { get; set; } //学生性别
        public string StudentSex { get; set; } //学生性别
        public string StudentPhone { get; set; } //学生电话
        public string StudentMail { get; set; } //学生邮箱

        //添加对象方便查询
        public MajorTypeEntity typeEntity { get; set; } //专业类型对象
        public MajorEntity majorEntity { get; set; } //专业对象
    }
}

四、数据访问层编写

（1）由于数据访问层需要使用实体类，所以需要添加实体类的引用。

即在MyDAL项目上右键-->添加-->引用-->项目，在项目中勾选MyEntity项目。

（2）将之前封装好的DBHelper文件复制到MyDAL项目中，并通过添加现有项，将DBHelper加入项目

备注：DBHelper参照第一章内容

namespace MyDAL
{
    public class MajorTypeDAL
    {
        DBHelper db = new DBHelper();
        #region 添加专业类型
        public int Add(MajorTypeEntity entity)
        {
            string sql = "insert into MajorType(MajorTypeName) values(@MajorTypeName)";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeName", entity.MajorTypeName);
            return db.ExecNonQuery();
        }
        #endregion

        #region 删除专业类型
        public int Delete(int MajorTypeId)
        {
            string sql = "delete from MajorType where MajorTypeId = @MajorTypeId";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeId", MajorTypeId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 修改专业类型
        public int Update(MajorTypeEntity entity)
        {
            string sql = "update MajorType set MajorTypeName=@MajorTypeName where MajorTypeId=@MajorTypeId";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeName", entity.MajorTypeName);
            db.SetParameter("MajorTypeId", entity.MajorTypeId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 查询所有专业类型
        public List<MajorTypeEntity> List()
        {
            string sql = "select * from MajorType";
            db.PrepareSql(sql);
            SqlDataReader reader = db.ExecDataReader();
            List<MajorTypeEntity> list = new List<MajorTypeEntity>();
            while (reader.Read())
            {
                MajorTypeEntity entity = new MajorTypeEntity();
                entity.MajorTypeId = int.Parse(reader["MajorTypeId"].ToString());
                entity.MajorTypeName = reader["MajorTypeName"].ToString();
                list.Add(entity);
            }
            reader.Close();
            return list;
        }
        #endregion

        #region 查询一个专业类型详情
        public MajorTypeEntity Detail(int MajorTypeId)
        {
            string sql = "select * from MajorType where MajorTypeId=@MajorTypeId";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeId", MajorTypeId);
            DataTable dt = new DataTable();
            dt = db.ExecQuery();
            if (dt.Rows.Count == 0)
                return null;
            MajorTypeEntity entity = new MajorTypeEntity();
            entity.MajorTypeId = int.Parse(dt.Rows[0]["MajorTypeId"].ToString());
            entity.MajorTypeName = dt.Rows[0]["MajorTypeName"].ToString();
            return entity;
        }
        #endregion


    }
}

namespace MyDAL
{
    public class MajorDAL
    {
        DBHelper db = new DBHelper();

        #region 添加专业
        public int Add(MajorEntity entity)
        {
            string sql = "insert into Major(MajorTypeId,MajorName) values(@MajorTypeId,@MajorName)";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeId", entity.MajorTypeId);
            db.SetParameter("MajorName", entity.MajorName);
            return db.ExecNonQuery();
        }
        #endregion

        #region 删除专业
        public int Delete(int MajorId)
        {
            string sql = "delete from Major where MajorId = @MajorId";
            db.PrepareSql(sql);
            db.SetParameter("MajorId", MajorId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 修改专业
        public int Update(MajorEntity entity)
        {
            string sql = "update Major set MajorTypeId=@MajorTypeId,MajorName=@MajorName where MajorId=@MajorId";
            db.PrepareSql(sql);
            db.SetParameter("MajorTypeId", entity.MajorTypeId);
            db.SetParameter("MajorName", entity.MajorName);
            db.SetParameter("MajorId", entity.MajorId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 查询所有专业
        public List<MajorEntity> List()
        {
            string sql = "select * from Major";
            db.PrepareSql(sql);
            SqlDataReader reader = db.ExecDataReader();
            List<MajorEntity> list = new List<MajorEntity>();
            while (reader.Read())
            {
                MajorEntity entity = new MajorEntity();
                entity.MajorId = int.Parse(reader["MajorId"].ToString());
                entity.MajorTypeId = int.Parse(reader["MajorTypeId"].ToString());
                entity.MajorName = reader["MajorName"].ToString();
                list.Add(entity);
            }
            reader.Close();
            return list;
        }
        #endregion

        #region 查询一个专业详情
        public MajorEntity Detail(int MajorId)
        {
            string sql = "select * from Major where MajorId=@MajorId";
            db.PrepareSql(sql);
            db.SetParameter("MajorId", MajorId);
            DataTable dt = new DataTable();
            dt = db.ExecQuery();
            if (dt.Rows.Count == 0)
                return null;
            MajorEntity entity = new MajorEntity();
            entity.MajorId = int.Parse(dt.Rows[0]["MajorId"].ToString());
            entity.MajorTypeId = int.Parse(dt.Rows[0]["MajorTypeId"].ToString());
            entity.MajorName = dt.Rows[0]["MajorName"].ToString();
            return entity;
        }
        #endregion
    }
}

namespace MyDAL
{
    public class StudentDAL
    {
        DBHelper db = new DBHelper();

        #region 添加学生
        public int Add(StudentEntity entity)
        {
            string sql = "insert into Student(MajorId,StudentName,StudentSex,StudentPhone,StudentMail) values(@MajorId,@StudentName,@StudentSex,@StudentPhone,@StudentMail)";
            db.PrepareSql(sql);
            db.SetParameter("MajorId", entity.MajorId);
            db.SetParameter("StudentName", entity.StudentName);
            db.SetParameter("StudentSex", entity.StudentSex);
            db.SetParameter("StudentPhone", entity.StudentPhone);
            db.SetParameter("StudentMail", entity.StudentMail);
            return db.ExecNonQuery();
        }
        #endregion

        #region 删除学生
        public int Delete(int StudentId)
        {
            string sql = "delete from Student where StudentId = @StudentId";
            db.PrepareSql(sql);
            db.SetParameter("StudentId", StudentId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 修改学生
        public int Update(StudentEntity entity)
        {
            string sql = "update Student set MajorId=@MajorId,StudentName=@StudentName,StudentSex=@StudentSex,StudentPhone=@StudentPhone,StudentMail=@StudentMail where StudentId=@StudentId";
            db.PrepareSql(sql);
            db.SetParameter("MajorId", entity.MajorId);
            db.SetParameter("StudentName", entity.StudentName);
            db.SetParameter("StudentSex", entity.StudentSex);
            db.SetParameter("StudentPhone", entity.StudentPhone);
            db.SetParameter("StudentMail", entity.StudentMail);
            db.SetParameter("StudentId", entity.StudentId);
            return db.ExecNonQuery();
        }
        #endregion

        #region 查询所有学生
        public List<StudentEntity> List()
        {
            string sql = "select * from Student";
            db.PrepareSql(sql);
            SqlDataReader reader = db.ExecDataReader();
            List<StudentEntity> list = new List<StudentEntity>();
            while (reader.Read())
            {
                StudentEntity entity = new StudentEntity();
                entity.StudentId = int.Parse(reader["StudentId"].ToString());
                entity.MajorId = int.Parse(reader["MajorId"].ToString());
                entity.StudentName = reader["StudentName"].ToString();
                entity.StudentSex = reader["StudentSex"].ToString();
                entity.StudentPhone = reader["StudentPhone"].ToString();
                entity.StudentMail = reader["StudentMail"].ToString();
                list.Add(entity);
            }
            reader.Close();
            return list;
        }
        #endregion

        #region 查询一个学生详情
        public StudentEntity Detail(int StudentId)
        {
            string sql = "select * from Student where StudentId=@StudentId";
            db.PrepareSql(sql);
            db.SetParameter("StudentId", StudentId);
            DataTable dt = new DataTable();
            dt = db.ExecQuery();
            if (dt.Rows.Count == 0)
                return null;
            StudentEntity entity = new StudentEntity();
            entity.StudentId = int.Parse(dt.Rows[0]["StudentId"].ToString());
            entity.MajorId = int.Parse(dt.Rows[0]["MajorId"].ToString());
            entity.StudentName = dt.Rows[0]["StudentName"].ToString();
            entity.StudentSex = dt.Rows[0]["StudentSex"].ToString();
            entity.StudentPhone = dt.Rows[0]["StudentPhone"].ToString();
            entity.StudentMail = dt.Rows[0]["StudentMail"].ToString();
            return entity;           
        }
        #endregion

        //--------------------------------------------------------------------------------------------------
        #region 搜索学生
        public List<StudentEntity> Search(StudentEntity searchEntity,int pageSize, int pageIndex, out int recordCount)
        {
            //搜索条件处理
            string sqlWhere = "";
            if (searchEntity.StudentName != null && searchEntity.StudentName.Length != 0)
                sqlWhere += " and StudentName like '%" + searchEntity.StudentName + "%'";
            //求总记录数量
            string sqlCount = "select count(*) from Student left join Major on Student.MajorId = Major.MajorId left join MajorType on Major.MajorTypeId = MajorType.MajorTypeId where 1 = 1 " + sqlWhere;
            db.PrepareSql(sqlCount);
            recordCount = (int)db.ExecScalar();
            //重新计算pageIndex
            pageIndex = PageHelper.ComputeCurrPage(pageIndex, pageSize, recordCount);
            string sql = "select * from (select ROW_NUMBER() over(order by StudentId desc) RowId,Student.*,Major.MajorTypeId,Major.MajorName,MajorType.MajorTypeName from Student left join Major on Student.MajorId = Major.MajorId left join MajorType on Major.MajorTypeId = MajorType.MajorTypeId where 1 = 1 "+sqlWhere+") Temp where RowId between @Start and @End ";
            db.PrepareSql(sql);
            db.SetParameter("Start", (pageIndex - 1) * pageSize + 1);
            db.SetParameter("End", pageIndex * pageSize);
            SqlDataReader reader = db.ExecDataReader();
            List<StudentEntity> list = new List<StudentEntity>();
            while (reader.Read())
            {
                StudentEntity entity = new StudentEntity();
                entity.StudentId = int.Parse(reader["StudentId"].ToString());
                entity.MajorId = int.Parse(reader["MajorId"].ToString());
                entity.StudentName = reader["StudentName"].ToString();
                entity.StudentSex = reader["StudentSex"].ToString();
                entity.StudentPhone = reader["StudentPhone"].ToString();
                entity.StudentMail = reader["StudentMail"].ToString();
                entity.majorEntity = new MajorEntity();
                entity.majorEntity.MajorId = int.Parse(reader["MajorId"].ToString());
                entity.majorEntity.MajorName = reader["MajorName"].ToString();
                entity.majorEntity.MajorTypeId = int.Parse(reader["MajorTypeId"].ToString());
                entity.typeEntity = new MajorTypeEntity();
                entity.typeEntity.MajorTypeId = int.Parse(reader["MajorTypeId"].ToString());
                entity.typeEntity.MajorTypeName = reader["MajorTypeName"].ToString();
                list.Add(entity);
            }
            reader.Close();
            return list;
        }
        #endregion

        #region 根据专业类型分组统计学生人数
        public List<object> GetCountByType()
        {
            string sql = "select MajorTypeName,COUNT(*) StuCount from Student ";
            sql += " left join Major on Student.MajorId = Major.MajorId ";
            sql += " left join MajorType on Major.MajorTypeId = MajorType.MajorTypeId ";
            sql += " group by MajorType.MajorTypeId,MajorTypeName ";
            db.PrepareSql(sql);
            DataTable dt = new DataTable();
            dt = db.ExecQuery();
            List<object> list = new List<object>();
            foreach (DataRow dr in dt.Rows)
            {
                var obj = new { TypeName = dr["MajorTypeName"].ToString(), StuCount = dr["StuCount"].ToString() };
                list.Add(obj);
            }
            return list;
        }
        #endregion
    }
}

数据访问层添加了一个工具PageHelper辅助分页功能，此工具也可以单独建立项目来实现。

namespace MyDAL
{
    /// <summary>
    ///PageHelper 的摘要说明
    /// </summary>
    public class PageHelper
    {
        #region 计算总页数
        public static int GetTotalPage(int totalRecord, int pageSize)
        {
            int totalPage = 0;
            if (totalRecord % pageSize == 0)
                totalPage = totalRecord / pageSize;
            else
                totalPage = totalRecord / pageSize + 1;
            return totalPage;
        }
        #endregion

        #region 计算当前页
        public static int ComputeCurrPage(int currPage, int totalPage)
        {

            if (currPage < 1)
                currPage = 1;
            if (currPage > totalPage)
                currPage = totalPage;
            return currPage;
        }
        public static int ComputeCurrPage(int pageIndex, int pageSize, int recordCount)
        {
            int pageCount = recordCount % pageSize == 0 ? recordCount / pageSize : recordCount / pageSize + 1;
            if (pageIndex < 1)
                pageIndex = 1;
            if (pageIndex > pageCount)
                pageIndex = pageCount;
            return pageIndex;
        }
        #endregion
    }
}

五、业务逻辑层编写

（1）由于业务逻辑层需要使用实体类，所以需要添加实体类的引用。

即在MyBLL项目上右键-->添加-->引用-->项目，在项目中勾选MyEntity项目。

（2）由于业务逻辑层需要调用数据访问层，所以需要添加数据访问层的引用。

即在MyBLL项目上右键-->添加-->引用-->项目，在项目中勾选MyDAL项目。

namespace MyBLL
{
    public class MajorTypeBLL
    {
        MajorTypeDAL dal = new MajorTypeDAL();

        #region 添加专业类型
        public int Add(MajorTypeEntity entity)
        {
            return dal.Add(entity);
        }
        #endregion

        #region 删除专业类型
        public int Delete(int MajorTypeId)
        {
            return dal.Delete(MajorTypeId);
        }
        #endregion

        #region 修改专业类型
        public int Update(MajorTypeEntity entity)
        {
            return dal.Update(entity);
        }
        #endregion

        #region 查询所有专业类型
        public List<MajorTypeEntity> List()
        {
            return dal.List();
        }
        #endregion

        #region 查询一个专业类型详情
        public MajorTypeEntity Detail(int MajorTypeId)
        {
            return dal.Detail(MajorTypeId);
        }
        #endregion

    }
}

namespace MyBLL
{
    public class MajorBLL
    {
        MajorDAL dal = new MajorDAL();

        #region 添加专业
        public int Add(MajorEntity entity)
        {
            return dal.Add(entity);
        }
        #endregion

        #region 删除专业
        public int Delete(int MajorId)
        {
            return dal.Delete(MajorId);
        }
        #endregion

        #region 修改专业
        public int Update(MajorEntity entity)
        {
            return dal.Update(entity);
        }
        #endregion

        #region 查询所有专业
        public List<MajorEntity> List()
        {
            return dal.List();
        }
        #endregion

        #region 查询一个专业详情
        public MajorEntity Detail(int MajorId)
        {
            return dal.Detail(MajorId);
        }
        #endregion
    }
}

namespace MyBLL
{
    public class StudentBLL
    {
        StudentDAL dal = new StudentDAL();

        #region 添加学生
        public int Add(StudentEntity entity)
        {
            return dal.Add(entity);
        }
        #endregion

        #region 删除学生
        public int Delete(int StudentId)
        {
            return dal.Delete(StudentId);
        }
        #endregion

        #region 修改学生
        public int Update(StudentEntity entity)
        {
            return dal.Update(entity);
        }
        #endregion

        #region 查询所有学生
        public List<StudentEntity> List()
        {
            return dal.List();
        }
        #endregion

        #region 查询一个学生详情
        public StudentEntity Detail(int StudentId)
        {
            return dal.Detail(StudentId);
        }
        #endregion

        //----------------------------------------------------------------
        #region 搜索学生
        public List<StudentEntity> Search(StudentEntity searchEntity, int pageSize, int pageIndex, out int recordCount)
        {
            return dal.Search(searchEntity, pageSize, pageIndex, out recordCount);
        }
        #endregion

        #region 根据专业类型分组统计学生人数
        public List<object> GetCountByType()
        {
            return dal.GetCountByType();
        }
        #endregion
    }
}

六、界面UI层编写

（1）由于界面UI层需要使用实体类，所以需要添加实体类的引用。

即在MyUI项目上右键-->添加-->引用-->项目，在项目中勾选MyEntity项目。

（2）由于界面UI层需要调用业务逻辑层，所以需要添加业务逻辑层的引用。

即在MyUI项目上右键-->添加-->引用-->项目，在项目中勾选MyBLL项目。

学生搜索查询及删除代码：

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>首页-学生列表</title>
    <style type="text/css">
        #search{ text-align:center; height:30px; line-height:30px;}
        #mylist table{ margin:10px auto;}
    </style>
    <link href="reveal/reveal.css" rel="stylesheet" type="text/css" />
    <script src="reveal/jquery-1.4.4.min.js" type="text/javascript"></script>
    <script src="reveal/jquery.reveal.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $(".update").click(function () {
                //alert(this.id);
                $("#EditFrame").attr("src", "Update.aspx?StudentId=" + this.id.split("_")[1]);
            })
        })
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div id="search">
        请输入姓名:<asp:TextBox ID="key" runat="server" ClientIDMode="Static"></asp:TextBox>
        <asp:Button ID="btSearch" runat="server" Text="立即搜索" onclick="btSearch_Click" />
        <a href="#"  data-reveal-id="AddModal" data-animation="none">添加学生</a>
        <a href="Group.aspx" target="_blank">统计人数</a>
    </div>
    <div id="mylist">
        <asp:GridView ID="gvStudent" runat="server" DataKeyNames="StudentId" AutoGenerateColumns="False" 
            CellPadding="4" ForeColor="#333333" GridLines="None" Width="912px" 
            onrowdeleting="gvStudent_RowDeleting">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="typeEntity.MajorTypeName" HeaderText="专业类型" />
                <asp:BoundField DataField="majorEntity.MajorName" HeaderText="专业名称" />
                <asp:BoundField DataField="StudentName" HeaderText="学生姓名" />
                <asp:BoundField DataField="StudentSex" HeaderText="学生性别" />
                <asp:BoundField DataField="StudentPhone" HeaderText="电话" />
                <asp:BoundField DataField="StudentMail" HeaderText="邮箱" />
                <asp:TemplateField>
                    <HeaderTemplate>操作</HeaderTemplate>
                    <ItemTemplate>
                        <a href="#"  data-reveal-id="EditModal" data-animation="none" class="update" id="a_<%#Eval("StudentId")%>">编辑</a>
                        <asp:LinkButton  ID="lbDelete" runat="server" CommandName="delete" OnClientClick="return confirm('确定要删除吗?');">删除</asp:LinkButton>                  
                    </ItemTemplate>  
                </asp:TemplateField>
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
    </div>
    <div>
        <uc1:NumPage ID="MyPage" runat="server" OnPageIndexChanged="MyPage_PageIndexChanged"   />
    </div>
    </form>
</body>
</html>
<%--由于插件样式表中left:50%,所以将margin-left设置成width的一半实现居中--%>
<div id="AddModal" class="reveal-modal" style=" width:520px; margin-left:-260px; height:320px;">
    <iframe src="Add.aspx" frameborder="0" width="520" height="320"></iframe>
    <a class="close-reveal-modal">&#215;</a>
</div>
<div id="EditModal" class="reveal-modal" style=" width:520px; margin-left:-260px; height:320px;">
    <iframe src="" frameborder="0" width="520" height="320" id="EditFrame"></iframe>
    <a class="close-reveal-modal">&#215;</a>
</div>

其中使用了Jquery和reveal插件，插件见实际项目。

namespace MyUI
{
    public partial class Index : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindData();
            }
        }

        #region 绑定数据到控件
        private void BindData()
        {
            //计算当前页
            int PageIndex = this.MyPage.GetPageIndex();
            //页码大小
            int PageSize = 3;
            //设置搜索条件给数据查询
            StudentEntity entity = new StudentEntity();
            entity.StudentName = this.key.Text;
            StudentBLL bll = new StudentBLL();
            int RecordCount = 0;
            List<StudentEntity> list = new List<StudentEntity>();
            list = bll.Search(entity, PageSize, PageIndex, out RecordCount);
            //绑定数据到控件
            this.gvStudent.DataSource = list;
            this.gvStudent.DataBind();
            //显示分页控件
            this.MyPage.ShowControl(PageSize, RecordCount);
        }
        #endregion

        protected void btSearch_Click(object sender, EventArgs e)
        {
            this.MyPage.SetPageIndex(1);
            BindData();
        }

        #region 删除学生信息
        protected void gvStudent_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            StudentBLL bll = new StudentBLL();
            bll.Delete(int.Parse(e.Keys["StudentId"].ToString()));
            BindData();
        }
        #endregion

        #region 分页
        protected void MyPage_PageIndexChanged(object sender, EventArgs e)
        {
            BindData();
        }
        #endregion

    }
}

学生新增代码：

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>添加学生</title>
    <style type="text/css">
        body,div{ margin:0px; padding:0px;}
        #addTitle{ font-size:16px; font-weight:bold; text-align:center; background-color:#f3f3f3; height:30px; line-height:30px;}
        #myTable{ width:500px; margin:10px auto;}
        #myTable td{ height:30px; line-height:30px;}
        .lefttd{ width:100px; text-align:right;}
        .rightrd{ width:400px; text-align:left;}
        .errInfo{ color:Red;}
    </style>
    <script src="jquery/jquery.js" type="text/javascript"></script>
    <script type="text/javascript">
        var jsonType = <%=ViewState["listType"] %>;
        var jsonMajor = <%=ViewState["listMajor"]%>;
        //绑定专业类型
        function BindType()
        {
            $("#ddlType").append("<option value=''>--请选择--</option>");
            for(var i = 0;i< jsonType.length;i++)
            {
                $("#ddlType").append("<option value='"+jsonType[i].MajorTypeId+"'>"+jsonType[i].MajorTypeName+"</option>");
            }
        }
        //绑定专业
        function BindMajor()
        {
            $("#ddlMajor").append("<option value=''>--请选择--</option>");
        }
        //检查专业类型
        function CheckType()
        {
            if($("#ddlType").val() == "")
            {
                $("#spanType").html("请选择专业类型");
                return false;
            }
            else
            {
                $("#spanType").html("");
                return true;              
            }
        }
        //检查专业
        function CheckMajor()
        {
            if($("#ddlMajor").val() == "")
            {
                $("#spanMajor").html("请选择专业类型");
                return false;
            }
            else
            {
                $("#spanMajor").html("");
                return true;              
            }
        }
        //检查姓名
        function CheckName()
        {
            if($("#txtName").val() == "")
            {
                $("#spanName").html("姓名不能为空");
                return false;
            }
            else
            {
                $("#spanName").html("");
                return true;              
            }
        }
        //检查性别
        function CheckSex()
        {
            if($(":checked[name=sex]").length == 0)
            {
                $("#spanSex").html("性别不能为空");
                return false; 
            }
            else
            {
                $("#spanSex").html("");
                return true;    
            }
        }
        //检查电话
        function CheckPhone()
        {
            var exp = /^(13|15|18)\d{9}$/;
            if(!exp.test($("#txtPhone").val()))
            {
                $("#spanPhone").html("手机号码为空或者格式不正确");
                return false;
            }
            else
            {
                $("#spanPhone").html("");
                return true;                    
            }     
        }
        //检查邮箱
        function CheckMail()
        {
            var exp = /^\w+@\w+(\.[a-zA-Z]{2,3}){1,2}$/;
            if(!exp.test($("#txtMail").val()))
            {
                $("#spanMail").html("邮箱为空或者格式不正确");
                return false;
            }
            else
            {
                $("#spanMail").html("");
                return true;                    
            }           
        }


        $(function(){
            BindType();
            BindMajor();
             //选择专业类型的时候切换专业
            $("#ddlType").change(function(){
                $("#ddlMajor").html("");
                $("#ddlMajor").append("<option value=''>--请选择--</option>");
                if($("#ddlType").val() == "")
                    return;
                for(var i = 0;i< jsonMajor.length;i++)
                {
                    if(jsonMajor[i].MajorTypeId == $("#ddlType").val())
                        $("#ddlMajor").append("<option value='"+jsonMajor[i].MajorId+"'>"+jsonMajor[i].MajorName+"</option>");
                }       
            }) 
            

            //表单提交验证
            $("#form1").submit(function(){
                if(CheckType()==true & CheckMajor()==true & CheckName()==true & CheckSex()==true & 
                CheckPhone() == true & CheckMail() == true)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            })

            $("#ddlType").blur(function(){
                CheckType();
            })
            $("#ddlMajor").blur(function(){
                CheckMajor();
            })
            $("#txtName").blur(function(){
                CheckName();
            })
            $("[name=sex]").blur(function(){
                CheckSex();
            })
            $("#txtPhone").blur(function(){
                CheckPhone();
            })
            $("#txtMail").blur(function(){
                CheckMail();
            })
        })
    </script>
</head>
<body>
    <form id="form1" runat="server" clientidmode="Static">
    <div>
        <div id="addTitle">添加学生信息</div>
        <table id="myTable">
            <tr>
                <td class="lefttd">专业类型：</td>
                <td class="rightrd">
                    <asp:DropDownList ID="ddlType" runat="server" ClientIDMode="Static">
                    </asp:DropDownList>
                    <span id="spanType" class="errInfo"></span>                   
                </td>
            </tr>
            <tr>
                <td class="lefttd">专业：</td>
                <td class="rightrd">
                    <asp:DropDownList ID="ddlMajor" runat="server" ClientIDMode="Static">
                    </asp:DropDownList>
                    <span id="spanMajor" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">姓名：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtName" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanName" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">性别：</td>
                <td class="rightrd">
                    <asp:RadioButton ID="rbBoy" runat="server" Text="男" Checked="false" GroupName="sex" ClientIDMode="Static" />
                    <asp:RadioButton ID="rbGirl" runat="server" Text="女" Checked="false" GroupName="sex"  ClientIDMode="Static" />
                    <span id="spanSex" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">电话：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtPhone" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanPhone" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">邮箱：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtMail" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanMail" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">&nbsp;</td>
                <td class="rightrd">
                    <asp:Button ID="btAdd" runat="server" ClientIDMode="Static" Text="添加学生" onclick="btAdd_Click" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

namespace MyUI
{
    public partial class Add : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                BindData();
        }

        #region 绑定类型和专业
        private void BindData()
        {
            List<MajorTypeEntity> listType = new List<MajorTypeEntity>();
            MajorTypeBLL typeBll = new MajorTypeBLL();
            listType = typeBll.List();
            ViewState["listType"] = MyJson.ToJsJson(listType);

            List<MajorEntity> listMajor = new List<MajorEntity>();
            MajorBLL majorBll = new MajorBLL();
            listMajor = majorBll.List();
            ViewState["listMajor"] = MyJson.ToJsJson(listMajor);
        }
        #endregion

        #region 添加学生信息
        protected void btAdd_Click(object sender, EventArgs e)
        {
            StudentBLL bll = new StudentBLL();
            StudentEntity entity = new StudentEntity();
            entity.MajorId = int.Parse(Request["ddlMajor"]);
            entity.StudentName = this.txtName.Text;
            entity.StudentSex = this.rbBoy.Checked == true ? "男" : "女";
            entity.StudentPhone = this.txtPhone.Text;
            entity.StudentMail = this.txtMail.Text;
            bll.Add(entity);
            Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('添加成功');window.parent.location.reload();</script>");
        }
        #endregion
    }
}

学生编辑修改代码：

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>修改学生</title>
    <style type="text/css">
        body,div{ margin:0px; padding:0px;}
        #addTitle{ font-size:16px; font-weight:bold; text-align:center; background-color:#f3f3f3; height:30px; line-height:30px;}
        #myTable{ width:500px; margin:10px auto;}
        #myTable td{ height:30px; line-height:30px;}
        .lefttd{ width:100px; text-align:right;}
        .rightrd{ width:400px; text-align:left;}
        .errInfo{ color:Red;}
    </style>
    <script src="jquery/jquery.js" type="text/javascript"></script>
    <script type="text/javascript">
        var jsonType = <%=ViewState["listType"] %>;
        var jsonMajor = <%=ViewState["listMajor"]%>;
        //检查专业类型
        function CheckType()
        {
            if($("#ddlType").val() == "")
            {
                $("#spanType").html("请选择专业类型");
                return false;
            }
            else
            {
                $("#spanType").html("");
                return true;              
            }
        }
        //检查专业
        function CheckMajor()
        {
            if($("#ddlMajor").val() == "")
            {
                $("#spanMajor").html("请选择专业类型");
                return false;
            }
            else
            {
                $("#spanMajor").html("");
                return true;              
            }
        }
        //检查姓名
        function CheckName()
        {
            if($("#txtName").val() == "")
            {
                $("#spanName").html("姓名不能为空");
                return false;
            }
            else
            {
                $("#spanName").html("");
                return true;              
            }
        }
        //检查性别
        function CheckSex()
        {
            if($(":checked[name=sex]").length == 0)
            {
                $("#spanSex").html("性别不能为空");
                return false; 
            }
            else
            {
                $("#spanSex").html("");
                return true;    
            }
        }
        //检查电话
        function CheckPhone()
        {
            var exp = /^(13|15|18)\d{9}$/;
            if(!exp.test($("#txtPhone").val()))
            {
                $("#spanPhone").html("手机号码为空或者格式不正确");
                return false;
            }
            else
            {
                $("#spanPhone").html("");
                return true;                    
            }     
        }
        //检查邮箱
        function CheckMail()
        {
            var exp = /^\w+@\w+(\.[a-zA-Z]{2,3}){1,2}$/;
            if(!exp.test($("#txtMail").val()))
            {
                $("#spanMail").html("邮箱为空或者格式不正确");
                return false;
            }
            else
            {
                $("#spanMail").html("");
                return true;                    
            }           
        }

        $(function(){
            $("#ddlType").change(function(){
                $("#ddlMajor").html("");
                $("#ddlMajor").append("<option value=''>--请选择--</option>");
                if($("#ddlType").val() == "")
                    return;
                for(var i = 0;i< jsonMajor.length;i++)
                {
                    if(jsonMajor[i].MajorTypeId == $("#ddlType").val())
                        $("#ddlMajor").append("<option value='"+jsonMajor[i].MajorId+"'>"+jsonMajor[i].MajorName+"</option>");
                }                 
            })


            //表单提交验证
            $("#form1").submit(function(){
                if(CheckType()==true & CheckMajor()==true & CheckName()==true & CheckSex()==true & 
                CheckPhone() == true & CheckMail() == true)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            })

            $("#ddlType").blur(function(){
                CheckType();
            })
            $("#ddlMajor").blur(function(){
                CheckMajor();
            })
            $("#txtName").blur(function(){
                CheckName();
            })
            $("[name=sex]").blur(function(){
                CheckSex();
            })
            $("#txtPhone").blur(function(){
                CheckPhone();
            })
            $("#txtMail").blur(function(){
                CheckMail();
            })

        })

    </script>
</head>
<body>
    <form id="form1" runat="server" clientidmode="Static">
    <div>
        <div id="addTitle">添加学生信息</div>
        <table id="myTable">
            <tr>
                <td class="lefttd">专业类型：</td>
                <td class="rightrd">
                    <asp:DropDownList ID="ddlType" runat="server" ClientIDMode="Static">
                    </asp:DropDownList>
                    <span id="spanType" class="errInfo"></span>                   
                </td>
            </tr>
            <tr>
                <td class="lefttd">专业：</td>
                <td class="rightrd">
                    <asp:DropDownList ID="ddlMajor" runat="server" ClientIDMode="Static">
                    </asp:DropDownList>
                    <span id="spanMajor" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">姓名：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtName" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanName" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">性别：</td>
                <td class="rightrd">
                    <asp:RadioButton ID="rbBoy" runat="server" Text="男" Checked="false" GroupName="sex" ClientIDMode="Static" />
                    <asp:RadioButton ID="rbGirl" runat="server" Text="女" Checked="false" GroupName="sex"  ClientIDMode="Static" />
                    <span id="spanSex" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">电话：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtPhone" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanPhone" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">邮箱：</td>
                <td class="rightrd">
                    <asp:TextBox ID="txtMail" runat="server" ClientIDMode="Static"></asp:TextBox>
                    <span id="spanMail" class="errInfo"></span>
                </td>
            </tr>
            <tr>
                <td class="lefttd">&nbsp;</td>
                <td class="rightrd">
                    <asp:Button ID="btUpdate" runat="server" ClientIDMode="Static" Text="修改学生" 
                        onclick="btUpdate_Click" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

namespace MyUI
{
    public partial class Update : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                BindData();
        }

        #region 学生信息
        private void BindData()
        {            
            //获取学生详情
            StudentEntity stuEntity = new StudentEntity();
            StudentBLL stuBll = new StudentBLL();
            stuEntity = stuBll.Detail(int.Parse(Request["StudentId"].ToString()));
            if (stuEntity == null)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('找不到该学生信息');window.parent.location.reload();</script>");
                return;
            }
            //通过学生信息获取专业信息，从专业信息中才能获取专业类型编号，因为学生表中没有专业类型编号
            MajorEntity majorEntity = new MajorEntity();
            MajorBLL majorBll = new MajorBLL();
            majorEntity = majorBll.Detail(stuEntity.MajorId);

            //绑定专业类型下拉框
            List<MajorTypeEntity> listType = new List<MajorTypeEntity>();
            MajorTypeBLL typeBll = new MajorTypeBLL();
            listType = typeBll.List();
            this.ddlType.DataSource = listType;
            this.ddlType.DataValueField = "MajorTypeId";
            this.ddlType.DataTextField = "MajorTypeName";
            this.ddlType.DataBind();
            this.ddlType.Items.Insert(0, new ListItem("--请选择--", ""));
            this.ddlType.SelectedValue = majorEntity.MajorTypeId.ToString();           
            ViewState["listType"] = MyJson.ToJsJson(listType);

            //绑定专业下拉框
            List<MajorEntity> listMajor = new List<MajorEntity>();
            listMajor = majorBll.List();
            ViewState["listMajor"] = MyJson.ToJsJson(listMajor);
            listMajor = listMajor.Where(p=>p.MajorTypeId == majorEntity.MajorTypeId).ToList();
            this.ddlMajor.DataSource = listMajor;
            this.ddlMajor.DataValueField = "MajorId";
            this.ddlMajor.DataTextField = "MajorName";
            this.ddlMajor.DataBind();
            this.ddlMajor.Items.Insert(0, new ListItem("--请选择--", ""));
            this.ddlMajor.SelectedValue = stuEntity.MajorId.ToString(); 
            

            //绑定表单其它元素
            this.txtName.Text = stuEntity.StudentName;
            this.txtPhone.Text = stuEntity.StudentPhone;
            this.txtMail.Text = stuEntity.StudentMail;
            if (stuEntity.StudentSex.Equals("男")) this.rbBoy.Checked = true;
            if (stuEntity.StudentSex.Equals("女")) this.rbGirl.Checked = true;
        }
        #endregion

        #region 修改学生信息
        protected void btUpdate_Click(object sender, EventArgs e)
        {
            StudentEntity entity = new StudentEntity();
            StudentBLL bll = new StudentBLL();
            entity = bll.Detail(int.Parse(Request["StudentId"].ToString()));
            if (entity == null)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('找不到该学生信息');window.parent.location.reload();</script>");
                return;
            }
            entity.MajorId = int.Parse(this.ddlMajor.SelectedValue.ToString());
            entity.StudentName = this.txtName.Text;
            entity.StudentSex = this.rbBoy.Checked == true ? "男" : "女";
            entity.StudentPhone = this.txtPhone.Text;
            entity.StudentMail = this.txtMail.Text;
            bll.Update(entity);
            Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功');window.parent.location.reload();</script>");
        }
        #endregion
    }
}

扩展：按照专业类型统计学生人数

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="gvGroup" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField HeaderText="专业类型" DataField="TypeName" />
                <asp:BoundField HeaderText="学生人数" DataField="StuCount" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

namespace MyUI
{
    public partial class Group : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                BindData();
        }

        #region 绑定数据
        private void BindData()
        {
            List<object> list = new List<object>();
            StudentBLL bll = new StudentBLL();
            list = bll.GetCountByType();
            this.gvGroup.DataSource = list;
            this.gvGroup.DataBind();
        }
        #endregion
    }
}