/// <summary> /// 将数据库数据导入到redis /// </summary> /// <typeparam name="T">表类型</typeparam> /// <param name="key">表的model类名</param> /// <param name="value">表记录</param> /// <param name="relationColumns">表外键</param> public void ImportDataToSet <T>(string key, List <T> value, string[] relationColumns, int recordCount) where T : class, new() { if (value.Count() > 0) { ArrayList arrayList = new ArrayList(); RedisValue[] redisValues = new RedisValue[] { }; PropertyInfo property; Type classType = typeof(T); //表属性 PropertyInfo[] propertyInfoArray = classType.GetProperties(BindingFlags.Public | BindingFlags.Instance | BindingFlags.IgnoreCase); string RedisConditionKeys = "";//查询条件keys int k = 0; Dictionary <string, object> recordDic = null; foreach (var item in value) { //循环表记录 string RedisConditionValus = ""; //查询条件values //给RedisConditionValus字段赋值 property = propertyInfoArray.FirstOrDefault(t => t.Name.ToUpper() == "HOSPITALID"); if (property != null) { object propertyValue = property.GetValue(item); if (propertyValue != null) { RedisConditionValus += propertyValue.ToString() + ","; } if (k == 0) { RedisConditionKeys += "HospitalId,"; } } property = propertyInfoArray.FirstOrDefault(t => t.Name.ToUpper() == "NAME"); if (property != null) { object propertyValue = property.GetValue(item); if (propertyValue != null) { RedisConditionValus += propertyValue.ToString() + ","; } if (k == 0) { RedisConditionKeys += "Name,"; } } property = propertyInfoArray.FirstOrDefault(t => t.Name.ToUpper() == "CODE"); if (property != null) { object propertyValue = property.GetValue(item); if (propertyValue != null) { RedisConditionValus += propertyValue.ToString() + ","; } if (k == 0) { RedisConditionKeys += "Code,"; } } foreach (string relationColumn in relationColumns) { property = propertyInfoArray.FirstOrDefault(t => t.Name.ToUpper() == relationColumn.ToUpper()); if (property != null) { object propertyValue = property.GetValue(item); if (propertyValue != null) { RedisConditionValus += propertyValue.ToString() + ","; } if (k == 0) { RedisConditionKeys += relationColumn + ","; } } } property = propertyInfoArray.FirstOrDefault(t => t.Name.ToUpper() == "ISACTIVE"); if (property != null) { object propertyValue = property.GetValue(item); if (propertyValue != null) { RedisConditionValus += propertyValue.ToString().ToLower() + ","; } if (k == 0) { RedisConditionKeys += "IsActive"; } } if (RedisConditionValus.EndsWith(",")) { RedisConditionValus = RedisConditionValus.Substring(0, RedisConditionValus.Length - 1); } property = classType.GetProperty("RedisConditionValus", BindingFlags.Public | BindingFlags.Instance | BindingFlags.IgnoreCase); property.SetValue(item, RedisConditionValus); //去掉带图片的字段 recordDic = new Dictionary <string, object>(); string guid = null; foreach (PropertyInfo propertyInfo in propertyInfoArray) { if (propertyInfo.PropertyType.FullName == "System.Byte[]") { continue; } if (propertyInfo.Name == "GUID") { guid = propertyInfo.GetValue(item).ToString(); } recordDic.Add(propertyInfo.Name, propertyInfo.GetValue(item)); } //string rowsJson = Newtonsoft.Json.JsonConvert.SerializeObject(recordDic); //RedisWriteHelper.SetHash(key, guid, rowsJson); RedisValue redisValue = (RedisValue)JsonSerializer.SerializeToString(recordDic); arrayList.Add(redisValue); k++; } if (arrayList.Count > 30000) { ArrayList arrayListPartOne = arrayList.GetRange(0, 20000); ArrayList arrayListPartTwo = arrayList.GetRange(20000, arrayList.Count - 20000); redisValues = (RedisValue[])arrayListPartOne.ToArray(typeof(RedisValue)); RedisWriteHelper.SetMutiAdd(key, redisValues); redisValues = (RedisValue[])arrayListPartTwo.ToArray(typeof(RedisValue)); RedisWriteHelper.SetMutiAdd(key, redisValues); } else { redisValues = (RedisValue[])arrayList.ToArray(typeof(RedisValue)); RedisWriteHelper.SetMutiAdd(key, redisValues); } if (RedisConditionKeys != "") { if (RedisConditionKeys.EndsWith(",")) { RedisConditionKeys = RedisConditionKeys.Substring(0, RedisConditionKeys.Length - 1); } RedisWriteHelper.SetHash <T>(RedisDefaultKey, key, RedisConditionKeys); } } }