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