AppChannelRepository.cs 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. using System.Collections.Generic;
  2. using System.Threading.Tasks;
  3. using AutoMapper;
  4. using Datory;
  5. using GxPress.Common.AppOptions;
  6. using GxPress.Common.Tools;
  7. using GxPress.EnumConst;
  8. using GxPress.Repository.Interface.AppChannel;
  9. using Microsoft.Extensions.Options;
  10. namespace GxPress.Repository.Implement.AppChannel
  11. {
  12. public class AppChannelRepository : IAppChannelRepository
  13. {
  14. private readonly Repository<Entity.tede2.AppChannel.AppChannel> _repository;
  15. private readonly IMapper _mapper;
  16. public AppChannelRepository(IOptionsMonitor<DatabaseOptions> dbOptionsAccessor, IMapper mapper)
  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<Entity.tede2.AppChannel.AppChannel>(database);
  21. _mapper = mapper;
  22. }
  23. public IDatabase Database => _repository.Database;
  24. public string TableName => _repository.TableName;
  25. public List<TableColumn> TableColumns => _repository.TableColumns;
  26. /// <summary>
  27. /// 获取详情
  28. /// </summary>
  29. /// <param name="id"></param>
  30. /// <returns></returns>
  31. public async Task<Entity.tede2.AppChannel.AppChannel> GetAsync(int id)
  32. {
  33. var result = await _repository.GetAsync(id);
  34. if (result != null)
  35. result.ImageUrls = StringUtils.AddDomain(result.ImageUrls);
  36. return result;
  37. }
  38. /// <summary>
  39. /// 查询
  40. /// </summary>
  41. /// <returns></returns>
  42. public async Task<IEnumerable<Entity.tede2.AppChannel.AppChannel>> GetAllAsync(AppChannelConst channelTypeValye)
  43. {
  44. var result = await _repository.GetAllAsync(Q.Where(nameof(Entity.tede2.AppChannel.AppChannel.ChannelTypeValye), channelTypeValye).OrderBy(nameof(Entity.tede2.AppChannel.AppChannel.Sort)));
  45. foreach (var item in result)
  46. {
  47. item.ImageUrls = StringUtils.AddDomain(item.ImageUrls);
  48. }
  49. return result;
  50. }
  51. /// <summary>
  52. /// 删除
  53. /// </summary>
  54. /// <param name="id"></param>
  55. /// <returns></returns>
  56. public async Task<bool> DeleteAsync(int id)
  57. {
  58. return await _repository.DeleteAsync(id);
  59. }
  60. /// <summary>
  61. /// 修改
  62. /// </summary>
  63. /// <param name="model"></param>
  64. /// <returns></returns>
  65. public async Task<bool> UpdateAsync(Entity.tede2.AppChannel.AppChannel request)
  66. {
  67. var model = await _repository.GetAsync(request.Id);
  68. if (!string.IsNullOrEmpty(request.ImageUrls))
  69. model.ImageUrls = StringUtils.RemoveDomain(request.ImageUrls);
  70. model.IsDisable = request.IsDisable;
  71. return await _repository.UpdateAsync(model);
  72. }
  73. /// <summary>
  74. /// 添加
  75. /// </summary>
  76. /// <param name="model"></param>
  77. /// <returns></returns>
  78. public async Task<bool> InsertAsync(Entity.tede2.AppChannel.AppChannel model)
  79. {
  80. return await _repository.InsertAsync(model) > 0;
  81. }
  82. }
  83. }