62,268
社区成员
发帖
与我相关
我的任务
分享
public static IList<Friend> FindByUserb(int userb, int state)//为什么要用IList<>呢
{
string sql = "select * from friend where userb=" + userb + " and state=" + state;
Friend friend = null;
IList<Friend> list = new List<Friend>();
using (SqlDataReader reader = DBHelper.GetReader(sql))
{
while (reader.Read())
{
friend = new Friend();
friend.Id = Convert.ToInt32(reader["id"].ToString());
friend.Usera = new UserInfo();
friend.Usera.Id = Convert.ToInt32(reader["usera"].ToString());
friend.Userb = new UserInfo();
friend.Userb.Id = Convert.ToInt32(reader["userb"].ToString());
friend.State = new FriendState();
friend.State.Id = Convert.ToInt32(reader["state"].ToString());
list.Add(friend);
}
reader.Close();
foreach (Friend f in list)
{
f.Usera = UserInfoService.FindById(f.Usera.Id);
f.Userb = UserInfoService.FindById(f.Userb.Id);
f.State = FriendStateService.FindById(f.State.Id);
}
return list;
}
}
public static IList<Friend> FindByUserb(int userb, int state)
{
return FriendService.FindByUserb(userb,state);
}
public class Friend
{
private int id;
private UserInfo usera;
private UserInfo userb;
private FriendState state;
public FriendState State
{
get { return state; }
set { state = value; }
}
public UserInfo Userb
{
get { return userb; }
set { userb = value; }
}
public UserInfo Usera
{
get { return usera; }
set { usera = value; }
}
public int Id
{
get { return id; }
set { id = value; }
}
}