public GroupList GetAllGroupByHostId(int hostId)
{
SqlCommand com = new SqlCommand();
string sql = "select * from Group where HostID={0}";
sql = string.Format(sql,hostId);
com.CommandText = sql;
DataSet ds = this.dbo.Select(com);
GroupList list = new GroupList();
foreach(DataRow row in ds.Tables[GroupOperator.TABLENAME].Rows)
{
Group g = new Group();
g.GroupID = Convert.ToInt32(row["GroupID"]);
g.GroupName = row["GroupName"].ToString();
g.GroupHostID = hostId;
g.GroupDescription = row["GroupDescription"].ToString();
g.GroupBuildTime = Convert.ToDateTime(row["GroupBuildTime"]);
list.Add(g);
}
return list;
}
public GroupList GetGroupListByUserId(int uid)
{
this.dbo = new DbOperate();
SqlCommand com = new SqlCommand();
string sql = string.Format("select * from group where groupId in"+
"(select * from friends where hostId={0} and friendId={0})",uid);
com.CommandText = sql;
DataTable table = this.dbo.Select(com).Tables[0];
GroupList list = new GroupList();
foreach(DataRow row in table.Rows)
{
Group g = new Group();
g.GroupID = Convert.ToInt32(row["GroupID"]);
g.GroupName = row["GroupName"].ToString();
g.GroupHostID = Convert.ToInt32(row["HostId"]);
g.GroupDescription = row["GroupDescription"].ToString();
g.GroupBuildTime = Convert.ToDateTime(row["GroupBuildTime"]);
list.Add(g);
}
return list;
}