TaskAssignment.cs 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. using Microsoft.AspNetCore.SignalR;
  2. using OASystem.Domain.Entities.Groups;
  3. using OASystem.Domain.Entities.PersonnelModule;
  4. using OASystem.Infrastructure.Repositories.PersonnelModule;
  5. using ILogger = Microsoft.Extensions.Logging.ILogger;
  6. namespace OASystem.API.OAMethodLib.Quartz.Business
  7. {
  8. /// <summary>
  9. /// 任务指派
  10. /// 定时任务
  11. /// </summary>
  12. public static class TaskAssignment
  13. {
  14. private readonly static TaskAllocationRepository _taskAllocationRep = AutofacIocManager.Instance.GetService<TaskAllocationRepository>();
  15. private readonly static ILogger _logger;
  16. /// <summary>
  17. /// 定时任务更改状态
  18. /// 每天下午六点定时更新
  19. /// </summary>
  20. public static async void PostTaskUpdateStatus()
  21. {
  22. var data = await _taskAllocationRep._sqlSugar
  23. .Queryable<Pm_TaskAllocation>()
  24. .Where(it => it.IsDel == 0 &&
  25. !string.IsNullOrEmpty(it.PredictEndTime) &&
  26. Convert.ToDateTime(it.PredictEndTime) >= DateTime.Now
  27. )
  28. .ToListAsync();
  29. if (data.Count > 0)
  30. {
  31. //处理要变更状态的员工
  32. List<int> primaryIds = new List<int>();
  33. primaryIds = data.Select(it => it.Id).ToList();
  34. var subData = await _taskAllocationRep._sqlSugar
  35. .Queryable<Pm_TaskRelevanceUser>()
  36. .Where(it => it.IsDel == 0 &&
  37. primaryIds.Contains(it.TAId) &&
  38. it.TaskStatus <= TaskerEnum.UnderWay
  39. )
  40. .ToListAsync();
  41. foreach (var item in subData)
  42. {
  43. item.OverTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  44. item.TaskStatus = TaskerEnum.UnFinished;
  45. item.Cause = string.Format(@"任务没有提交完成或者超时,由系统设置任务未完成");
  46. }
  47. if (subData.Count > 0)
  48. {
  49. var updateStatus = await _taskAllocationRep._sqlSugar
  50. .Updateable(subData)
  51. .WhereColumns(it => it.Id)
  52. .ExecuteCommandAsync();
  53. }
  54. }
  55. }
  56. }
  57. }