/// <summary> /// 删除搜索历史记录 /// </summary> public ApiResult DeleteHistory(int uid, int lType, long userId) { string memberKey = string.Format(RedisKeyConst.Plan_ExpertHistory, lType, userId);//"history_" + userId + "_" + lType; List <ExpertSearchModel> list = CacheHelper.GetCache <List <ExpertSearchModel> >(memberKey); if (uid > 0) { ExpertSearchModel e1 = list.Where(x => x.UserId == uid && x.lType == lType).FirstOrDefault(); list.Remove(e1); //CacheHelper.WriteCache(memberKey, list, 144000); CacheHelper.AddCache(memberKey, list, 144000); } else { CacheHelper.DeleteCache(memberKey); } return(new ApiResult()); }
/// <summary> /// 插入搜索数据 /// </summary> public ApiResult InsertHotSearch(long uid, int lType, long userId) { //ReturnMessageJson msg = new ReturnMessageJson(); string countsql = string.Format("select count(1) from ExpertHotSearch where UserId ={0} and lType = {1}", uid, lType); int count = Convert.ToInt32(SqlHelper.ExecuteScalar(countsql)); string strsql = ""; if (count > 0) { strsql = @"update ExpertHotSearch set Count=Count+1 where UserId=@UserId and lType=@lType "; } else { strsql = @"insert into ExpertHotSearch(UserId, Count, lType) values(@UserId,1,@lType)"; } SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@UserId", uid), new SqlParameter("@lType", lType) }; int data = SqlHelper.ExecuteNonQuery(strsql, sp); if (data > 0) { List <ExpertSearchModel> list = new List <ExpertSearchModel>(); long MyUserId = userId; string memberKey = string.Format(RedisKeyConst.Plan_ExpertHistory, lType, MyUserId);// "history_" + MyUserId + "_" + lType; list = CacheHelper.GetCache <List <ExpertSearchModel> >(memberKey) ?? new List <ExpertSearchModel>(); UserInfo u = PersonalService.GetUser(uid); ExpertSearchModel e = new ExpertSearchModel(); e.Avater = u.Avater; e.UserId = (int)uid; e.Name = u.NickName; e.lType = lType; e.isFollow = 0; if (list.Count > 0) { ExpertSearchModel e1 = list.Where(x => x.UserId == uid && x.lType == lType).FirstOrDefault(); if (e1 == null) { list.Add(e); } } else { list.Add(e); } // CacheHelper.WriteCache(memberKey, list, 144000); CacheHelper.AddCache(memberKey, list, 144000); return(new ApiResult()); } else { return(new ApiResult(-999, "数据库错误")); } }