/// <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 pageIndex = int.Parse(context.Request["PageIndex"]); int pageSize = int.Parse(context.Request["PageSize"]); string reviewTitle = context.Request["Title"]; string type = context.Request["type"]; string haveReply = context.Request["HaveReply"];//是否有回复 string sort = context.Request["Sort"]; StringBuilder sbWhere = new StringBuilder(); StringBuilder sbOrderBy = new StringBuilder(); sbWhere.AppendFormat(" ReviewType='话题' AND websiteOwner='{0}'", bllReview.WebsiteOwner); if (!string.IsNullOrEmpty(reviewTitle)) { sbWhere.AppendFormat(" AND ReviewTitle like '%{0}%'", reviewTitle); } if (!string.IsNullOrEmpty(type)) { sbWhere.AppendFormat(" AND CategoryType LIKE '%{0}%'", type); } if (!string.IsNullOrEmpty(haveReply)) { sbWhere.Append(" AND NumCount>0"); } sbOrderBy.Append(" AutoId DESC "); if (sort.Equals("Newhf")) { sbOrderBy.Clear(); sbOrderBy.Append(" ReplyDateTiem DESC"); } if (sort.Equals("Mosthf")) { sbOrderBy.Clear(); sbOrderBy.Append(" NumCount DESC"); } if (sort.Equals("Mosthp")) { sbOrderBy.Clear(); sbOrderBy.Append(" PraiseNum DESC, ReplyDateTiem DESC"); } List <ReviewInfo> list = bllReview.GetLit <ReviewInfo>(pageSize, pageIndex, sbWhere.ToString(), sbOrderBy.ToString()); apiResp.status = true; apiResp.result = list; 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)); }