public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int pageIndex = !string.IsNullOrEmpty(context.Request["pageindex"]) ? int.Parse(context.Request["pageindex"]) : 1; int pageSize = !string.IsNullOrEmpty(context.Request["pagesize"]) ? int.Parse(context.Request["pagesize"]) : 10; string keyWord = context.Request["keyword"]; string sort = context.Request["activity_sort"]; string cateId = context.Request["category_id"]; string column = context.Request["column"]; string is_forward = context.Request["is_forward"]; string isFee = context.Request["isFee"]; bool myActivity = false;//查看已经报过名的活动 JuActivityInfoList data = new JuActivityInfoList(); int total = 0; data.list = GetActivityData(pageSize, pageIndex, cateId, keyWord, myActivity, sort, out total, column, is_forward == "1", isFee); data.totalcount = total; context.Response.Write(ZentCloud.Common.JSONHelper.ObjectToJson(data)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int pageIndex = !string.IsNullOrEmpty(context.Request["pageindex"]) ? int.Parse(context.Request["pageindex"]) : 1; int pageSize = !string.IsNullOrEmpty(context.Request["pagesize"]) ? int.Parse(context.Request["pagesize"]) : 10; string keyWord = context.Request["keyword"]; string sort = context.Request["activity_sort"]; string cateId = context.Request["category_id"]; bool myActivity = false; //查看已经报过名的活动 StringBuilder sbWhere = new StringBuilder(); string orderBy = ""; //默认排序 switch (sort) { case "activity_start_time": orderBy = " ActivityStartDate DESC"; break; case "activity_signcount ": orderBy = " SignUpCount DESC"; break; default: orderBy = " Sort DESC"; break; } sbWhere.AppendFormat(" ArticleType='activity' AND IsDelete=0 AND WebsiteOwner='{0}'", bll.WebsiteOwner); if (!string.IsNullOrEmpty(cateId)) { sbWhere.AppendFormat(" And CategoryId={0}", cateId); } if (!string.IsNullOrEmpty(keyWord)) { sbWhere.AppendFormat(" And (ActivityName like'%{0}%' Or ActivityAddress like'%{0}%')", keyWord); } if (myActivity) { sbWhere.AppendFormat(" And SignUpActivityID in(select ActivityID from ZCJ_ActivityDataInfo where UserId='{0}')", bll.GetCurrUserID()); } sbWhere.Append(" AND IsSys = 0 "); JuActivityInfoList data = new JuActivityInfoList(); data.list = new List <RequestModel>(); data.totalcount = bll.GetCount <JuActivityInfo>(sbWhere.ToString()); var juActivityData = bll.GetLit <JuActivityInfo>(pageSize, pageIndex, sbWhere.ToString(), orderBy); foreach (JuActivityInfo p in juActivityData) { RequestModel requestModel = new RequestModel(); requestModel.activity_id = p.JuActivityID; requestModel.activity_name = p.ActivityName; if (p.ActivityStartDate != null) { requestModel.activity_start_time = bll.GetTimeStamp((DateTime)p.ActivityStartDate); } requestModel.activity_address = p.ActivityAddress; requestModel.category_name = p.CategoryName; requestModel.activity_img_url = bll.GetImgUrl(p.ThumbnailsPath); requestModel.activity_pv = p.PV; requestModel.activity_signcount = p.SignUpCount; requestModel.activity_score = p.ActivityIntegral; if (!string.IsNullOrEmpty(p.Tags)) { requestModel.activity_tags = p.Tags.Split(',').Take(5).ToList(); } if (p.IsHide == 1) { requestModel.activity_status = 1; } if ((p.MaxSignUpTotalCount > 0) && (p.SignUpTotalCount >= p.MaxSignUpTotalCount)) { requestModel.activity_status = 2; } data.list.Add(requestModel); } context.Response.Write(ZentCloud.Common.JSONHelper.ObjectToJson(data)); }