// 나중에 ETL 까지 같이 생각해야함... 지금은 RDW에서 가져옴.
//public void loadNPV(DateTime referenceDate)
//{
// // db 접속 후 로드함. 그리고 나머지 계산함..?
// this.referenceDate_ = referenceDate;
// this.npv_ = 999999;
// this.dailyProfitLoss_ = 999999;
// this.totalProfitLoss_ = 999999;
// DataTable tb = new DataTable();
// using (SqlCeConnection connection = new SqlCeConnection(connectionStr_))
// using (SqlCeCommand command = connection.CreateCommand())
// {
// string exportItemCodeWrap = QueryStr.wrapComma(this.exportItemCode_);
// command.CommandText = "SELECT DATE, TRADE_ID , NPV , TOTAL_PL , " +
// " DAILY_PL,EXPORT_ITEMCODE FROM POSITION_PL WHERE EXPORT_ITEMCODE =" + exportItemCodeWrap;
// connection.Open();
// SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
// dataAdapter.Fill(tb);
// }
// DataRow[] resultRows = tb.Select();
// if (resultRows.Length == 0)
// {
// OutputLogViewModel.addResult("no result pl : " + tradeID_);
// }
// foreach (DataRow item in resultRows)
// {
// //this.tradeID_ = item["ITEM_CODE"].ToString();
// //this.Name_ = item["ITEM_NAME"].ToString();
// this.npv_ = Convert.ToDouble(item["TRADE_ID"].ToString());
// this.totalProfitLoss_ = Convert.ToDouble(item["TYPE"].ToString());
// this.dailyProfitLoss_ = Convert.ToDouble(item["TYPE"].ToString());
// //mivm.TradeDate_ = DateTime.Parse(item["TRADE_DATE"].ToString());
// //mivm.MaturityDate_ = DateTime.Parse(item["MATURITY_DATE"].ToString());
// }
//}
public Control view()
{
Control v = new Excel_profitLossView();
v.DataContext = this;
return(v);
}
// 나중에 ETL 까지 같이 생각해야함... 지금은 RDW에서 가져옴.
//public void loadNPV(DateTime referenceDate)
//{
// // db 접속 후 로드함. 그리고 나머지 계산함..?
// this.referenceDate_ = referenceDate;
// this.npv_ = 999999;
// this.dailyProfitLoss_ = 999999;
// this.totalProfitLoss_ = 999999;
// DataTable tb = new DataTable();
// using (SqlCeConnection connection = new SqlCeConnection(connectionStr_))
// using (SqlCeCommand command = connection.CreateCommand())
// {
// string exportItemCodeWrap = QueryStr.wrapComma(this.exportItemCode_);
// command.CommandText = "SELECT DATE, TRADE_ID , NPV , TOTAL_PL , " +
// " DAILY_PL,EXPORT_ITEMCODE FROM POSITION_PL WHERE EXPORT_ITEMCODE =" + exportItemCodeWrap;
// connection.Open();
// SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
// dataAdapter.Fill(tb);
// }
// DataRow[] resultRows = tb.Select();
// if (resultRows.Length == 0)
// {
// OutputLogViewModel.addResult("no result pl : " + tradeID_);
// }
// foreach (DataRow item in resultRows)
// {
// //this.tradeID_ = item["ITEM_CODE"].ToString();
// //this.Name_ = item["ITEM_NAME"].ToString();
// this.npv_ = Convert.ToDouble(item["TRADE_ID"].ToString());
// this.totalProfitLoss_ = Convert.ToDouble(item["TYPE"].ToString());
// this.dailyProfitLoss_ = Convert.ToDouble(item["TYPE"].ToString());
// //mivm.TradeDate_ = DateTime.Parse(item["TRADE_DATE"].ToString());
// //mivm.MaturityDate_ = DateTime.Parse(item["MATURITY_DATE"].ToString());
// }
//}
public Control view()
{
Control v = new Excel_profitLossView();
v.DataContext = this;
return v;
}
