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