DAL/AccessDU_UserInfo.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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

namespace DAL
{
    public class AccessDU_UserInfo
    {

        /// <summary>
        /// 查询用户名是否存在
        /// </summary>
        /// <param name="U_Id"></param>
        /// <returns></returns>
        public int ExistsName(string U_Name)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from U_UserInfo");
            strSql.Append(" where ");
            strSql.Append(" U_Name = @U_Name  ");
            OleDbParameter[] parameters = {
					new OleDbParameter("@U_Name", OleDbType.VarChar,50)
};
            parameters[0].Value = U_Name;

            return Convert.ToInt32(AccessDBHelp.ExecuteScalar(strSql.ToString(), parameters));
        }


        /// <summary>
        /// 查询用户名和密码是否存在
        /// </summary>
        /// <param name="U_Id"></param>
        /// <returns></returns>
        public DataSet ExistsPwd(string U_Name, string pwd)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 U_Id,U_RoleType from U_UserInfo");
            strSql.Append(" where ");
            strSql.Append(" U_Name = @U_Name and U_PassWord=@U_PassWord ");
            OleDbParameter[] parameters = {
					new OleDbParameter("@U_Name", OleDbType.VarChar,50),
                    new OleDbParameter("@U_PassWord", OleDbType.VarChar,50)
};
            parameters[0].Value = U_Name;
            parameters[1].Value = pwd;

            DataSet ds = AccessDBHelp.ExecuteDataSet(strSql.ToString(), parameters);

            return ds;
        }

        /// <summary>
        /// 根据用户名和密保问题查询出密码
        /// </summary>