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