public ActionResult MessageIng(string msg) { MessageServices msgServices = new MessageServices(); JsonResult <string> result = new JsonResult <string>(); string userip = UserAddress.GetUserAddress(); //10分钟内,同一ip只可留言一次 var newMsg = msgServices.query.Where(q => q.user_ip == userip).OrderByDescending(q => q.msg_time).FirstOrDefault(); if (newMsg != null && ((TimeSpan)(DateTime.Now - newMsg.msg_time)).TotalMinutes < 10) { result.Fail("已留言," + (10 - ((TimeSpan)(DateTime.Now - newMsg.msg_time)).TotalMinutes).ToString("F0") + "分钟内无法再次留言"); return(Json(result, JsonRequestBehavior.AllowGet)); } message add = new message(); add.is_del = false; add.msg_time = DateTime.Now; add.content = msg; add.user_ip = userip; if (msgServices.Add(add) > 0) { result.Success(); } else { result.Fail("留言失败"); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ArtReplyMsg(int artreplyid, string artreplymsg) { JsonResult <string> result = new JsonResult <string>(); ArticleCommentServicese commnetServices = new ArticleCommentServicese(); if (artreplyid > 0) { article_comment add = new article_comment(); add.add_time = DateTime.Now; add.is_del = false; add.is_reply = false; add.content = artreplymsg; add.reply_id = null; add.article_id = artreplyid; if (commnetServices.Add(add) > 0) { result.Success(); } else { result.Fail("无法进行回复"); } } else { result.Fail("该文章不存在,无法回复"); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 评论回复 /// </summary> /// <param name="msgid"></param> /// <param name="replymsg"></param> /// <returns></returns> public ActionResult ReplyMsg(int msgid, string replymsg) { JsonResult <string> result = new JsonResult <string>(); ArticleCommentServicese commnetServices = new ArticleCommentServicese(); var msg = commnetServices.query.Where(q => q.id == msgid).Where(q => q.is_del != true).FirstOrDefault(); if (msg != null) { article_comment add = new article_comment(); add.add_time = DateTime.Now; add.is_del = false; add.is_reply = true; add.content = replymsg; add.reply_id = msgid; add.article_id = msg.article_id; if (commnetServices.Add(add) > 0) { result.Success(); } else { result.Fail("无法进行回复"); } } else { result.Fail("该评论不存在,无法回复"); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetMoreArticle(int skip, int num) { JsonResult <List <ArticlListModel> > result = new JsonResult <List <ArticlListModel> >(); List <ArticlListModel> articls = new List <ArticlListModel>(); var list = articleDB.query.Where(q => q.is_show == true).OrderByDescending(q => q.add_time).Skip(skip).Take(num).ToList(); if (list.Count() > 0) { foreach (var item in list) { articls.Add(new ArticlListModel() { ID = item.id, AddTime = item.add_time.Value.ToString("yyyy-MM-dd"), Abstract = item.@abstract, BrowseNum = (int)item.browse_num, Title = item.title, TypeName = item.article_type.type_name, CommentNum = item.article_comment.Where(q => q.is_del != true).Count(), Image = item.image, }); } result.Success(articls); } else { result.Fail("没有更多的文章啦!"); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult OCRImg(string imgPath = null) { //"img/{size}/t{imageType}t{yearMonth}-{id}.{format}" var result = new JsonResult <object>(); if (string.IsNullOrEmpty(imgPath)) { result.Fail(); } else { var physicalPath = Server.MapPath("~/storage/images/2017/"); var pj = imgPath.Split('/'); var p3 = pj[3]; var pDate = p3.Split('-')[0]; var imgKey = p3.Substring(p3.IndexOf('-') + 1); var imgFix = imgKey.Substring(imgKey.IndexOf('.') + 1).ToLower(); ImageFormat imageFormat = imgFix == "jpg" ? ImageFormat.Jpeg : ImageFormat.Png; physicalPath = physicalPath + pDate.Substring(pDate.Length - 2) + "/" + imgKey.Substring(0, imgKey.IndexOf('.')) + "/" + "Full" + imgKey.Substring(imgKey.IndexOf('.')); var imgDatas = OcrImgToDataServer.GetData(physicalPath); result.Succeed(); result.Value = new { Data = imgDatas.Item1, ListData = imgDatas.Item2 }; } return(result); }
/// <summary> /// 点赞、踩 /// </summary> /// <param name="msgid"></param> /// <param name="is_up"></param> /// <returns></returns> public ActionResult LikeMsg(int msgid, bool is_up) { JsonResult <string> result = new JsonResult <string>(); CommentLikeServices likeservices = new CommentLikeServices(); var userAddress = UserAddress.GetUserAddress(); var lieks = likeservices.query.Where(q => q.comment_id == msgid).ToList(); var like = likeservices.query.Where(q => q.comment_id == msgid).Where(q => q.user_ip == userAddress).FirstOrDefault(); if (like != null) { if (like.is_like == is_up) { result.Fail(""); } else { like.is_like = is_up; if (likeservices.Update(like) > 0) { result.Success(); } else { result.Fail(""); } } } else { comment_like add = new comment_like(); add.is_like = is_up; //add.user_id add.user_ip = userAddress; add.add_time = DateTime.Now; add.comment_id = msgid; if (likeservices.Add(add) > 0) { result.Success(); } else { result.Fail(""); } } return(Json(result, JsonRequestBehavior.AllowGet)); }