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