static void OnPostprocessAllAssets(string[] importedAssets, string[] deletedAssets, string[] movedAssets, string[] movedFromAssetPaths) { foreach (string asset in importedAssets) { if (!filePath.Equals(asset)) { continue; } Entity_Sheet1 data = (Entity_Sheet1)AssetDatabase.LoadAssetAtPath(exportPath, typeof(Entity_Sheet1)); if (data == null) { data = ScriptableObject.CreateInstance <Entity_Sheet1> (); AssetDatabase.CreateAsset((ScriptableObject)data, exportPath); data.hideFlags = HideFlags.NotEditable; } data.sheets.Clear(); using (FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { IWorkbook book = null; if (Path.GetExtension(filePath) == ".xls") { book = new HSSFWorkbook(stream); } else { book = new XSSFWorkbook(stream); } foreach (string sheetName in sheetNames) { ISheet sheet = book.GetSheet(sheetName); if (sheet == null) { Debug.LogError("[QuestData] sheet not found:" + sheetName); continue; } Entity_Sheet1.Sheet s = new Entity_Sheet1.Sheet(); s.name = sheetName; for (int i = 1; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); ICell cell = null; Entity_Sheet1.Param p = new Entity_Sheet1.Param(); cell = row.GetCell(0); p.number = (int)(cell == null ? 0 : cell.NumericCellValue); cell = row.GetCell(1); p.name = (cell == null ? "" : cell.StringCellValue); s.list.Add(p); } data.sheets.Add(s); } } ScriptableObject obj = AssetDatabase.LoadAssetAtPath(exportPath, typeof(ScriptableObject)) as ScriptableObject; EditorUtility.SetDirty(obj); } }
public void NewQuetion(int _qnumber) { es = Resources.Load("example") as Entity_Sheet1; //データの読み込み NowQuestion = GameObject.Find("NowQuestion"); NowQuestion.GetComponent <TextMeshProUGUI>().text = es.sheets[_qnumber].list[0].q; }
public void PushStartButton() { es = Resources.Load("takeuchi") as Entity_Sheet1; //エクセル呼び出し int i; for (i = 0; i < 16; i++) {//長さはlength取得に変更すべき if (SampleStart.Equals(es.sheets[0].list[i].name)) { Debug.Log("発:" + es.sheets[0].list[i].name); //発:ありましたのデバッグ表示 start = i; //発の駅の番号を保管しておく } if (SampleGoal.Equals(es.sheets[0].list[i].name)) { Debug.Log("着:" + es.sheets[0].list[i].name); //着:ありましたのデバッグ表示 goal = i; //着の駅の番号を保管しておく } } if (goal > start) { ekisuu = goal - start; //駅数を算出 } else { ekisuu = start - goal; //駅数を算出 } /* num.text = ekisuu.ToString(); int型(数字のみ)からstring型(文字)へ*/ //バグが出るので隠してる(長田) /*st.text = es.sheets[0].list[start].name;*/ //いらんかも(長田) Debug.Log("駅数:" + ekisuu); /*go.text = es.sheets[0].list[goal].name;*/ //いらんかも(長田) //もし駅がなかったらの処理が必要 SceneManager.LoadScene("ResultScene"); //次のシーンに飛ぶ。次のシーンの名前を書く(長田) }
public void NextQuestion(int _number, int _qnumber) { es = Resources.Load("example") as Entity_Sheet1; Question = GameObject.Find("Question"); Question.GetComponent <TextMeshProUGUI>().text = es.sheets[_qnumber].list[_number].question; }
// Start is called before the first frame update void Start() { es = Resources.Load("example") as Entity_Sheet1; //データの読み込み Question = GameObject.Find("Question"); Question.GetComponent <TextMeshProUGUI>().text = es.sheets[0].list[0].question; }
public void NextQuestion(int _number, int _qnumber, float _comb) { es = Resources.Load("example") as Entity_Sheet1; NowQuestion = GameObject.Find("NowQuestion"); NowQuestion.GetComponent <TextMeshProUGUI>().text = es.sheets[_qnumber].list[_number].q; Combo.text = _comb.ToString() + "コンボ"; }
// Start is called before the first frame update void Start() { es = Resources.Load("example") as Entity_Sheet1; //データの読み込み NowQuestion = GameObject.Find("NowQuestion"); NowQuestion.GetComponent <TextMeshProUGUI>().text = es.sheets[0].list[0].q; Debug.Log("q1-1:" + es.sheets[0].list[0].q); }
void Start() { es = Resources.Load("example") as Entity_Sheet1; hpMax = es.sheets[0].list[0].hp; hp = hpMax; HPSlider.maxValue = hpMax; HPSlider.value = hpMax; at = 10; }
void Start() { SoundManager.sound_bgm(); IsPlayerTurn = true; IsMaruBastu = false; IsGameOver = false; GameoverPanel.SetActive(false); ResultPanel.SetActive(false); es = Resources.Load("example") as Entity_Sheet1; Debug.Log("player-hp" + player.hp); Debug.Log("player" + enemy.hp); }
public void Output() { Debug.Log(ThisHizuke); Debug.Log(ThisTime); DateTime Thisdt = DateTime.Parse(ThisHizuke); //DateTime型に変換 WeekDay = Thisdt.DayOfWeek.ToString(); Debug.Log(WeekDay); if (WeekDay.Equals("Saturday") | WeekDay.Equals("Sunday")) //曜日が平日か土日か { Daiya = 0; } else { Daiya = 1; } Thisdt2 = DateTime.Parse("12/30/1899 " + ThisTime); //DateTime型に変換 Debug.Log(Thisdt2); int i; for (i = 0; i < SMA.StationJapanese.Length; i++) { if (hatu.Equals(SMA.StationJapanese[i])) { hatu = SMA.StationAlpha[i]; Direction = 1; RailDirection = "odpt.RailDirection:TokyoMetro.YoyogiUehara"; } if (chaku.Equals(SMA.StationJapanese[i])) { chaku = SMA.StationAlpha[i]; Direction = 0; RailDirection = "odpt.RailDirection:TokyoMetro.KitaAyase"; } } bool ExistCheck = true; if (Daiya == 0) //土日 { double oadate0 = 1; int store = 0; DateTime Karidt = Thisdt2; double oadate = Karidt.ToOADate(); Debug.Log(oadate); hatu = "odpt.Station:TokyoMetro.Chiyoda." + hatu; //Excelの形式に chaku = "odpt.Station:TokyoMetro.Chiyoda." + chaku; Debug.Log("出発:" + hatu); Debug.Log("到着:" + chaku); while (ExistCheck) { for (i = 0; i < 6215; i++) //6216 { if (oadate < es2.sheets[0].list[i].departure_Time && oadate0 > es2.sheets[0].list[i].departure_Time && hatu.Equals(es2.sheets[0].list[i].departure_Station) && RailDirection.Equals(es2.sheets[0].list[i].rail_direction)) { oadate0 = es2.sheets[0].list[i].departure_Time; Ddt = DateTime.FromOADate(oadate0); store = i; } } for (i = 0; i < 6215; i++) //6216 { //同じ電車番号 if (es3.sheets[0].list[i].train_number.Equals(es2.sheets[0].list[store].train_number)) { //かつ 着が発で存在するとき(端っこは存在しない) if (es3.sheets[0].list[i].arrival_Station.Equals(chaku)) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 //Debug.Log(i); Adt = DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time); } else if (chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase") && es2.sheets[0].list[i].departure_Station.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase")) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 Debug.Log("たし5"); Adt = DateTime.FromOADate(es2.sheets[0].list[i].departure_Time); Adt = Adt.AddMinutes(5); } else if (chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.YoyogiUehara") && es2.sheets[0].list[i].departure_Station.Equals("odpt.Station:TokyoMetro.Chiyoda.YoyogiKoen")) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 Debug.Log("たし2"); Adt = DateTime.FromOADate(es2.sheets[0].list[i].departure_Time); Adt = Adt.AddMinutes(2); } } } //同じ電車番号で綾瀬発があれば5分足す //北綾瀬-綾瀬間(sも含む) if ((hatu.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase") && chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase")) || (hatu.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase") && chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase"))) { oadate0 = 1; for (i = 0; i < 6215; i++) //6216 { //下から同じ電車番号 s1とか if (SubstringRight(SubstringRight(es3.sheets[0].list[i].arrival_Station, 2), 2).Equals(SubstringRight(SubstringRight(chaku, 2), 2))) { if (es2.sheets[0].list[store].departure_Time < es3.sheets[0].list[i].arrival_Time && oadate0 >= es3.sheets[0].list[i].arrival_Time) { oadate0 = es3.sheets[0].list[i].arrival_Time; ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //出発時刻 //Debug.Log(i); Adt = DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time); } } } } oadate = oadate0; oadate0 = 1; if (oadate == 1) { Debug.Log("無理"); ExistCheck = false; } } } else if (Daiya == 1) //平日 { double oadate0 = 1; int store = 0; DateTime Karidt = Thisdt2; double oadate = Karidt.ToOADate(); hatu = "odpt.Station:TokyoMetro.Chiyoda." + hatu; //Excelの形式に chaku = "odpt.Station:TokyoMetro.Chiyoda." + chaku; while (ExistCheck) { for (i = 6215; i < 13923; i++) { if (oadate < es2.sheets[0].list[i].departure_Time && oadate0 >= es2.sheets[0].list[i].departure_Time && hatu.Equals(es2.sheets[0].list[i].departure_Station) && RailDirection.Equals(es2.sheets[0].list[i].rail_direction)) { oadate0 = es2.sheets[0].list[i].departure_Time; //Debug.Log("出発" + DateTime.FromOADate(oadate0)); //出発時刻 //Debug.Log(i); Ddt = DateTime.FromOADate(oadate0); store = i; } } for (i = 6215; i < 13923; i++) { //同じ電車番号 if (es3.sheets[0].list[i].train_number.Equals(es2.sheets[0].list[store].train_number)) { //かつ 着が発で存在するとき(端っこは存在しない) if (es3.sheets[0].list[i].arrival_Station.Equals(chaku)) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 //Debug.Log(i); Adt = DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time); } else if (chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase") && es2.sheets[0].list[i].departure_Station.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase")) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 Debug.Log("たし5"); Adt = DateTime.FromOADate(es2.sheets[0].list[i].departure_Time); Adt = Adt.AddMinutes(5); } else if (chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.YoyogiUehara") && es2.sheets[0].list[i].departure_Station.Equals("odpt.Station:TokyoMetro.Chiyoda.YoyogiKoen")) { ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //到着時刻 Debug.Log("たし2"); Adt = DateTime.FromOADate(es2.sheets[0].list[i].departure_Time); Adt = Adt.AddMinutes(2); } } } //同じ電車番号で綾瀬発があれば5分足す //北綾瀬-綾瀬間(sも含む) if ((hatu.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase") && chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase")) || (hatu.Equals("odpt.Station:TokyoMetro.Chiyoda.Ayase") && chaku.Equals("odpt.Station:TokyoMetro.Chiyoda.KitaAyase"))) { oadate0 = 1; for (i = 0; i < 6215; i++) //6216 { //下から同じ電車番号 s1とか if (SubstringRight(SubstringRight(es3.sheets[0].list[i].arrival_Station, 2), 2).Equals(SubstringRight(SubstringRight(chaku, 2), 2))) { if (es2.sheets[0].list[store].departure_Time < es3.sheets[0].list[i].arrival_Time && oadate0 >= es3.sheets[0].list[i].arrival_Time) { oadate0 = es3.sheets[0].list[i].arrival_Time; ExistCheck = false; //Debug.Log("到着" + DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time)); //出発時刻 //Debug.Log(i); Adt = DateTime.FromOADate(es3.sheets[0].list[i].arrival_Time); } } } } oadate = oadate0; oadate0 = 1; if (oadate == 1) { //Debug.Log("無理"); ExistCheck = false; } } } dtime = Ddt.ToString(); atime = Adt.ToString(); taketime1 = Adt - Ddt; taketime2 = taketime1.ToString(); depa = Hatu.text; arri = Chaku.text; es = Resources.Load("takeuchi") as Entity_Sheet1; //エクセル呼び出し for (i = 0; i < 20; i++) { //長さはlength取得に変更すべき if (depa.Equals(es.sheets[0].list[i].name)) { Debug.Log("発:" + es.sheets[0].list[i].name); //発:ありましたのデバッグ表示 start = i; //発の駅の番号を保管しておく } if (arri.Equals(es.sheets[0].list[i].name)) { Debug.Log("着:" + es.sheets[0].list[i].name); //着:ありましたのデバッグ表示 goal = i; //着の駅の番号を保管しておく } } if (goal > start) { ekisuu = goal - start; //駅数を算出 } else { ekisuu = start - goal; } Debug.Log(dtime); Debug.Log(atime); Debug.Log("かかる時間"); Debug.Log(taketime2); SceneManager.LoadScene("ResultScene"); }
void Load() { Entity_Sheet1 = ES3.Load <Entity_Sheet1>("PlayerScore"); }