PSI.DAL/UserDAL.cs

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

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

using PSI.Common;
using PSI.DbUtility;
using PSI.Models.DModels;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PSI.DAL
{
    public  class UserDAL:BaseDAL<UserInfoModel>
    {
        /// <summary>
        /// 登录，返回UserId
        /// </summary>
        /// <param name="uName"></param>
        /// <param name="uPwd"></param>
        /// <returns></returns>
        public int Login(string uName,string uPwd)
        {
            string strWhere = "UserName=@UserName and UserPwd=@UserPwd and UserState=1";
            SqlParameter[] paras =
            {
                new SqlParameter("@UserName",uName),
                 new SqlParameter("@UserPwd",uPwd)
            };
            UserInfoModel user = GetModel(strWhere, "UserId", paras);
            if (user != null)
                return user.UserId;
            else
                return 0;
        }

        /// <summary>
        /// 条件查询用户列表
        /// </summary>
        /// <param name="uName"></param>
        /// <returns></returns>
        public List<UserInfoModel> GetUserList(string uName)
        {
            string strWhere = " 1=1 and UserName <> (select UserName from UserInfos where UserId in (select UserId from UserRoleInfos where RoleId = (select RoleId from RoleInfos where IsAdmin=1))) and IsDeleted=0";
            if (!string.IsNullOrEmpty(uName))
                strWhere += " and UserName like @uName";
            SqlParameter paraName = new SqlParameter("@uName", "%"+uName+"%");
            string cols = "UserId,UserName,UserState,CreateTime";
            return GetModelList(strWhere,cols,paraName);
        }

        /// <summary>
        /// 修改用户状态
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="userState"></param>
        /// <returns></returns>
        public bool UpdateUserState(int userId,int userState)
        {
            string sql = "update UserInfos set UserState=@userState where UserId=@userId";