/// <summary> /// 获取好友列表 /// </summary> /// <param name="uid">ID</param> /// <returns>好友集合</returns> public static ArrayList getFriendList(String uid) { //查询所有好友 Object[] parameter = getParameterList(new SqlParameter[] { new SqlParameter("uid", uid) }); ArrayList arr = SQLUtil.rawQuery("Select * From FriendRelation Where SendUid = @uid Or AcceptUid = @uid", parameter); if (arr.Count > 0) { String[] arruid = new String[arr.Count]; for (int i = 0; i < arr.Count; i++) { Hashtable table = (Hashtable)arr[i]; if (table["SendUid"].ToString().Trim() == uid) { arruid[i] = table["AcceptUid"].ToString(); } else { arruid[i] = table["SendUid"].ToString(); } } //查询所有好友基本信息 ArrayList firendlist = new ArrayList(); for (int i = 0; i < arruid.Length; i++) { UserInfoModel user = BaseUtil.getUserInfo(arruid[i]); firendlist.Add(user); } return(firendlist); } else { return(null); } }
/// <summary> /// 发送好友请求 /// </summary> /// <param name="senduid">发送ID</param> /// <param name="acceptuid">接受ID</param> /// <returns>执行结果 为Empty时发送请求成功</returns> public static String sendFriendRequest(String senduid, String acceptuid) { String error = String.Empty; //查询是否已发送过请求 if (!BaseUtil.exist(acceptuid)) { return("不存在此用户"); } if (isFirend(senduid, acceptuid)) { return("你们已经是好友"); } Object[] parameter = getParameterList(new SqlParameter[] { new SqlParameter("@senduid", senduid), new SqlParameter("@acceptuid", acceptuid) }); ArrayList arr = SQLUtil.rawQuery("Select id From FriendRequest Where SendUid = @senduid And AcceptUid = @acceptuid", parameter); if (arr != null) { if (arr.Count > 0) { return("好友请求已存在,请勿重复发送好友请求"); } else { parameter = getParameterList(new SqlParameter[] { new SqlParameter("@senduid", senduid), new SqlParameter("@acceptuid", acceptuid) }); int result = SQLUtil.excuteSQL("Insert into FriendRequest Values(@senduid,@acceptuid)", parameter); return(result > 0 ? String.Empty : "发送好友请求失败"); } } return("未知错误"); }