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); }