using AutoMapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Model.ModelDto.SysDto;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
using WMS.IDAL.ISysInterface;
|
using System.Security.Cryptography;
|
using OracleInternal.Secure.Network;
|
using Utility.Tools;
|
using System.Linq;
|
using SqlSugar;
|
using WMS.Entity.Context;
|
using WMS.Entity.BllTaskEntity;
|
using WMS.DAL;
|
using Utility;
|
using System.Text.RegularExpressions;
|
|
namespace WMS.BLL.SysServer
|
{
|
public class UserInforServer : IUserInforServer
|
{
|
readonly IMapper _mapper;
|
private readonly IFunSettingServer _setting;
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
private readonly UserManager _userManager;
|
public UserInforServer(IMapper mapper, IFunSettingServer setting, UserManager userManager)
|
{
|
_mapper = mapper;
|
_setting = setting;
|
_userManager = userManager;
|
}
|
|
public async Task<int> LoginAdmin(string loginName, string loginPwd)
|
{
|
//loginPwd = Md5Tools.CalcMd5(loginPwd);
|
var modUser = await Db.Queryable<SysUserInfor>().FirstAsync(m => m.UserName == loginName && m.PassWord == loginPwd &&m.IsDel=="0");
|
if (modUser != null) //账号密码是否正确
|
{
|
if (modUser.Status == "0") //当前账号是否正常启用
|
{
|
//最后登陆时间
|
await Db.Updateable(modUser).UpdateColumns(s => s.LoginTime == DateTime.Now).ExecuteCommandAsync();
|
return modUser.Id;
|
}
|
else //当前账号被禁用
|
{
|
return 0;
|
}
|
}
|
else //账号密码不正确或没有此账号
|
{
|
return -1;
|
}
|
}
|
|
/// <summary>
|
/// 获取用户角色信息
|
/// </summary>
|
/// <returns></returns>
|
public async Task<List<UserInfoDto>> GetUserRoleList(string UserName, string DepartmentNo, string RoleNo, string Status)
|
{
|
var modUser = await Db.Queryable<SysUserInfor>().FirstAsync(s => s.Id == _userManager.UserId);
|
return await Db.Queryable<SysUserInfor>()
|
.LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
|
.LeftJoin<SysDepartment>((a, b, c) => a.DepartmentNo == c.DepartmentNo)
|
.LeftJoin<SysRoles>((a, b, c, d) => a.RoleNo == d.RoleNo)
|
.Where((a,b,c,d)=>d.IsDel == "0")
|
.WhereIF(!string.IsNullOrEmpty(UserName), a => a.UserName.Contains(UserName))
|
.WhereIF(!string.IsNullOrEmpty(DepartmentNo), a => a.DepartmentNo == DepartmentNo)
|
.WhereIF(!string.IsNullOrEmpty(RoleNo), a => a.RoleNo == RoleNo)
|
.WhereIF(!string.IsNullOrEmpty(Status), a => a.Status == Status)
|
.WhereIF(modUser.UserName.ToUpper() != "ADMIN", a => a.CreateUser == _userManager.UserId)
|
.Where(a => a.IsDel == "0")
|
.Select<UserInfoDto>((a, b, c, d) => new UserInfoDto()
|
{
|
RealName = a.RealName,
|
CreateUserName = b.RealName,
|
DepartmentName = c.DepartmentName,
|
RoleName = d.RoleName,
|
}, true)
|
.ToListAsync();
|
}
|
|
/// <summary>
|
/// 根据编号获取用户信息列表
|
/// </summary>
|
/// <param name="UserNo">用户编号</param>
|
/// <param name="userName">用户登录名</param>
|
/// <param name="id">用户ID</param>
|
/// <returns></returns>
|
public async Task<int> GetUserInfoByNo(string userNo, string userName, int id)
|
{
|
return await Db.Queryable<SysUserInfor>()
|
.Where(s => s.IsDel == "0")
|
.Where(s => s.UserNo == userNo || s.UserName == userName)
|
.WhereIF(id != 0, a => a.Id != id)
|
.CountAsync();
|
}
|
|
/// <summary>
|
/// 新增用户信息
|
/// </summary>
|
/// <param name="UserInfoDto">用户视图模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常</exception>
|
public async Task<int> InsertUserInfo(UserInfoDto UserInfoDto)
|
{
|
//数据模型映射
|
SysUserInfor userinfo = _mapper.Map<SysUserInfor>(UserInfoDto);
|
//判断用户号是否唯一
|
int count = await GetUserInfoByNo(userinfo.UserNo, userinfo.UserName, 0);
|
int i = 0;
|
if (count > 0)
|
{
|
throw Oops.Bah("用户名或登录名重复");
|
}
|
else if (count == 0)
|
{
|
userinfo.PassWord = Md5Tools.CalcMd5("boxline");
|
userinfo.SetPasswordTime = DateTime.Now;
|
userinfo.CreateTime = DateTime.Now;
|
userinfo.CreateUser = _userManager.UserId;
|
i = await Db.Insertable(userinfo).ExecuteCommandAsync();
|
if (i <= 0)
|
throw Oops.Bah("新增用户信息失败");
|
}
|
return i;
|
|
}
|
|
/// <summary>
|
/// 删除用户信息
|
/// </summary>
|
/// <param name="user">用户实体模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常</exception>
|
public async Task DeleteUserinfo(SysUserInfor user)
|
{
|
await Db.Updateable<SysUserInfor>()
|
.Where(s => s.Id == user.Id)
|
.SetColumns(s => s.IsDel == "1")
|
.SetColumns(s => s.UpdateTime == DateTime.Now)
|
.SetColumns(s => s.UpdateUser == _userManager.UserId)
|
.ExecuteCommandAsync();
|
|
}
|
|
/// <summary>
|
/// 编辑用户信息
|
/// </summary>
|
/// <param name="userdto">用户Dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常exception>
|
public async Task<int> UpdateUserinfo(UserInfoDto userdto)
|
{
|
//映射数据模型
|
SysUserInfor userlist = _mapper.Map<SysUserInfor>(userdto);
|
//判断用户号是否唯一
|
int count = await GetUserInfoByNo(userdto.UserNo, userdto.UserName, userdto.Id);
|
int i = 0;
|
if (count > 0)
|
{
|
throw Oops.Bah("用户名或登录名重复");
|
}
|
else if (count == 0)
|
{
|
userdto.UpdateUser = _userManager.UserId;
|
userdto.UpdateTime = DateTime.Now;
|
i = await Db.Updateable(userlist)
|
.UpdateColumns(s => new { s.UserName, s.UserNo, s.Sex, s.RoleNo, s.RealName, s.Phone, s.Paper, s.Nationality, s.JobNo, s.Email, s.Demo, s.Addres, s.UpdateUser, s.UpdateTime })
|
.ExecuteCommandAsync();
|
if (i <= 0)
|
throw Oops.Bah("编辑用户信息失败");
|
}
|
return i;
|
}
|
|
/// <summary>
|
/// 根据id获取用户信息列表
|
/// </summary>
|
/// <param name="userids">用户id</param>
|
/// <returns></returns>
|
public async Task<SysUserInfor> GetUserInfoById(int userid)
|
{
|
return await Db.Queryable<SysUserInfor>().FirstAsync(s => s.Id == userid && s.IsDel == "0");
|
}
|
|
/// <summary>
|
/// 修改用户密码
|
/// </summary>
|
/// <param name="pwdNew">新密码</param>
|
/// <param name="userId">用户id</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> UptUserPassWord(string pwdNew,string pwdNewTwo, int userId)
|
{
|
var funSet = Db.Queryable<SysFunSetting>().Where(m => m.IsDel == "0" && m.FunSetName == "密码规则" && m.IsEnable == "NO").ToList().FirstOrDefault();
|
if (funSet != null)
|
{
|
bool t = false;
|
switch (funSet.FunSetNo)
|
{
|
case "Fun052": //数字，字母，符号
|
t = Regex.IsMatch(pwdNewTwo, @"^(?:(?=.*[0-9].*)(?=.*[A-Za-z].*)(?=.*[^0-9A-Za-z].*)).{3,}");
|
break;
|
case "Fun053": //字母，数字
|
t = Regex.IsMatch(pwdNewTwo, @"^(?:(?=.*[0-9].*)(?=.*[A-Za-z].*)).{2,}");
|
break;
|
case "Fun051": //数字，字母，符号，长度
|
t = Regex.IsMatch(pwdNewTwo, @"^(?=.*[0-9])(?=.*[a-zA-Z])(?=([\x21-\x7e]+)[^a-zA-Z0-9]).{8,30}");
|
break;
|
default:
|
break;
|
}
|
if (!t)
|
{
|
throw Oops.Bah("输入密码不符合密码规则");
|
}
|
}
|
return await Db.Updateable<SysUserInfor>()
|
.Where(s => s.Id == userId)
|
.SetColumns(s => s.UpdateTime == DateTime.Now)
|
.SetColumns(s => s.UpdateUser == _userManager.UserId)
|
.SetColumns(s => s.PassWord == pwdNew)
|
.SetColumns(s => s.SetPasswordTime == DateTime.Now)
|
.ExecuteCommandAsync();
|
|
}
|
/// <summary>
|
/// x天后提醒用户修改密码
|
/// </summary>
|
/// <param name="userId"></param>
|
/// <returns></returns>
|
public async Task<int> IsPassWordTime(int userId)
|
{
|
SysFunSetting funSettings = await Db.Queryable<SysFunSetting>().FirstAsync(a => a.IsDel == "0" && a.FunSetNo == "Fun026");
|
if (funSettings != null && funSettings.IsEnable == "NO")
|
{
|
SysUserInfor userinfo = await Db.Queryable<SysUserInfor>().FirstAsync(s => s.Id == userId && s.IsDel == "0");
|
if (userinfo.SetPasswordTime != null)
|
{
|
int days = string.IsNullOrEmpty(funSettings.SetValue) ? 30 : Convert.ToInt32(funSettings.SetValue);
|
bool isTime = userinfo.SetPasswordTime.Value.AddDays(days) < DateTime.Now;
|
if (isTime)
|
{
|
return 1;
|
}
|
}
|
}
|
return 0;
|
}
|
}
|
}
|
