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