/// <summary> /// /// </summary> /// <param name="pageNumber"></param> /// <param name="rowsPrePage"></param> /// <param name="filter"></param> /// <returns></returns> public async Task <PageResult <UserSunpleDto> > GetPageAsync(int pageNumber, int rowsPrePage, UserOption filter) { List <UserSunpleDto> data = new List <UserSunpleDto>(); PageResult <UserSunpleDto> list = new PageResult <UserSunpleDto>(); string orderby = " id desc"; var predicate = PredicateBuilder.True <User>(); predicate = predicate.And(o => o.DeleteMark == null); if (!string.IsNullOrWhiteSpace(filter.Account)) { predicate = predicate.And(o => o.Account == filter.Account); } if (!string.IsNullOrWhiteSpace(filter.RealName)) { predicate = predicate.And(o => o.RealName == filter.RealName); } var tlist = await UserRep.Find(pageNumber, rowsPrePage, orderby, predicate).ToListAsync() ?? new List <User>(); data = MapperHelper.MapList <User, UserSunpleDto>(tlist); List <long> roleIds = tlist.Select(o => o.RoleId).Distinct().ToList(); if (roleIds.Count() > 0) { var roles = await RoleRep.Find(o => roleIds.Contains(o.Id)).ToListAsync(); foreach (var d in data) { var r = roles.FirstOrDefault(o => o.Id == d.RoleId); d.RoleName = r?.Name; } } List <long?> DepartmentIds = tlist.Select(o => o.DepartmentId).Distinct().ToList(); DepartmentIds.Remove(null); if (DepartmentIds.Count() > 0) { var Departments = await DepartmentRep.Find(o => DepartmentIds.Contains(o.Id)).ToListAsync(); foreach (var d in data) { var r = Departments.FirstOrDefault(o => o.Id == d.DepartmentId); d.deptname = r?.Name; } } list.Data = data.ToList(); int total = await UserRep.GetCountAsync(predicate); list.ItemCount = total; return(list); }
public Department Load(int Id) { IDepartmentRep departmentRep = new DepartmentRep(); return(departmentRep.Load(Id)); }
public void Update(Department mod) { IDepartmentRep departmentRep = new DepartmentRep(); departmentRep.Update(mod); }
public void Save(Department mod) { IDepartmentRep departmentRep = new DepartmentRep(); departmentRep.Insert(mod); }
public List <Department> LoadMain() { IDepartmentRep department = new DepartmentRep(); return(department.LoadMain()); }
public List <Department> departments() { IDepartmentRep departmentRep = new DepartmentRep(); return(departmentRep.LoadMain()); }