public JsonResult LoginIn(LoginUser loginUser) { var userResult = new CommonResult<CyUserEntity>(); try { var user = new CyUserEntity() { UserName = loginUser.UserName, UserPwd = loginUser.UserPwd, ValideCode = loginUser.ValideCode }; //验证用户信息 userResult = CyUserService.Login(user); //验证成功 if (userResult.Success) { var cyUser = userResult.ResultObj; var model = new UserModel() { UserNo = cyUser.UserNo, UserName = cyUser.UserName, NickName = cyUser.NickName, TrueName = cyUser.TrueName, MemberType = cyUser.MemberType, Role = cyUser.Role }; UserContext.SetAuthCookie(model, true); var loginLog = new CyUserLoginLogEntity() { UserNo = cyUser.UserNo, LoginIp = IpHelper.GetUserIpAddress(), LoginTime = DateTime.Now }; CyUserService.AddCyUserLoginLog(loginLog); } } catch (Exception ex) { userResult.Success = false; userResult.Message = ex.Message; } return Json(userResult, JsonRequestBehavior.AllowGet); }
public void TestAddUser() { try { var userPwd = StringUtil.ToHashString("123"); var userNo = new CySequenceCounterProvider().GetNextCounterId("UserNo"); var entity = new CyUserEntity() { UserNo = userNo.ToString(), UserName = "******", UserPwd = userPwd, Birthday = "1987-09-14", BirthPlace = "四川岳池", CreateTime = DateTime.Now, CreateUserNo = "Admin", DataStatus = DataStatus.Valid, Email = "", Gender = Gender.Male, MemberType = MemberType.Normal, MobilePhone = "", NickName = "潇刚", QQ = "", Residence = "北京", Role = Role.Admin, TrueName = "成刚", UpdateTime = DateTime.Now, UpdateUserNo = "Admin" }; var userId = new CyUserService().AddCyUser(entity, null); } catch (Exception) { throw; } }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null) { try { //生成会员编号 var userNo = CySequenceCounterProvider.GetNextCounterId("UserNo"); entity.UserNo = "CYHY" + userNo.ToString("000000"); //登录密码加密 var userPwd = StringUtil.ToHashString(entity.UserPwd); entity.UserPwd = userPwd; return CyUserProvider.AddCyUser(entity, trans); } catch (Exception) { throw; } }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null) { try { return CyUserProvider.ModifyCyUser(entity, trans); } catch (Exception) { throw; } }
public CommonResult<CyUserEntity> Login(CyUserEntity user) { try { var commonResult = new CommonResult<CyUserEntity>(); if (string.IsNullOrEmpty(user.UserName)) { commonResult.Success = false; commonResult.Message = "用户名为空"; return commonResult; } if (string.IsNullOrEmpty(user.UserPwd)) { commonResult.Success = false; commonResult.Message = "密码为空"; return commonResult; } var userResult = CyUserProvider.GetCyUserByUserName(user.UserName); if (userResult.Success) { var userModel = userResult.ResultObjList; if (userModel.Count == 0) { commonResult.Success = false; commonResult.Message = "用户名不存在"; return commonResult; } //如果同一用户名出现重复记录 if (userModel.Count > 1) { commonResult.Success = false; commonResult.Message = "用户信息异常请联系管理员"; return commonResult; } if (userModel[0].UserPwd != StringUtil.ToHashString(user.UserPwd)) { commonResult.Success = false; commonResult.Message = "密码错误"; return commonResult; } if (!string.Equals(HttpContext.Current.Session["vcode"].ToString(), user.ValideCode, StringComparison.CurrentCultureIgnoreCase)) { commonResult.Success = false; commonResult.Message = "验证码填写错误"; return commonResult; } commonResult.Success = true; commonResult.Message = "验证成功"; commonResult.ResultObj = userModel[0]; } else { commonResult = userResult; return commonResult; } return commonResult; } catch (Exception) { throw; } }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"UPDATE [dbo].[CyUser] SET [NickName] =@NickName ,[TrueName] =@TrueName ,[Gender] =@Gender ,[MobilePhone] =@MobilePhone ,[Email] =@Email ,[QQ] =@QQ ,[Birthday] =@Birthday ,[BirthPlace] =@BirthPlace ,[Residence] =@Residence ,[UpdateUserNo] =@UpdateUserNo ,[UpdateTime] =@UpdateTime WHERE UserNo=@UserNo"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"INSERT INTO [dbo].[CyUser] ([UserNo] ,[UserName] ,[UserPwd] ,[NickName] ,[TrueName] ,[Gender] ,[MobilePhone] ,[Email] ,[QQ] ,[Industry] ,[Position] ,[Birthday] ,[BirthPlace] ,[Residence] ,[MemberType] ,[Role] ,[CreateUserNo] ,[CreateTime] ,[UpdateUserNo] ,[UpdateTime] ,[DataStatus]) VALUES (@UserNo ,@UserName ,@UserPwd ,@NickName ,@TrueName ,@Gender ,@MobilePhone ,@Email ,@QQ ,@Industry ,@Position ,@Birthday ,@BirthPlace ,@Residence ,@MemberType ,@Role ,@CreateUserNo ,@CreateTime ,@UpdateUserNo ,@UpdateTime ,@DataStatus)"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }