コード例 #1
0
    /// <summary>
    /// 新增歌曲資訊至 BeatmapList
    /// </summary>
    /// <param name="packageName">歌曲包名稱</param>
    /// <param name="osuFilePath">.osu檔路徑</param>
    public static int InsertBeatmap(string packageName, string osuFilePath)
    {
        var beatmap = new BeatmapSimple(osuFilePath);

        if (beatmap.General.Mode != 3 || beatmap.Difficulty.CircleSize != 4)
        {
            return(0);
        }
        using (var songList = new SqliteManager(Application.streamingAssetsPath, "GameData.db")
        {
            Table = "BeatmapList"
        })
        {
            using (var dr = songList.Select($"BeatmapID = {beatmap.Metadata.BeatmapID}", "BeatmapID"))
            {
                if (!dr.HasRows)
                {
                    //  MP3 轉 WAV
                    if (Path.GetExtension(beatmap.General.AudioFilename) == ".mp3")
                    {
                        var src = Path.Combine(Application.streamingAssetsPath, "Songs", packageName, beatmap.General.AudioFilename);
                        var dst = Path.ChangeExtension(src, ".wav");
                        beatmap.General.AudioFilename = Path.ChangeExtension(beatmap.General.AudioFilename, ".wav");
                        // 如果該素材尚未轉檔,轉換之
                        if (!File.Exists(dst))
                        {
                            NAudioPlayer.ConvertMp3ToWav(src);
                            // 刪除原始檔
                            File.Delete(src);
                        }
                    }
                    // 新增至資料庫
                    songList.Insert(
                        beatmap.Metadata.BeatmapID,
                        beatmap.Metadata.BeatmapSetID,
                        beatmap.Metadata.Title,
                        beatmap.Metadata.TitleUnicode,
                        beatmap.Metadata.Artist,
                        beatmap.Metadata.ArtistUnicode,
                        beatmap.Metadata.Creator,
                        beatmap.Metadata.Version,
                        packageName,
                        beatmap.Events.Filename,
                        beatmap.General.AudioFilename,
                        Path.GetFileName(osuFilePath)
                        );
                    // 新增至圖譜清單
                    BeatmapTileList.BeatmapTileDatas.Add(new BeatmapTileData(
                                                             beatmap.Metadata.BeatmapID,
                                                             beatmap.Metadata.BeatmapSetID,
                                                             beatmap.Metadata.Title,
                                                             beatmap.Metadata.TitleUnicode,
                                                             beatmap.Metadata.Artist,
                                                             beatmap.Metadata.ArtistUnicode,
                                                             beatmap.Metadata.Creator,
                                                             beatmap.Metadata.Version,
                                                             packageName,
                                                             beatmap.Events.Filename,
                                                             beatmap.General.AudioFilename,
                                                             Path.GetFileName(osuFilePath)
                                                             ));
                    return(1);
                }
            }
            return(0);
        }
    }