public VPageBootstrapTable <UserInfoDto> GetUserInfoList(VUserListCondition input) { var listUser = _userInfoRepository.GetList(); var listDept = _deptInfoRepository.GetList(); var list = from t in listUser join d in listDept on t.UserDeptId equals d.DeptId select new UserInfoDto { ID = t.Id, Phone = t.Phone, Remark = t.Remark, UserDeptName = d.DeptName, UserName = t.UserName, Duty = t.Duty }; if (!string.IsNullOrEmpty(input.userName)) { list = list.Where(w => w.UserName.Contains(input.userName)); } if (!string.IsNullOrEmpty(input.duty)) { list = list.Where(w => w.Duty.Contains(input.duty)); } VPageBootstrapTable <UserInfoDto> page = new VPageBootstrapTable <UserInfoDto>(); page.rows = list.Skip(input.offset).Take(input.limit).ToList(); page.total = list.Count(); return(page); }
public List <DeptInfo> GetDeptFatherList() { return(_deptInfoRepository.GetList().Where(w => w.DeptFatherId == 1).OrderBy(o => o.DeptOrder).ToList()); }