private string QueryActivity(HttpContext context) { int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); string activityName = context.Request["ActivityName"]; string activityId = context.Request["ActivityId"]; System.Text.StringBuilder sbWhere = new System.Text.StringBuilder(string.Format("IsDelete = 0 And WebsiteOwner='{0}'", bllUser.WebsiteOwner)); if (!string.IsNullOrEmpty(activityName)) { sbWhere.AppendFormat("And ActivityName like '%{0}%'", activityName);; } if (!string.IsNullOrEmpty(activityId)) { sbWhere.AppendFormat("And ActivityID ='{0}'", activityId);; } List <ActivityInfo> dataList = bllActivity.GetLit <ActivityInfo>(pageSize, pageIndex, sbWhere.ToString(), "ActivityStatus DESC,ActivityID DESC"); int totalCount = bllActivity.GetCount <ActivityInfo>(sbWhere.ToString()); return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = dataList })); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; ResponseMessage resp = new ResponseMessage(); try { if (string.IsNullOrEmpty(context.Request["activityid"])) { resp.Status = -1; resp.Message = "活动ID不能为空"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } if (string.IsNullOrEmpty(context.Request["sortfield"])) { resp.Status = -1; resp.Message = "排序字段不能为空"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } if (string.IsNullOrEmpty(context.Request["count"])) { resp.Status = -1; resp.Message = "获取数量不能为空"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } BLLJIMP.BLLActivity bll = new BLLJIMP.BLLActivity(""); int activityid; string sortfield = context.Request["sortfield"]; int count; //检查有效性 if (!int.TryParse(context.Request["activityid"], out activityid)) { resp.Status = -1; resp.Message = "活动ID错误"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } if (!int.TryParse(context.Request["count"], out count)) { resp.Status = -1; resp.Message = "获取数量错误"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } //筛选活动id范围 if (bll.GetCount <GameActivityQueryLimit>(string.Format("ActivityID={0}", activityid)) > 0) { List <ActivityDataInfo> dataList = bll.GetLit <ActivityDataInfo>(count, 1, string.Format("ActivityID='{0}' And IsDelete !=1", activityid), string.Format(" CAST({0} as INTEGER) DESC", sortfield)); for (int i = 0; i < dataList.Count; i++) { dataList[i].WebsiteOwner = null; } context.Response.Write(Common.JSONHelper.ObjectToJson(dataList)); return; } else { resp.Status = -1; resp.Message = "不允许查询的活动"; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } } catch (Exception ex) { resp.Status = -1; resp.Message = ex.Message; context.Response.Write(Common.JSONHelper.ObjectToJson(resp)); return; } }
/// <summary> /// 手动添加报名数据 /// </summary> /// <param name="context"></param> /// <returns></returns> private string Add(HttpContext context) { string autoIds = context.Request["Ids"]; string activityId = context.Request["ActivityID"]; int successCount = 0; foreach (var autoId in autoIds.Split(',')) { UserInfo userInfo = bllUser.GetUserInfoByAutoID(int.Parse(autoId)); if (bllActivity.GetCount <ActivityDataInfo>(string.Format(" ActivityID={0} And IsDelete=0 And UserId='{1}'", activityId, userInfo.UserID)) > 0) { resp.Msg = string.Format("{0}已经报过名了,不需要重复报名", userInfo.TrueName); return(Common.JSONHelper.ObjectToJson(resp)); } ActivityDataInfo model = new ActivityDataInfo(); var newActivityUId = 1001; var lastActivityDataInfo = bllActivity.Get <ActivityDataInfo>(string.Format("ActivityID='{0}' order by UID DESC", activityId)); if (lastActivityDataInfo != null) { newActivityUId = lastActivityDataInfo.UID + 1; } model.ActivityID = activityId; model.UID = newActivityUId; model.InsertDate = DateTime.Now; model.WebsiteOwner = bllActivity.WebsiteOwner; model.SpreadUserID = "system"; #region 自动补充信息 model.WeixinOpenID = userInfo.WXOpenId; model.UserId = userInfo.UserID; if (!string.IsNullOrEmpty(userInfo.TrueName)) { model.Name = userInfo.TrueName; } else { model.Name = "系统添加"; } if (!string.IsNullOrEmpty(userInfo.Phone)) { model.Phone = userInfo.Phone; } if (string.IsNullOrEmpty(model.Phone)) { resp.Msg = string.Format("手机号不能为空"); return(Common.JSONHelper.ObjectToJson(resp)); } var fieldMappingList = bllActivity.GetActivityFieldMappingList(activityId); Type type = model.GetType(); if (!string.IsNullOrEmpty(userInfo.Company)) { if (fieldMappingList.Where(p => p.MappingName.Contains("公司")).Count() > 0) { PropertyInfo propertyInfo = type.GetProperty("K" + fieldMappingList.Where(p => p.MappingName.Contains("公司")).First().ExFieldIndex.ToString()); propertyInfo.SetValue(model, userInfo.Company, null); } } if (!string.IsNullOrEmpty(userInfo.Postion)) { if (fieldMappingList.Where(p => p.MappingName.Contains("职位")).Count() > 0) { PropertyInfo propertyInfo = type.GetProperty("K" + fieldMappingList.Where(p => p.MappingName.Contains("职位")).First().ExFieldIndex.ToString()); propertyInfo.SetValue(model, userInfo.Postion, null); } } if (!string.IsNullOrEmpty(userInfo.Email)) { if (fieldMappingList.Where(p => p.MappingName.Contains("邮箱")).Count() > 0) { PropertyInfo propertyInfo = type.GetProperty("K" + fieldMappingList.Where(p => p.MappingName.Contains("邮箱")).First().ExFieldIndex.ToString()); propertyInfo.SetValue(model, userInfo.Email, null); } } #endregion if (bllActivity.Add(model)) { successCount++; resp.Status = 1; } else { resp.Msg = "添加失败"; return(Common.JSONHelper.ObjectToJson(resp)); } } resp.ExInt = successCount; return(Common.JSONHelper.ObjectToJson(resp)); }
public void ProcessRequest(HttpContext context) { try { string activityId = context.Request["activity_id"]; 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"]; if (string.IsNullOrEmpty(activityId)) { resp.errcode = (int)BLLJIMP.Enums.APIErrCode.IsNotFound; resp.errmsg = "activity_id 为必填项,请检查"; context.Response.Write(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); return; } JuActivityInfo juActivity = bllJuActivity.GetJuActivity(int.Parse(activityId), false); if (juActivity == null) { resp.errmsg = "不存在该条活动"; resp.errcode = (int)BLLJIMP.Enums.APIErrCode.IsNotFound; context.Response.Write(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); return; } System.Text.StringBuilder sbWhere = new System.Text.StringBuilder(string.Format(" WebSiteOwner='{0}' AND isDelete=0 AND ActivityID='{1}' ", bllActivity.WebsiteOwner, juActivity.SignUpActivityID)); if (!string.IsNullOrEmpty(keyWord)) { sbWhere.AppendFormat(" AND Name like '%{0}%' ", keyWord); } int totalCount = bllActivity.GetCount <ActivityDataInfo>(sbWhere.ToString()); var dataList = bllActivity.GetLit <ActivityDataInfo>(pageSize, pageIndex, sbWhere.ToString()); List <ActivityFieldMappingInfo> fieldMapList = bllActivity.GetActivityFieldMappingList(juActivity.SignUpActivityID); resp.isSuccess = true; List <dynamic> list = new List <dynamic>(); List <dynamic> maplist = new List <dynamic>(); var fieldlist = bllActivity.GetActivityFieldMappingList(juActivity.SignUpActivityID); foreach (var item in fieldlist) { maplist.Add(new { key = item.MappingName, value = item.FieldName }); } for (int i = 0; i < dataList.Count; i++) { list.Add(new { name = dataList[i].Name, phone = dataList[i].Phone, insert_time = bllActivity.GetTimeStamp(dataList[i].InsertDate), k1 = dataList[i].K1, k2 = dataList[i].K2, k3 = dataList[i].K3, k4 = dataList[i].K4, k5 = dataList[i].K5, k6 = dataList[i].K6, k7 = dataList[i].K7, k8 = dataList[i].K8, k9 = dataList[i].K9, k10 = dataList[i].K10, k11 = dataList[i].K11, k12 = dataList[i].K12, k13 = dataList[i].K13, k14 = dataList[i].K14, k15 = dataList[i].K15, k16 = dataList[i].K16, k17 = dataList[i].K17, k18 = dataList[i].K18, k19 = dataList[i].K19, k20 = dataList[i].K20, k21 = dataList[i].K21, k22 = dataList[i].K22, k23 = dataList[i].K23, k24 = dataList[i].K24, k25 = dataList[i].K25, k26 = dataList[i].K26, k27 = dataList[i].K27, k28 = dataList[i].K28, k29 = dataList[i].K29, k30 = dataList[i].K30, k31 = dataList[i].K31, k32 = dataList[i].K32, k33 = dataList[i].K33, k34 = dataList[i].K34, k35 = dataList[i].K35, k36 = dataList[i].K36, k37 = dataList[i].K37, k38 = dataList[i].K38, k39 = dataList[i].K39, k40 = dataList[i].K40, k41 = dataList[i].K41, k42 = dataList[i].K42, k43 = dataList[i].K43, k44 = dataList[i].K44, k45 = dataList[i].K45, k46 = dataList[i].K46, k47 = dataList[i].K47, k48 = dataList[i].K48, k49 = dataList[i].K49, k50 = dataList[i].K50, k51 = dataList[i].K51, k52 = dataList[i].K52, k53 = dataList[i].K53, k54 = dataList[i].K54, k55 = dataList[i].K55, k56 = dataList[i].K56, k57 = dataList[i].K57, k58 = dataList[i].K58, k59 = dataList[i].K59, k60 = dataList[i].K60, }); } var data = new { totalcount = totalCount, list = list, }; resp.returnObj = new { data = data, maplist = maplist }; } catch (Exception ex) { resp.errcode = (int)BLLJIMP.Enums.APIErrCode.OperateFail; resp.errmsg = ex.Message; } context.Response.Write(ZentCloud.Common.JSONHelper.ObjectToJson(resp)); }