public static void CleanFreCount()
{
DataTable dt = new MemcachedGetFrequencyDAL().SelectTableId();
IList <int> frequencyIds = new List <int>();
foreach (DataRow row in dt.Rows)
{
frequencyIds.Add(int.Parse(row["MemcachedGetFrequencyId"].ToString()));
}
MemcachedGetFrequencyDAL dal = new MemcachedGetFrequencyDAL();
foreach (int frequenceId in frequencyIds)
{
try
{
MemcachedGetFrequencyEntity entity = dal.Select(frequenceId);
if (entity != null)
{
entity.FreCount = 0;
entity.DataChange_LastTime = DateTime.Now;
entity.LastGetDateTime = DateTime.Now;
dal.Update(entity);
}
}
catch (Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}
}
public static void CleanFreCount()
{
DataTable dt = new MemcachedGetFrequencyDAL().SelectTableId();
IList<int> frequencyIds = new List<int>();
foreach (DataRow row in dt.Rows)
{
frequencyIds.Add(int.Parse(row["MemcachedGetFrequencyId"].ToString()));
}
MemcachedGetFrequencyDAL dal = new MemcachedGetFrequencyDAL();
foreach (int frequenceId in frequencyIds)
{
try
{
MemcachedGetFrequencyEntity entity = dal.Select(frequenceId);
if (entity != null)
{
entity.FreCount = 0;
entity.DataChange_LastTime = DateTime.Now;
entity.LastGetDateTime = DateTime.Now;
dal.Update(entity);
}
}
catch (Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}
}
public static void InitCfgData(string key, string jsonCallEnity)
{
try
{
var index = key.IndexOf(CacheManager.MAIN_KEY_SPLIT_CHAR);
string cacheKeyPrefix = index >= 0 ? key.Substring(0, index) : key;
MemcachedUpdateSetConfigDAL configDAL = new MemcachedUpdateSetConfigDAL();
MemcachedUpdateSetConfigEntity configEngity = configDAL.Select(string.Format("CacheKeyPrefix='{0}'", cacheKeyPrefix));
if (configEngity == null)
{
configEngity = new MemcachedUpdateSetConfigEntity();
configEngity.CacheKeyPrefix = cacheKeyPrefix;
configEngity.DataChange_LastTime = DateTime.Now;
configEngity.FreMin = 0;//数据库默认
configEngity.IsJobActByMin = 0;
configEngity.UpdateHourSpan = KeyMinuteManager.DefaultMinute;
configDAL.Insert(configEngity);
}
MemcachedUpdateRuleDAL ruleDAL = new MemcachedUpdateRuleDAL();
MemcachedUpdateRuleEntity ruleEntity = ruleDAL.Select(string.Format("CacheKey='{0}'", key));
if (ruleEntity == null)
{
ruleEntity = new MemcachedUpdateRuleEntity();
ruleEntity.CacheKey = key;
ruleEntity.CacheKeyPrefix = cacheKeyPrefix;
ruleEntity.ConditionEntityJson = jsonCallEnity;
ruleEntity.DataChange_LastTime = DateTime.Now;
ruleEntity.IsJobActByMin = configEngity.IsJobActByMin;
ruleEntity.LastUpdateTime = DateTime.Now;
ruleEntity.UpdateHourSpan = configEngity.UpdateHourSpan;
ruleDAL.Insert(ruleEntity);
}
MemcachedGetFrequencyDAL freqDAL = new MemcachedGetFrequencyDAL();
MemcachedGetFrequencyEntity freqEntity = freqDAL.Select(string.Format("CacheKey='{0}'", key));
if (freqEntity == null)
{
freqEntity = new MemcachedGetFrequencyEntity();
freqEntity.CacheKey = key;
freqEntity.CacheKeyPrefix = cacheKeyPrefix;
freqEntity.DataChange_LastTime = DateTime.Now;
freqEntity.FreMin = configEngity.FreMin;
freqEntity.FreCount = 1;
freqEntity.LastGetDateTime = DateTime.Now;
freqDAL.Insert(freqEntity);
}
}
catch (Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}
public static void UpdateFreCount(string key, int freCount)
{
try
{
MemcachedGetFrequencyDAL frequencyDAL = new MemcachedGetFrequencyDAL();
MemcachedGetFrequencyEntity entity = frequencyDAL.Select(string.Format("CacheKey='{0}'", key));
if (entity != null)
{
entity.FreCount += freCount;
entity.LastGetDateTime = DateTime.Now;
entity.DataChange_LastTime = DateTime.Now;
frequencyDAL.Update(entity);
}
}
catch (Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}
public static void UpdateFreCount(string key, int freCount)
{
try
{
MemcachedGetFrequencyDAL frequencyDAL = new MemcachedGetFrequencyDAL();
MemcachedGetFrequencyEntity entity = frequencyDAL.Select(string.Format("CacheKey='{0}'", key));
if (entity != null)
{
entity.FreCount += freCount;
entity.LastGetDateTime = DateTime.Now;
entity.DataChange_LastTime = DateTime.Now;
frequencyDAL.Update(entity);
}
}
catch (Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}
public static void InitCfgData(string key, string jsonCallEnity)
{
try
{
var index=key.IndexOf(CacheManager.MAIN_KEY_SPLIT_CHAR);
string cacheKeyPrefix = index >= 0 ? key.Substring(0, index) : key;
MemcachedUpdateSetConfigDAL configDAL = new MemcachedUpdateSetConfigDAL();
MemcachedUpdateSetConfigEntity configEngity = configDAL.Select(string.Format("CacheKeyPrefix='{0}'", cacheKeyPrefix));
if (configEngity == null)
{
configEngity = new MemcachedUpdateSetConfigEntity();
configEngity.CacheKeyPrefix = cacheKeyPrefix;
configEngity.DataChange_LastTime = DateTime.Now;
configEngity.FreMin = 0;//数据库默认
configEngity.IsJobActByMin = 0;
configEngity.UpdateHourSpan = KeyMinuteManager.DefaultMinute;
configDAL.Insert(configEngity);
}
MemcachedUpdateRuleDAL ruleDAL = new MemcachedUpdateRuleDAL();
MemcachedUpdateRuleEntity ruleEntity = ruleDAL.Select(string.Format("CacheKey='{0}'", key));
if (ruleEntity == null)
{
ruleEntity = new MemcachedUpdateRuleEntity();
ruleEntity.CacheKey = key;
ruleEntity.CacheKeyPrefix = cacheKeyPrefix;
ruleEntity.ConditionEntityJson = jsonCallEnity;
ruleEntity.DataChange_LastTime = DateTime.Now;
ruleEntity.IsJobActByMin = configEngity.IsJobActByMin;
ruleEntity.LastUpdateTime = DateTime.Now;
ruleEntity.UpdateHourSpan = configEngity.UpdateHourSpan;
ruleDAL.Insert(ruleEntity);
}
MemcachedGetFrequencyDAL freqDAL = new MemcachedGetFrequencyDAL();
MemcachedGetFrequencyEntity freqEntity = freqDAL.Select(string.Format("CacheKey='{0}'", key));
if (freqEntity == null)
{
freqEntity = new MemcachedGetFrequencyEntity();
freqEntity.CacheKey = key;
freqEntity.CacheKeyPrefix = cacheKeyPrefix;
freqEntity.DataChange_LastTime = DateTime.Now;
freqEntity.FreMin = configEngity.FreMin;
freqEntity.FreCount = 1;
freqEntity.LastGetDateTime = DateTime.Now;
freqDAL.Insert(freqEntity);
}
}
catch(Exception ex)
{
Logging.HHLogHelperV2.ERRORGlobalException(ex);
}
}