void GenerateIdiomsMaster()
{
idioms_master instance = ScriptableObject.CreateInstance <idioms_master>();
instance.Data = new List <idioms_master.idioms_master_data>();
foreach (DataRow row in sqlDB.ExecuteQuery("SELECT * FROM idioms_master").Rows)
{
int id = (int)row["id"];
int? grade = (int?)((string)row["grade"] == "" ? null : row["grade"]);
string left_kanji = (string)row["left_kanji"];
string right_kanji = (string)row["right_kanji"];
string phonetic = (string)row["phonetic"];
string mean = (string)row["mean"];
idioms_master.idioms_master_data newData = new idioms_master.idioms_master_data(id, grade, left_kanji, right_kanji, phonetic, mean);
instance.Data.Add(newData);
}
#if UNITY_EDITOR
AssetDatabase.CreateAsset(instance, "Assets/Resources/ScriptableObject/idioms_master.asset");
#endif
}
public string GetPhonetic(char leftKanji, char rightKanji)
{
idioms_master.idioms_master_data result = idioms_master.FirstOrDefault(row => row.left_kanji == leftKanji.ToString() && row.right_kanji == rightKanji.ToString());
return(result == null ? "" : result.phonetic);
}
