ProcessGroupRepository.cs 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. using System.Collections.Generic;
  2. using System.Threading.Tasks;
  3. using GxPress.Common.AppOptions;
  4. using GxPress.Common.Exceptions;
  5. using GxPress.Common.Tools;
  6. using GxPress.Entity.WorkProcess;
  7. using GxPress.Repository.Interface.WorkProcess;
  8. using GxPress.Request.ProcessGroup;
  9. using Microsoft.Extensions.Options;
  10. using Datory;
  11. namespace GxPress.Repository.Implement.WorkProcess
  12. {
  13. public class ProcessGroupRepository : IProcessGroupRepository
  14. {
  15. private readonly Repository<ProcessGroup> _repository;
  16. public ProcessGroupRepository(IOptionsMonitor<DatabaseOptions> dbOptionsAccessor)
  17. {
  18. var databaseType = StringUtils.ToEnum<DatabaseType>(dbOptionsAccessor.CurrentValue.DatabaseType, DatabaseType.MySql);
  19. var database = new Database(databaseType, dbOptionsAccessor.CurrentValue.ConnectionString);
  20. _repository = new Repository<ProcessGroup>(database);
  21. }
  22. public IDatabase Database => _repository.Database;
  23. public string TableName => _repository.TableName;
  24. public List<TableColumn> TableColumns => _repository.TableColumns;
  25. public async Task<bool> ExistsAsync(int id)
  26. {
  27. return await _repository.ExistsAsync(id);
  28. }
  29. public async Task<bool> IsNameExistsAsync(string name)
  30. {
  31. return await _repository.ExistsAsync(Q.Where(nameof(ProcessGroup.Name), name));
  32. }
  33. public async Task<int> InsertAsync(ProcessGroup processGroup)
  34. {
  35. return await _repository.InsertAsync(processGroup);
  36. }
  37. public async Task<ProcessGroup> GetAsync(int id)
  38. {
  39. return await _repository.GetAsync(id);
  40. }
  41. public async Task<bool> UpdateAsync(ProcessGroup processGroup)
  42. {
  43. return await _repository.UpdateAsync(processGroup);
  44. }
  45. public async Task<IEnumerable<ProcessGroup>> GetListAsync()
  46. {
  47. return await _repository.GetAllAsync();
  48. }
  49. /// <summary>
  50. /// ����
  51. /// </summary>
  52. /// <param name="request"></param>
  53. /// <returns></returns>
  54. public async Task<ProcessGroup> AddAsync(ArticleGroupAddRequest request)
  55. {
  56. var exist = await IsNameExistsAsync(request.Name);
  57. if (exist) throw new BusinessException("�����������ظ�");
  58. var group = new ProcessGroup
  59. {
  60. Name = request.Name,
  61. Sort = request.Sort
  62. };
  63. group.Id = await InsertAsync(group);
  64. return group;
  65. }
  66. /// <summary>
  67. /// �޸�
  68. /// </summary>
  69. /// <param name="id"></param>
  70. /// <param name="request"></param>
  71. /// <returns></returns>
  72. public async Task<bool> UpdateAsync(int id, ArticleGroupAddRequest request)
  73. {
  74. var group = await GetAsync(id);
  75. if (group == null) throw new BusinessException("�÷��鲻����");
  76. if (group.Name != request.Name)
  77. {
  78. var exist = await IsNameExistsAsync(request.Name);
  79. if (exist) throw new BusinessException("�����������ظ�");
  80. }
  81. group.Name = request.Name;
  82. group.Sort = request.Sort;
  83. return await UpdateAsync(group);
  84. }
  85. /// <summary>
  86. /// ɾ��
  87. /// </summary>
  88. /// <param name="id"></param>
  89. /// <returns></returns>
  90. public async Task<bool> DeleteAsync(int id)
  91. {
  92. var group = await GetAsync(id);
  93. if (group == null) throw new BusinessException("�������鲻����");
  94. return await _repository.DeleteAsync(id);
  95. }
  96. }
  97. }