/// <summary>

    /// SqlSugar二级缓存（必须是内存缓存）

    /// </summary>

    public class SqlSugarCache : ICacheService

    {

        private static readonly ICache _cache = Cache.Default;

        public void Add<V>(string key, V value)

        {

            _cache.Set(key, value);

        }

        public void Add<V>(string key, V value, int cacheDurationInSeconds)

        {

            _cache.Set(key, value, cacheDurationInSeconds);

        }

        public bool ContainsKey<V>(string key)

        {

            return _cache.ContainsKey(key);

        }

        public V Get<V>(string key)

        {

            return _cache.Get<V>(key);

        }

        public IEnumerable<string> GetAllKey<V>()

        {

            return _cache.Keys;

        }

        public V GetOrCreate<V>(string cacheKey, Func<V> create, int cacheDurationInSeconds = int.MaxValue)

        {

            if (!_cache.TryGetValue<V>(cacheKey, out V value))

            {

                value = create();

                _cache.Set(cacheKey, value, cacheDurationInSeconds);

            }

            return value;

        }

        public void Remove<V>(string key)

        {

            _cache.Remove(key);

        }

    }

//二级缓存 : SqlSugar二级缓存（必须是内存缓存）

db.CurrentConnectionConfig.ConfigureExternalServices = new ConfigureExternalServices()

{

    //AppSettingsConstVars.RedisUseCache

    //判断是否开启redis设置二级缓存方式

    //DataInfoCacheService = AppSettingsConstVars.RedisUseCache ? (ICacheService)new SqlSugarRedisCache000() : new SqlSugarMemoryCache()

   DataInfoCacheService  = new SqlSugarCache(),

};

//... ... ...

#region 实体配置过滤器

        /// <summary>

        /// 配置租户过滤器

        /// </summary>

        private static void SetTenantEntityFilter(SqlSugarClient db)

        {

            //炒鸡管理员工 直接略过

            var isSuperAdmin = App.User?.Claims?.Where(p => p.Type == ClaimTypes.Role)?.Any(p => p.Value == "superadmin") ?? false ;

            if (isSuperAdmin) return;

            var tenantId = App.User?.FindFirst(GlobalConstVars.TenantId)?.Value;

            if (string.IsNullOrWhiteSpace(tenantId)) return;

            // 配置租户缓存

            var cacheKey = $"db:{211314}:TenantId:{tenantId}";

            var tableFilterItemList = db.DataCache.Get<List<TableFilterItem<object>>>(cacheKey);//sqlsugar 二级缓存

            if (tableFilterItemList == null)

            {

                // 获取租户实体数据表

                var entityTypes = App.EffectiveTypes.Where(u => !u.IsInterface && !u.IsAbstract && u.IsClass

                    && (u.BaseType == typeof(EntityTenantNew) || u.BaseType == typeof(EntityTenantId)));

                if (!entityTypes.Any()) return;

                var tableFilterItems = new List<TableFilterItem<object>>();

                foreach (var entityType in entityTypes)

                {

                    var lambda = DynamicExpressionParser.ParseLambda(new[] {

                    Expression.Parameter(entityType, "u") }, typeof(bool), $"{nameof(EntityTenantNew.tenantId)} == @0", long.Parse(tenantId));

                    var tableFilterItem = new TableFilterItem<object>(entityType, lambda);

                    tableFilterItems.Add(tableFilterItem);

                    db.QueryFilter.Add(tableFilterItem);

                }

                db.DataCache.Add(cacheKey, tableFilterItems);

            }

            else

            {

                tableFilterItemList.ForEach(u =>

                {

                    db.QueryFilter.Add(u);

                });

            }

        }

        #endregion