SQLServerDAL/LoginDAL.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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

using CheckOnWork.Model;
using CheckOnWork.WebConfig;
using CheckOnWork.DBHelper;
using CheckOnWork.IDAL;
using CheckOnWork.SQLServerDAL;

namespace CheckOnWork.SQLServerDAL
{
    public class LoginDAL : DBAccess, ILogin
    {
        /// <summary>
        /// 登录情况，传入用户ID，Pwd以及角色，进行登录，用户名密码均正确返回Ture，失败返回FALSE
        /// </summary>
        /// <param name="ID">用户ID</param>
        /// <param name="Pwd">用户密码</param>
        /// <param name="role">用户角色</param>
        /// <returns></returns>
        public bool UserLogin(string ID, string Pwd,Role role)
        {

            GedRoleProcedure detailRole = new GedRoleProcedure(role);

            //五种角色的登录存储过程均用了相同的参数@ID和@Pwd
            SqlParameter[] param={
                                  new SqlParameter("@ID",ID),
                                  new SqlParameter("@Pwd",Pwd),
                                 };
           
            SqlDataReader sqlRead = ExecuteReader(detailRole.Procedure,param);
            if (sqlRead.Read())
            {
                sqlRead.Close();
                return true;
            }
                
            else
                return false;
            
        }
    
        
    }

    
   
}