C# Linq版七层登录

不明白七层的，可以看下我的上一篇文章，内容与直接连接SQL的没有太大区别，在Entity中少了一个转换类，DAL中多了一个Linqtosql类，….

将数据库文件添加到vs中
具体步骤
视图->服务器资源管理器
效果图

右键数据连接->添加连接 ->数据源(我选的是数据库文件)->数据库文件名 (点击浏览找到你自己的数据库)->确定

在DAL中要添加 我的是LinqToSQL.dbml

将你连接在vs上的数据库中的表拖进去
效果图

总构图

Entity层

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

namespace Entity
{
    public class UserInfo
    {
        private string userName;
        private string password;

        public string UserName
        {
            get { return userName; }
            set { userName = value; }
        }
        public string Password
        {
            get { return password; }
            set { password = value; }
        }
    }
}

IDAL层

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

namespace IDAL
{
    public interface IUserLoginDAL
    {
        List<Entity.UserInfo> Login(Entity.UserInfo userInfo);
    }
}

DAL
UserLoginDAL:

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

namespace DAL
{
    public class UserLoginDAL:IDAL.IUserLoginDAL
    {
        public List<Entity.UserInfo> Login(Entity.UserInfo userInfo)
       {
         List<Entity.UserInfo> user = new List<Entity.UserInfo>();
         LinqToSqlDAL login = new LinqToSqlDAL();
         try
         {
             var query = login.LoginLinqToSql(userInfo);
             user.Add(new Entity.UserInfo { UserName = query[0].UserName, Password = query[0].Password });
         }
         catch
         {
             user = null;
             return user;
         }
             return user;
       }
    }
}

LinqToSqlDAL

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

namespace DAL
{
    class LinqToSqlDAL
    {
        public List<User_Info> LoginLinqToSql(Entity.UserInfo userInfo)
        {
            string Constr = System.Configuration.ConfigurationManager.AppSettings["ConnStr"];
            LinqToSQLDataContext db = new LinqToSQLDataContext(Constr);
            Table<User_Info> tbl = db.GetTable<User_Info>();
            var query1 = db.User_Info.Where(s => s.UserName.Equals(userInfo.UserName) && s.Password.Equals(userInfo.Password)).ToList();
            return query1;

        }
    }
}

IBLL

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

namespace IBLL
{
    public interface IUserLoginBLL
    {
        bool Login(Entity.UserInfo userInfo);
    }
}

BLL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entity;
namespace BLL
{
    public class UserLoginBLL:IBLL.IUserLoginBLL
    {
        public bool Login(Entity.UserInfo userInfo)
        { 
            Factory.FactoryDAL fact = new Factory.FactoryDAL();
            IDAL.IUserLoginDAL idal = fact.CreatDAL();
            List<Entity.UserInfo> userList = idal.Login(userInfo);
            bool flag;
            if (userList!=null)
            {
                flag = true;
            }
            else
            {
                flag = false;
            }
            return flag;
        }
    }
}

Factory
FactoryBLL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using System.Configuration;
namespace Factory
{
   public class FactoryBLL
    {
       string AssemblyName = "BLL";
       string StrDAL = System.Configuration.ConfigurationManager.AppSettings["BLL"];

       public IBLL.IUserLoginBLL CreatBLL()
       {
           string className = AssemblyName + ".UserLoginBLL";
           IBLL.IUserLoginBLL ibll = (IBLL.IUserLoginBLL)Assembly.Load(StrDAL).CreateInstance(className);
           return ibll;
       }
    }
}

FactoryDAL

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

namespace Factory
{
    public class FactoryDAL
    {
        string AssemblyName = "DAL";
        string StrDAL = System.Configuration.ConfigurationManager.AppSettings["DAL"];

        public IDAL.IUserLoginDAL CreatDAL()
        {
            string className = AssemblyName + ".UserLoginDAL";
            IDAL.IUserLoginDAL idal = (IDAL.IUserLoginDAL)Assembly.Load(StrDAL).CreateInstance(className);
            return idal;
        }
    }
}

UI

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace UI
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            if (txtUserName.Text == "")
            {
                MessageBox.Show("用户名不能为空");
            }
            if (txtPassword.Text == "")
            {
                MessageBox.Show("密码不能为空");
            }
            try
            {
                Entity.UserInfo user = new Entity.UserInfo();
                user.UserName = txtUserName.Text.Trim();
                user.Password = txtPassword.Text;
                Factory.FactoryBLL bllfact = new Factory.FactoryBLL();
                IBLL.IUserLoginBLL ibll = bllfact.CreatBLL();
                if (ibll.Login(user))
                {
                    txtUserName.Clear();
                    txtPassword.Clear();
                    MessageBox.Show("登录成功");
                }
                else
                {

                    txtUserName.Clear();
                    txtPassword.Clear();
                    MessageBox.Show("登录失败");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
    }
}

配置文件

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="ConnStr" value="Server=.;User=sa;Pwd=12345;Database=UserLogin"/>
    <add key="DAL" value="DAL"/>
    <add key="BLL" value="BLL"/>
  </appSettings>
</configuration>

如有不对，欢迎提出，及时修改。

版权声明：本文为博主原创文章，转载请注明出处。