/// <summary> /// 查询报名数据 /// </summary> private string Query(HttpContext context) { string activityId = context.Request["ActivityID"]; int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); string keyWord = context.Request["SearchTitle"]; string linkName = context.Request["LinkName"]; string status = context.Request["Status"]; string source = context.Request["Source"]; string paymentStatus = context.Request["PaymentStatus"]; string dealStatus = context.Request["DealStatus"]; string orderBy = " InsertDate DESC"; var strWhere = string.Format("ActivityID='{0}' AND IsDelete = 0 ", activityId); if (!string.IsNullOrEmpty(keyWord)) { strWhere += "And Name like '%" + keyWord + "%'"; } if (!string.IsNullOrEmpty(linkName)) { strWhere += string.Format(" AND SpreadUserID='{0}'", linkName); } if (!string.IsNullOrWhiteSpace(status)) { strWhere += string.Format(" AND Status in ({0}) ", status); } if (!string.IsNullOrWhiteSpace(paymentStatus)) { strWhere += string.Format(" AND PaymentStatus ={0}", paymentStatus); } if (!string.IsNullOrWhiteSpace(dealStatus)) { strWhere += string.Format(" AND Status ={0}", dealStatus); } if (!string.IsNullOrWhiteSpace(source)) { switch (source) { case "0": strWhere += string.Format(" AND (SpreadUserID='' or SpreadUserID is null) ", status); break; case "1": strWhere += string.Format(" AND SpreadUserID!=''", status); break; default: break; } } List <ActivityDataInfo> data = bllActivity.GetLit <ActivityDataInfo>(pageSize, pageIndex, strWhere, orderBy); var webSiteInfo = bllActivity.GetWebsiteInfoModelFromDataBase(); for (int i = 0; i < data.Count; i++) { int rcode = 0; if (int.TryParse(data[i].DistributionOffLineRecommendCode, out rcode)) { var rUser = bllUser.GetUserInfoByAutoID(rcode); if (rUser != null) { if (rUser.UserID == bllActivity.WebsiteOwner) { data[i].DistributionOffLineRecommendName = webSiteInfo.WebsiteName; } else { data[i].DistributionOffLineRecommendName = bllUser.GetUserDispalyName(rUser); //如果是当前站点所有者,则显示站点的名称 if (bllActivity.WebsiteOwner == rUser.UserID) { data[i].DistributionOffLineRecommendName = bllActivity.GetWebsiteInfoModel().WebsiteName; } } } } } int totalCount = bllActivity.GetCount <ActivityDataInfo>(strWhere); return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = data })); }