/// <summary> /// 获取数据库连接字符串 /// </summary> /// <param name="dbserver"></param> /// <returns></returns> public string GetConnectStr(DbServerOutput dbserver) { string aesPwd = dbserver.Password; try { var p = EncryptHelper.AesDecrpt(dbserver.Password); aesPwd = p; } catch { } switch (dbserver.DbTypeName.ToUpper()) { case "DB2": return(string.Format("Server={0}:{1};Database={2};UID={3};PWD={4};Connection Timeout =3600", dbserver.Ip, dbserver.Port, dbserver.DataCase, dbserver.User, aesPwd)); case "ORACLE": return(string.Format("Data Source={0}:{1}/{2};User Id={3};Password={4};Connection Timeout =3600", dbserver.Ip, dbserver.Port, dbserver.DataCase, dbserver.User, aesPwd)); case "MYSQL": //return string.Format("Data Source={0}:{1}/{2};User Id={3};Password={4};Connection Timeout =3600", dbserver.Ip, dbserver.Port, dbserver.DataCase, dbserver.User, dbserver.Password); break; case "SQLSERVER": //return string.Format("Data Source={0}:{1}/{2};User Id={3};Password={4};Connection Timeout =3600", dbserver.Ip, dbserver.Port, dbserver.DataCase, dbserver.User, dbserver.Password); break; default: //默认oracle return(string.Format("Data Source={0}:{1}/{2};User Id={3};Password={4};Connection Timeout =3600", dbserver.Ip, dbserver.Port, dbserver.DataCase, dbserver.User, aesPwd)); } return(""); }
protected void SearchBtn_Click(object sender, EventArgs e) { string code = this.code.Value; string queryParams = this.queryParams.Value; string xmlStr = EncryptHelper.AesDecrpt(this.xmlStr.Value); string rpName = this.rpName.Value; DataTable dt = new DataTable(); EasyMan.Dtos.ErrorInfo err = new EasyMan.Dtos.ErrorInfo(); //从ioc容器中获取当前需要的接口实例 var _reportApp = Abp.Dependency.IocManager.Instance.Resolve <IReportAppService>(); #region 避免调用接口方法嵌套了多个复杂类型的方法 //string sql = _reportApp.GetSqlByCode(code, queryParams); //var _dbServerApp = Abp.Dependency.IocManager.Instance.Resolve<IDbServerAppService>(); //dt= _dbServerApp.ExecuteGetTable(1, sql); #endregion //GetDataTableFromCode方法中调用_dbServerApp.ExecuteGetTable(dbserver.Id, sql),不能传复杂类型dbserver dt = _reportApp.GetDataTableFromCode(code, queryParams, ref err); reportViewer1.LocalReport.DataSources.Clear();//清理原rdlc数据 reportViewer1.LocalReport.DisplayName = rpName; reportViewer1.LocalReport.LoadReportDefinition(GenerateRdlc(xmlStr)); ReportDataSource reportDataSource = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(reportDataSource);//赋值新数据 reportViewer1.LocalReport.Refresh(); }
public async Task <JsonResult> AppLogin(ApiLoginBean loginBean) { CheckModelState(); // 对密码进行AES解密 loginBean.username = EncryptHelper.AesDecrpt(loginBean.username); loginBean.password = EncryptHelper.AesDecrpt(loginBean.password); var loginModel = new LoginViewModel { UsernameOrEmailAddress = loginBean.username, Password = loginBean.password, TenancyName = loginBean.tenancyname }; var loginResult = await GetLoginResultAsync( loginModel.UsernameOrEmailAddress, loginModel.Password, loginModel.TenancyName ); ValidateCycleAndComplex(loginModel, loginResult);//密码复杂度和周期校验 await SignInAsync(loginResult.User, loginResult.Identity, loginModel.RememberMe); var userBean = new ApiUserBean { id = loginResult.User.Id, name = loginResult.User.UserName, }; //return Json(userBean); return(Json(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(userBean)))); }
/// <summary> /// 删除文件 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string FileDel(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestEntityBean>(decrptStr); var result = _fileAppService.FileDel(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
/// <summary> /// 检查版本更新 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string CheckUpdate(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestEntityBean>(decrptStr); var result = _appCommonAppService.CheckUpdate(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
/// <summary> /// 登录时获取用户信息 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string GetUserLoginInfo(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestEntityBean>(decrptStr); var result = _userInfoAppService.GetUserLoginInfo(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
/// <summary> /// 点赞内容评论 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string LikeContentReview(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestEntityBean>(decrptStr); var result = _contentAppService.LikeContentReview(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
/// <summary> /// 分页获取评论的回复 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string ContentReviewCommentList(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestPageBean>(decrptStr); var result = _contentAppService.GetPageReviewComment(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
/// <summary> /// 修改用户密码 /// </summary> /// <param name="requestObject"></param> /// <returns></returns> public string UserEditPwd(ApiEncryptedRequestBean requestObject) { var decrptStr = EncryptHelper.AesDecrpt(requestObject.reqData); var request = JsonConvert.DeserializeObject <ApiRequestSaveEntityBean <ApiKeyValueBean> >(decrptStr); var result = _userInfoAppService.UserEditPwd(request); return(EncryptHelper.AesEncrypt(JsonConvert.SerializeObject(result))); }
//public string[] AllowSites { get; set; } public override void OnActionExecuting(ActionExecutingContext context) { var origin = context.HttpContext.Request.Headers["Origin"].ToString(); string requestHeaders = context.HttpContext.Request.Headers["Access-Control-Request-Headers"]; Action action = () => { context.HttpContext.Response.Headers.Add("Access-Control-Allow-Origin", origin); context.HttpContext.Response.Headers.Add("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS"); context.HttpContext.Response.Headers.Add("Access-Control-Request-Headers", "Content-Type"); context.HttpContext.Response.Headers.Add("Access-Control-Allow-Credentials", "true"); }; action(); if (context.HttpContext.Request.Path.Value.ToLower() == "/api/data/getnowdate") { base.OnActionExecuting(context); } else { try { var t = context.HttpContext.Request.Form["TimeStamp"]; var dt = EncryptHelper.AesDecrpt(t); var clientTime = DateTimeHelper.StampToDateTime(dt); var now = DateTime.Now; var sec = now.Subtract(clientTime).TotalSeconds; double interval = 90; if (interval < Math.Abs(sec)) { var result = new LotteryServiceResponse() { Code = ResponseCode.TimeStampError, Message = "请求发生异常" }; context.Result = new JsonResult(result); } else { base.OnActionExecuting(context); } } catch (Exception ex) { var result = new LotteryServiceResponse() { Code = ResponseCode.TimeStampError, Message = "请求发生异常" }; context.Result = new JsonResult(result); } } }
public JsonResult SaveModifiedPwd(ModifyPwdViewModel modifyModel) { var errorInfo = new ApiErrorBean(); // 确认密码不匹配 if (!modifyModel.NewPassword.Trim().Equals(modifyModel.ConfirmPassword.Trim())) { errorInfo.isError = true; errorInfo.code = 1; errorInfo.message = "两次新密码输入不一致,请重新输入!"; return(Json(errorInfo)); } var keyValue = new ApiKeyValueBean { key = modifyModel.OldPassword, value = modifyModel.NewPassword }; var savePara = new ApiRequestSaveEntityBean <ApiKeyValueBean> { userId = modifyModel.UserId, entity = keyValue }; // 保存修改密码 errorInfo = _userInfoAppService.UserEditPwd(savePara); if (!errorInfo.isError)//写入密码修改记录 { _userPwdAppService.InsertUserPwdLog(new Dto.UserPwdLogDto { NewPwd = EncryptHelper.AesDecrpt(modifyModel.NewPassword), OldPwd = EncryptHelper.AesDecrpt(modifyModel.OldPassword), UserId = modifyModel.UserId }); } return(Json(errorInfo)); }
public async Task <JsonResult> Login(LoginViewModel loginModel, string returnUrl = "", string returnUrlHash = "") { EasyMan.Dtos.ErrorInfo err = new EasyMan.Dtos.ErrorInfo(); err.IsError = false; try { CheckModelState(); // 对密码进行AES解密 loginModel.Password = EncryptHelper.AesDecrpt(loginModel.Password); #region 取消验证码 //var verifyCode = loginModel.VerifyCode; //var isMatch = ToolHelper.MatchVerifyCode(verifyCode); //if (!isMatch) //{ // //throw new UserFriendlyException("登录失败", "验证码错误"); // throw new Exception("登录失败:验证码错误!"); //} #endregion var loginResult = await GetLoginResultAsync( loginModel.UsernameOrEmailAddress, loginModel.Password, loginModel.TenancyName ); ValidateCycleAndComplex(loginModel, loginResult);//密码复杂度和周期校验 await SignInAsync(loginResult.User, loginResult.Identity, loginModel.RememberMe); #region // 原-生成页面水印 //var systemName = ConfigurationManager.AppSettings["SysName"]; //var waterMark = ToolHelper.CreateWatermark(systemName, loginResult.User.UserName); //var filePath = AppDomain.CurrentDomain.BaseDirectory + "/UpFiles/Bg/"; //if (!Directory.Exists(filePath)) //{ // Directory.CreateDirectory(filePath); //} //var fileFullName = filePath + loginResult.User.Id + ".jpg"; //System.IO.File.WriteAllBytes(fileFullName, waterMark); #endregion if (string.IsNullOrWhiteSpace(returnUrl) || returnUrl == @"/") { //returnUrl = Request.ApplicationPath; returnUrl = Url.Content("~/Home/Index"); } if (!string.IsNullOrWhiteSpace(returnUrlHash)) { returnUrl = returnUrl + returnUrlHash; } err.IsError = false; err.Message = returnUrl; return(Json(err)); //return Json(new AjaxResponse { TargetUrl = returnUrl }); } catch (Exception e) { err.IsError = true; err.Message = e.Message; err.Excep = e; return(Json(err)); } }
/// <summary> /// 修改密码 /// </summary> /// <param name="request"></param> /// <returns></returns> public ApiErrorBean UserEditPwd(ApiRequestSaveEntityBean <ApiKeyValueBean> request) { var errorInfo = new ApiErrorBean(); var userId = request.userId; var oldPwd = EncryptHelper.AesDecrpt(request.entity.key); var newPwd = EncryptHelper.AesDecrpt(request.entity.value); try { DataTable dt = DbHelper.ExecuteGetTable("select id,PASSWORD from ABP_USERS where id='" + userId + "'"); if (dt != null && dt.Rows.Count > 0) { object uid = dt.Rows[0]["ID"]; if (uid != null && Convert.ToInt32(uid) > 0) { #region 验证旧密码 var hashHandler = new PasswordHasher(); var verifiedResult = hashHandler.VerifyHashedPassword(dt.Rows[0]["PASSWORD"].ToString(), oldPwd); //旧密码不匹配 if (!verifiedResult.Equals(PasswordVerificationResult.Success)) { errorInfo.isError = true; errorInfo.code = 3; errorInfo.message = "旧密码错误"; return(errorInfo); } #endregion #region 密码复杂度 string resComplex = ValidateComplex(newPwd); if (!string.IsNullOrEmpty(resComplex) && resComplex.Length > 0) { errorInfo.isError = true; errorInfo.code = 3; errorInfo.message = "密码复杂度不够:\r\n" + resComplex; return(errorInfo); } #endregion Common.DbHelper.Execute("update ABP_USERS set PASSWORD='******' where ID=" + uid); } } else { errorInfo.isError = true; errorInfo.code = 2; errorInfo.message = "当前用户不存在"; return(errorInfo); } } catch (Exception ex) { errorInfo.isError = true; errorInfo.code = 2; errorInfo.message = "异常错误:" + ex.Message; return(errorInfo); } errorInfo.isError = false; errorInfo.code = 0; errorInfo.message = "修改成功"; return(errorInfo); }