コード例 #1
0
        public static DataTable GetMemberInfo()
        {
            string    sql = "select * from [dbo].[User] ";
            DataTable dt  = OperatorDb.GetDataTable(sql);

            return(dt);
        }
コード例 #2
0
        public static DataTable GetTeamInfo()
        {
            string    sql = "select * from [dbo].[Team] ";
            DataTable dt  = OperatorDb.GetDataTable(sql);

            return(dt);
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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);
        }