Exemplo n.º 1
0
        public static ConnectionManage GetConnectionManage(string apiKey, string dbKey)
        {
            ConnectionManage entity = RedisCache.Get <ConnectionManage>("DB_Connection");

            if (entity != null)
            {
                return(entity);
            }

            var ss     = string.Format("key={0}&entityKey={1}", apiKey, dbKey);
            var result = HttpMethods.PostExecuteResult(Config.GetValue("GetDb"), "POST", ss);
            var api    = result.ToObject <ApiClass>();

            entity = api.Result;
            if (!string.IsNullOrEmpty(entity.PkConnection))
            {
                entity.PkConnection = DESEncrypt.Decrypt(entity.PkConnection, entity.BasicsId);
            }
            if (!string.IsNullOrEmpty(entity.SpareConnection))
            {
                entity.SpareConnection = DESEncrypt.Decrypt(entity.SpareConnection, entity.BasicsId);
            }
            RedisCache.Set("DB_Connection", entity);

            return(entity);
        }
Exemplo n.º 2
0
        public ConnectionManage GetConnectionManage(string dbKey)
        {
            var entity = _cache.Get <ConnectionManage>(dbKey);

            if (entity != null)
            {
                return(entity);
            }
            var ss     = string.Format("key={0}&entityKey={1}", APIKey, dbKey);
            var result = HttpMethods.PostExecuteResult(DBUrl, "POST", ss);
            var data   = JsonConvert.DeserializeObject <dynamic>(result);

            entity = data;
            if (!string.IsNullOrEmpty(entity.PkConnection))
            {
                entity.PkConnection = DESEncrypt.Decrypt(entity.PkConnection, entity.BasicsId);
            }
            if (!string.IsNullOrEmpty(entity.SpareConnection))
            {
                entity.SpareConnection = DESEncrypt.Decrypt(entity.SpareConnection, entity.BasicsId);
            }
            _cache.Set(dbKey, entity, TimeSpan.FromSeconds(300));
            return(entity);
        }