public ActionResult GetBoundUserDataList(string userName = "", int demartment = 0, int ibound = 1, int courseID = 0, int pIndex = 1)
{
var a = CourseID;
var userIds = new List <int>();
int courseIDC = CourseID == 0 ? courseID : CourseID;
if (courseIDC > 0)
{
userIds = courseBoundService.GetCourseBoundUserId(courseIDC);
}
ViewBag.pageName = "GetBoundUserDataList";
var input = new GetUserAccountInput()
{
Username = userName,
DepartmentId = demartment,
Isbound = ibound,
UserIds = userIds,
SkipCount = (pIndex - 1) * PageSize, MaxResultCount = PageSize
};
var pagedata = userAccountService.GetPagedUserAccountsUD(input);
GetPageData(pagedata.Count());
return(PartialView("Shared/BoundUserDataList", pagedata.Skip((pIndex - 1) * PageSize).Take(PageSize)));
}
public JsonResult GetPagedUserAccounts(GetUserAccountInput input)
{
try
{
var list = _userAccountService.GetPagedUserAccounts(input);
return(Json(list, JsonRequestBehavior.AllowGet));
}
catch (Exception) {
return(new JsonResult());
}
}
// 课程管理分页信息
public ActionResult GetAccountUserDataList(string name = "", int departmentId = 0, int jobPostId = 0, int pIndex = 1)
{
ViewBag.pageName = "GetAccountUserDataList";
var input = new GetUserAccountInput()
{
Username = name,
DepartmentId = departmentId,
jobId = jobPostId,
SkipCount = (pIndex - 1) * PageSize, MaxResultCount = PageSize
};
var pagedata = _userAccountService.GetPagedUserAccountsUD(input);
GetPageData(pagedata.Count());
return(PartialView("Shared/AccountUserDataList", pagedata.Skip((pIndex - 1) * PageSize).Take(PageSize)));
}
/// <summary>
/// 根据查询条件获取用户账号信息分页列表
/// </summary>
public PagedResultDto <UserAccountListDto> GetPagedUserAccounts(GetUserAccountInput input)
{
var query = from user in _userAccountRepository.GetAll()
join de in _departmentRepository.GetAll() on user.DepartmentID equals de.DepartmentId into gc
from gci in gc.DefaultIfEmpty()
join job in _jobPostRepository.GetAll() on user.PostID equals job.Id into jc
from jci in jc.DefaultIfEmpty()
select new UserAccountListDto
{
Id = user.Id,
SysNO = user.SysNO,
LoginName = user.LoginName,
DisplayName = user.DisplayName,
DepartmentID = user.DepartmentID,
DepartmentName = gci.DisplayName,
province = user.province,
ProvinceID = user.ProvinceID,
City = user.City,
CityID = user.CityID,
Area = user.Area,
AreaID = user.AreaID,
DetailedAddress = user.DetailedAddress,
PostID = user.PostID,
PostName = jci.Name,
PhoneNumber = user.PhoneNumber,
Email = user.Email,
Status = user.Status,
CreationTime = user.CreationTime
};
IQueryable <UserAccountListDto> userAccountList = query;
//TODO:根据传入的参数添加过滤条件
if (!string.IsNullOrEmpty(input.Username))
{
userAccountList = userAccountList.Where(c => c.DisplayName.Contains(input.Username));
}
if (input.DepartmentId > 0)
{
userAccountList = userAccountList.Where(c => c.DepartmentID == input.DepartmentId);
}
if (input.Isbound != 0)
{
if (input.Isbound == 1)
{
userAccountList = userAccountList.Where(c => input.UserIds.Contains((int)c.SysNO));
userAccountList.ToList().ForEach(t => t.IsExitCourse = true);
}
else if (input.Isbound == 2)
{
userAccountList = userAccountList.Where(c => !input.UserIds.Contains((int)c.SysNO));
userAccountList.ToList().ForEach(t => t.IsExitCourse = false);
}
}
if (input.jobId > 0)
{
userAccountList = userAccountList.Where(c => c.PostID == input.jobId);
}
var userAccountCount = userAccountList.Count();
var userAccounts = userAccountList
.OrderByDescending(t => t.CreationTime)
.PageBy(input)
.ToList();
var userAccountListDtos = userAccounts.MapTo <List <UserAccountListDto> >();
return(new PagedResultDto <UserAccountListDto>(
userAccountCount,
userAccountListDtos
));
}
/// <summary>
/// 根据查询条件获取用户账号信息分页列表
/// </summary>
public IEnumerable <UserAccountListDto> GetPagedUserAccountsUD(GetUserAccountInput input)
{
var query = from user in _userAccountRepository.GetAll()
join de in _departmentRepository.GetAll() on user.DepartmentID equals de.DepartmentId into gc
from gci in gc.DefaultIfEmpty()
join job in _jobPostRepository.GetAll() on user.PostID equals job.Id into jc
from jci in jc.DefaultIfEmpty()
select new UserAccountListDto
{
Id = user.Id,
SysNO = user.SysNO,
LoginName = user.LoginName,
DisplayName = user.DisplayName,
DepartmentID = user.DepartmentID,
DepartmentName = gci.DisplayName,
province = user.province,
ProvinceID = user.ProvinceID,
City = user.City,
CityID = user.CityID,
Area = user.Area,
AreaID = user.AreaID,
DetailedAddress = user.DetailedAddress,
PostID = user.PostID,
PostName = jci.Name,
PhoneNumber = user.PhoneNumber,
Email = user.Email,
Status = user.Status,
CreationTime = user.CreationTime,
Path = gci.Path
};
IEnumerable <UserAccountListDto> userAccountList = query.MapTo <List <UserAccountListDto> >();
//TODO:根据传入的参数添加过滤条件
if (!string.IsNullOrEmpty(input.Username))
{
userAccountList = userAccountList.Where(c => c.DisplayName.Contains(input.Username));
}
if (input.DepartmentId > 0)
{
var depaertmentDate = _departmentRepository.GetAll().FirstOrDefault(c => c.DepartmentId == input.DepartmentId);
if (depaertmentDate != null)
{
userAccountList = userAccountList.Where(c => c.Path.StartsWith(depaertmentDate.Path));
}
}
if (input.Isbound != 0)
{
if (input.Isbound == 1)
{
userAccountList = userAccountList.Where(c => input.UserIds.Contains((int)c.SysNO));
userAccountList.ToList().ForEach(t => t.IsExitCourse = true);
}
else if (input.Isbound == 2)
{
userAccountList = userAccountList.Where(c => !input.UserIds.Contains((int)c.SysNO));
userAccountList.ToList().ForEach(t => t.IsExitCourse = false);
}
}
if (input.jobId > 0)
{
userAccountList = userAccountList.Where(c => c.PostID == input.jobId);
}
return(userAccountList);
}
