private string getApplyList(HttpContext context) { int page = Convert.ToInt32(context.Request["page"]), rows = Convert.ToInt32(context.Request["rows"]); List <CommRelationInfo> cris = bllCommRelation.GetRelationList(BLLJIMP.Enums.CommRelationType.ApplyToTutor, null, null, page, rows); int TCount = bllCommRelation.GetRelationCount(BLLJIMP.Enums.CommRelationType.ApplyToTutor, null, null); List <dynamic> result = new List <dynamic>(); foreach (var item in cris) { UserInfo user = bllUser.GetUserInfo(item.RelationId); result.Add(new { id = item.AutoId, userAutoId = user.AutoID, userId = user.UserID, name = user.TrueName, company = user.Company, postion = user.Postion, phone = user.Phone, userFollowCount = bllCommRelation.GetRelationCount(BLLJIMP.Enums.CommRelationType.FollowUser, null, item.RelationId), followUserCount = bllCommRelation.GetRelationCount(BLLJIMP.Enums.CommRelationType.FollowUser, item.RelationId, null), articleCount = bllUser.GetCount <JuActivityInfo>(string.Format(" UserId ='{0}' And IsDelete=0 And IsHide=0 And WebsiteOwner='{1}'", item.RelationId, bllUser.WebsiteOwner)), applyDate = item.RelationTime.ToString("yyyy-MM-dd") }); } return(Common.JSONHelper.ObjectToJson(new { rows = result, total = TCount })); }
public void ProcessRequest(HttpContext context) { string relationId = context.Request["rel_id"]; int page = 1; int rows = int.MaxValue; if (!string.IsNullOrWhiteSpace(context.Request["page"])) { page = Convert.ToInt32(context.Request["page"]); } if (!string.IsNullOrWhiteSpace(context.Request["rows"])) { rows = Convert.ToInt32(context.Request["rows"]); } UserInfo CurrentUserInfo = bllUser.GetCurrentUserInfo(); if (string.IsNullOrWhiteSpace(relationId) && CurrentUserInfo != null) { relationId = CurrentUserInfo.AutoID.ToString(); } if (string.IsNullOrWhiteSpace(relationId)) { relationId = "-999"; } List <CommRelationInfo> rellist = bLLCommRelation.GetRelationList(CommRelationType.Friend, null, relationId, 1, int.MaxValue, colName: "AutoId,MainId"); if (rellist.Count == 0) { apiResp.code = (int)BLLJIMP.Enums.APIErrCode.IsSuccess; apiResp.msg = "查询完成"; apiResp.status = true; apiResp.result = new { totalcount = 0, list = rellist }; bLLCommRelation.ContextResponse(context, apiResp); return; } string autoIds = ZentCloud.Common.MyStringHelper.ListToStr(rellist.Select(p => p.MainId).ToList(), "", ","); int total = 0; List <UserInfo> uList = bllUser.GetUserList(page, rows, null, null, null, null, null, out total, autoIds, "AutoID,UserID,WXNickname,TrueName,WebsiteOwner,WXHeadimgurl,Avatar,Phone,ViewType,TotalScore,OnlineTimes,Description"); var list = from p in uList join r in rellist on p.AutoID.ToString() equals r.MainId orderby r.AutoId descending select new { id = p.AutoID, avatar = bllUser.GetUserDispalyAvatar(p), userName = bllUser.GetUserDispalyName(p), describe = p.Description, phone = p.ViewType == 1 ? "" : p.Phone, score = p.TotalScore, times = p.OnlineTimes, userHasRelation = CurrentUserInfo == null ? false : bLLCommRelation.ExistRelation(CommRelationType.Friend, p.AutoID.ToString(), CurrentUserInfo.AutoID.ToString()) }; apiResp.code = (int)BLLJIMP.Enums.APIErrCode.IsSuccess; apiResp.msg = "查询完成"; apiResp.status = true; apiResp.result = new { totalcount = total, list = list }; bLLCommRelation.ContextResponse(context, apiResp); }