//stockremain stockremain = new stockremain();
private async void btnAPI_Click(object sender, EventArgs e)
{
DateTime currentTime = System.DateTime.Now.AddDays(0);
string strYMD = currentTime.ToString("yyyy-MM-dd");
string str = strYMD.Replace("-", "");
dataModel dataModel = new dataModel();
//計算執行時間 Stopwatch
System.Diagnostics.Stopwatch watcher = new System.Diagnostics.Stopwatch();
watcher.Start();
Modelview.dataModelview.stockData res = await dataModel.Read(str);
StockEntities stock = new StockEntities();
this.dataGridView1.DataSource = stock.data.ToList();
watcher.Stop();
this.label3.Text = $"非同步共耗時 {watcher.Elapsed.TotalSeconds} 秒，共{stock.data.Count()}筆資料";
this.dataGridView1.Columns.Remove("id");
//取得更新收盤價
if (db.stockremain.Count() != 0)
{
var price = (from d in db.data
join s in db.stockremain
on d.證券代號 equals s.證券代號
select d.收盤價).ToList();
dataModel.Update(price);
}
//更新自選清單
if (db.datasave.Count() != 0)
{
var save = (from d in db.data
join ds in db.datasave
on d.證券代號 equals ds.證券代號
select d).ToList();
dataModel.Updatedatasave(save);
}
}
public MainWindow()
{
InitializeComponent();
_data = new dataModel();
this.DataContext = _data;
}
