/// <summary>
/// 根据用户编号，查找该用户的所有好友信息列表
/// </summary>
/// <param name="hostId">用户编号</param>\
/// <param name="friendShipID">好友信息策略</param>
/// <returns>该用户对应的好友信息列表</returns>
public FriendList LoadFrendList(int hostId,int friendShipID)
{
//定义数据库操作通用类的一个对象
DbOperate dbo = new DbOperate();
dbo.TableName = FriendsOperator.TABLENAME;
//定义数据操作对象，并初始化其将执行的SQL语句
SqlCommand com = new SqlCommand();
com.CommandText = "select * from Friends where HostId=@HostId and FriendShipPolicy=@FriendShipPolicy";
//对数据操作对象的SQL语句中的参数赋值
SqlParameter hid = new SqlParameter("@HostId",SqlDbType.Int);
hid.Value = hostId;
SqlParameter friendShipPolicy = new SqlParameter("@FriendShipPolicy", SqlDbType.Int);
friendShipPolicy.Value = friendShipID;
com.Parameters.Add(hid);
com.Parameters.Add(friendShipPolicy);
//执行SQL语句，获取其数据集中的数据表
DataTable table = dbo.Select(com).Tables[0];
//迭代，将数据表中的好友信息添加到好友列表（集合）中
foreach(DataRow row in table.Rows)
{
FriendItem item = new FriendItem();
item.Id = Convert.ToInt32(row["id"]);
item.HostId = Convert.ToInt32(row["HostId"]);
item.FriendId = Convert.ToInt32(row["FriendId"]);
item.FriendShipId = Convert.ToInt32(row["FriendShipPolicy"]);
if (row["GroupId"] != null && row["GroupId"].ToString().Length >0)
{
item.GroupId = Convert.ToInt32(row["GroupId"].ToString());
}
else
{
item.GroupId = 0;
}
this.list.Add(item);
}
return this.list.Length >= 1 ? this.list : null;
}
/// <summary>
/// 通过群组号获取群组人员ID
/// </summary>
/// <param name="groupId">群组ID</param>
/// <returns>群组Friend列表</returns>
public FriendList LoadFriendListByGroupId(int groupId)
{
this.list = new FriendList();
DbOperate dbo = new DbOperate();
dbo.TableName = FriendsOperator.TABLENAME;
SqlCommand com = new SqlCommand();
com.CommandText = string.Format("select * from Friends where groupId={0}",groupId);
DataTable table = dbo.Select(com).Tables[0];
foreach(DataRow row in table.Rows)
{
FriendItem item = new FriendItem();
item.Id = Convert.ToInt32(row["id"]);
item.HostId = Convert.ToInt32(row["HostId"]);
item.FriendId = Convert.ToInt32(row["FriendId"]);
item.FriendShipId = Convert.ToInt32(row["FriendShipPolicy"]);
if (row["GroupId"] != null)
{
item.GroupId = Convert.ToInt32(row["GroupId"]);
}
else
{
item.GroupId = 0;
}
this.list.Add(item);
}
return this.list.Length >= 1 ? this.list : null;
}
/// <summary>
/// 往好友集合中添加一个好友
/// </summary>
/// <param name="item">好友实体对象</param>
/// <returns>该好友在集合中的下标位置</returns>
public int Add(FriendItem item)
{
return this.list.Add(item);
}
