public string GetValue(string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
if (entityModels != null && entityModels.Any())
{
foreach (var item in entityModels)
{
return(item["value"].ToString());
}
return(null);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public static bool StaticSetValue(string value, string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}';", "id");
if (entityModels != null && entityModels.Any() && entityModels.Count > 0)
{
foreach (var item in entityModels)
{
if (item["key"].ToString() == key)
{
item["value"] = value;
item.SaveChange("value");
}
}
return(true);
}
else
{
var entityModel = new EntityModel();
entityModel.ConnectionString = ConnectionString;
entityModel.EntityName = tmpUserCacheTableName;
entityModel.PrimaryKey = new KeyValuePair <string, object>("id", Guid.NewGuid());
entityModel.Add("key", key);
entityModel.Add("value", value);
return(entityModelFactory.AddEntityModel(entityModel));
}
}
catch (Exception ex)
{
return(false);
}
}
public Dictionary <string, object> GetAll()
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName}", "id");
if (entityModels != null && entityModels.Any())
{
var dictionary = new Dictionary <string, object>();
foreach (var item in entityModels)
{
dictionary.Add(item["key"].ToString(), Json2KeyValue.JsonConvert.DeserializeObject <UserInfo>(item["value"].ToString()));
}
return(dictionary);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public bool Contains(string key)
{
try
{
var entityModelFactory = new EntityModelFactory();
entityModelFactory.ConnectionString = ConnectionString;
var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
if (entityModels != null && entityModels.Any())
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}