public IActionResult List(UserRequestPayload payload)
{
using (_dbContext)
{
var query = _dbContext.DncUser.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.DisplayName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > UserStatus.All)
{
query = query.Where(x => x.Status == payload.Status);
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <DncUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(data, totalCount);
return(Ok(response));
}
}
public IActionResult List(UserRequestPayload payload)
{
using (_dbContext)
{
IQueryable <DncUser> query = _dbContext.DncUser.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.DisplayName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > UserStatus.All)
{
query = query.Where(x => x.Status == payload.Status);
}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
System.Collections.Generic.List <DncUser> list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
int totalCount = query.Count();
System.Collections.Generic.IEnumerable <UserJsonModel> data = list.Select(_mapper.Map <DncUser, UserJsonModel>);
ResponseResultModel response = ResponseModelFactory.CreateResultInstance;
response.SetData(data, totalCount);
return(Ok(response));
}
}
public IActionResult List(UserRequestPayload payload)
{
using (_dbContext)
{
var query = from u in _dbContext.SystemUser
join d in _dbContext.Department
on u.DepartmentUuid equals d.DepartmentUuid
join ro in _dbContext.SystemRole
on u.SystemRoleUuid equals ro.SystemRoleUuid.ToString()
select new
{
SystemUserUuid = u.SystemUserUuid,
LoginName = u.LoginName,
RealName = u.RealName,
UserIdCard = u.UserIdCard,
DepartmentName = d.Name,
SystemRoleUuid = u.SystemRoleUuid,
SystemRoleName = ro.RoleName,
AddTime = u.AddTime,
AddPeople = u.AddPeople,
UserType = u.UserType,
IsDeleted = u.IsDeleted,
Id = u.Id
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
//if (payload.Status > UserStatus.All)
//{
// query = query.Where(x => x.Status == payload.Status);
//}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:系统用户信息数据", _dbContext);
return(Ok(response));
}
}
public IActionResult List(UserRequestPayload payload)
{
using (_dbContext)
{
var roles = _dbContext.SystemRole.Where(x => x.IsDeleted == 0).ToList();
var query = from u in _dbContext.SystemUser
where u.UserType != 5
select new
{
SystemUserUuid = u.SystemUserUuid,
LoginName = u.LoginName,
RealName = u.RealName,
UserIdCard = u.UserIdCard,
AddTime = u.AddTime,
AddPeople = u.AddPeople,
UserType = GetRoleName(u.SystemRoleUuid, roles),
IsDeleted = u.IsDeleted,
u.OldCard,
Id = u.Id
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
//if (payload.Status > UserStatus.All)
//{
// query = query.Where(x => x.Status == payload.Status);
//}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(UserRequestPayload payload)
{
using (_dbContext)
{
var roles = _dbContext.SystemRole.Where(x => x.IsDeleted == 0).ToList();
var query = from u in _dbContext.SystemUser
select new
{
SystemUserUuid = u.SystemUserUuid,
LoginName = u.LoginName,
RealName = u.RealName,
UserIdCard = u.UserIdCard,
AddTime = u.AddTime,
AddPeople = u.AddPeople,
UserType = GetRoleName(u.SystemRoleUuid, roles),
IsDeleted = u.IsDeleted,
SchoolUUID = u.SchoolUuid,
SchoolName = u.SchoolUu.SchoolName,
Type = u.UserType,
//u.OldCard,
_disabled = IsDisabled(u.IsCreEdu.Value, u.UserType),
Id = u.Id,
u.IsUploadVideo,
u.IsUploadPicture,
u.IsAddPrecord,
u.Phone,
u.IsFlow,
};
if (payload.UserType == 0 && AuthContextService.CurrentUser.SchoolGuid != null)
{
query = query.Where(x => x.Type != 5 && x.SchoolUUID == AuthContextService.CurrentUser.SchoolGuid);
}
if (payload.UserType == 0 && AuthContextService.CurrentUser.SchoolGuid == null)
{
query = query.Where(x => x.Type != 5);
}
if (payload.UserType == 1)
{
query = query.Where(x => x.Type == 5);
}
if ((!string.IsNullOrEmpty(payload.Phone.Trim())) && payload.UserType == 1)
{
query = query.Where(x => x.Phone.Contains(payload.Phone));
}
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
//if (payload.Status > UserStatus.All)
//{
// query = query.Where(x => x.Status == payload.Status);
//}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
