/// <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();
