C#项目之三层架构实例

一、UI层设计

引用BDM层
namespace LoginUI
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
        }
        private void btnLogin_Click(object sender, EventArgs e)
        {
            //获取用户输入的账号与密码，赋值给userName,password
            string userName = txtUserName.Text.Trim();
            string password = txtPassword.Text;

            //实例化B层LoginManager
            Login.BLL.LoginManager mgr = new Login.BLL.LoginManager();
            //mgr调用userlogin方法，将获取的用户名和密码封装，准备传数据，此时跳转到B层
            Login.Model.UserInfo user = mgr.UserLogin(userName, password);
            MessageBox.Show("登录用户：" + user.UserName);
        }
    }
}

二、业务逻辑层设计

namespace Login.BLL
{
    public class LoginManager
    {
        public Login.Model .UserInfo UserLogin(string userName,string  password)
        {
            //实例化D层，引用D层，和实体层Model
            Login.DAL.UserDAO uDao = new Login.DAL.UserDAO();
            //跳转到D层，把当前userName,password传给实体层
            Login.Model.UserInfo user = uDao.SelectUser(userName, password);
            //-----------------------------------------------------------------
            //分割线上面会跳转到D层的UserDAO中
            //下面为D层返回user，再跳转到D层的ScoreDAO中加用户的积分

            //如果user不为空值
            if (user !=null ) //登录成功
            {
                //实例化D层ScoreDao
                Login.DAL.ScoreDAO sDao = new Login.DAL.ScoreDAO();

                //更新用户积分
                sDao.UpdateScore(userName, 10);
                //返回user到U层
                return user;

             }
            else
            {
                throw new Exception("登录失败");
            }
        }
    }
}

三、D层的连接数据库类

namespace Login.DAL
{
   public  class DbUtil//连接数据库，使程序和数据库交互
    {
        public static string ConnString = @"Server=CHEN;Database=Login;User ID=sa;Password=123";//计算机名，数据库名，登录账户，登录密码
    }
}

四、D层的表的操作类

1.负责对数据库中Scores表的操作

namespace Login.DAL
{
    public class ScoreDAO//负责对数据库中Scores表的操作
    {
        //UpdateScore方法需要传入userName和value两个参数
        public void UpdateScore(string userName, int value)
        {
            //实例化数据库连接conn
            using (SqlConnection conn = new SqlConnection(DbUtil.ConnString))
            {
               SqlCommand cmd = conn .CreateCommand ();
                cmd.CommandText =@"INSERT INTO SCORES (UserName,Score) Values(@UserName,@Score)";
                cmd .Parameters.Add(new SqlParameter("@UserName",userName));
                cmd .Parameters.Add (new SqlParameter("@Score",value ));
                conn .Open ();
                //执行SQL指令
                cmd.ExecuteNonQuery();
            }                
          }
        }
    }

2.负责对数据库中Users表的操作

namespace Login.DAL
{
 public  class UserDAO//负责对数据库中Users表的操作
  {
     //设定了两个参数,返回类型为Login.Model.UserInfo
     public Login .Model .UserInfo  SelectUser(string userName,string password)
     {
         //throw new NotImplementedException();
         //链接数据库，有了using，数据库会自动关闭
         using(SqlConnection conn =new SqlConnection (DbUtil.ConnString))
         {
             SqlCommand  cmd =conn .CreateCommand ();
             cmd.CommandText =@"SELECT ID,UserName,Password ,Email FROM USERS WHERE UserName=@UserName AND Password=@Password";
             cmd .CommandType=CommandType .Text ;
             cmd .Parameters.Add(new SqlParameter ("@UserName",userName ));
             cmd .Parameters.Add(new SqlParameter ("@Password",password  ));
             conn.Open();
             SqlDataReader reader = cmd.ExecuteReader();
             Login.Model .UserInfo  user= null;               
             while (reader .Read ())
             {
                 if (user==null)
                 {
                     user =new Login.Model .UserInfo ();
                 }
                 user .ID =reader .GetInt32 (0);
                 user.UserName =reader .GetString (1);
                 user.Password =reader .GetString (2);//密码不需要往外取
                 if(!reader .IsDBNull (3))
                 {
                     user .Email =reader .GetString (3);
                 }
             }
             return user ;
        }
     }
  }
}