asp.net三层架构简单例子说明

1.首先建立数据库表结构：
   我们就随便建个简单的表tb_Admin,字段包括AdminID int,Admin varchar(20),PassWord varchar(20)
2.数据库实例类(MOdel层)：

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

namespace SystemModel
{
    #region 管理员信息表
    /// <summary>
    /// 管理员表  实体类对应数据库表字段
    /// </summary>
    #endregion
    public class AdminModel
    {
        private int m_AdminID;
        private string m_Admin;
        private string m_PassWord;

        public int M_AdminID
        {
            get { return m_AdminID; }
            set { m_AdminID = value; }
        }

        public string M_Admin
        {
            get { return m_Admin; }
            set { m_Admin = value; }
        }

        public string M_PassWord
        {
            get { return m_PassWord; }
            set { m_PassWord= value; }
        }

    }
}
3.数据库访问层(DAL层)

using System;
using System.Collections.Generic;
using System.Text;
//引用命名空间
using System.Data;
using System.Data.SqlClient;
using SystemModel;

namespace SystemDAL
{
    #region 管理员信息表 DAL
    /// <summary>
    /// 管理员信息表 DAL
    /// </summary>
    #endregion
    public class AdminDAL
    {
        private string sql = "";
   
        #region 插入一条信息
        public bool Insert_Admin(AdminModel Admin)
        {
            StringBuilder sql = new StringBuilder("insert into tb_Admin(Admin,PassWord,values(");
            sql.Append("@Admin,@PassWord)");
            SqlParameter[] parameters = new SqlParameter[]
                  {
                      new SqlParameter("@Admin",Admin.M_Admin),
                      new SqlParameter("@PassWord",Admin.M_PassWord)
                   };
            return Convert.ToInt32(SqlHelper.ExecuteNonQuery(sql.ToString(), CommandType.Text, parameters)) > 0;    
        }
        #endregion

    }
}

4.业务逻辑层(BLL层)

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using SystemDAL;
using SystemModel;

namespace SystemBLL
{
    public class AdminBLL
    {
        #region 插入一条信息
        /// <summary>
        /// 插入一条信息
        /// </summary>
        /// <param name="Admin">管理员</param>
        /// <returns>true 成功</returns>
        public bool Insert_Admin(AdminModel Admin)
        {
            //实例化类操作
            return new AdminDAL().Insert_Admin(Admin);
        }
        #endregion

     }
}