/// <summary> /// 获取角色列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult GetRoleList(RoleSearch model) { int totalCount = 0; var whereLambda = PredicateBuilder.True <Role>(); Expression <Func <Role, DateTime> > orderLambda = d => d.UpdateTime; if (!string.IsNullOrEmpty(model.Name)) { whereLambda = whereLambda.AndAlso(d => d.RoleName.Contains(model.Name)); } var roles = new RoleBLL().Get(orderLambda, whereLambda, model.Order, model.Rows, model.Page, out totalCount); var roleList = roles.Select(d => new RoleList { Id = d.Id, Name = d.RoleName, UpdateTime = d.UpdateTime, UpdateBy = d.UpdateBy, Description = d.Description }).ToList(); var result = new DataResult <RoleList> { total = totalCount, rows = roleList }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public IEnumerable <RoleGetDto> Execute(RoleSearch search) { var query = context.Roles.AsQueryable(); if (!string.IsNullOrEmpty(search.Name) || !string.IsNullOrWhiteSpace(search.Name)) { query = query.Where(x => x.Name.ToLower().Contains(search.Name.ToLower())); } //var skipCount = search.PerPage * (search.Page - 1); //var response = new PageResponse<RoleDto> //{ // CurrentPage = search.Page, // ItemsPerPage = search.PerPage, // TotalCount = query.Count(), // Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new RoleDto // { // Id = x.Id, // Name = x.Name // }).ToList() //}; //return response; return(_mapper.Map <IEnumerable <RoleGetDto> >(query)); //return query.Paged(search, x => new RoleDto //{ // Id = x.Id, // Name = x.Name //}); }
public PagedResponse <RoleDto> Execute(RoleSearch search) { var query = _context.Roles.AsQueryable(); if (!string.IsNullOrEmpty(search.RoleName) || !string.IsNullOrWhiteSpace(search.RoleName)) { query = query.Where(x => x.RoleName.ToLower().Contains(search.RoleName.ToLower())); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <RoleDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new RoleDto { Id = x.Id, RoleName = x.RoleName }).ToList() }; return(response); }
public PagedResponse <RoleDto> Execute(RoleSearch request) { var query = Context.Roles.AsQueryable(); if (request.Name != null) { query = query.Where(r => r.Name.ToLower().Contains(request.Name.ToLower())); } if (request.PageNumber != 0) { query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage); } var totalCount = query.Count(); var pagesCount = (int)System.Math.Ceiling((double)totalCount / request.PerPage); return(new PagedResponse <RoleDto> { TotalCount = totalCount, PagesCount = pagesCount, CurrentPage = request.PageNumber, Data = query.Select(r => new RoleDto { Id = r.Id, Name = r.Name, Users = r.Users.Select(u => u.FirstName + " " + u.LastName) }) }); }
// GET: Roles public ActionResult Index([FromQuery] RoleSearch roleSearch) { roleSearch.PageNumber = 0; var roles = _searchRolesCommand.Execute(roleSearch); return(View(roles.Data)); }
public IEnumerable <RoleResponseDTO> Execute(RoleSearch request) { var query = AiContext.Roles.AsQueryable() .Where(x => x.IsDeleted == 0); var keyword = request.Keyword; if (keyword != null) { query = query .Where(r => r.Name.ToLower().Contains(keyword.ToLower())); } return(query .Include(r => r.Users) .Select(r => new RoleResponseDTO { Id = r.Id, Name = r.Name, Users = AiContext.Users .Where(u => u.IsDeleted == 0) .Where(u => u.RoleId == r.Id) .Select(u => new UserResponseDTO { Id = u.Id, FirstName = u.FirstName, LastName = u.LastName, Username = u.Username, RoleId = u.RoleId, RoleName = u.Role.Name }) })); }
public IActionResult Get( [FromQuery] RoleSearch search, [FromServices] IGetRolesQuery query) { var result = _executor.ExecuteQuery(query, search); return(Ok(result)); }
public PagedResponse <RoleDto> Execute(RoleSearch search) { var query = context.Roles.AsQueryable(); if (!string.IsNullOrEmpty(search.RoleName) || !string.IsNullOrWhiteSpace(search.RoleName)) { query = query.Where(x => x.RoleName.ToLower().Contains(search.RoleName.ToLower())); } return(query.Paged <RoleDto, Domain.Roles>(search, _mapper)); }
public PagedResponse <RoleDto, Role> Execute(RoleSearch search) { var query = _context.Roles.Include(r => r.RoleUseCases).ThenInclude(r => r.UseCase).AsQueryable(); if (!string.IsNullOrEmpty(search.Name) && !string.IsNullOrWhiteSpace(search.Name)) { query = query.Where(r => r.Name.ToLower().Contains(search.Name.ToLower())); } return(new PagedResponse <RoleDto, Role>(query, search, _mapper)); }
public ActionResult <PagedResponse <RoleDto> > Get([FromQuery] RoleSearch roleSearch) { try { var roles = this.getRolesCommand.Execute(roleSearch); return(Ok(roles)); } catch (Exception) { return(StatusCode(500)); } }
public ActionResult Index(RoleSearch search, int pageIndex) { var roles = _roleAppService.GetAllList(search.KeyWord, search.TimeMin, search.TimeMax); PagedList <RoleDto> model = roles.OrderBy(a => a.Id).ToPagedList(pageIndex, search.pageSize); if (Request.Headers["X-Requested-With"] == "XMLHttpRequest") { return(PartialView("List", model)); } ViewBag.Title = "角色管理"; return(View(model)); }
public IActionResult Get([FromQuery] RoleSearch dto) { try { var roles = _getCommand.Execute(dto); return(Ok(roles)); } catch (Exception) { return(StatusCode(500, "An error occured")); } }
public async Task <IEnumerable <TRoleDto> > Search(RoleSearch searchModel) { var rolesQuery = roleManager.Roles; if (string.IsNullOrEmpty(searchModel.Name)) { rolesQuery = rolesQuery.Where(x => x.NormalizedName == searchModel.Name.ToUpperInvariant()); } var roles = await rolesQuery.ToListAsync(); return(mapper.Map <IEnumerable <TRoleDto> >(roles)); }
public void Delete(RoleSearch request) { var matches = Get(request) as List <Role>; if (true != matches?.Any()) { throw new HttpError(HttpStatusCode.NotFound, "No matches for request"); } matches.ForEach(match => { Delete(match); }); }
public IHttpActionResult Search([FromUri] RoleSearchFilter filter) { ThrowIfUserHasNoRole(readRole); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var roleSearch = new RoleSearch(Db)) { var data = roleSearch.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }
public JsonResult List(RoleSearch search, FormCollection form) { PageView view = new PageView(form); if (search == null) { search = new RoleSearch(); } search.ORG_ID = base.CurrentUserOrgId; string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; PagedList<SYS_ROLE> pList = _cservice.QueryRoleList(search, view); JsonQTable fdata = JsonQTable.ConvertFromPagedList<SYS_ROLE>(pList, colkey, colsinfo.Split(',')); return Json(fdata); }
public string FanDemo(int index) { DataSet ds = new DataSet(); WeiPage w = new WeiPage(); List <FansList_Ex> list = sbo.QueryFansListByBuy(); RoleSearch search = new RoleSearch(); PageView view = new PageView(); view.PageIndex = index; view.PageSize = 10; PagedList <CUST_INFO> list_cust = sbo.QueryCustList(search, view); //foreach (var item in list_cust.DataList) //{ // if (!string.IsNullOrEmpty(item.MOBILE)) // { // try // { // Z_LOY_BP_GETDETAILResponse zloy = w.SelectMemberByUpdate(item.MOBILE); // int code = 0; // if (zloy.T_ADDRESSDATA.Length > 0) // { // if (zloy.T_ADDRESSDATA[0].CITY!="") // { // code = int.Parse(zloy.T_ADDRESSDATA[0].CITY); // } // } // City c = mss.GetCityByCode(code); // CUST_INFO cust = mss.GetCust(item.FROM_USER_NAME); // cust.CustLevel = zloy.E_LEVEL; // cust.CustCity = c == null ? "" : c.CityName; // mss.UpdateCustInfoS(cust); // } // catch (Exception e) // { // continue; // } // } //} ds.Tables.Add(ToDataTable(list)); NewNPOI.ExportDataTableToExcel(ds.Tables[0], "test1.xls", "test1"); return((index + 1).ToString() + "_" + list_cust.Total); }
public PagedList <SYS_ROLE> QueryRoleList(RoleSearch search, PageView view) { string cols = @" * "; string sqlWhere = " AND ORG_ID=" + search.ORG_ID + " AND ROLE_TYPE<>0"; if (!string.IsNullOrEmpty(search.ROLE_NAMES)) { sqlWhere += " AND A.[ROLE_NAME] LIKE '%" + search.ROLE_NAMES + "%'"; } return(base.PageGet <SYS_ROLE>(view, cols, "[SYS_ROLE] A " //table , sqlWhere , "A.ROLE_ID DESC", "")); }
public ActionResult Get([FromQuery] RoleSearch rs) { try { var getRolles = _getRoles.Execute(rs); return(Ok(getRolles)); } catch (EntityNotFoundException e) { return(NotFound(e.Message)); } catch (Exception) { return(StatusCode(500, "An error occured.Please try again later.")); } }
public JsonResult GetBookingList(RoleSearch search, FormCollection form) { PageView view = new PageView(form); if (search == null) { search = new RoleSearch(); } search.ORG_ID = base.CurrentLoginUser.ID; string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; PagedList <WD_BOOKING> pList = _spservice.GetBookingListByMid(CurrentMerchants.ID, view); JsonQTable fdata = JsonQTable.ConvertFromPagedList <WD_BOOKING>(pList, colkey, colsinfo.Split(',')); return(Json(fdata)); }
public IHttpActionResult Search([FromUri] RoleSearchFilter filter) { string accessType = "Role_ViewAll"; ThrowIfUserCannotAccess(accessType); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var roleSearch = new RoleSearch(Db)) { var data = roleSearch.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }
public PagedResponse <RoleDto> Execute(RoleSearch request) { var query = this.Context.Roles .Where(r => !r.IsDeleted) .AsQueryable(); if (request.Name != null) { query = query.Where( r => r.Name.ToLower() .Contains(request.Name.ToLower())); } if (request.IsActive != null) { query = query.Where( r => r.IsActive == request.IsActive); } int totalCount = query.Count(); // number of pages/buttons int numberOfPages = (int)Math.Ceiling((double)totalCount / request.PerPage); query = query.Skip(request.PageNumber * request.PerPage - request.PerPage).Take(request.PerPage); // second way .Skip((request.PageNumber - 1)* request.PerPage).Take(request.PerPage); var result = new PagedResponse <RoleDto> { TotalNumber = totalCount, PagesNumber = numberOfPages, CurrentPage = request.PageNumber, Data = query.Select(r => new RoleDto { Id = r.Id, Name = r.Name, IsActive = r.IsActive }) }; return(result); }
public async Task <Pagination <AdminRole> > Search(RoleSearch search, Pager page) { Expression <Func <AdminRole, bool> > predicate = x => true; if (!string.IsNullOrWhiteSpace(search.RoleName)) { predicate = predicate.And(x => x.Name.Contains(search.RoleName.Trim())); } var total = await _roleRepository.CountAsync(predicate); var data = await _roleRepository.Query(predicate) .OrderByDescending(x => x.Id) .Offset(page.Offset) .Take(page.Limit) .ToListAsync(); var ret = new Pagination <AdminRole>(total, data, page); return(ret); }
public IEnumerable <GetRolesDto> Execute(RoleSearch request) { var query = _context.Roles.Where(r => r.IsDeleted == false).AsQueryable(); if (request.RoleName != null) { if (!query.Any(r => r.RoleName.ToLower().Contains(request.RoleName.ToLower()))) { throw new EntityNotFoundException("Role"); } query = query.Where(r => r.RoleName.ToLower().Contains(request.RoleName.ToLower())); } return(query.Select(r => new GetRolesDto { Id = r.Id, RoleName = r.RoleName, CreatedOn = r.CreatedOn, ModifiedOn = r.ModifiedOn })); }
public PagedResponse <RoleDto> Execute(RoleSearch request) { var query = Context.Roles.AsQueryable(); if (request.Name != null) { query = query.Where(r => r.Name.ToLower().Contains(request.Name.ToLower())); } if (request.Active.HasValue) { query = query.Where(c => c.IsDeleted != request.Active); } else { query = query.Where(c => c.IsDeleted == false); } var totalCount = query.Count(); query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage); var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage); var response = new PagedResponse <RoleDto> { CurrentPage = request.PageNumber, TotalCount = totalCount, PagesCount = pagesCount, Data = query.Select(r => new RoleDto { Id = r.Id, Name = r.Name, }) }; return(response); }
public IEnumerable <RoleDTO> Execute(RoleSearch request) { var data = Context.Roles.AsQueryable(); if (request.RoleName != null) { var name = request.RoleName; data = data.Where(r => r.RoleName.ToLower().Contains(name) && r.Deleted == false); } if (request.OnlyActive.HasValue) { data = data.Where(r => r.Deleted != request.OnlyActive); } return(data.Include(u => u.Users).Select(d => new RoleDTO { Id = d.Id, RoleName = d.RoleName, Users = d.Users.Select(u => u.Username) })); }
public IEnumerable <RoleDto> Execute(RoleSearch request) { var query = Context.Roles.AsQueryable(); if (request.Name != null) { query = query.Where(c => c.Name .ToLower() .Contains(request.Name.ToLower())); } if (request.OnlyActive.HasValue) { query = query.Where(c => c.isDeleted != request.OnlyActive); } return(query.Select(c => new RoleDto { Id = c.Id, Name = c.Name })); }
public IEnumerable <GetRoleDto> Execute(RoleSearch request) { var query = context.Roles.AsQueryable(); if (request.Name != null) { query = query.Where(x => x.Name .ToLower() .Contains(request.Name.ToLower())); } if (request.OnlyActive.HasValue) { if (request.OnlyActive == true) { query = query.Where(x => x.DeletedAt == null); } } query = query.SkipItems(request.Page, request.ItemsPerPage); return(query.Select(x => _mapper.Map <Role, GetRoleDto>(x)).ToList()); }
public PageResult <ColorModel> GetSearchPaging(RoleSearch search) { var query = _colorRepository.FindAll(); if (search.Id > 0) { query = query.Where(r => r.Id == search.Id); } if (!string.IsNullOrEmpty(search.Name)) { query = query.Where(r => r.Name.Contains(search.Name)); } //if (!string.IsNullOrEmpty(search.Description)) //{ // query = query.Where(r => r.Description.Contains(search.Description)); //} var Total = query.Count(); var data = query .OrderByDescending(U => U.CreatedDate) .Skip((search.PageIndex - 1) * search.PageSize) .Take(search.PageSize) .Select(u => u.ToModel()) .ToList(); var result = new PageResult <ColorModel>() { Results = data, PageIndex = search.PageIndex, PageSize = search.PageSize, Total = Total, }; return(result); }
public Task <IdentityUtilsResult <TRoleDto> > Search(RoleSearch search) => restClient.Post <IdentityUtilsResult <TRoleDto> >($"{BasePath}/search", search).ParseRestResultTask();