List(DepartmentRequestPaload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
await using (_dbContext)
{
var query = _dbContext.UserDepartment.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.Code.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > CommonEnum.Status.All)
{
query = query.Where(x => x.Status == payload.Status);
}
var list = await query.Paged(payload.CurrentPage, payload.PageSize).
OrderBy(r => r.SortID).ToListAsync();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <UserDepartment, DepartmentJsonModel>);
response.SetData(data, totalCount);
return(Ok(response));
}
}
public IActionResult List(DepartmentRequestPaload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.Department.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Name.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "ASC");
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<Department, DepartmentJsonViewModel>);
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:部门信息数据", _dbContext);
return(Ok(response));
}
//var response = ResponseModelFactory.CreateResultInstance;
//using (_dbContext)
//{
// var query = from a in _dbContext.Department
// where a.IsDeleted == 0
// select new
// {
// DepartmentUuid = a.DepartmentUuid,
// Id = a.Id,
// Name = a.Name,
// Remark = a.Remark,
// EstablishName = a.EstablishName,
// EstablishTime = a.EstablishTime,
// IsDeleted = a.IsDeleted,
// };
// if (!string.IsNullOrEmpty(payload.Kw))
// {
// query = query.Where(x => x.Name.Contains(payload.Kw.Trim()));
// }
// 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();
// response.SetData(list, totalCount);
// return Ok(response);
//}
}
public IActionResult List(DepartmentRequestPaload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.Department.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.DepartmentName.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <Department, DepartmentJsonViewModel>);
response.SetData(data, totalCount);
return(Ok(response));
}
}
