/// <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();
}
}
