public static DataTable GetMemberInfo()
{
string sql = "select * from [dbo].[User] ";
DataTable dt = OperatorDb.GetDataTable(sql);
return(dt);
}
public static DataTable GetTeamInfo()
{
string sql = "select * from [dbo].[Team] ";
DataTable dt = OperatorDb.GetDataTable(sql);
return(dt);
}
public static DataTable GetMemberByTeamID(string TeamID)
{
string sql = "select * from [dbo].[User],Team where UserTeam=TeamID";
if (TeamID != "0")
{
sql += " and TeamID='" + TeamID + "'";
}
DataTable dt = OperatorDb.GetDataTable(sql);
return(dt);
}
public static DataTable GetMemberByTeamID(string groupID)
{
string sql = "";
if (groupID == "*" || groupID == "0")
{
sql = "select * from [dbo].[User],Team where TeamID=UserTeam";
}
else
{
sql = "select * from [dbo].[User] where UserTeam='" + groupID + "'";
}
DataTable dt = OperatorDb.GetDataTable(sql);
return(dt);
}