public async Task AppointRepairMan(int repairId, int repairManId)
{
var sql = $"update RepairList set RepairManId = {repairManId} ,status = 2 where Id = {repairId}";
await DapperService.Execute(sql);
var repair = await _userRepository.FirstOrDefultAsync(p => p.Id == repairManId);
var info = new RepairListInfo()
{
ListId = repairId,
Remake = $"系统派单，修理工：{repair.Name}（{repair.Mobile}）",
Status = (int)RepairStatusEnum.Sure
};
await _infoRepository.InsertAsync(info);
var repairList = await _repository.FirstOrDefultAsync(p => p.Id == repairId);
var user = await _userRepository.FirstOrDefultAsync(p => p.Id == repairList.UserId);
SmsHelper.sendUserMsg(user.Mobile, new { name = repair.Name, tel = repair.Mobile });
Console.WriteLine("发送给用户：" + user.Mobile);
var comm = await _communityRepository.FirstOrDefultAsync(p => p.Id == user.CommunityId);
SmsHelper.sendRepairMsg(repair.Mobile, new { home = $"{comm.Name}-{user.HomeNum}" });
Console.WriteLine("发送给维修工：" + repair.Mobile);
}
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);
}
public async Task update(int repairListId, RepairStatusEnum statusEnum)
{
var sql = $" update RepairList set Status = {(int)statusEnum} where Id = {repairListId} ";
await DapperService.Execute(sql);
var msg = "";
if (statusEnum == RepairStatusEnum.Doing)
{
msg = "修理工已到达";
}
if (statusEnum == RepairStatusEnum.Down)
{
msg = "已完成，待评价";
}
if (statusEnum == RepairStatusEnum.Success)
{
msg = "完成";
}
var info = new RepairListInfo()
{
ListId = repairListId,
Remake = msg,
Status = (int)statusEnum
};
await _infoRepository.InsertAsync(info);
}
public async Task <QueryResult <RepairListDTO> > PageRepairList(QueryRepairListModel pageBase)
{
var sql = @"select
r.*,
c.`Name` as CommunityName,
(select name from Users where id = r.RepairManId) as RepairManName
from
Community c
join RepairList r on r.CommunityId = c.Id where 1=1 ";
if (pageBase.AdminId.HasValue)
{
sql += $" and c.AdminId = {pageBase.AdminId.Value} ";
}
if (pageBase.StatusEnum.HasValue)
{
sql += $" and r.status = {pageBase.StatusEnum.Value} ";
}
var list = await DapperService.PageList <RepairListDTO>(sql, pageBase);
var user = await _userRepository.GetAllAsync();
list.List.ForEach(p =>
{
p.statusName = ((RepairStatusEnum)p.Status).GetDisplayName();
p.User = user.FirstOrDefault(x => x.Id == p.UserId);
});
return(list);
}
public async Task CancleRepairMan(int userId)
{
var sql = $"update Users set IsRepairMan = 0 where id = {userId}";
await DapperService.Execute(sql);
var sql2 = $"delete from RepairMan where UserId = {userId}";
await DapperService.Execute(sql2);
}
public async Task SetCommuityAdmin(int commuityId, int userId)
{
var sql = $"update Community set AdminId = {userId} where Id = {commuityId} ";
await DapperService.Execute(sql);
var sql2 = $"update Users set IsAdmin = 1 where Id = {userId}";
await DapperService.Execute(sql2);
}
public async Task <QueryResult <User> > GetUserList2(QueryUserModel pageBase)
{
var comm = await _communityService.FirstOrDefult(p => p.AdminId == pageBase.AdminId);
var sql = $" SELECT u.* from RepairMan r RIGHT JOIN Users u ON u.Id = r.UserId where r.CommunityId = {comm.Id} ";
var list = await DapperService.PageList <User>(sql, pageBase);
return(list);
}
public async Task <QueryResult <User> > GetAllRepair(QueryUserModel pageBase)
{
var comm = await _communityService.FirstOrDefult(p => p.AdminId == pageBase.AdminId);
var sql = $" SELECT * FROM Users WHERE IsRepairMan = 1 ";
var list = await DapperService.PageList <User>(sql, pageBase);
return(list);
}
public async Task DelCommunity(int id)
{
var sql = $" DELETE FROM Community WHERE Id = {id} ";
await DapperService.Execute(sql);
var sql2 = $" DELETE FROM RepairList WHERE CommunityId = {id}; ";
await DapperService.Execute(sql2);
var sql3 = $" DELETE FROM RepairMan WHERE CommunityId = {id}; ";
await DapperService.Execute(sql3);
}
public async Task CommRepairRemake(ComRepairDTO dto)
{
var sql = $" UPDATE RepairList SET `Status` = {(int)RepairStatusEnum.Success} WHERE Id = {dto.repairId} ;";
await DapperService.Execute(sql);
var info = new RepairListInfo()
{
ListId = dto.repairId,
Remake = dto.str,
Status = (int)RepairStatusEnum.Success
};
await _repository.InsertAsync(info);
}
public async Task SetCommuityRepairMan(int commuityId, int userId)
{
var sql = $"update Community set RepairManId = {userId} where Id = {commuityId} and RepairManId > 0 ";
await DapperService.Execute(sql);
var u = await _userRepository.FirstOrDefultAsync(p => p.Id == userId);
var comm = await _repository.FirstOrDefultAsync(p => p.Id == commuityId);
var man = new RepairMan()
{
CommunityId = commuityId,
UserId = userId,
RepairManName = u?.Name,
CommunityName = comm?.Name
};
await _repairManRepository.InsertAsync(man);
}
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 MakeRepairMan(int userId, string communityIds)
{
var sql = $"update Users set IsRepairMan = 1 where id = {userId}";
await DapperService.Execute(sql);
//var hasMan = await _repairManRepository.CountAsync(p => p.UserId == userId);
//if (hasMan > 0)
//{
// var sql2 = $"update RepairMan set CommunityIds = '{communityIds}' ";
// await DapperService.Execute(sql2);
//}
//else
//{
// var repairMan = new RepairMan()
// {
// UserId = userId,
// CommunityIds = communityIds
// };
// await _repairManRepository.InsertAsync(repairMan);
//}
}
