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); }