DA/DBuserss.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data ;
using System.Data.SqlClient;
namespace DA
{
   public  class DBuserss: IDisposable 
    {
          string sql;
        SqlHelpers sqlh;
        DataSet ds;
       // SqlDataReader dr;
        public DBuserss()
        {
            sqlh = new SqlHelpers();
        }
       public DBuserss(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }


        /// <summary>
        /// 验证用户登录的方法
        /// </summary>
        /// <param name="u"></param>
        /// <returns></returns>
        public DataSet DBUser(CUsers u)
        {
            List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@uName", SqlDbType.VarChar, 20));
            pars[0].Value = u.CuName1 ;
            pars.Add(new SqlParameter("@uPwd", SqlDbType.VarChar, 30));
            pars[1].Value = u.CuPwd1 ;
            sql = "select * from Users where uName=@uName and uPwd=@uPwd";
            ds = sqlh.ExcuteSelect(sql, "Users", pars);
            return ds;
        }

        /// <summary>
        /// 查询所有用户的方法
        /// </summary>
        /// <returns></returns>
        public DataSet DBAllUsers()
        {
            sql = "select u.uId,u.uName,u.uPwd,r.rName from Users u inner join Roles r on u.rId=r.rId";
            ds = sqlh.ExcuteSelect(sql, "UR", null );
            return ds;
        }

        /// <summary>
        /// 插入用户信息的方法
        /// </summary>
        /// <param name="u"></param>