/// <summary> /// 根据一条数据记录创建实体对象 /// </summary> public static MemcachedUpdateSetConfigEntity CreateEntity(DataRow dr) { MemcachedUpdateSetConfigEntity ent = new MemcachedUpdateSetConfigEntity(); if (dr["CacheKeyPrefix"] != DBNull.Value) { ent.CacheKeyPrefix = (string)dr["CacheKeyPrefix"]; } if (dr["UpdateHourSpan"] != DBNull.Value) { ent.UpdateHourSpan = int.Parse(dr["UpdateHourSpan"].ToString()); } if (dr["IsJobActByMin"] != DBNull.Value) { ent.IsJobActByMin = int.Parse(dr["IsJobActByMin"].ToString()); } if (dr["FreMin"] != DBNull.Value) { ent.FreMin = int.Parse(dr["FreMin"].ToString()); } if (dr["DataChange_LastTime"] != DBNull.Value) { ent.DataChange_LastTime = DateTime.Parse(dr["DataChange_LastTime"].ToString()); } return(ent); }
/// <summary> /// 根据一条数据记录创建实体对象 /// </summary> public static MemcachedUpdateSetConfigEntity CreateEntity(DataRow dr) { MemcachedUpdateSetConfigEntity ent = new MemcachedUpdateSetConfigEntity(); if(dr["CacheKeyPrefix"] != DBNull.Value)ent.CacheKeyPrefix = (string)dr["CacheKeyPrefix"]; if(dr["UpdateHourSpan"] != DBNull.Value)ent.UpdateHourSpan = int.Parse(dr["UpdateHourSpan"].ToString()); if(dr["IsJobActByMin"] != DBNull.Value)ent.IsJobActByMin = int.Parse(dr["IsJobActByMin"].ToString()); if(dr["FreMin"] != DBNull.Value)ent.FreMin = int.Parse(dr["FreMin"].ToString()); if(dr["DataChange_LastTime"] != DBNull.Value)ent.DataChange_LastTime = DateTime.Parse(dr["DataChange_LastTime"].ToString()); return ent; }
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 List <MemcachedUpdateSetConfigEntity> GetAll() { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "select * from MemcachedUpdateSetConfig with(nolock)"; cmd.CommandType = System.Data.CommandType.Text; DataSet ds = DB.ExecuteDataSet(cmd); List <MemcachedUpdateSetConfigEntity> list = new List <MemcachedUpdateSetConfigEntity>(); foreach (DataRow item in ds.Tables[0].Rows) { list.Add(MemcachedUpdateSetConfigEntity.CreateEntity(item)); } return(list); }
/// <summary> /// 根据条件获取一个实体对象 /// </summary> public MemcachedUpdateSetConfigEntity Select(string where) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "select * from MemcachedUpdateSetConfig with(nolock) where " + where; cmd.CommandType = System.Data.CommandType.Text; DataSet ds = DB.ExecuteDataSet(cmd); if (ds.Tables[0].Rows.Count == 0) { return(null); } DataRow dr = ds.Tables[0].Rows[0]; return(MemcachedUpdateSetConfigEntity.CreateEntity(dr)); }
/// <summary> /// 根据主键获取一个实体对象 /// </summary> public MemcachedUpdateSetConfigEntity SelectKey(string CacheKeyPrefix) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "select * from MemcachedUpdateSetConfig with(nolock) where CacheKeyPrefix=@CacheKeyPrefix"; cmd.CommandType = System.Data.CommandType.Text; DB.AddInParameter(cmd, "CacheKeyPrefix", DbType.AnsiString, CacheKeyPrefix); DataSet ds = DB.ExecuteDataSet(cmd); if (ds.Tables[0].Rows.Count == 0) { return(null); } DataRow dr = ds.Tables[0].Rows[0]; return(MemcachedUpdateSetConfigEntity.CreateEntity(dr)); }
public bool Update(MemcachedUpdateSetConfigEntity entity) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "spA_MemcachedUpdateSetConfig_u"; cmd.CommandType = System.Data.CommandType.StoredProcedure; if (entity.CacheKeyPrefix != null) { DB.AddInParameter(cmd, "@CacheKeyPrefix", DbType.AnsiString, entity.CacheKeyPrefix); } DB.AddInParameter(cmd, "@UpdateHourSpan", DbType.Int32, entity.UpdateHourSpan); DB.AddInParameter(cmd, "@IsJobActByMin", DbType.Int32, entity.IsJobActByMin); DB.AddInParameter(cmd, "@FreMin", DbType.Int32, entity.FreMin); if (entity.DataChange_LastTime.Year != 1) { DB.AddInParameter(cmd, "@DataChange_LastTime", DbType.DateTime, entity.DataChange_LastTime); } return(DB.ExecuteNonQuery(cmd) == 0 ? true : false); }
public bool Update(MemcachedUpdateSetConfigEntity entity) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "spA_MemcachedUpdateSetConfig_u"; cmd.CommandType = System.Data.CommandType.StoredProcedure; if (entity.CacheKeyPrefix != null) DB.AddInParameter(cmd, "@CacheKeyPrefix", DbType.AnsiString, entity.CacheKeyPrefix); DB.AddInParameter(cmd, "@UpdateHourSpan", DbType.Int32, entity.UpdateHourSpan); DB.AddInParameter(cmd, "@IsJobActByMin", DbType.Int32, entity.IsJobActByMin); DB.AddInParameter(cmd, "@FreMin", DbType.Int32, entity.FreMin); if (entity.DataChange_LastTime.Year != 1) DB.AddInParameter(cmd, "@DataChange_LastTime", DbType.DateTime, entity.DataChange_LastTime); return DB.ExecuteNonQuery(cmd) == 0 ? true : false; }
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); } }