private async Task <IRoleSearchViewModel> PoulateDropDownListAsync(IRoleSearchViewModel model, CancellationToken cancellationToken) { if (model == null) { model = new RoleSearchViewModel(); } return(model); }
public ActionResult JurisdictionRolePackageSearch(RoleSearchViewModel rolesearch) { //分页获取所有的角色信息 var total = 0; var result = JurisdictionBusiness.SearchRole(rolesearch, out total); var page = new Page(total, rolesearch.CurrentPage); var list = new List <JurisdictionRoleGroupIndexViewModel>(); foreach (var item in result) { var viewModel = new JurisdictionRoleGroupIndexViewModel { GroupId = item.RoleId, GroupName = item.Rolename, GroupCode = item.RoleCode, }; //根据用户id去资源权限分类表查询资源信息 var relationinfo = JurisdictionBusiness.GetUserRoleRelationByGroupId(long.Parse(EncryptHelper.DesDecrypt(item.RoleId.ToString()))); if (relationinfo != null) { foreach (var roloGroup in relationinfo) { var userInfo = HomeBusiness.GetUserById(roloGroup.BURUserId); if (userInfo != null) { viewModel.UserInfo += userInfo.BUName + "(" + userInfo.BUJobNumber + ")" + ","; } } if (viewModel.UserInfo != null && viewModel.UserInfo.Length > 0) { viewModel.UserInfo = viewModel.UserInfo.Substring(0, viewModel.UserInfo.Length - 1); } } list.Add(viewModel); } var resultModel = new JurisdictionRoleGroupSearchModel() { Models = list, Page = page }; return(View(resultModel)); }
public List <RoleView> SearchRole(RoleSearchViewModel search, out int totalCount) { var list = new List <RoleView>(); var sql = new StringBuilder(); var countSql = new StringBuilder(); var whereSql = new StringBuilder(); whereSql.Append(" WHERE 1=1 "); if (!string.IsNullOrEmpty(search.GroupName)) { whereSql.Append(string.Format(" AND BGName LIKE '%{0}%'", search.GroupName)); } sql.Append(string.Format(@" SELECT newTable.* FROM ( SELECT TOP ( {0} * {1} ) ROW_NUMBER() OVER (ORDER BY Id DESC) RowNum ,Id AS RoleId ,BGCode AS RoleCode ,BGName AS Rolename FROM {2} WITH(NOLOCK) {3} Order BY Id DESC ) newTable WHERE newTable.RowNum>(({0}-1)*{1}) ", search.CurrentPage, search.PageSize, tableName, whereSql.ToString())); countSql.Append(string.Format(@"SELECT COUNT(1) FROM {0} WITH(NOLOCK) {1} ", tableName, whereSql.ToString())); var ds = ExecuteDataSet(CommandType.Text, sql.ToString()); totalCount = ExecuteCount(CommandType.Text, countSql.ToString()); if (ds != null && ds.Tables.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; list = DataConvertHelper.DataTableToList <RoleView>(dt); } return(list); }
public async Task <IActionResult> Index(RoleSearchViewModel viewModel) { // check roles var token = HttpContext.Session.GetString("Token"); var id = new Guid(HttpContext.Session.GetString("UserId")); var roles = await _manageRole.GetRoleByUserId(token, id); var rolosAccess = roles.data.Any(x => x.RoleName == CommonController.VIEW); if (rolosAccess == false) { return(Redirect("/Role/AccessDenied")); } ; // end check roles var rs = await _manageRole.GetAllRole(token); ViewBag.Data = rs.data; ViewBag.statusMessage = TempData["Result"]; return(View()); }