/// <summary> /// 获取当前登录用户的数据访问权限 /// </summary> /// <param name="blDeptCondition">是否开启,默认开启</param> /// <returns></returns> protected virtual string GetDataPrivilege(bool blDeptCondition = true) { string where = "1=1"; //开权限数据过滤 if (blDeptCondition) { var identities = HttpContextHelper.HttpContext.User.Identities; var claimsIdentity = identities.First <ClaimsIdentity>(); List <Claim> claimlist = claimsIdentity.Claims as List <Claim>; YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); if (claimlist[1].Value != "admin") { //如果公司过滤条件不为空,那么需要进行过滤 List <String> list = JsonSerializer.Deserialize <List <String> >(yuebonCacheHelper.Get("User_RoleData_" + claimlist[0].Value).ToJson()); if (list.Count() > 0) { string DataFilterCondition = String.Join(",", list.ToArray()); if (!string.IsNullOrEmpty(DataFilterCondition)) { where += string.Format(" and (DeptId in ('{0}') or CreatorUserId='{1}')", DataFilterCondition.Replace(",", "','"), claimlist[0].Value); } } else { where += string.Format(" and CreatorUserId='{0}'", claimlist[0].Value); } bool isMultiTenant = Configs.GetConfigurationValue("AppSetting", "IsMultiTenant").ToBool(); if (isMultiTenant) { where += string.Format(" and TenantId='{0}'", claimlist[3].Value); } } } return(where); }
public async Task <IActionResult> GetListByParentEnCode(string enCode) { CommonResult result = new CommonResult(); try { if (CurrentUser != null) { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); List <MenuOutputDto> functions = new List <MenuOutputDto>(); functions = yuebonCacheHelper.Get("User_Function_" + CurrentUser.UserId).ToJson().ToObject <List <MenuOutputDto> >(); MenuOutputDto functionOutputDto = functions.Find(s => s.EnCode == enCode); List <MenuOutputDto> nowFunList = new List <MenuOutputDto>(); if (functionOutputDto != null) { nowFunList = functions.FindAll(s => s.ParentId == functionOutputDto.Id && s.IsShow && s.MenuType.Equals("F")).OrderBy(s => s.SortCode).ToList(); } result.ErrCode = ErrCode.successCode; result.ResData = nowFunList; } else { result.ErrCode = "40008"; result.ErrMsg = ErrCode.err40008; } } catch (Exception ex) { Log4NetHelper.Error("根据父级功能编码查询所有子集功能,主要用于页面操作按钮权限,代码生成异常", ex); result.ErrCode = ErrCode.failCode; result.ErrMsg = "获取模块功能异常"; } return(ToJsonContent(result)); }
public void UpdateCacheAllowApp() { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); IEnumerable <APP> appList = repository.GetAllByIsNotDeleteAndEnabledMark(); yuebonCacheHelper.Add("AllowAppId", appList); }
public IActionResult YuebonConnecSys(string systype) { CommonResult result = new CommonResult(); try { if (!string.IsNullOrEmpty(systype)) { SystemType systemType = iService.GetByCode(systype); string openmf = MD5Util.GetMD5_32(DEncrypt.Encrypt(CurrentUser.UserId + systemType.Id, GuidUtils.NewGuidFormatN())).ToLower(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); TimeSpan expiresSliding = DateTime.Now.AddSeconds(20) - DateTime.Now; yuebonCacheHelper.Add("openmf" + openmf, CurrentUser.UserId, expiresSliding, false); result.ErrCode = ErrCode.successCode; result.ResData = systemType.Url + "?openmf=" + openmf; } else { result.ErrCode = ErrCode.failCode; result.ErrMsg = "切换子系统参数错误"; } } catch (Exception ex) { Log4NetHelper.Error("切换子系统异常", ex); result.ErrMsg = ErrCode.err40110; result.ErrCode = "40110"; } return(ToJsonContent(result)); }
/// <summary> /// 发送邮件 /// </summary> /// <param name="mailBodyEntity">邮件基础信息</param> public static SendResultEntity SendMail(MailBodyEntity mailBodyEntity) { var sendResultEntity = new SendResultEntity(); if (mailBodyEntity == null) { throw new ArgumentNullException(); } SendServerConfigurationEntity sendServerConfiguration = new SendServerConfigurationEntity(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); AppSetting sysSetting = yuebonCacheHelper.Get <AppSetting>("SysSetting"); if (sysSetting != null) { sendServerConfiguration.SmtpHost = DEncrypt.Decrypt(sysSetting.Emailsmtp); sendServerConfiguration.SenderAccount = sysSetting.Emailusername; sendServerConfiguration.SenderPassword = DEncrypt.Decrypt(sysSetting.Emailpassword); sendServerConfiguration.SmtpPort = sysSetting.Emailport.ToInt(); sendServerConfiguration.IsSsl = sysSetting.Emailssl.ToBool(); sendServerConfiguration.MailEncoding = "utf-8"; mailBodyEntity.Sender = sysSetting.Emailnickname; mailBodyEntity.SenderAddress = sysSetting.Emailusername; } else { sendResultEntity.ResultInformation = "邮件服务器未配置"; sendResultEntity.ResultStatus = false; throw new ArgumentNullException(); } sendResultEntity = SendMail(mailBodyEntity, sendServerConfiguration); return(sendResultEntity); }
/// <summary> /// 初始化 /// </summary> public virtual void Initial() { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); if (sysSetting != null) { yuebonCacheHelper.Add("SysSetting", sysSetting); } }
public async Task <IActionResult> CreateDBConn(DbConnInfo dbConnInfo) { CommonResult result = new CommonResult(); DBConnResult dBConnResult = new DBConnResult(); if (dbConnInfo != null) { if (string.IsNullOrEmpty(dbConnInfo.DbName)) { dbConnInfo.DbName = "master"; } else if (string.IsNullOrEmpty(dbConnInfo.DbAddress)) { result.ErrMsg = "访问地址不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbUserName)) { result.ErrMsg = "访问用户不能为空"; } else if (string.IsNullOrEmpty(dbConnInfo.DbPassword)) { result.ErrMsg = "访问密码不能为空"; } if (string.IsNullOrEmpty(dbConnInfo.DbPort.ToString())) { if (dbConnInfo.DbType == "SqlServer") { dbConnInfo.DbPort = 1433; } else if (dbConnInfo.DbType == "MySql") { dbConnInfo.DbPort = 3306; } } if (dbConnInfo.DbType == "SqlServer") { dBConnResult.ConnStr = string.Format("Server={0},{1};Database={2};User id={3}; password={4};MultipleActiveResultSets=True;", dbConnInfo.DbAddress, dbConnInfo.DbPort, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword); } else if (dbConnInfo.DbType == "MySql") { dBConnResult.ConnStr = string.Format("server={0};database={1};uid={2}; pwd={3};port={4};Allow User Variables=True;", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword, dbConnInfo.DbPort); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now; yuebonCacheHelper.Add("CodeGeneratorDbConn", dBConnResult.ConnStr, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbType", dbConnInfo.DbType, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbName", dbConnInfo.DbName, expiresSliding, false); DbExtractor dbExtractor = new DbExtractor(); List <DataBaseInfo> listTable = dbExtractor.GetAllDataBases(); result.ResData = listTable; result.Success = true; result.ErrCode = ErrCode.successCode; } return(ToJsonContent(result)); }
/// <summary> /// 根据相关信息,写入用户的操作日志记录 /// </summary> /// <param name="tableName">操作表名称</param> /// <param name="operationType">操作类型</param> /// <param name="note">操作详细表述</param> /// <returns></returns> public bool OnOperationLog(string tableName, string operationType, string note) { try { //虽然实现了这个事件,但是我们还需要判断该表是否在配置表里面,如果不在,则不记录操作日志。 //var identities = _httpContextAccessor.HttpContext.User.Identities; if (HttpContextHelper.HttpContext == null) { return(false); } var identities = HttpContextHelper.HttpContext.User.Identities; var claimsIdentity = identities.First <ClaimsIdentity>(); List <Claim> claimlist = claimsIdentity.Claims as List <Claim>; string userId = claimlist[0].Value; YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); YuebonCurrentUser CurrentUser = new YuebonCurrentUser(); var user = yuebonCacheHelper.Get("login_user_" + userId).ToJson().ToObject <YuebonCurrentUser>(); if (user != null) { CurrentUser = user; bool insert = operationType == DbLogType.Create.ToString();; //&& settingInfo.InsertLog; bool update = operationType == DbLogType.Update.ToString(); // && settingInfo.UpdateLog; bool delete = operationType == DbLogType.Delete.ToString(); // && settingInfo.DeleteLog; bool deletesoft = operationType == DbLogType.DeleteSoft.ToString(); // && settingInfo.DeleteLog; bool exception = operationType == DbLogType.Exception.ToString(); // && settingInfo.DeleteLog; bool sql = operationType == DbLogType.SQL.ToString(); // && settingInfo.DeleteLog; if (insert || update || delete || deletesoft || exception || sql) { Log info = new Log(); info.ModuleName = tableName; info.Type = operationType; info.Description = note; info.Date = info.CreatorTime = DateTime.Now; info.CreatorUserId = CurrentUser.UserId; info.Account = CurrentUser.Account; info.NickName = CurrentUser.NickName; info.OrganizeId = CurrentUser.OrganizeId; info.IPAddress = CurrentUser.CurrentLoginIP; info.IPAddressName = CurrentUser.IPAddressName; info.Result = true; long lg = _iLogRepository.Insert(info); if (lg > 0) { return(true); } } } }catch (Exception ex) { Log4NetHelper.Error("", ex); return(false); } return(false); }
public async Task <IActionResult> ContentWxAppletQrCode([FromBody] ContentPlayBillModel info) { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); try { if (info == null) { return(ToJsonContent(result)); } string page = info.Page; //此接口不可以带参数,如果需要加参数,必须加到scene中 string scene = info.Scene;; //id=xxxxxx,scene最多允许32个字符 int width = string.IsNullOrEmpty(info.Width.ToString()) ? 480 : info.Width.ToInt(); //图片名称 string picname = "ref" + width + GuidUtils.CreateNo() + ".png"; var _tempfilepath = "/upload/contentqrcode/"; var uploadPath = _filePath + _tempfilepath; if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } string qrcodePicPath = uploadPath + picname;//小程序二维码图片 MemoryStream ms = new MemoryStream(); if (!System.IO.File.Exists(qrcodePicPath)) { var resultImg = await WxAppApi.GetWxaCodeUnlimitAsync(WxOpenAppId, qrcodePicPath, scene, page, width, false, null, true); if (resultImg.errcode == ReturnCode.请求成功) { result.Success = true; result.ErrCode = ErrCode.successCode; result.ResData = _tempfilepath + picname; } else { result.ErrCode = resultImg.errcode.ToString(); result.ErrMsg = resultImg.errmsg; } } else { result.ErrCode = ErrCode.successCode; result.ErrMsg = _tempfilepath + picname; } } catch (Exception ex) { Log4NetHelper.Error("代码生成异常", ex); result.ErrMsg = "代码生成异常:" + ex.Message; result.ErrCode = ErrCode.failCode; } return(ToJsonContent(result)); }
public AliYunSMS() { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); AppSetting sysSetting = yuebonCacheHelper.Get <AppSetting>("SysSetting"); if (sysSetting != null) { this.Appkey = DEncrypt.Decrypt(sysSetting.Smsusername); this.Appsecret = DEncrypt.Decrypt(sysSetting.Smspassword); this.SignName = sysSetting.SmsSignName; } }
public async Task <IActionResult> GetSysInfo() { CommonResult result = new CommonResult(); try { SysSetting sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); yuebonCacheHelper.Add("SysSetting", sysSetting); DashboardOutModel dashboardOutModel = new DashboardOutModel(); dashboardOutModel.CertificatedCompany = sysSetting.CompanyName; dashboardOutModel.WebUrl = sysSetting.WebUrl; dashboardOutModel.Title = sysSetting.SoftName; dashboardOutModel.MachineName = Environment.MachineName; dashboardOutModel.ProcessorCount = Environment.ProcessorCount; dashboardOutModel.SystemPageSize = Environment.SystemPageSize; dashboardOutModel.WorkingSet = Environment.WorkingSet; dashboardOutModel.TickCount = Environment.TickCount; dashboardOutModel.RunTimeLength = (Environment.TickCount / 1000).ToBrowseTime(); dashboardOutModel.FrameworkDescription = RuntimeInformation.FrameworkDescription; dashboardOutModel.OSName = RuntimeInformation.IsOSPlatform(OSPlatform.Linux) ? "Linux" : RuntimeInformation.IsOSPlatform(OSPlatform.OSX) ? "OSX" : "Windows"; dashboardOutModel.OSDescription = RuntimeInformation.OSDescription + " " + RuntimeInformation.OSArchitecture; dashboardOutModel.OSArchitecture = RuntimeInformation.OSArchitecture.ToString(); dashboardOutModel.ProcessArchitecture = RuntimeInformation.ProcessArchitecture.ToString(); dashboardOutModel.Directory = AppContext.BaseDirectory; Version version = Environment.Version; dashboardOutModel.SystemVersion = version.Major + "." + version.Minor + "." + version.Build; dashboardOutModel.Version = AppVersionHelper.Version; dashboardOutModel.Manufacturer = AppVersionHelper.Manufacturer; dashboardOutModel.WebSite = AppVersionHelper.WebSite; dashboardOutModel.UpdateUrl = AppVersionHelper.UpdateUrl; dashboardOutModel.IPAdress = Request.HttpContext.Connection.LocalIpAddress.ToString(); dashboardOutModel.Port = Request.HttpContext.Connection.LocalPort.ToString(); dashboardOutModel.TotalUser = await userService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalModule = await menuService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalRole = await roleService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalTask = await taskManagerService.GetCountByWhereAsync("1=1"); result.ResData = dashboardOutModel; result.ErrCode = ErrCode.successCode; } catch (Exception ex) { Log4NetHelper.Error("获取系统信息异常", ex); result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } return(ToJsonContent(result)); }
/// <summary> /// 数据库连接,根据数据库类型自动识别,类型区分用配置名称是否包含主要关键字 /// MSSQL、MYSQL、ORACLE、SQLITE、MEMORY、NPGSQL /// </summary> /// <returns></returns> public DbConnection OpenSharedConnection() { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); object connCode = yuebonCacheHelper.Get("CodeGeneratorDbConn"); DbConnectionOptions dbConnectionOptions = DBServerProvider.GeDbConnectionOptions(); DatabaseType dbType = DatabaseType.SqlServer; if (connCode != null) { defaultSqlConnectionString = connCode.ToString(); string dbTypeCache = yuebonCacheHelper.Get("CodeGeneratorDbType").ToString(); dbType = (DatabaseType)Enum.Parse(typeof(DatabaseType), dbTypeCache); } else { defaultSqlConnectionString = dbConnectionOptions.ConnectionString; dbType = dbConnectionOptions.DatabaseType; TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now; yuebonCacheHelper.Add("CodeGeneratorDbConn", defaultSqlConnectionString, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbType", dbType, expiresSliding, false); } if (dbType == DatabaseType.SqlServer) { dbConnection = new SqlConnection(defaultSqlConnectionString); } else if (dbType == DatabaseType.MySql) { dbConnection = new MySqlConnection(defaultSqlConnectionString); } else if (dbType == DatabaseType.Oracle) { dbConnection = new OracleConnection(defaultSqlConnectionString); } else if (dbType == DatabaseType.SQLite) { dbConnection = new SqliteConnection(defaultSqlConnectionString); } else if (dbType == DatabaseType.Npgsql) { dbConnection = new NpgsqlConnection(defaultSqlConnectionString); } else { throw new NotSupportedException("The database is not supported"); } if (dbConnection.State != ConnectionState.Open) { dbConnection.Open(); } return(dbConnection); }
/// <summary> /// 获取省可用的地区,用于select2下拉选项 /// </summary> /// <returns></returns> public List <AreaSelect2OutDto> GetProvinceAll() { List <AreaSelect2OutDto> list = new List <AreaSelect2OutDto>(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); list = JsonConvert.DeserializeObject <List <AreaSelect2OutDto> >(yuebonCacheHelper.Get("Area_ProvinceToArea_Select2").ToJson()); if (list == null || list.Count <= 0) { list = service.GetAllByIsNotDeleteAndEnabledMark("Layers =1").OrderBy(t => t.Id).ToList().MapTo <AreaSelect2OutDto>(); yuebonCacheHelper.Add("Area_ProvinceToArea_Select2", list); } return(list); }
public async Task <IActionResult> GetListDataBase() { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); yuebonCacheHelper.Remove("CodeGeneratorDbConn"); yuebonCacheHelper.Remove("CodeGeneratorDbName"); CommonResult result = new CommonResult(); DbExtractor dbExtractor = new DbExtractor(); List <DataBaseInfo> listTable = dbExtractor.GetAllDataBases(); result.ResData = listTable; result.ErrCode = ErrCode.successCode; return(ToJsonContent(result)); }
/// <summary> /// 获取所有可用的地区,用于uniapp下拉选项 /// </summary> /// <returns></returns> public List <AreaPickerOutputDto> GetAllByEnable() { List <AreaPickerOutputDto> list = new List <AreaPickerOutputDto>(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); list = JsonConvert.DeserializeObject <List <AreaPickerOutputDto> >(yuebonCacheHelper.Get("Area_Enable_Uniapp").ToJson()); if (list == null || list.Count <= 0) { List <Area> listFunction = _repository.GetAllByIsNotDeleteAndEnabledMark("Layers in (0,1,2)").OrderBy(t => t.SortCode).ToList(); list = UniappViewJson(listFunction, ""); yuebonCacheHelper.Add("Area_Enable_Uniapp", list); } return(list); }
public IActionResult Save(SysSetting info) { CommonResult result = new CommonResult(); info.LocalPath = _hostingEnvironment.WebRootPath; SysSetting sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); sysSetting = info; //对关键信息加密 if (!string.IsNullOrEmpty(info.Email)) { sysSetting.Email = DEncrypt.Encrypt(info.Email); } if (!string.IsNullOrEmpty(info.Emailsmtp)) { sysSetting.Emailsmtp = DEncrypt.Encrypt(info.Emailsmtp); } if (!string.IsNullOrEmpty(info.Emailpassword)) { sysSetting.Emailpassword = DEncrypt.Encrypt(info.Emailpassword); } if (!string.IsNullOrEmpty(info.Smspassword)) { sysSetting.Smspassword = DEncrypt.Encrypt(info.Smspassword); } if (!string.IsNullOrEmpty(info.Smsusername)) { sysSetting.Smsusername = DEncrypt.Encrypt(info.Smsusername); } string uploadPath = _hostingEnvironment.WebRootPath + "/" + sysSetting.Filepath; if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); if (yuebonCacheHelper.Exists("SysSetting")) { yuebonCacheHelper.Replace("SysSetting", sysSetting); } else { //写入缓存 yuebonCacheHelper.Add("SysSetting", sysSetting); } XmlConverter.Serialize <SysSetting>(sysSetting, "xmlconfig/sys.config"); result.ErrCode = ErrCode.successCode; return(ToJsonContent(result)); }
public override async Task <IActionResult> DeleteBatchAsync(DeletesInputDto info) { CommonResult result = new CommonResult(); string where = string.Empty; where = "id in ('" + info.Ids.Join(",").Trim(',').Replace(",", "','") + "')"; if (!string.IsNullOrEmpty(where)) { dynamic[] jobsId = info.Ids; foreach (var item in jobsId) { if (string.IsNullOrEmpty(item.ToString())) { continue; } UploadFile uploadFile = new UploadFileApp().Get(item.ToString()); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); if (uploadFile != null) { if (System.IO.File.Exists(sysSetting.LocalPath + "/" + uploadFile.FilePath)) { System.IO.File.Delete(sysSetting.LocalPath + "/" + uploadFile.FilePath); } if (!string.IsNullOrEmpty(uploadFile.Thumbnail)) { if (System.IO.File.Exists(sysSetting.LocalPath + "/" + uploadFile.Thumbnail)) { System.IO.File.Delete(sysSetting.LocalPath + "/" + uploadFile.Thumbnail); } } } } bool bl = await iService.DeleteBatchWhereAsync(where).ConfigureAwait(false); if (bl) { result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43003; result.ErrCode = "43003"; } } return(ToJsonContent(result)); }
/// <summary> /// 获取县区,用于select2下拉选项 /// </summary> /// <param name="id">城市Id</param> /// <returns></returns> public List <AreaSelect2OutDto> GetDistrictByCityId(string id) { List <AreaSelect2OutDto> list = new List <AreaSelect2OutDto>(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); list = JsonConvert.DeserializeObject <List <AreaSelect2OutDto> >(yuebonCacheHelper.Get("Area_DistrictToArea_Enable_Select2" + id).ToJson()); if (list == null || list.Count <= 0) { string sqlWhere = string.Format("ParentId='{0}'", id); list = service.GetAllByIsNotDeleteAndEnabledMark(sqlWhere).OrderBy(t => t.Id).ToList().MapTo <AreaSelect2OutDto>(); yuebonCacheHelper.Add("Area_DistrictToArea_Enable_Select2" + id, list); } return(list); }
public IActionResult GetAllInfo() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); SysSettingOutputDto sysSettingOutputDto = new SysSettingOutputDto(); if (sysSetting == null) { sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); } //对关键信息解密 if (!string.IsNullOrEmpty(sysSetting.Email)) { sysSetting.Email = DEncrypt.Decrypt(sysSetting.Email); } if (!string.IsNullOrEmpty(sysSetting.Emailsmtp)) { sysSetting.Emailsmtp = DEncrypt.Decrypt(sysSetting.Emailsmtp); } if (!string.IsNullOrEmpty(sysSetting.Emailpassword)) { sysSetting.Emailpassword = DEncrypt.Decrypt(sysSetting.Emailpassword); } if (!string.IsNullOrEmpty(sysSetting.Smspassword)) { sysSetting.Smspassword = DEncrypt.Decrypt(sysSetting.Smspassword); } if (!string.IsNullOrEmpty(sysSetting.Smsusername)) { sysSetting.Smsusername = DEncrypt.Decrypt(sysSetting.Smsusername); } sysSettingOutputDto = sysSetting.MapTo <SysSettingOutputDto>(); if (sysSettingOutputDto != null) { sysSettingOutputDto.CopyRight = UIConstants.CopyRight; result.ResData = sysSettingOutputDto; result.Success = true; result.ErrCode = ErrCode.successCode; } else { result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } return(ToJsonContent(result)); }
public CommonResult <PageResult <DbTableInfo> > FindListTable(SearchModel search) { CommonResult <PageResult <DbTableInfo> > result = new CommonResult <PageResult <DbTableInfo> >(); if (!string.IsNullOrEmpty(search.EnCode)) { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); object connCode = yuebonCacheHelper.Get("CodeGeneratorDbConn"); if (connCode != null) { string SqlConnectionString = connCode.ToString(); string[] sqlconn = SqlConnectionString.Split(";"); string[] dataName = sqlconn[1].Split("="); dataName[1] = search.EnCode; sqlconn[1] = dataName.Join("="); string newConnStr = sqlconn.Join(";"); TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now; yuebonCacheHelper.Add("CodeGeneratorDbConn", newConnStr, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbName", search.EnCode, expiresSliding, false); } } string orderByDir = search.Order; string orderFlied = string.IsNullOrEmpty(search.Sort)? "TableName": search.Sort; bool order = orderByDir == "asc" ? false : true; string where = "1=1"; if (!string.IsNullOrEmpty(search.Keywords)) { where += " and TableName like '%" + search.Keywords + "%'"; } PagerInfo pagerInfo = new PagerInfo { PageSize = search.PageSize, CurrenetPageIndex = search.CurrenetPageIndex }; DbExtractor dbExtractor = new DbExtractor(); List <DbTableInfo> listTable = dbExtractor.GetTablesWithPage(search.Keywords, orderFlied, order, pagerInfo); PageResult <DbTableInfo> pageResult = new PageResult <DbTableInfo>(); pageResult.CurrentPage = pagerInfo.CurrenetPageIndex; pageResult.Items = listTable; pageResult.ItemsPerPage = pagerInfo.PageSize; pageResult.TotalItems = pagerInfo.RecordCount; result.ResData = pageResult; result.ErrCode = ErrCode.successCode; return(result); }
/// <summary> /// 验证appId是否被允许 /// </summary> /// <param name="appId"></param> /// <returns></returns> private static AllowCacheApp VerifyAppId(string appId) { AllowCacheApp allowCacheApp = new AllowCacheApp(); if (string.IsNullOrEmpty(appId)) { return(allowCacheApp); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); List <AllowCacheApp> list = yuebonCacheHelper.Get("AllowAppId").ToJson().ToList <AllowCacheApp>(); if (list.Count > 0) { allowCacheApp = list.Where(s => s.AppId == appId).FirstOrDefault(); } return(allowCacheApp); }
public IActionResult Logout() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); yuebonCacheHelper.Remove("login_user_" + CurrentUser.UserId); yuebonCacheHelper.Remove("User_Function_" + CurrentUser.UserId); UserLogOn userLogOn = _userLogOnService.GetWhere("UserId='" + CurrentUser.UserId + "'"); userLogOn.UserOnLine = false; _userLogOnService.Update(userLogOn, userLogOn.Id); CurrentUser = null; result.Success = true; result.ErrCode = ErrCode.successCode; result.ErrMsg = "成功退出"; return(ToJsonContent(result)); }
public DbExtractor() { MssqlExtractor mssqlExtractor = new MssqlExtractor(); mssqlExtractor.OpenSharedConnection(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); string dbTypeCache = yuebonCacheHelper.Get("CodeGeneratorDbType").ToString(); if (dbTypeCache != null) { dbType = (DatabaseType)Enum.Parse(typeof(DatabaseType), dbTypeCache); } object odbn = yuebonCacheHelper.Get("CodeGeneratorDbName"); if (odbn != null) { dbName = odbn.ToString(); } }
public async Task <IActionResult> ContentWxAppletQrCodeRes([FromQuery] ContentPlayBillModel info) { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); MemoryStream ms = new MemoryStream(); try { if (info == null) { return(ToJsonContent(result)); } string page = info.Page; //此接口不可以带参数,如果需要加参数,必须加到scene中 string scene = info.Scene;; //id=xxxxxx,scene最多允许32个字符 int width = string.IsNullOrEmpty(info.Width.ToString()) ? 480 : info.Width.ToInt(); var resultImg = await WxAppApi.GetWxaCodeUnlimitAsync(WxOpenAppId, ms, scene, page, width); ms.Position = 0; if (resultImg.errcode == ReturnCode.请求成功) { var imgBase64 = Convert.ToBase64String(ms.GetBuffer()); result.Success = true; result.ErrCode = ErrCode.successCode; result.ResData = imgBase64; } else { result.ErrCode = resultImg.errcode.ToString(); result.ErrMsg = resultImg.errmsg; } } catch (Exception ex) { Log4NetHelper.Error("代码生成异常", ex); result.ErrMsg = "代码生成异常:" + ex.Message; result.ErrCode = ErrCode.failCode; } finally{ ms.Dispose(); } return(ToJsonContent(result)); }
public IActionResult DeleteFile(string id) { CommonResult result = new CommonResult(); try { UploadFile uploadFile = new UploadFileApp().Get(id); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); string localpath = _hostingEnvironment.WebRootPath; if (uploadFile != null) { string filepath = (localpath + "/" + uploadFile.FilePath).ToFilePath(); if (System.IO.File.Exists(filepath)) { System.IO.File.Delete(filepath); } string filepathThu = (localpath + "/" + uploadFile.Thumbnail).ToFilePath(); if (System.IO.File.Exists(filepathThu)) { System.IO.File.Delete(filepathThu); } result.ErrCode = ErrCode.successCode; result.Success = true; } else { result.ErrCode = ErrCode.failCode; result.Success = false; } } catch (Exception ex) { Log4NetHelper.Error("", ex); result.ErrCode = "500"; result.ErrMsg = ex.Message; } return(ToJsonContent(result)); }
public async Task <CommonResult <AuthGetVerifyCodeOutputDto> > CaptchaAsync() { Captcha captcha = new Captcha(); var code = await captcha.GenerateRandomCaptchaAsync().ConfigureAwait(false); var result = await captcha.GenerateCaptchaImageAsync(code); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); TimeSpan expiresSliding = DateTime.Now.AddMinutes(5) - DateTime.Now; yuebonCacheHelper.Add("ValidateCode" + result.Timestamp.ToString("yyyyMMddHHmmssffff"), code, expiresSliding, false); AuthGetVerifyCodeOutputDto authGetVerifyCodeOutputDto = new AuthGetVerifyCodeOutputDto(); authGetVerifyCodeOutputDto.Img = Convert.ToBase64String(result.CaptchaMemoryStream.ToArray()); authGetVerifyCodeOutputDto.Key = result.Timestamp.ToString("yyyyMMddHHmmssffff"); CommonResult <AuthGetVerifyCodeOutputDto> commonResult = new CommonResult <AuthGetVerifyCodeOutputDto>(); commonResult.ErrCode = ErrCode.successCode; commonResult.ResData = authGetVerifyCodeOutputDto; return(commonResult); }
/// <summary> /// 判断当前用户是否拥有某功能点的权限 /// </summary> /// <param name="functionCode">功能编码code</param> /// <param name="userId">用户id</param> /// <returns></returns> public static bool HasFunction(string functionCode, string userId) { bool hasFunction = false; if (!string.IsNullOrEmpty(userId)) { if (string.IsNullOrEmpty(functionCode)) { hasFunction = true; } else { List <MenuOutputDto> listFunction = new YuebonCacheHelper().Get("User_Function_" + userId).ToJson().ToList <MenuOutputDto>(); if (listFunction != null && listFunction.Count(t => t.EnCode == functionCode) > 0) { hasFunction = true; } } } return(hasFunction); }
public IActionResult GetInfo() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); SysSettingOutputDto sysSettingOutputDto = new SysSettingOutputDto(); if (sysSetting == null) { sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); } sysSetting.Email = ""; sysSetting.Emailsmtp = ""; sysSetting.Emailpassword = ""; sysSetting.Smspassword = ""; sysSetting.SmsSignName = ""; sysSetting.Smsusername = ""; sysSettingOutputDto = sysSetting.MapTo <SysSettingOutputDto>(); if (sysSettingOutputDto != null) { sysSettingOutputDto.CopyRight = UIConstants.CopyRight; result.ResData = sysSettingOutputDto; result.Success = true; result.ErrCode = ErrCode.successCode; } else { result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } IEnumerable <APP> appList = aPPService.GetAllByIsNotDeleteAndEnabledMark(); yuebonCacheHelper.Add("AllowAppId", appList); return(ToJsonContent(result)); }
/// <summary> /// 获取省、市、县/区三级可用的地区,用于uniapp下拉选项 /// </summary> /// <returns></returns> public List <AreaPickerOutputDto> GetProvinceToAreaByEnable() { List <AreaPickerOutputDto> list = new List <AreaPickerOutputDto>(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); list = JsonConvert.DeserializeObject <List <AreaPickerOutputDto> >(yuebonCacheHelper.Get("Area_ProvinceToArea_Enable_Uniapp").ToJson()); if (list == null || list.Count <= 0) { List <Area> listFunctionTemp = _repository.GetAllByIsNotDeleteAndEnabledMark("Layers in (1,2,3)").OrderBy(t => t.Id).ToList(); List <Area> listFunction = new List <Area>(); foreach (Area item in listFunctionTemp) { if (item.Layers == 1) { item.ParentId = ""; } listFunction.Add(item); } list = UniappViewJson(listFunction, ""); yuebonCacheHelper.Add("Area_ProvinceToArea_Enable_Uniapp", list); } return(list); }
public async Task <IActionResult> RegisterAsync(RegisterViewModel tinfo) { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); var vCode = yuebonCacheHelper.Get("ValidateCode" + tinfo.VerifyCodeKey); string code = vCode != null?vCode.ToString() : "11"; if (code != tinfo.VerificationCode.ToUpper()) { result.ErrMsg = "验证码错误"; return(ToJsonContent(result)); } if (!string.IsNullOrEmpty(tinfo.Account)) { if (string.IsNullOrEmpty(tinfo.Password) || tinfo.Password.Length < 6) { result.ErrMsg = "密码不能为空或小于6位"; return(ToJsonContent(result)); } User user = await iService.GetByUserName(tinfo.Account); if (user != null) { result.ErrMsg = "登录账号不能重复"; return(ToJsonContent(result)); } } else { result.ErrMsg = "登录账号不能为空"; return(ToJsonContent(result)); } User info = new User(); info.Id = GuidUtils.CreateNo(); info.Account = tinfo.Account; info.Email = tinfo.Email; info.CreatorTime = DateTime.Now; info.CreatorUserId = info.Id; info.OrganizeId = ""; info.EnabledMark = true; info.IsAdministrator = false; info.IsMember = true; info.RoleId = roleService.GetRole("usermember").Id; info.DeleteMark = false; info.SortCode = 99; UserLogOn userLogOn = new UserLogOn(); userLogOn.UserPassword = tinfo.Password; userLogOn.AllowStartTime = userLogOn.LockEndDate = userLogOn.LockStartDate = userLogOn.ChangePasswordDate = DateTime.Now; userLogOn.AllowEndTime = DateTime.Now.AddYears(100); userLogOn.MultiUserLogin = userLogOn.CheckIPAddress = false; userLogOn.LogOnCount = 0; result.Success = await iService.InsertAsync(info, userLogOn); if (result.Success) { yuebonCacheHelper.Remove("ValidateCode"); result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43001; result.ErrCode = "43001"; } return(ToJsonContent(result)); }