コード例 #1
0
        private void groupLabel_Click(object sender, EventArgs e)
        {
            GroupLabel tp = (GroupLabel)sender;

            Art_track_table.Controls.Clear();
            string          sql     = "SELECT tracks.* FROM tracks INNER JOIN track_group ON tracks.idtracks = track_group.idTrack LEFT JOIN `group` ON `group`.idGroup = track_group.idGroup WHERE `group`.idGroup = " + tp.id + " GROUP BY tracks.trackName";
            MySqlCommand    command = new MySqlCommand(sql, conn);
            MySqlDataReader reader  = command.ExecuteReader();

            while (reader.Read())
            {
                byte[] data = ((byte[])reader.GetValue(6));

                TrackLabel t = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
                t.Click += new System.EventHandler(this.trackLabel_Click);
                t.Text   = reader[1].ToString();
                Art_track_table.Controls.Add(t, 0, MyPl_track_table.RowCount - 1);
            }
            reader.Close();
        }
コード例 #2
0
        private void tab_panel_SelectedIndexChanged(object sender, EventArgs e)
        {
            TabControl tc;

            tc = (TabControl)sender;
            //MessageBox.Show(tc.SelectedIndex.ToString());
            switch (tc.SelectedIndex)
            {
            case 0:
            {        //news
                News_track_table.Controls.Clear();
                string          sql     = "SELECT * from tracks;";
                MySqlCommand    command = new MySqlCommand(sql, conn);
                MySqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    byte[]     data = ((byte[])reader.GetValue(6));
                    TrackLabel t    = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
                    t.Click += new System.EventHandler(this.trackLabel_Click);
                    t.Text   = reader[1].ToString();
                    News_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
                }
                reader.Close();
                break;
            }

            case 1:
            {        //charts
                Charts_track_table.Controls.Clear();
                string          sql     = "SELECT * FROM tracks ORDER BY countListens DESC LIMIT 10; ";
                MySqlCommand    command = new MySqlCommand(sql, conn);
                MySqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    byte[]     data = ((byte[])reader.GetValue(6));
                    TrackLabel t    = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
                    t.Click += new System.EventHandler(this.trackLabel_Click);
                    t.Text   = reader[1].ToString();
                    Charts_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
                }
                reader.Close();
                break;
            }

            case 2:
            {        //Artists
                Art_artisits_table.Controls.Clear();
                string          sql     = "SELECT * FROM `group`;";
                MySqlCommand    command = new MySqlCommand(sql, conn);
                MySqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    GroupLabel t = new GroupLabel(reader[0].ToString(), reader[1].ToString(), reader[2].ToString());
                    t.Click += new System.EventHandler(this.groupLabel_Click);
                    t.Text   = reader[1].ToString();
                    Art_artisits_table.Controls.Add(t, 0, Art_artisits_table.RowCount - 1);
                }
                reader.Close();
                break;
            }

            case 3:
            {        //Tracks
                Tr_track_table.Controls.Clear();
                string          sql     = "SELECT * from tracks;";
                MySqlCommand    command = new MySqlCommand(sql, conn);
                MySqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    byte[]     data = ((byte[])reader.GetValue(6));
                    TrackLabel t    = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
                    t.Click += new System.EventHandler(this.trackLabel_Click);
                    t.Text   = reader[1].ToString();
                    Tr_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
                }
                reader.Close();
                break;
            }

            case 4:
            {        //Playlists
                MyPl_pl_table.Controls.Clear();
                string          sql     = "SELECT playlists.* FROM playlists INNER JOIN user_playlist ON user_playlist.idPlayList = playlists.idPlayLists LEFT JOIN user ON user_playlist.idUser = user.idUser WHERE user.idUser = "******" GROUP BY playlists.playListName";
                MySqlCommand    command = new MySqlCommand(sql, conn);
                MySqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    PlaylistLabel t = new PlaylistLabel(reader[0].ToString(), reader[1].ToString());
                    t.Click += new System.EventHandler(this.playlistLabel_Click);
                    t.Text   = reader[1].ToString();
                    MyPl_pl_table.Controls.Add(t, 0, MyPl_pl_table.RowCount - 1);
                }
                reader.Close();
                break;
            }

            case 5:
            {        //Settings
                login_textBox.Text    = usr_login;
                password_textBox.Text = usr_pass;
                //Bitmap t = new Bitmap(avatar_patch);
                avatar_picturebox.Image = new Bitmap(avatar_patch);
                //t.Dispose();
                break;
            }
            }
        }