/// <summary> /// 好友列表 /// </summary> /// <param name="session">本人session</param> /// <returns></returns> public string GetFriendList(string session) { HF.Cloud.BLL.Common.Logger.Error("FriendList获取到的session为" + session); JavaScriptSerializer js = new JavaScriptSerializer(); List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); //session获取用户UserID SB_UserEL userEL = new SB_UserEL(); userEL.Session_True = session; userEL.ExecuteEL(41); HF.Cloud.BLL.Common.Logger.Error("userEL.ID:" + userEL.ID); if (userEL.ID > 0) { long userID = userEL.ID; //通过userID在好友表中查询好友列表 FriendsEL frenEL = new FriendsEL(); frenEL.UserID = userID; DataTable dt = frenEL.ExecDT(31); HF.Cloud.BLL.Common.Logger.Error("获取到好友列表,好友个数为:" + dt.Rows.Count); foreach (DataRow dr in dt.Rows) { long userid_Friend = long.Parse(dr["UserID_Friend"].ToString()); //通过userid_Friend获取好友信息 userEL.ID = userid_Friend; userEL.ExecuteEL(4); string userName = userEL.UserName; string userTel = userEL.UserTel; string duty = userEL.Duty; string imgUrl = userEL.ImgUrl; string session_Friend = userEL.Session_True; long companyID = userEL.CompanyID; //通过companyID获取公司名称 CompanysEL compaEL = new CompanysEL(); compaEL.ID = companyID; compaEL.ExecuteEL(2); string companyName = compaEL.CompanyName; HF.Cloud.BLL.Common.Logger.Error("好友名称:" + userEL.UserName + "公司名称:" + companyName); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("UserName", userName); dic.Add("UserTel", userTel); dic.Add("Duty", duty); dic.Add("ImgUrl", imgUrl); dic.Add("Session", session_Friend); dic.Add("CompanyName", companyName); list.Add(dic); } } string strJson = js.Serialize(list); HF.Cloud.BLL.Common.Logger.Error("返回的好友列表json数据:" + strJson); return(strJson); }
/// <summary> /// 查看是多少人的好友,被多少人添加好友,保存数 /// </summary> /// <param name="session"></param> /// <returns></returns> public int GetSaveNumber(string session) { //通过Session换取UserID UserBLL userBLL = new UserBLL(); long userID = userBLL.GetUserIDBySession(session); FriendsEL friendsEL = new FriendsEL(); friendsEL.UserID_Friend = userID; DataTable dt = friendsEL.ExecDT(33); int sum = dt.Rows.Count; return(sum); }
/// <summary> /// 判断sessionFriend是否是session的好友 /// </summary> /// <param name="session">本人session</param> /// <param name="sessionFriend">(好友)session</param> /// <returns></returns> public bool IsFriend(string session, string sessionFriend) { bool isFriend = false; //通过session获取UserID UserBLL userBLL = new UserBLL(); long userID = userBLL.GetUserIDBySession(session); long userIDFriend = userBLL.GetUserIDBySession(sessionFriend); FriendsEL friendEL = new FriendsEL(); friendEL.UserID = userID; friendEL.UserID_Friend = userIDFriend; DataTable dt = friendEL.ExecDT(32); HF.Cloud.BLL.Common.Logger.Error("IsFriend方法执行查找好友结果:" + dt.Rows.Count + "---userID:" + userID + "---userIDFriend:" + userIDFriend); if (dt.Rows.Count > 0) { isFriend = true; } return(isFriend); }