用三层架构实现登录，并模拟后台审核功能，未审核成功不予登录（ASP.NET）

先建如下项目：

先写模型层

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

namespace Model
{
    public class Student
    {
        private string stuId;

        public string StuId
        {
            get { return stuId; }
            set { stuId = value; }
        }
        private string stuPwd;

        public string StuPwd
        {
            get { return stuPwd; }
            set { stuPwd = value; }
        }
        private string stuName;

        public string StuName
        {
            get { return stuName; }
            set { stuName = value; }
        }
        private string stuAge;

        public string StuAge
        {
            get { return stuAge; }
            set { stuAge = value; }
        }
        private string stuSex;

        public string StuSex
        {
            get { return stuSex; }
            set { stuSex = value; }
        }
        private string stuTel;

        public string StuTel
        {
            get { return stuTel; }
            set { stuTel = value; }
        }
        private string stuAddr;

        public string StuAddr
        {
            get { return stuAddr; }
            set { stuAddr = value; }
        }
        private string stuAudit;

        public string StuAudit
        {
            get { return stuAudit; }
            set { stuAudit = value; }
        }
    }
}
 

然后写数据链路层：

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

namespace DAL
{
    public class Student_DAL
    {
        /// <summary>
        /// 验证用户登陆
        /// </summary>
        /// <param name="user"></param>
        /// <param name="right"></param>
        /// <returns></returns>
        public object CheckStuLogin(Student student,string right)
        {
            string sqlText;
            sqlText = "select stuPwd from stuInfo where stuId=@userId";
            SqlParameter[] paras = new SqlParameter[1]
            {
                new SqlParameter("userId",student.StuId)
            };
            object obj = SqlLink.GetScaler(sqlText, paras);
            return obj;
        }
    }
}
 

然后写业务层

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DAL;
using Model;
using System.Data;

namespace BLL
{
    public class Student_BLL
    {
        Student_DAL studal = new Student_DAL();
        public int CheckStuLogin(Student student, string right)
        {
            object obj = studal.CheckStuLogin(student, right);
            int result = -1;
            if (obj == null)
            {
                result = 0; //用户不存在
            }
            else if (obj.ToString().Trim() == student.StuPwd)
            {
                result = 1;//正确
            }
            else if (obj.ToString().Trim() != student.StuPwd)
            {
                result = 2;//密码错误
            }
            else
            {
                result = 3; //系统错误
            }
            return result;
        }
    }
}
 

然后写表示层

以上都只是部分的代码及截图。需要详细代码，以及数据库脚本的可以留言，或发邮件。191660130@qq.com

整个项目效果图如下：

通过审核的效果如下

未通过审核的效果如下：

后台审核：