/// <summary> /// 从数据库读取任一歌单内容,返回歌单内所有音乐信息 /// </summary> /// <param name="musicList"></param> /// <returns></returns> public MusicList GetMusicList(MusicList musicList) { try { string sql = "SELECT * FROM musiclistinfo WHERE user_id = '" + musicList.User_Id + "' and Listname = '" + musicList.ListName + "'"; MySqlDataReader rd = Read(sql); while (rd.Read()) { string filename = rd["Fileurl"].ToString().Replace("/", "\\"); string musicname = rd["musicname"].ToString(); string musicsinger = rd["musicsinger"].ToString(); string musicalbum = rd["musicalbum"].ToString(); Music music = new Music(musicname, musicsinger, musicalbum, filename); musicList.Add(music); } rd.Close(); return(musicList); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(null); } }
/// <summary> /// 从数据库读取用户歌单信息 /// </summary> /// <returns></returns> public List <MusicList> GetAllMusicList(User user) { try { string sql = "SELECT Listname FROM user_musiclist_info WHERE user_id = '" + user.User_Id + "'"; MySqlDataReader rd = Read(sql); List <string> listNames = new List <string>(); while (rd.Read()) { listNames.Add(rd["Listname"].ToString()); } rd.Close(); List <MusicList> musicLists = new List <MusicList>(); for (int i = 0; i < listNames.Count; i++) { MusicList musicList = new MusicList(listNames[i], user.User_Id); musicList.Musics = GetMusics(musicList); musicLists.Add(musicList); } return(musicLists); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(null); } }
public MLButton(MusicList musicList) { MusicList = musicList; FlatStyle = System.Windows.Forms.FlatStyle.Flat; Font = new System.Drawing.Font("微軟正黑體 Light", 10F); Margin = new System.Windows.Forms.Padding(0); Size = new Size(160, 30); TextAlign = System.Drawing.ContentAlignment.MiddleLeft; Cursor = System.Windows.Forms.Cursors.Hand; }
/// <summary> /// 删除数据库中歌单 /// </summary> /// <param name="musicList"></param> /// <returns></returns> public bool DeleteMusicList(MusicList musicList) { try { bool n = mDB.DeleteMusicList(musicList); CreatedMusicList.Remove(musicList.ListName); return(n); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(false); } }
public void ResetLogoutInfo() { try { IsLogin = false; this.user = new User(); HistoryMusicList = new MusicList("播放历史"); LikedMusicList = new MusicList("我喜欢"); AllMusicLists = new List <MusicList>(); CreatedMusicList = new Dictionary <string, int>(); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); } }
/// <summary> /// 删除数据库中指定歌单 /// </summary> /// <param name="musicList"></param> /// <returns></returns> public bool DeleteMusicList(MusicList musicList) { try { string sql1 = "DELETE FROM musiclistinfo WHERE Listname = '" + musicList.ListName + "' and user_id = '" + musicList.User_Id + "'"; int n = ExcuteNonQuery(sql1); string sql2 = "DELETE FROM user_musiclist_info WHERE Listname = '" + musicList.ListName + "' and user_id = '" + musicList.User_Id + "'"; n += ExcuteNonQuery(sql2); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(false); } }
/// <summary> /// 修改数据库中歌单名,返回数据库操作所涉及的数据条数,失败返回-1 /// </summary> /// <param name="musicList"></param> /// <param name="ListName"></param> public int UpdateMusicList(MusicList musicList, string ListName) { try { string sql1 = "UPDATE musiclistinfo SET Listname = '" + ListName + "' WHERE user_id = '" + musicList.User_Id + "' and Listname = '" + musicList.ListName + "'"; int n = ExcuteNonQuery(sql1); string sql2 = "UPDATE user_musiclist_info SET Listname = '" + ListName + "' WHERE user_id = '" + musicList.User_Id + "' and Listname = '" + musicList.ListName + "'"; n += ExcuteNonQuery(sql2); return(n); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(-1); } }
/// <summary> /// 修改数据库中对应的音乐表,返回操作涉及的项数,失败返回-1 /// </summary> /// <param name="musicList">列表对象</param> /// <param name="music">音乐对象</param> /// <returns></returns> public int UpdateMusicList(MusicList musicList) { try { string filepath = ""; List <string> lines = new List <string>(); if (musicList.ListName.ToString() == "本地与下载") { filepath = "../local/local.txt"; foreach (Music music in musicList.Musics) { lines.Add(WriteLocalMusic(music)); } File.WriteAllLines(filepath, lines.ToArray()); return(0); } else if (musicList.ListName.ToString() == "播放列表") { filepath = "../local/playing.txt"; foreach (Music music in musicList.Musics) { lines.Add(WriteLocalMusic(music)); } File.WriteAllLines(filepath, lines.ToArray()); return(0); } else { int n = 0; string sql1 = "DELETE FROM musiclistinfo WHERE user_id = '" + musicList.User_Id + "' and Listname = '" + musicList.ListName + "'"; n += ExcuteNonQuery(sql1); foreach (Music music in musicList.Musics) { string sql2 = "INSERT INTO musiclistinfo VALUES('" + musicList.ListName + "','" + musicList.User_Id + "','" + music.FileURL.Replace("\\", "/") + "') ON DUPLICATE KEY UPDATE Fileurl = '" + music.FileURL.Replace("\\", "/") + "'"; n += ExcuteNonQuery(sql2); } return(n); } } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(-1); } }
/// <summary> /// 更新对应歌单(MusicList)的相关信息 /// </summary> /// <param name="musicList">歌单</param> public bool UpdateMusicList(MusicList musicList) { try { if (musicList != null) { int n = 0; n = mDB.UpdateMusicList(musicList); return(n >= 0); } return(false); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(false); } }
/// <summary> /// 创建自定义歌单 /// </summary> /// <param name="musicList"></param> /// <returns></returns> public bool CreateMusicList(MusicList musicList) { try { int n = 0; if (GetCreatedMusicListNumber() < ListLimits) { n = mDB.CreateMusicList(musicList); int i = AllMusicLists.Count(); AllMusicLists.Add(musicList); CreatedMusicList.Add(musicList.ListName, i); } return(n >= 0); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(false); } }
/// <summary> /// 修改数据库中歌单名 /// </summary> /// <param name="musicList"></param> /// <param name="ListName"></param> public bool UpdateMusicList(MusicList musicList, string ListName) { try { if (musicList != null) { int index = CreatedMusicList[musicList.ListName]; CreatedMusicList.Remove(musicList.ListName); int n = mDB.UpdateMusicList(musicList, ListName); musicList.ListName = ListName; AllMusicLists[index].ListName = ListName; CreatedMusicList.Add(musicList.ListName, index); return(n >= 0); } return(false); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(false); } }
/// <summary> /// 从本地读取歌单 /// </summary> /// <returns></returns> public MusicList GetLocalMusicList(MusicList musicList) { try { FileInfo myFile; if (musicList.ListName.ToString() == "本地与下载") { myFile = new FileInfo("../local/local.txt"); } else { myFile = new FileInfo("../local/playing.txt"); } StreamReader sR = myFile.OpenText(); string filename = ""; string nextLine; while ((nextLine = sR.ReadLine()) != null) { filename += nextLine.TrimEnd('】').TrimStart('【').TrimEnd('\n'); if (nextLine.Last() == '】') { Music music = ReadLocalMusic(filename); musicList.Add(music); filename = ""; } } sR.Close(); return(musicList); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(new MusicList()); } }
/// <summary> /// 在数据库中添加新建歌单 /// </summary> /// <param name="musicList"></param> /// <returns></returns> public int CreateMusicList(MusicList musicList) { try { int n = 0; string sql1 = "INSERT INTO user_musiclist_info VALUES('" + musicList.User_Id + "','" + musicList.ListName + "')"; n += ExcuteNonQuery(sql1); foreach (Music music in musicList.Musics) { if (music.FileURL != "") { string sql2 = "INSERT INTO musiclistinfo VALUES('" + musicList.ListName + "','" + musicList.User_Id + "','" + music.FileURL.Replace("\\", "/") + "') ON DUPLICATE KEY UPDATE Fileurl = '" + music.FileURL.Replace("\\", "/") + "'"; n += ExcuteNonQuery(sql2); } } return(n); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.StackTrace); return(-1); } }