public async Task<IActionResult> Index(PaginationRequestViewModel paginationRequestViewModel)
{
var pagedTenantsViewModel = PagedResultsViewModel<TenantViewModel>.InitEmpty();
try
{
paginationRequestViewModel.PageSize ??= HttpContext.TryGetPageSizeFromCookie();
var pagination = _mapper.Map<Pagination>(paginationRequestViewModel);
var pagedTenants = await _internalApiClient.GetTenants(pagination);
pagedTenantsViewModel = _mapper.Map<PagedResultsViewModel<TenantViewModel>>(pagedTenants);
_mapper.Map(pagination, pagedTenantsViewModel);
}
catch (BasicWebAppException ex)
{
ExceptionProcessor.ProcessError(LoggingEvents.ReadItemsFailed, _logger, HttpContext, ex);
}
return View(pagedTenantsViewModel);
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Department> > > GetDepartmentList([FromBody] PaginationRequestViewModel pagination)
{
return(_department.GetDepartmentList(pagination));
}
/// <summary>
/// 基于用户id获取请假表
/// </summary>
/// <returns></returns>
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > > GetLeavesById(PaginationRequestViewModel pagination, string id)
{
var data = db.Leave.Where(x => x.UserId == id);
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > >
{
code = (int)codes.Success,
data = new PaginationResponeViewModel <IEnumerable <Leave> >
{
list = data.OrderByDescending(x => x.LeaveTime).Skip(pagination.page).Take(pagination.limit),
total = data.Count()
}
});
}
/// <summary>
/// 获取请假审批表
/// </summary>
/// <returns></returns>
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > > GetCheckLeaves(PaginationRequestViewModel pagination)
{
var data = db.Leave.Where(x => x.LeaveState == 3);
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > >
{
code = (int)codes.Success,
data = new PaginationResponeViewModel <IEnumerable <Leave> >
{
list = data.Skip(pagination.page).Take(pagination.limit),
total = data.Count()
}
});
}
/// <summary>
/// 获取请假表
/// </summary>
/// <returns></returns>
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > > GetLeaves(PaginationRequestViewModel pagination)
{
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > >
{
code = (int)codes.Success,
data = new PaginationResponeViewModel <IEnumerable <Leave> >
{
list = db.Leave.OrderByDescending(x => x.LeaveTime).Skip(pagination.page).Take(pagination.limit),
total = db.Leave.Count()
}
});
}
/// <summary>
/// 获取同事列表
/// </summary>
/// <param name="pagination"></param>
/// <returns></returns>
public PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > getColleaguesList(PaginationRequestViewModel pagination)
{
return(new PaginationResponeViewModel <IEnumerable <UserInfoViewModel> >()
{
list = db.AspNetUsers.Skip(pagination.page).Take(pagination.limit).Select(userInfo => new UserInfoViewModel
{
RealName = userInfo.RealName,
Birthday = userInfo.Birthday,
Sex = userInfo.Sex,
PhoneNumber = userInfo.PhoneNumber,
Salary = userInfo.Salary,
Address = userInfo.Address,
JoinTime = userInfo.JoinTime,
}),
total = db.AspNetUsers.Count()
});
}
/// <summary>
/// 查询同事
/// </summary>
/// <param name="pagination"></param>
/// <returns></returns>
public PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > findColleagueByName(PaginationRequestViewModel <string> pagination)
{
var data = db.AspNetUsers.Where(x => x.RealName.Contains(pagination.data))
.Select(userInfo => new UserInfoViewModel
{
Id = userInfo.Id,
RealName = userInfo.RealName,
Birthday = userInfo.Birthday,
Sex = userInfo.Sex,
PhoneNumber = userInfo.PhoneNumber,
Salary = userInfo.Salary,
Address = userInfo.Address,
JoinTime = userInfo.JoinTime,
Introduction = userInfo.Introduction
});
return(new PaginationResponeViewModel <IEnumerable <UserInfoViewModel> >()
{
total = data.Count(),
list = data.Skip(pagination.page).Take(pagination.limit),
});
}
/// <summary>
/// 排序搜索获取员工列表
/// </summary>
/// <param name="pagination"></param>
/// <returns></returns>
public PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > getStaffListByOrder(PaginationRequestViewModel <OrderPropKeywordViewModel> pagination)
{
var staffs = db.AspNetUsers.Select(x => x);
//排序
switch (pagination.data.Prop + "_" + pagination.data.Order)
{
case "id_descending":
staffs = staffs.OrderByDescending(s => s.Id);
break;
case "departmentId_descending":
staffs = staffs.OrderByDescending(s => s.DepartmentId);
break;
case "salary_descending":
staffs = staffs.OrderByDescending(s => s.Salary);
break;
}
if (!string.IsNullOrEmpty(pagination.data.keyword))
{
//搜索
switch (pagination.data.select)
{
case "id":
staffs = staffs.Where(x => x.Id.Contains(pagination.data.keyword));
break;
case "realName":
staffs = staffs.Where(x => x.RealName.Contains(pagination.data.keyword));
break;
case "departmentId":
var id = db.Department.Where(y => y.DepartmentName.Contains(pagination.data.keyword)).FirstOrDefault();
staffs = staffs.Where(x => x.DepartmentId == (id == null ? 0 : id.DepartmentId));
break;
}
}
return(new PaginationResponeViewModel <IEnumerable <UserInfoViewModel> >()
{
list = staffs.Skip(pagination.page).Take(pagination.limit).Select(userInfo => new UserInfoViewModel
{
RealName = userInfo.RealName,
Birthday = userInfo.Birthday,
Sex = userInfo.Sex,
PhoneNumber = userInfo.PhoneNumber,
Salary = userInfo.Salary,
Address = userInfo.Address,
JoinTime = userInfo.JoinTime,
Id = userInfo.Id,
DepartmentId = userInfo.DepartmentId,
Introduction = userInfo.Introduction
}),
total = staffs.Count()
});
}
/// <summary>
/// 获取部门列表
/// </summary>
/// <param name="pagination"></param>
/// <returns></returns>
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Department> > > GetDepartmentList(PaginationRequestViewModel pagination)
{
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <Department> > >()
{
data = new PaginationResponeViewModel <IEnumerable <Department> >()
{
list = db.Department.Skip(pagination.page).Take(pagination.limit),
total = db.Department.Count(),
},
code = (int)codes.Success,
});
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > > GetLeaves([FromBody] PaginationRequestViewModel pagination)
{
return(_leave.GetLeaves(pagination));
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <Leave> > > GetLeavesById([FromBody] PaginationRequestViewModel pagination)
{
return(_leave.GetLeavesById(pagination, GetIdByToken()));
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > > GetStaffListByOrder([FromBody] PaginationRequestViewModel <OrderPropKeywordViewModel> pagination)
{
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > >()
{
code = (int)codes.Success,
data = _aspNetUsers.getStaffListByOrder(pagination),
});
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > > FindColleagueByName([FromBody] PaginationRequestViewModel <string> pagination)
{
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > >()
{
code = (int)codes.Success,
data = _aspNetUsers.findColleagueByName(pagination),
});
}
public ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > > GetColleaguesList([FromBody] PaginationRequestViewModel pagination)
{
return(new ReturnViewModel <PaginationResponeViewModel <IEnumerable <UserInfoViewModel> > >()
{
code = (int)codes.Success,
data = _aspNetUsers.getColleaguesList(pagination),
});
}
