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 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 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 <RepairList> Insert(RepairList repair)
{
var model = await _repository.InsertAsync(repair);
var info = new RepairListInfo()
{
ListId = model.Id,
Remake = repair.Remake,
Status = (int)RepairStatusEnum.Init
};
await _infoRepository.InsertAsync(info);
var comm = await _communityRepository.FirstOrDefultAsync(p => p.Id == repair.CommunityId);
if (comm.AdminId != 0)
{
var admin = await _userRepository.FirstOrDefultAsync(p => p.Id == comm.AdminId);
SmsHelper.sendAdminMsg(admin.Mobile, new { });
}
return(model);
}
public Task <int> InsertAsync(RepairListInfo entity)
{
return(_repository.InsertAsync(entity));
}
/// <summary>
/// 新增
/// </summary>
/// <returns>操作影响的行数</returns>
public int Insert(RepairListInfo entity)
{
return(_repository.Insert(entity));
}
public Task <int> DeleteAsync(RepairListInfo entity)
{
return(_repository.DeleteAsync(entity));
}
/// <summary>
/// 根据实体删除
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns>操作影响的行数</returns>
public int Delete(RepairListInfo entity)
{
return(_repository.Delete(entity));
}
public Task <int> UpdateAsync(RepairListInfo entity, string[] ignoreColumns = null)
{
return(_repository.UpdateAsync(entity, ignoreColumns));
}
/// <summary>
/// 修改（主键是更新条件）
/// </summary>
/// <param name="entity"> 实体对象（必须指定主键特性 [SugarColumn(IsPrimaryKey=true)]）</param>
/// <param name="ignoreColumns">不更新的列</param>
/// <returns>操作影响的行数</returns>
public int Update(RepairListInfo entity, string[] ignoreColumns = null)
{
return(_repository.Update(entity, ignoreColumns));
}
public Task <RepairListInfo> InsertReturnEntityAsync(RepairListInfo entity)
{
return(_repository.InsertReturnEntityAsync(entity));
}
/// <summary>
/// 新增并返回实体
/// </summary>
/// <returns>操作影响的行数</returns>
public RepairListInfo InsertReturnEntity(RepairListInfo entity)
{
return(_repository.InsertReturnEntity(entity));
}
