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