/// <summary> /// 添加(判断Account是否已存在) /// </summary> /// <param name="entity"></param> /// <returns>-1: 失败 , 0:已存在 ,1:成功</returns> public async Task <(string Error, User user)> InsertAsync(User entity) { //已存在 int count = await UserRep.GetCountAsync(o => o.Account == entity.Account); if (count > 0) { return("帐号已存在", null); } await UserRep.AddAsync(entity); return(string.Empty, null); }
/// <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); }