/// <summary>
/// 讀取上市當沖標的資料寫入SQLite
/// </summary>
/// <param name="date">日期</param>
public static bool WriteListedAlertToSQL(string date)
{
List <string> Data = new List <string>();
// 爬取資料
var AlertIndfo = ParseListedAlert(date);
if (AlertIndfo != null)
{
foreach (var item in AlertIndfo)
{
Data.Add(item.Key + "_" + item.Value);
}
// 寫入SQLite
SQliteDb sQlite = new SQliteDb();
string insertString = "";
if (sQlite.DataAdd(Args_.ListedAlert_saveDir, $"Data{date}", Args_.ListedAlert_header, Data, insertString))
{
Console.WriteLine($"{date} : 完成");
return(true);
}
}
Console.WriteLine($"{date}:上市當沖標的取得失敗!");
return(false);
}
private void OTCalertRun()
{
string startDate = "";
string startDateSlash = "";
string endDate = "";
string endDateSlash = "";
this.Invoke((MethodInvoker) delegate()
{
label1.Text = "新增中..";
startDate = MyFunction.SolarToVids(txt_fromday.Text, false);
startDateSlash = MyFunction.SolarToVids(txt_fromday.Text, true);
endDate = MyFunction.SolarToVids(txt_endday.Text, false);
endDateSlash = MyFunction.SolarToVids(txt_endday.Text, true);
});
List <string> TestDays = MyFunction.GetAllDaysNoWeekend(startDateSlash, endDateSlash);
SQliteDb sQlite = new SQliteDb();
foreach (var item in TestDays)
{
// 資料表不存在 => 寫入SQLite
if (!sQlite.CheckDatatable(Args_.ListedAlert_saveDir, "Data" + item))
{
MyFunction.WriteListedAlertToSQL(item);
}
Thread.Sleep(5000);
}
this.Invoke((MethodInvoker) delegate()
{
label1.Text = "新增完畢";
});
}
