/// <summary> /// 添加用户组 /// </summary> /// <param name="userGroup">用户组信息</param> /// <returns>包含用户组id的Result</returns> public Result AddUserGroup(UserGroup userGroup) { string userGroupId = DALService.AddUserGroup(member.Id, userGroup.UserGroupName); if (userGroupId == null) return new Result() { Status = MessageStatus.Failed }; else return new Result() { Status = MessageStatus.OK, UserGroup = new UserGroup() { UserGroupId = userGroupId, UserGroupName = userGroup.UserGroupName } }; }
public Result DeleteUserGroup(string id, UserGroup userGroup) { if (DALService.DeleteUserGroup(id, userGroup.UserGroupId)) return new Result() { Status = MessageStatus.OK }; else return new Result() { Status = MessageStatus.Failed }; }
/// <summary> /// 获取好友id的List /// </summary> /// <param name="id">用户id</param> /// <returns></returns> static public List<UserGroup> GetFriendList(string id) { MySqlCommand cmd = null; List<UserGroup> userGroups = new List<UserGroup>(); List<String> friends = null; try { string sql = String.Format("select friendId,groupId,groupName from tblFriend where id=?id "); string temp = String.Empty; cmd = new MySqlCommand(sql, Conn); cmd.Parameters.AddWithValue("id", id); Prepare(cmd.Parameters); List<Tuple> userGroupList = new List<Tuple>(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { string groupId = reader["groupId"].ToString(); string groupName = reader["groupName"].ToString(); temp = reader["friendId"].ToString(); friends = GetNames(temp); userGroupList.Add(new Tuple(groupId, groupName, friends)); } } foreach (Tuple tuple in userGroupList) { List<Member> members = new List<Member>(); foreach (string tempid in tuple.Friends) { Member member = GetMember(tempid); if (member != null) members.Add(member); } UserGroup userGroup = new UserGroup(); userGroup.UserGroupId = tuple.GroupId; userGroup.UserGroupName = tuple.GroupName; userGroup.Members = members; userGroups.Add(userGroup); } return userGroups; } catch (Exception e) { MyLogger.Logger.Error("获取好友列表出现错误\n", e); return null; } finally { if (cmd != null) cmd.Dispose(); } }