public ActionResult AddOrEdit(int blogid = 0)
{
var res = new BloginfoView();
if (blogid > 0)
{
var blogres = BlogHelper.GetModelByKID_Bloginfo(blogid);
res = blogres;
}
return(View(res));
}
public BloginfoView GetBlog(string blogNum)
{
var bloginfoView = new BloginfoView();
try
{
using (var db = new DBHelper())
{
var sql = $"select a.*,b.Content from bloginfo a join blogcontent b on a.BlogNum=b.BloginfoNum where a.BlogNum='{blogNum}' and a.IsDeleted=0 ";
var data = db.ExecuteDataTable(sql);
bloginfoView = ToEntity <BloginfoView>(data);
sql = $"select count(*) from articlepraise where IsDeleted=0 and BlogNum='{blogNum}'";
var count = db.ExecuteScalarInt(sql);
bloginfoView.Start = count;
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex, "BloginfoRepository/GetBlog");
}
return(bloginfoView);
}
public JsonResponse AddPraise([FromBody] JsonRequest model)
{
var res = new Result {
IsSucceed = false
};
try
{
CommentView item = model?.Data.ToString()?.DeserialObject <CommentView>();
if (item == null || string.IsNullOrEmpty(item.BlogNum))
{
return(new JsonResponse {
Code = 1, Msg = "参数不合法"
});
}
var mem = UtilConst.GetLoginOpt(model.Token);
var dic = new Dictionary <string, object>
{
{ nameof(ArticlePraise.MemberId), mem.UserId },
{ nameof(ArticlePraise.BlogNum), item.BlogNum },
{ nameof(ArticlePraise.IsDeleted), 0 }
};
var dodic = new Dictionary <string, object>
{
{ nameof(ArticlePraise.MemberId), mem.UserId },
{ nameof(ArticlePraise.BlogNum), item.BlogNum },
};
var ap = BlogHelper.GetModelByWhere_ArticlePraise(dodic);
var opt = new OpertionUser();
bool isadd = true;//记录点赞还是取消点赞
#region 点赞处理
//取消点赞
if (ap != null && ap.KID > 0)
{
isadd = false;
dodic.Add(nameof(ArticlePraise.IsDeleted), 1);
dodic = UtilConst.AddBaseInfo <ArticlePraise>(dodic, model.Token, false, ref opt);
res = BlogHelper.Update_ArticlePraise(dodic, ap.KID, opt);
}
//点赞
else
{
dodic.Add(nameof(ArticlePraise.IpAddress), GetIP());
dodic = UtilConst.AddBaseInfo <ArticlePraise>(dodic, model.Token, true, ref opt);
res = BlogHelper.Add_ArticlePraise(dodic, opt);
}
#endregion
#region 处理list 和 item 缓存
Task.Run(() =>
{
if (res.IsSucceed)
{
string key = $"{CJJ.Blog.Apiv2.Models.ConfigUtil.BlogItemCacheKeyPrefix}{item.BlogNum}";
BloginfoView bloginfoView = CacheHelper.GetCacheItem(key)?.ToString()?.DeserialObject <BloginfoView>();
bloginfoView.Start += isadd ? 1 : -1;
CacheHelper.AddCacheItem(key, bloginfoView.SerializObject(), DateTime.Now.AddDays(2), Cache.NoSlidingExpiration, CacheItemPriority.High);
string alllistkey = ConfigUtil.BlogListCacheKey;
string allinfo = CacheHelper.GetCacheItem(alllistkey)?.ToString();
List <Bloginfo> cachelist = allinfo?.DeserialObjectToList <Bloginfo>();
Bloginfo info = cachelist.FirstOrDefault(x => x.BlogNum == item.BlogNum);
if (cachelist != null && cachelist.Count > 0 && info != null && info.KID > 0)
{
cachelist.FirstOrDefault(x => x.BlogNum == item.BlogNum).Start += isadd ? 1 : -1;
CacheHelper.AddCacheItem(alllistkey, cachelist.SerializObject(), DateTime.Now.AddDays(2), Cache.NoSlidingExpiration, CacheItemPriority.High);
}
}
});
#endregion
return(new JsonResponse {
Code = res.IsSucceed ? 0 : 1, Data = res
});
}
catch (Exception ex)
{
LogHelper.WriteLog(ex, "BlogController/AddPraise");
return(new JsonResponse {
Code = 1, Msg = "程序好像开小差了" + ex.Message
});
}
}
public JsonResponse GetItemBlog([FromBody] BaseViewModel model)
{
try
{
if (string.IsNullOrEmpty(model.Num))
{
return(new JsonResponse {
Code = 1, Msg = "参数不合法"
});
}
string key = $"{CJJ.Blog.Apiv2.Models.ConfigUtil.BlogItemCacheKeyPrefix}{model.Num}";
BloginfoView bloginfoView = CacheHelper.GetCacheItem(key)?.ToString()?.DeserialObject <BloginfoView>();
if (bloginfoView == null)
{
bloginfoView = BlogHelper.GetModelByNum(model.Num);
CacheHelper.AddCacheItem(key, bloginfoView.SerializObject(), DateTime.Now.AddDays(2), Cache.NoSlidingExpiration, CacheItemPriority.High);
}
bloginfoView.Views += 1;
#region 处理list 和 item 缓存
Task.Run(() =>
{
//CacheHelper.DelCacheItem(key);
CacheHelper.AddCacheItem(key, bloginfoView.SerializObject(), DateTime.Now.AddDays(2), Cache.NoSlidingExpiration, CacheItemPriority.High);
string alllistkey = ConfigUtil.BlogListCacheKey;
string allinfo = CacheHelper.GetCacheItem(alllistkey)?.ToString();
List <Bloginfo> cachelist = allinfo?.DeserialObjectToList <Bloginfo>();
Bloginfo info = cachelist.FirstOrDefault(x => x.BlogNum == model.Num);
if (cachelist != null && cachelist.Count > 0 && info != null && info.KID > 0)
{
cachelist.FirstOrDefault(x => x.BlogNum == model.Num).Views += 1;
//CacheHelper.DelCacheItem(alllistkey);
CacheHelper.AddCacheItem(alllistkey, cachelist.SerializObject(), DateTime.Now.AddDays(2), Cache.NoSlidingExpiration, CacheItemPriority.High);
}
});
#endregion
#region 异步添加访问次数,统计访问地址信息
Task.Run(() =>
{
try
{
var dic = new Dictionary <string, object>()
{
{ nameof(Bloginfo.BlogNum), model.Num },
{ nameof(Bloginfo.IsDeleted), 0 }
};
var bloginfomodel = BlogHelper.GetModelByWhere_Bloginfo(dic);
BlogHelper.UpdateNums_Bloginfo(nameof(Bloginfo.Views), 1, dic,
new Service.Models.View.OpertionUser());
var adddic = new Dictionary <string, object>()
{
{ nameof(Access.AccessType), 1 },
{ nameof(Access.IpAddress), GetIP() },
{ nameof(Access.BlogName), bloginfoView.Title },
{ nameof(Access.BlogNum), model.Num },
{ nameof(Access.CreateTime), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") },
{ nameof(Access.CreateUserId), 1 },
{ nameof(Access.CreateUserName), "system" }
};
BlogHelper.Add_Access(adddic, new OpertionUser {
});
}
catch (Exception ex)
{
LogHelper.WriteLog(ex, "BlogController/GetItemBlog 访问次数");
}
});
#endregion
return(new JsonResponse {
Code = bloginfoView != null ? 0 : 1, Data = bloginfoView != null ? bloginfoView : null
});
}
catch (Exception ex)
{
LogHelper.WriteLog(ex, "BlogController/GetListBlog");
return(new JsonResponse {
Code = 1, Msg = "程序好像开小差了" + ex.Message
});
}
}
