public string EventDataConvertQue(List <EventData> data) { if (data.Count == 0) { logOutput.writeLog("実行するクエリがありません。"); return(""); } string outQue = string.Format("INSERT INTO {0} (ID, EmgName, LiveName, EmgTime, EmgType) VALUES ", tablename); int count = 1; string tmpdata = ""; foreach (EventData ev in data) { string adddata = ""; if (ev is emgQuest) { emgQuest emg = ev as emgQuest; adddata += string.Format("('{0}','{1}','{2}','{3}','0')", count.ToString(), myFunction.escapeStr(emg.eventName), myFunction.escapeStr(emg.live), emg.eventTime.ToString()); } if (ev is casino) { casino ca = ev as casino; adddata += string.Format("('{0}','{1}','','{2}','1')", count.ToString(), myFunction.escapeStr(ca.eventName), ca.eventTime.ToString()); } if (data.Count != count) { adddata += ","; } else { adddata += ";"; } tmpdata += adddata; count++; } outQue += tmpdata; //logOutput.writeLog("QUE:{0}", outQue); return(outQue); }
public override List <EventData> ConvertStringToData(string data) { //Jsonをパース List <JsonPSO2Event> EVData = new List <JsonPSO2Event>(); EVData = JsonConvert.DeserializeObject <List <JsonPSO2Event> >(data); List <EventData> output = new List <EventData>(); //出力するEventDataを作成 //ライブ関係 bool live = false; string livename = ""; foreach (JsonPSO2Event ev in EVData) { DateTime emgDT = new DateTime(DateTime.Now.Year, ev.Month, ev.Date, ev.Hour, ev.Minute, 0); if (ev.EventType == "緊急") { emgQuest emg; if (live == true) { emg = new emgQuest(emgDT, ev.EventName, livename); live = false; livename = ""; } else { emg = new emgQuest(emgDT, ev.EventName); } output.Add(emg); } if (ev.EventType == "ライブ") { live = true; livename = ev.EventName; } if (ev.EventType == "カジノイベント") { casino cas = new casino(emgDT); output.Add(cas); } } return(output); }