public async Task <MessageModel <string> > Assign([FromBody] AssignView assignView) { var data = new MessageModel <string>(); if (assignView.rid > 0) { data.success = true; var roleModulePermissions = await _roleModulePermissionServices.Query(d => d.RoleId == assignView.rid); var remove = roleModulePermissions.Where(d => !assignView.pids.Contains(d.PermissionId.ObjToInt())).Select(c => (object)c.Id); data.success &= remove.Any() ? await _roleModulePermissionServices.DeleteByIds(remove.ToArray()) : true; foreach (var item in assignView.pids) { var rmpitem = roleModulePermissions.Where(d => d.PermissionId == item); var moduleid = (await _permissionServices.Query(p => p.Id == item)).FirstOrDefault()?.Mid; if (!rmpitem.Any()) { RoleModulePermission roleModulePermission = new RoleModulePermission() { IsDeleted = false, RoleId = assignView.rid, ModuleId = moduleid.ObjToInt(), PermissionId = item, }; roleModulePermission.CreateId = _user.ID; roleModulePermission.CreateBy = _user.Name; data.success &= (await _roleModulePermissionServices.Add(roleModulePermission)) > 0; } else { foreach (var role in rmpitem) { if (!role.ModuleId.Equals(moduleid)) { role.ModuleId = moduleid.Value; await _roleModulePermissionServices.Update(role, new List <string> { "ModuleId" }); } } } } if (data.success) { _requirement.Permissions.Clear(); data.response = ""; data.msg = "保存成功"; } } return(data); }
public async Task <MessageModel <string> > Assign([FromBody] AssignView assignView) { var data = new MessageModel <string>(); try { if (assignView.rid > 0) { data.success = true; var roleModulePermissions = await _roleModulePermissionServices.Query(d => d.RoleId == assignView.rid); var remove = roleModulePermissions.Where(d => !assignView.pids.Contains(d.PermissionId.ObjToInt())).Select(c => (object)c.Id); data.success |= await _roleModulePermissionServices.DeleteByIds(remove.ToArray()); foreach (var item in assignView.pids) { var rmpitem = roleModulePermissions.Where(d => d.PermissionId == item); if (!rmpitem.Any()) { var moduleid = (await _permissionServices.Query(p => p.Id == item)).FirstOrDefault()?.Mid; RoleModulePermission roleModulePermission = new RoleModulePermission() { IsDeleted = false, RoleId = assignView.rid, ModuleId = moduleid.ObjToInt(), PermissionId = item, }; roleModulePermission.CreateId = _user.ID; roleModulePermission.CreateBy = _user.Name; data.success |= (await _roleModulePermissionServices.Add(roleModulePermission)) > 0; } } if (data.success) { data.response = ""; data.msg = "保存成功"; } } } catch (Exception) { data.success = false; } return(data); }
public async Task <MessageModel <ResponseEnum> > Get() { var data = new MessageModel <ResponseEnum>(); var i = 0; var d = 3 / i; var blogArticles = await _blogArticleServices.GetBlogs(); var roleModulePermissions = await _roleModulePermissionServices.QueryMuchTable(); var roleModuleTask = _roleModulePermissionServices.Query(); var listTask = _advertisementServices.Query(); var ad = await roleModuleTask; var list = await listTask; _advertisementServices.ReturnExp(); Love love = null; love.SayLoveU(); return(data); }
public async Task <MessageModel <ResponseEnum> > Get() { var data = new MessageModel <ResponseEnum>(); // 测试模拟异常,全局异常过滤器拦截 var i = 0; var d = 3 / i; // 测试多表联查 var roleModulePermissions = await _roleModulePermissionServices.QueryMuchTable(); // 测试多个异步执行时间 var roleModuleTask = _roleModulePermissionServices.Query(); var listTask = _advertisementServices.Query(); var ad = await roleModuleTask; var list = await listTask; // 测试service层返回异常 _advertisementServices.ReturnExp(); Love love = null; love.SayLoveU(); return(data); }
public async Task <MessageModel <ResponseEnum> > Get() { var data = new MessageModel <ResponseEnum>(); /* * 测试 sql 查询 */ var queryBySql = await _blogArticleServices.QuerySql("SELECT bsubmitter,btitle,bcontent,bCreateTime FROM BlogArticle WHERE bID>5"); /* * 测试按照指定列查询 */ var queryByColums = await _blogArticleServices .Query <BlogViewModels>(it => new BlogViewModels() { btitle = it.btitle }); /* * 测试 sql 更新 * * 【SQL参数】:@bID:5 * @bsubmitter:laozhang619 * @IsDeleted:False * 【SQL语句】:UPDATE `BlogArticle` SET * `bsubmitter`=@bsubmitter,`IsDeleted`=@IsDeleted WHERE `bID`=@bID */ var updateSql = await _blogArticleServices.Update(new { bsubmitter = $"laozhang{DateTime.Now.Millisecond}", IsDeleted = false, bID = 5 }); // 测试模拟异常,全局异常过滤器拦截 var i = 0; var d = 3 / i; // 测试 AOP 缓存 var blogArticles = await _blogArticleServices.GetBlogs(); // 测试多表联查 var roleModulePermissions = await _roleModulePermissionServices.QueryMuchTable(); // 测试多个异步执行时间 var roleModuleTask = _roleModulePermissionServices.Query(); var listTask = _advertisementServices.Query(); var ad = await roleModuleTask; var list = await listTask; // 测试service层返回异常 _advertisementServices.ReturnExp(); return(data); }
public BaseResponse GetNavigationBar(int uid) { if (uid > 0) { var roleId = _userRoleServices.Get(d => d.IsDeleted == false && d.UserId == uid)?.RoleId; if (roleId > 0) { var pids = _roleModulePermissionServices.Query(d => d.IsDeleted == false && d.RoleId == roleId).Select(d => d.PermissionId).Distinct(); if (pids.Any()) { var rolePermissionMoudles = _permissionServices.Query(d => pids.Contains(d.Id) && d.IsButton == false).OrderBy(c => c.OrderSort); var permissionTrees = (from child in rolePermissionMoudles where child.IsDeleted == false orderby child.Id select new NavigationBar { id = child.Id, name = child.Name, pid = (int)child.Pid, order = child.OrderSort, path = child.Code, iconCls = child.Icon, key = child.Key, component = child.Component, isbutton = child.IsButton, meta = new NavigationBarMeta { requireAuth = true, title = child.Name, icon = child.Icon } }).ToList(); NavigationBar rootRoot = new NavigationBar() { id = 0, pid = 0, order = 0, name = "根节点", path = "", iconCls = "", component = "BasicLayout", key = "", meta = new NavigationBarMeta(), }; permissionTrees = permissionTrees.OrderBy(d => d.order).ToList(); RecursionHelper.LoopNaviBarAppendChildren(permissionTrees, rootRoot); List <NavigationBar> list = new List <NavigationBar>(); list.Add(rootRoot); return(new SuccessResponse(list)); } } } return(new SuccessResponse()); }
public async Task <MessageModel <ResponseEnum> > Get() { var data = new MessageModel <ResponseEnum>(); await _redisBasketRepository.ListLeftPushAsync(RedisMqKey.Loging, "xxxxxxxxxxxxxxxxxxx"); /* * 测试 sql 查询 */ var queryBySql = await _blogArticleServices.QuerySql("SELECT bsubmitter,btitle,bcontent,bCreateTime FROM BlogArticle WHERE bID>5"); /* * 测试 sql 更新 * * 【SQL参数】:@bID:5 * @bsubmitter:laozhang619 * @IsDeleted:False * 【SQL语句】:UPDATE `BlogArticle` SET * `bsubmitter`=@bsubmitter,`IsDeleted`=@IsDeleted WHERE `bID`=@bID */ var updateSql = await _blogArticleServices.Update(new { bsubmitter = $"laozhang{DateTime.Now.Millisecond}", IsDeleted = false, bID = 5 }); // 测试模拟异常,全局异常过滤器拦截 var i = 0; var d = 3 / i; // 测试 AOP 缓存 var blogArticles = await _blogArticleServices.GetBlogs(); // 测试多表联查 var roleModulePermissions = await _roleModulePermissionServices.QueryMuchTable(); // 测试多个异步执行时间 var roleModuleTask = _roleModulePermissionServices.Query(); var listTask = _advertisementServices.Query(); var ad = await roleModuleTask; var list = await listTask; // 测试service层返回异常 _advertisementServices.ReturnExp(); Love love = null; love.SayLoveU(); return(data); }
public async Task<ApiResponseModel<NavigationBarDto>> GetNavigationBar(int uid) { var token = _httpContext.HttpContext.Request.Headers["Authorization"].ObjToString().Replace("Bearer ", ""); var id = JwtHelper.SerializeJwt(token)?.Uid; if (id != uid) { return ApiResponse.Error<NavigationBarDto>("参数和token不一样"); } var roleIds = (await _userRoleServices.Query(m => m.IsDeleted == false && m.UserId == id)).Select(m => m.RoleId).Distinct().ToList(); if (!roleIds.Any()) { return ApiResponse.Error<NavigationBarDto>("用户未分配角色"); } var permissionIds = (await _roleModulePermissionServices.Query(d => d.IsDeleted == false && roleIds.Contains(d.RoleId))).Select(m => m.PermissionId).Distinct().ToList(); var permissionList = (await _permissionServices.Query(m => permissionIds.Contains(m.Id) && m.IsDeleted == false)).OrderBy(c => c.OrderSort).ToList(); var permissionTree = permissionList.Select(child => new NavigationBarDto { id = child.Id, name = child.Name, pid = child.Pid, order = child.OrderSort, path = child.Code, iconCls = child.Icon, Func = child.Func, IsHide = child.IsHide.ObjToBool(), IsButton = child.IsButton.ObjToBool(), meta = new NavigationBarMetaDto { requireAuth = true, title = child.Name, NoTabPage = child.IsHide.ObjToBool() } }).ToList(); NavigationBarDto rootRoot = new NavigationBarDto { id = 0, pid = 0, order = 0, name = "根节点", path = "", iconCls = "", meta = new NavigationBarMetaDto(), }; LoopNaviBarAppendChildren(permissionTree, rootRoot); return ApiResponse.Success(rootRoot); }
public async Task <MessageModel <string> > SaveData2TsvAsync() { var data = new MessageModel <string>() { success = true, msg = "" }; if (_env.IsDevelopment()) { JsonSerializerSettings microsoftDateFormatSettings = new JsonSerializerSettings { DateFormatHandling = DateFormatHandling.MicrosoftDateFormat }; // 取出数据,序列化,自己可以处理判空 var rolesJson = JsonConvert.SerializeObject(await _roleServices.Query(d => d.IsDeleted == false), microsoftDateFormatSettings); FileHelper.WriteFile(Path.Combine(_env.WebRootPath, "BlogCore.Data.json", "Role_New.tsv"), rolesJson, Encoding.UTF8); var permissionsJson = JsonConvert.SerializeObject(await _permissionServices.Query(d => d.IsDeleted == false), microsoftDateFormatSettings); FileHelper.WriteFile(Path.Combine(_env.WebRootPath, "BlogCore.Data.json", "Permission_New.tsv"), permissionsJson, Encoding.UTF8); var modulesJson = JsonConvert.SerializeObject(await _moduleServices.Query(d => d.IsDeleted == false), microsoftDateFormatSettings); FileHelper.WriteFile(Path.Combine(_env.WebRootPath, "BlogCore.Data.json", "Modules_New.tsv"), modulesJson, Encoding.UTF8); var rmpsJson = JsonConvert.SerializeObject(await _roleModulePermissionServices.Query(d => d.IsDeleted == false), microsoftDateFormatSettings); FileHelper.WriteFile(Path.Combine(_env.WebRootPath, "BlogCore.Data.json", "RoleModulePermission_New.tsv"), rmpsJson, Encoding.UTF8); data.success = true; data.msg = "生成成功!"; } else { data.success = false; data.msg = "当前不处于开发模式,代码生成不可用!"; } return(data); }
public async Task <MessageModel <ResponseEnum> > Get() { var data = new MessageModel <ResponseEnum>(); var roleModuleTask = _roleModulePermissionServices.Query(); var listTask = _advertisementServices.Query(); var ad = await roleModuleTask; var list = await listTask; _advertisementServices.ReturnExp(); Love love = null; love.SayLoveU(); return(data); }