GroupFolderRepository.cs 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Threading.Tasks;
  5. using AutoMapper;
  6. using GxPress.Common.AppOptions;
  7. using GxPress.Common.Exceptions;
  8. using GxPress.Common.Tools;
  9. using GxPress.Entity;
  10. using GxPress.Repository.Interface;
  11. using GxPress.Request.App.GroupFolder;
  12. using Microsoft.AspNetCore.Hosting;
  13. using Microsoft.Extensions.Options;
  14. using Datory;
  15. namespace GxPress.Repository.Implement
  16. {
  17. public class GroupFolderRepository:IGroupFolderRepository
  18. {
  19. private readonly Repository<GroupFolder> _repository;
  20. private readonly IMapper _mapper;
  21. private readonly IWebHostEnvironment _environment;
  22. public GroupFolderRepository(IOptionsMonitor<DatabaseOptions> dbOptionsAccessor, IMapper mapper,
  23. IWebHostEnvironment environment)
  24. {
  25. var databaseType =
  26. StringUtils.ToEnum<DatabaseType>(dbOptionsAccessor.CurrentValue.DatabaseType, DatabaseType.MySql);
  27. var database = new Database(databaseType, dbOptionsAccessor.CurrentValue.ConnectionString);
  28. _repository = new Repository<GroupFolder>(database);
  29. _environment = environment;
  30. _mapper = mapper;
  31. }
  32. public IDatabase Database => _repository.Database;
  33. public string TableName => _repository.TableName;
  34. public List<TableColumn> TableColumns => _repository.TableColumns;
  35. /// <summary>
  36. /// 添加小组文件夹
  37. /// </summary>
  38. /// <param name="request"></param>
  39. /// <returns></returns>
  40. public async Task<bool> InsertAsync(GroupFolderInRequest request)
  41. {
  42. if (string.IsNullOrEmpty(request.Name))
  43. throw new BusinessException("文件夹名称不能为空");
  44. if (request.ParentId < 0)
  45. throw new BusinessException("参数错误");
  46. if (request.UserId <= 0)
  47. throw new BusinessException("参数错误");
  48. var groupFolder = new GroupFolder
  49. {
  50. Name = request.Name, ParentId = request.ParentId, UserId = request.UserId
  51. };
  52. return await _repository.InsertAsync(groupFolder) > 0;
  53. }
  54. /// <summary>
  55. /// 修改文件夹
  56. /// </summary>
  57. /// <param name="request"></param>
  58. /// <returns></returns>
  59. public async Task<bool> UpdateAsync(GroupFolderUpRequest request)
  60. {
  61. var groupFolder = await _repository.GetAsync(request.Id);
  62. if (!string.IsNullOrEmpty(request.Name))
  63. groupFolder.Name = request.Name;
  64. return await _repository.UpdateAsync(groupFolder);
  65. }
  66. /// <summary>
  67. /// 删除文件
  68. /// </summary>
  69. /// <param name="id"></param>
  70. /// <returns></returns>
  71. public async Task<bool> DeleteAsync(int id)
  72. {
  73. return await _repository.DeleteAsync(id);
  74. }
  75. /// <summary>
  76. ///
  77. /// </summary>
  78. /// <param name="request"></param>
  79. /// <returns></returns>
  80. public async Task<IEnumerable<GroupFolder>> FindGroupFoldersAsync(GroupFolderFindRequest request)
  81. {
  82. return await _repository.GetAllAsync(Q.Where(nameof(GroupFolder.ParentId), request.GroupFolderId)
  83. .Where(nameof(GroupFolder.UserId), request.UserId));
  84. }
  85. }
  86. }