public List <Station_Info> SearchRoleInfoByWhere(UserRoleSearchViewModel userRoleSearchViewModel)
{
int SkipNum = userRoleSearchViewModel.pageViewModel.CurrentPageNum * userRoleSearchViewModel.pageViewModel.PageSize;
var preciate = SearchRoleWhere(userRoleSearchViewModel);
return(DbSet.Where(preciate).Skip(SkipNum)
.Take(userRoleSearchViewModel.pageViewModel.PageSize).ToList());
}
//用户搜索条件
private Expression <Func <User_Role, bool> > SearchUserRoleWhere(UserRoleSearchViewModel userRoleSearchViewModel)
{
var predicate = WhereExtension.True <User_Role>();//初始化where表达式
predicate = predicate.And(p => p.RoleName.Contains(userRoleSearchViewModel.RoleName));
predicate = predicate.And(p => p.Status.Contains(userRoleSearchViewModel.Status));
predicate = predicate.And(p => p.RoleType.Contains(userRoleSearchViewModel.RoleType));
return(predicate);
}
private Expression <Func <Station_Info, bool> > SearchRoleWhere(UserRoleSearchViewModel userRoleSearchViewModel)
{
var predicate = WhereExtension.True <Station_Info>();//初始化where表达式
predicate = predicate.And(p => p.StaffCode.Contains(userRoleSearchViewModel.StaffCode));
predicate = predicate.And(p => p.StaffName.Contains(userRoleSearchViewModel.StaffName));
// predicate = predicate.And(p => p.Createdate.ToString().Contains(healthEverySearchViewModel.Createdate == null ? "" : healthEverySearchViewModel.Createdate.Value.ToString("yyyy-MM-dd")));
// predicate = predicate.And(p => p.Id==lineSearchViewModel.Id);
return(predicate);
}
public List <User_Role> SearchRoleInfoByWhere(UserRoleSearchViewModel userRoleSearchViewModel)
{
int skipNum = userRoleSearchViewModel.pageViewModel.CurrentPageNum * userRoleSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchUserRoleWhere(userRoleSearchViewModel);
return(DbSet.Where(predicate).OrderBy(o => o.Createdate)
.Skip(skipNum)
.Take(userRoleSearchViewModel.pageViewModel.PageSize)
.ToList());
}
//角色查询
public List <UserRoleSearChMiddles> User_Role_Search(UserRoleSearchViewModel userRoleSearchViewModel)
{
List <User_Role> user_Roles = _IUserRoleRepository.SearchRoleInfoByWhere(userRoleSearchViewModel);
List <UserRoleSearChMiddles> userRoleSearchList = new List <UserRoleSearChMiddles>();
foreach (var item in user_Roles)
{
var userRoleSearChMiddles = _IMapper.Map <User_Role, UserRoleSearChMiddles>(item);
userRoleSearchList.Add(userRoleSearChMiddles);
}
return(userRoleSearchList);
}
public ActionResult <UserRoleSearchResModel> Manage_UserRole_Search(UserRoleSearchViewModel userRoleSearchViewModel)
{
UserRoleSearchResModel userRoleSearchResModel = new UserRoleSearchResModel();
var UserRoleSearchResult = _roleService.User_Role_Search(userRoleSearchViewModel);
var TotalNum = _roleService.Role_Get_ALLNum(userRoleSearchViewModel);
userRoleSearchResModel.userRoles = UserRoleSearchResult;
userRoleSearchResModel.isSuccess = true;
userRoleSearchResModel.baseViewModel.Message = "查询成功";
userRoleSearchResModel.baseViewModel.ResponseCode = 200;
userRoleSearchResModel.TotalNum = TotalNum;
_ILogger.Information("角色查询成功");
return(Ok(userRoleSearchResModel));
}
//获取所有角色
public int Role_Get_ALLNum(UserRoleSearchViewModel userRoleSearchViewModel)
{
return(_IUserRoleRepository.GetRoleAll(userRoleSearchViewModel).Count());
}
/// <summary>
/// 获得角色数量
/// </summary>
/// <param name="userRoleSearchViewModel"></param>
/// <returns></returns>
public IQueryable <User_Role> GetRoleAll(UserRoleSearchViewModel userRoleSearchViewModel)
{
var predicate = SearchUserRoleWhere(userRoleSearchViewModel);
return(DbSet.Where(predicate));
}
