/// <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));
}
