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