src/SSCMS.Core/Repositories/RelatedFieldItemRepository.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Datory;
using SSCMS.Core.Utils;
using SSCMS.Models;
using SSCMS.Repositories;
using SSCMS.Services;

namespace SSCMS.Core.Repositories
{
    public partial class RelatedFieldItemRepository : IRelatedFieldItemRepository
    {
        private readonly Repository<RelatedFieldItem> _repository;

        public RelatedFieldItemRepository(ISettingsManager settingsManager)
        {
            _repository = new Repository<RelatedFieldItem>(settingsManager.Database, settingsManager.Redis);
        }

        public IDatabase Database => _repository.Database;

        public string TableName => _repository.TableName;

        public List<TableColumn> TableColumns => _repository.TableColumns;

        private string GetCacheKey(int siteId)
        {
            return CacheUtils.GetListKey(_repository.TableName, siteId);
        }

        public async Task<int> InsertAsync(RelatedFieldItem info)
        {
            info.Taxis = await GetMaxTaxisAsync(info.SiteId, info.ParentId) + 1;

            info.Id = await _repository.InsertAsync(info, Q.CachingRemove(GetCacheKey(info.SiteId)));
            return info.Id;
        }

        public async Task<bool> UpdateAsync(RelatedFieldItem info)
        {
            return await _repository.UpdateAsync(info, Q.CachingRemove(GetCacheKey(info.SiteId)));
        }

        public async Task DeleteAsync(int siteId, int id)
        {
            var childIds = await _repository.GetAllAsync<int>(Q
                .Select(nameof(RelatedFieldItem.Id))
                .Where(nameof(RelatedFieldItem.ParentId), id)
            );
            if (childIds.Any())
            {
                foreach (var childId in childIds)
                {
                    await DeleteAsync(siteId, childId);
                }
            }
            await _repository.DeleteAsync(id, Q.CachingRemove(GetCacheKey(siteId)));
        }