/// <summary> /// 添加登录日志 /// </summary> /// <param name="entity"></param> /// <param name="trans"></param> /// <returns></returns> public CommonResult<string> AddCyUserLoginLog(CyUserLoginLogEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"INSERT INTO [dbo].[CyUserLoginLog] ([UserNo] ,[LoginTime] ,[LoginIp]) VALUES (@UserNo ,@LoginTime ,@LoginIp)"; 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> AddCyUserLoginLog(CyUserLoginLogEntity entity, IDbTransaction trans = null) { try { return CyUserProvider.AddCyUserLoginLog(entity, trans); } catch (Exception) { throw; } }
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); }