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;
|
|
namespace WMS.BLL.SysServer
|
{
|
public class UserInforServer : IUserInforServer
|
{
|
public IUserInforRepository UserSvc { get; set; }
|
readonly IMapper _mapper;
|
private readonly IFunSettingServer _setting;
|
public UserInforServer(IUserInforRepository userSvc, IMapper mapper, IFunSettingServer setting)
|
{
|
UserSvc = userSvc;
|
_mapper = mapper;
|
_setting = setting;
|
}
|
|
public bool LoginAdmin(string loginName, string loginPwd, out int adminId)
|
{
|
//loginPwd = Md5Tools.CalcMd5(loginPwd);
|
var date = UserSvc.GetAllAsync().First(m => m.UserName == loginName && m.PassWord == loginPwd);
|
|
if (date != null) //账号密码是否正确
|
{
|
if (date.Status == "0") //当前账号是否正常启用
|
{
|
//最后登陆时间
|
UserSvc.UptUserLoginTime(date.Id);
|
adminId = date.Id;
|
return true;
|
}
|
else //当前账号被禁用
|
{
|
adminId = 0;
|
return true;
|
}
|
}
|
else //账号密码不正确或没有此账号
|
{
|
adminId = 0;
|
return false;
|
}
|
}
|
public SysUserInfor CeShi()
|
{
|
var date = UserSvc.ceshi();
|
|
return date;
|
|
}
|
|
/// <summary>
|
/// 获取用户角色信息
|
/// </summary>
|
/// <returns></returns>
|
public List<UserInfoDto> GetUserRoleList(string UserName, string DepartmentNo, string RoleNo, string Status)
|
{
|
|
string str = "select user1.Id Id,user1.UserNo UserNo,user1.UserName UserName,user1.RealName RealName,user1.PassWord PassWord,user1.JobNo JobNo,user1.Status Status,user1.Sex Sex,user1.Nationality Nationality,user1.CreateTime CreateTime,user1.CreateUser CreateUser,user1.Paper Paper,user1.Phone Phone,user1.Email Email,user1.Addres Addres,user1.Demo Demo,role.RoleName,user2.RealName CreateUserName,depa.DepartmentName DepartmentName from SysUserInfor user1 left join SysRoles role on user1.RoleNo = role.RoleNo left join SysUserInfor user2 on user1.CreateUser = user2.Id left join SysDepartment depa on user1.DepartmentNo = depa.DepartmentNo where user1.IsDel = '0'";
|
|
//判断登录名称是否为空
|
if (!string.IsNullOrEmpty(UserName))
|
{
|
str += $" and user1.UserName like '%{UserName}%'";
|
}
|
//判断部门号是否为0
|
if (!string.IsNullOrEmpty(DepartmentNo))
|
{
|
str += $" and user1.DepartmentNo = '{DepartmentNo}'";
|
}
|
//判断角色号是否为空
|
if (!string.IsNullOrEmpty(RoleNo))
|
{
|
str += $" and user1.RoleNo = '{RoleNo}'";
|
}
|
//判断状态是否为空
|
if (!string.IsNullOrEmpty(Status))
|
{
|
str += $" and user1.Status = '{Status}'";
|
}
|
|
List<UserInfoDto> userInfoDtos = UserSvc.GetUserRoleList(str);
|
|
//var arr = Md5Tools.CalcMd5(userInfoDtos[3].PassWord);
|
|
return userInfoDtos;
|
}
|
|
/// <summary>
|
/// 根据编号获取用户信息列表
|
/// </summary>
|
/// <param name="UserNo">用户编号</param>
|
/// <param name="userName">用户登录名</param>
|
/// <param name="id">用户ID</param>
|
/// <returns></returns>
|
public int GetUserInfoByNo(string userNo, string userName,int id)
|
{
|
string str = $"select * from SysUserInfor where IsDel=0 and (UserNo = '{userNo}' or UserName = '{userName}') ";
|
if (id!=0)
|
{
|
str += $"and Id != {id} ";
|
}
|
List<SysUserInfor> user = UserSvc.GetUserInfoByNo(str);
|
return user.Count;
|
}
|
|
/// <summary>
|
/// 新增用户信息
|
/// </summary>
|
/// <param name="UserInfoDto">用户视图模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常</exception>
|
public async Task<int> InsertUserInfo(UserInfoDto UserInfoDto)
|
{
|
//异常
|
try
|
{
|
//数据模型映射
|
SysUserInfor userinfo = _mapper.Map<SysUserInfor>(UserInfoDto);
|
//判断用户号是否唯一
|
int count = GetUserInfoByNo(userinfo.UserNo,userinfo.UserName,0);
|
int i = 0;
|
if (count > 0)
|
{
|
i = 3;
|
}
|
else if (count ==0)
|
{
|
//新增用户
|
i = await UserSvc.InsertUserInfo(userinfo);
|
}
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("新增用户信息异常", ex);
|
}
|
|
}
|
|
/// <summary>
|
/// 删除用户信息
|
/// </summary>
|
/// <param name="user">用户实体模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常</exception>
|
public async Task<int> DeleteUserinfo(SysUserInfor user)
|
{
|
//异常
|
try
|
{
|
//删除
|
int i = await UserSvc.DeleteUserinfo(user);
|
//返回数据
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("删除用户信息异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 编辑用户信息
|
/// </summary>
|
/// <param name="userdto">用户Dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">异常exception>
|
public async Task<int> UpdateUserinfo(UserInfoDto userdto)
|
{
|
//异常
|
try
|
{
|
//映射数据模型
|
SysUserInfor userlist = _mapper.Map<SysUserInfor>(userdto);
|
//判断用户号是否唯一
|
int count = GetUserInfoByNo(userdto.UserNo, userdto.UserName,userdto.Id);
|
int i = 0;
|
if (count > 0)
|
{
|
i = 3;
|
}
|
else if (count == 0)
|
{
|
//编辑
|
i = await UserSvc.UpdateUserinfo(userlist);
|
}
|
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("编辑用户信息异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 根据id获取用户信息列表
|
/// </summary>
|
/// <param name="userids">用户id</param>
|
/// <returns></returns>
|
public SysUserInfor GetUserInfoById(int userids)
|
{
|
//获取信息列表
|
SysUserInfor user= UserSvc.GetUserInfoById(userids);
|
//返回数据
|
return user;
|
}
|
|
/// <summary>
|
/// 修改用户密码
|
/// </summary>
|
/// <param name="pwdOld">原密码</param>
|
/// <param name="pwdNew">新密码</param>
|
/// <param name="pwdNewTwo">确认密码</param>
|
/// <param name="userId">用户id</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> UptUserPassWord(string pwdOld, string pwdNew, string pwdNewTwo, int userId)
|
{
|
//捕获异常
|
try
|
{
|
//验证两次新密码是否一致
|
if (pwdNew == pwdNewTwo)
|
{
|
int i = await UserSvc.UptUserPassWord(pwdOld, pwdNew, pwdNewTwo, userId);
|
return i;
|
}
|
else
|
{
|
return 3;
|
}
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("修改密码异常",ex);
|
}
|
}
|
/// <summary>
|
/// x天后提醒用户修改密码
|
/// </summary>
|
/// <param name="userId"></param>
|
/// <returns></returns>
|
public int IsPassWordTime(int userId)
|
{
|
//捕获异常
|
try
|
{
|
SysFunSetting funSettings = _setting.GetFunSettingByNo("Fun026");
|
if (funSettings != null && funSettings.IsEnable == "NO")
|
{
|
SysUserInfor userinfo = UserSvc.GetAllAsync().First(m => m.Id == userId);
|
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;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("修改密码异常", ex);
|
}
|
}
|
}
|
}
|
