public static int CachePreheatingMACAddressByUser(IRedisClient redisClient, string userId) { int result = 0; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryCode, "MacAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldDeletionStateCode, 0)); string key = "MAC:" + userId; BaseParameterManager parameterManager = new BaseParameterManager(); parameterManager.SelectFields = BaseParameterEntity.FieldParameterContent; using (IDataReader dataReader = parameterManager.ExecuteReader(parameters)) { while (dataReader.Read()) { string macAddress = dataReader[BaseParameterEntity.FieldParameterContent].ToString().ToLower(); redisClient.AddItemToSet(key, macAddress); result++; } dataReader.Close(); redisClient.ExpireEntryAt(key, DateTime.Now.AddMonths(3)); } return(result); }
/// <summary> /// 缓存预热,强制重新缓存 /// </summary> /// <returns>影响行数</returns> public static int CachePreheatingMacAddress() { var result = 0; var parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryCode, "MacAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldDeleted, 0)); // 把所有的数据都缓存起来的代码 var manager = new BaseParameterManager(); var dataReader = manager.ExecuteReader(parameters); if (dataReader != null && !dataReader.IsClosed) { while (dataReader.Read()) { var key = "MAC:" + dataReader[BaseParameterEntity.FieldParameterId]; var macAddress = dataReader[BaseParameterEntity.FieldParameterContent].ToString().ToLower(); CacheUtil.Set(key, macAddress); result++; if (result % 500 == 0) { Console.WriteLine(result + " : " + macAddress); } } dataReader.Close(); } return(result); }
/// <summary> /// 缓存预热,强制重新缓存 /// </summary> /// <returns>影响行数</returns> public static int CachePreheatingMACAddress() { int result = 0; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryCode, "MacAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldDeletionStateCode, 0)); // 把所有的数据都缓存起来的代码 BaseParameterManager manager = new BaseParameterManager(); using (var redisClient = PooledRedisHelper.GetClient()) { using (IDataReader dataReader = manager.ExecuteReader(parameters)) { while (dataReader.Read()) { string key = "MAC:" + dataReader[BaseParameterEntity.FieldParameterId].ToString(); string macAddress = dataReader[BaseParameterEntity.FieldParameterContent].ToString().ToLower(); redisClient.AddItemToSet(key, macAddress); redisClient.ExpireEntryAt(key, DateTime.Now.AddMonths(3)); result++; System.Console.WriteLine(result.ToString() + " : " + macAddress); } dataReader.Close(); } } return(result); }
/// <summary> /// 根据用户编号删除预热的IP /// </summary> /// <param name="userId"></param> /// <returns></returns> public static int CachePreheatingIpAddressByUser(string userId) { var result = 0; var parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId), new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryCode, "IPAddress"), new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1), new KeyValuePair <string, object>(BaseParameterEntity.FieldDeleted, 0) }; var key = "IP:" + userId; var parameterManager = new BaseParameterManager { SelectFields = BaseParameterEntity.FieldParameterContent }; var dataReader = parameterManager.ExecuteReader(parameters); if (dataReader != null && !dataReader.IsClosed) { while (dataReader.Read()) { var ipAddress = dataReader[BaseParameterEntity.FieldParameterContent].ToString().ToLower(); CacheUtil.Set(key, ipAddress); result++; } dataReader.Close(); } return(result); }