public async Task <QueryResult <RepairManDTO> > GetRepairManList(QueryRepairManModel pageBase)
{
var sql = "select u.* from Community c right join Users u on c.RepairManId = u.Id where u.IsAdmin = 0 and u.IsRepairMan = 1 ";
if (!string.IsNullOrWhiteSpace(pageBase.mobile))
{
sql += $" and u.mobile = '{pageBase.mobile}' ";
}
if (pageBase.communnityId.HasValue)
{
sql += $" and c.id = {pageBase.communnityId.Value} ";
}
var list = await DapperService.PageList <RepairManDTO>(sql, pageBase, "group by u.id");
var commList = await _communityService.GetAllAsync();
list.List.ForEach(p =>
{
var nameList = commList.Where(x => x.RepairManId == p.Id).Select(x => x.Name).ToList();
p.CommunityName = string.Join("，", nameList);
p.AdminName = commList.FirstOrDefault(x => x.AdminId == p.Id)?.Name;
});
return(list);
}
/// <summary>
/// 修理工列表
/// </summary>
/// <returns></returns>
public async Task <IActionResult> RepairManList()
{
var comm = await _communityService.FirstOrDefult(p => p.AdminId == loginDto.CurrentId.Value);
var model = new QueryRepairManModel();
if (IsSuper() != 1)
{
model.communnityId = comm?.Id;
}
ViewBag.SearchModel = model;
return(View());
}
public async Task <QueryResult <RepairManDTO> > GetAllRepairManList(QueryRepairManModel pageBase)
{
var sql = $" SELECT * from Users where IsRepairMan = 1 ";
if (!string.IsNullOrWhiteSpace(pageBase.mobile))
{
sql += $" and Mobile = '{pageBase.mobile}' ";
}
var list = await DapperService.PageList <RepairManDTO>(sql, pageBase);
var commList = await _repairManRepository.GetAllAsync();
list.List.ForEach(p =>
{
p.CommunityName = string.Join(',', commList.Where(x => x.UserId == p.Id).Select(x => x.CommunityName).ToList());
});
return(list);
}
public async Task <JsonResult> GetAllRepairManList(QueryRepairManModel pageBase)
{
var list = await _userService.GetRepairManList(pageBase);
return(Jsons(list));
}
