public EmployeeViewModel.EmployeeInfoListResult getEmployeeInfoListResult(EmployeeViewModel.EmployeeInfoListQueryParam param)
{
EmployeeViewModel.EmployeeInfoListResult ret = new EmployeeViewModel.EmployeeInfoListResult();
try {
ret = this.empSvc.getEmployeeInfoListResult(param);
} catch (Exception ex) {
ret.success = false;
ret.resultCode = "500";
ret.resultException = ex.ToString();
}
return(ret);
}
public EmployeeViewModel.EmployeeInfoListResult getEmployeeInfoListResult(EmployeeViewModel.EmployeeInfoListQueryParam param)
{
EmployeeViewModel.EmployeeInfoListResult ret = new EmployeeViewModel.EmployeeInfoListResult();
Tuple <List <EmployeeViewModel.EmployeeInfoLight>, int> list_ret = this.empDao.getEmpInfoList(param);
ret.success = true;
ret.resultCode = "200";
ret.count = list_ret.Item2;
ret.list = list_ret.Item1;
ret.orderField = param.orderField;
ret.pageIndex = param.pageIndex;
ret.pageSize = param.pageSize;
return(ret);
}
public Tuple <List <EmployeeViewModel.EmployeeInfoLight>, int> getEmpInfoList(EmployeeViewModel.EmployeeInfoListQueryParam param)
{
Tuple <List <EmployeeViewModel.EmployeeInfoLight>, int> ret = null;
int count = 0;
List <EmployeeViewModel.EmployeeInfoLight> list = new List <EmployeeViewModel.EmployeeInfoLight>();
using (NaNaEntities db = new NaNaEntities()) {
var predicate = PredicateBuilder.True <ViewEmployeeLightInfo>();
if (!string.IsNullOrEmpty(param.id))
{
List <string> idsArr = param.id.Split(',').ToList();
predicate = predicate.And(x => idsArr.Contains(x.ID));
}
if (!string.IsNullOrEmpty(param.keyword))
{
predicate = predicate.And(
x =>
x.ldapid.ToLower().Contains(param.keyword.ToLower()) ||
x.phoneNumber.Contains(param.keyword) ||
x.userName.Contains(param.keyword) ||
x.ID.Contains(param.keyword) ||
x.departmentID.Contains(param.keyword) ||
x.departmentName.Contains(param.keyword));
}
if (string.IsNullOrEmpty(param.orderField))
{
param.orderField = "ID";
}
List <ViewEmployeeLightInfo> queryList = db.ViewEmployeeLightInfo.AsExpandable()
.Where(predicate)
.OrderBy(param.orderField, param.desc)
.Skip((param.pageIndex - 1) * param.pageSize)
.Take(param.pageSize).ToList();
foreach (var e in queryList)
{
list.Add(new EmployeeViewModel.EmployeeInfoLight()
{
avatar = "",
department = string.IsNullOrEmpty(e.departmentName) ? "" : e.departmentName,
departmentId = string.IsNullOrEmpty(e.departmentID) ? "" : e.departmentID,
extNo = string.IsNullOrEmpty(e.phoneNumber) ? "" : e.phoneNumber,
id = string.IsNullOrEmpty(e.ID) ? "" : e.ID,
name = string.IsNullOrEmpty(e.userName) ? "" : e.userName
});
}
count = db.ViewEmployeeLightInfo.AsExpandable()
.Where(predicate)
.Count();
ret = Tuple.Create(list, count);
}
return(ret);
}
