private void button4_Click(object sender, EventArgs e) { Utility.FinanceUtil finance = new Utility.FinanceUtil(); stockPriceEntityBindingSource.DataSource = finance.GetStockPriceEntityList(Convert.ToInt32(txtStockCode.Text)); profileEntityBindingSource.DataSource = finance.GetProfileEntityList(Convert.ToInt32(txtStockCode.Text)); }
private void button3_Click(object sender, EventArgs e) { XDocument xml; try { Utility.HtmlUtil htmlUtil = new Utility.HtmlUtil(); xml = htmlUtil.ParseHtml(this.textBox1.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } var ns = xml.Root.Name.Namespace; var q = from s in xml.Descendants(ns + "tr") select s; foreach (var s in q) { //Console.WriteLine(s.Value ); foreach (var s2 in s.Descendants()) { Console.WriteLine(s2.Value); } } Utility.FinanceUtil finance = new Utility.FinanceUtil(); dividendEntityBindingSource.DataSource = finance.GetDividendEntityList(); }
private void btnDividend_Click(object sender, EventArgs e) { using (Utility.DbUtil db = new Utility.DbUtil()) { // テーブルを作成 List <decimal> tblLst = db.DBSelect <decimal>("SELECT COUNT(*) CNT FROM sqlite_master WHERE type = 'table' AND name = 'dividend'"); if (tblLst[0] > 0) { db.DBExecuteSQL("DROP TABLE dividend "); } string sql = @"CREATE TABLE dividend ( OrderNo NUMERIC ,StockCode NUMERIC ,Market TEXT ,CompanyName TEXT ,Dividend NUMERIC ,DividendYield NUMERIC ,DetailUrl TEXT ) "; db.DBExecuteSQL(sql); List <Utility.DividendEntity> list = new List <Utility.DividendEntity>(); Utility.FinanceUtil finance = new Utility.FinanceUtil(); list = finance.GetDividendEntityList(); string insertSql = @"INSERT INTO dividend ( OrderNo ,StockCode ,Market ,CompanyName ,Dividend ,DividendYield ,DetailUrl ) VALUES ( :OrderNo ,:StockCode ,:Market ,:CompanyName ,:Dividend ,:DividendYield ,:DetailUrl )"; db.DBInsert(insertSql, list); } // 配当データをSqliteから取得 this.dgvDividend.DataSource = GetDividendList(); }
private async void GetData(int stockCode) { this.btnDownLoad.Enabled = false; this.lblStatus.Text = "データ取得開始・・・"; List <Utility.StockPriceEntity> listStockPrice = new List <Utility.StockPriceEntity>(); List <Utility.ProfileEntity> listProfile = new List <Utility.ProfileEntity>(); await Task.Delay(1000); this.lblStatus.Text = "株価取得開始・・・"; await Task.Run(() => { Utility.FinanceUtil finance = new Utility.FinanceUtil(); listStockPrice = finance.GetStockPriceEntityList(stockCode); }); this.lblStatus.Text = "株価取得終了・・・"; await Task.Delay(1000); if (listStockPrice.Count == 0) { this.lblStatus.Text = "データが取得できません。中断しました。"; this.btnDownLoad.Enabled = true; this.btnDownLoad.Focus(); return; } this.lblStatus.Text = "企業情報開始・・・"; await Task.Run(() => { Utility.FinanceUtil finance = new Utility.FinanceUtil(); listProfile = finance.GetProfileEntityList(stockCode); }); this.lblStatus.Text = "企業情報終了・・・"; await Task.Delay(1000); this.lblStatus.Text = "データ取得終了・・・"; // stockprice登録 registerStockPrice(listStockPrice); // profile登録 registerProfile(listProfile); this.btnDownLoad.Enabled = true; this.btnDownLoad.Focus(); }
private async void SampleAsync() { // 非同期処理参考URL // http://qiita.com/Temarin_PITA/items/ff74d39ae1cfed89d1c5 // http://qiita.com/shundroid/items/cd6764f2ed510377df2a // https://tocsworld.wordpress.com/2014/07/16/c-task%E3%81%AE%E3%82%AD%E3%82%BD/ // ↓イメージは以下が一番つかみやすい? 一旦UIスレッドでReturnして、別スレッドで処理してまたUIに戻る。コンパイラ頑張ってる!! // http://www.atmarkit.co.jp/fdotnet/chushin/masterasync_02/masterasync_02_01.html // // // // // // // // // // // // // // this.btnTask.Text = "実行中"; List <Utility.StockPriceEntity> list = new List <Utility.StockPriceEntity>(); await Task.Run(() => { Utility.FinanceUtil finance = new Utility.FinanceUtil(); list = finance.GetStockPriceEntityList(6178); }); this.btnTask.Text = "完了"; foreach (Utility.StockPriceEntity r in list) { await Task.Run(() => { Thread.Sleep(2000); }); this.btnTask.Text = r.HighPrice.ToString(); } }
private void btnNikkeiDollarYen_Click(object sender, EventArgs e) { List <Utility.NikkeiAverageEntity> list = new Utility.FinanceUtil().GetNikkeiAverageEntityList(); List <Utility.DollarYenEntity> listDY = new Utility.FinanceUtil().GetDollarYenEntityList(); }