/// <summary> /// 查询文章评论后台 /// </summary> /// <param name="context"></param> /// <returns></returns> private string QueryArticleReview(HttpContext context) { if ((!bllReview.WebsiteOwner.Equals(currUserInfo.UserID)) && (!currUserInfo.UserType.Equals(1))) { return("无权访问"); } int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); System.Text.StringBuilder sbWhere = new StringBuilder(string.Format(" WebsiteOwner='{0}' And ReviewType='文章评论'", bllReview.WebsiteOwner)); string keyWord = context.Request["KeyWord"]; if (!string.IsNullOrEmpty(keyWord)) { sbWhere.AppendFormat(" And ReplyContent like '%{0}%'", keyWord); } int totalCount = bllReview.GetCount <ReplyReviewInfo>(sbWhere.ToString()); List <ReplyReviewInfo> data = bllReview.GetLit <ReplyReviewInfo>(pageSize, pageIndex, sbWhere.ToString(), " AutoId DESC"); return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = data })); }
public void ProcessRequest(HttpContext context) { int autoId = int.Parse(context.Request["AutoID"]); string content = context.Request["Context"]; ReviewInfo reviewInfo = bllReview.Get <ReviewInfo>(string.Format("AutoId={0}", autoId)); ReplyReviewInfo replyReview = new ReplyReviewInfo() { ReviewID = Convert.ToInt32(autoId), InsertDate = DateTime.Now, ReplyContent = content, UserId = CurrentUserInfo.UserID, UserName = CurrentUserInfo.LoginName, PraentId = 0, WebSiteOwner = bllReview.WebsiteOwner }; bool isSuccess = bllReview.Add(replyReview); if (isSuccess) { reviewInfo.NumCount++; reviewInfo.ReplyDateTiem = DateTime.Now; if (bllReview.Update(reviewInfo)) { //给回复者加分 int replyCount = bllReview.GetCount <ReplyReviewInfo>(string.Format("ReviewID={0} And UserId='{1}'", autoId, CurrentUserInfo.UserID)); if (replyCount <= 1)//第一次回答才得分 { bllUser.AddUserScoreDetail(CurrentUserInfo.UserID, CommonPlatform.Helper.EnumStringHelper.ToString(ZentCloud.BLLJIMP.Enums.ScoreDefineType.AnswerQuestions), bllUser.WebsiteOwner, null, null); } apiResp.status = true; } else { } } else { } BLLRedis.ClearReviewList(bllReview.WebsiteOwner); context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); }
public void ProcessRequest(HttpContext context) { string autoId = context.Request["AutoID"]; int pageIndex = int.Parse(context.Request["PageIndex"]); int pageSize = int.Parse(context.Request["PageSize"]); List <ReplyReviewInfo> dataList = bllReview.GetLit <ReplyReviewInfo>(pageSize, pageIndex, string.Format(" ReviewID={0} And Status=1", autoId), " AutoId DESC"); foreach (ReplyReviewInfo item in dataList) { UserInfo userInfo = bllUser.GetUserInfo(item.UserId); item.HTNum = bllReview.GetCount <ReviewInfo>(string.Format(" ForeignkeyId='{0}' AND websiteOwner='{1}'", item.UserId, bllReview.WebsiteOwner)); if (userInfo != null) { item.Img = bllUser.GetUserDispalyAvatar(userInfo); item.NickName = userInfo.WXNickname; item.UserName = userInfo.TrueName; } } apiResp.status = true; apiResp.result = dataList; context.Response.Write(Common.JSONHelper.ObjectToJson(apiResp)); }
public void ProcessRequest(HttpContext context) { var commentId = context.Request["commentid"]; var replyId = Convert.ToInt32(context.Request["replyid"]);//回复了评论里的哪个回复 var content = context.Request["content"]; int isHideUserName = Convert.ToInt32(context.Request["isHideUserName"]); currentUserInfo = bllUser.GetCurrentUserInfo(); if (this.currentUserInfo == null) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.UserIsNotLogin; apiResp.msg = "请先登录"; bllUser.ContextResponse(context, apiResp); return; } if (string.IsNullOrWhiteSpace(commentId) || string.IsNullOrWhiteSpace(content)) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.PrimaryKeyIncomplete; bllReview.ContextResponse(context, apiResp); return; } if (bllReview.GetCount <ReviewInfo>(string.Format(" ReviewMainId = {0} ", commentId)) == 0) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.ContentNotFound; bllReview.ContextResponse(context, apiResp); return; } //敏感词检查 BLLFilterWord bllFilterWord = new BLLFilterWord(); string errmsg = ""; if (!bllFilterWord.CheckFilterWord(content, this.bllReview.WebsiteOwner, out errmsg, "0")) { apiResp.msg = errmsg; apiResp.code = (int)BLLJIMP.Enums.APIErrCode.OperateFail; bllReview.ContextResponse(context, apiResp); return; } //添加回复 int reviewId = 0; var addResult = bllReview.AddReview(BLLJIMP.Enums.ReviewTypeKey.CommentReply, commentId, replyId, this.currentUserInfo.UserID, "评论", content, this.bllReview.WebsiteOwner, out reviewId, isHideUserName); if (addResult) { apiResp.status = true; apiResp.result = reviewId.ToString(); if (bllUser.IsTutor(this.currentUserInfo.UserID)) { bllTutor.UpdateAnswers(this.currentUserInfo.UserID); } } else { apiResp.status = false; } bllReview.ContextResponse(context, apiResp); }