// 메모리에 어디까지 올릴건가
// 지금은 그냥 db access함
public void loadMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
try
{
this.setFromDAO(mt_dao);
}
catch (Exception)
{
OutputLogViewModel.addResult("favor not implemeted");
}
//DataTable tb = new DataTable();
//using (SqlCeConnection connection = new SqlCeConnection(connectionStr_))
//using (SqlCeCommand command = connection.CreateCommand())
//{
// string itemCodeWrap = QueryStr.wrapComma(itemCode);
// command.CommandText = "SELECT TRADE_ID, ITEM_CODE , ITEM_NAME , NOTIONAL , TYPE, " +
// " TRADE_DATE , MATURITY_DATE , COUNTERPARTY , EXPORT_ITEMCODE FROM MASTERINFORMATION WHERE ITEM_CODE =" + itemCodeWrap;
// connection.Open();
// SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
// dataAdapter.Fill(tb);
//}
//DataRow[] resultRows = tb.Select();
//string formatString = "yyyyMMdd";
//foreach (DataRow item in resultRows)
//{
// this.tradeID_ = item["TRADE_ID"].ToString();
// this.itemCode_ = item["ITEM_CODE"].ToString();
// this.name_ = item["ITEM_NAME"].ToString();
// this.notional_ = item["NOTIONAL"].ToString();
// this.type_ = item["TYPE"].ToString();
// this.tradeDate_ = DateTime.ParseExact(item["TRADE_DATE"].ToString(), formatString,null);
// this.maturityDate_ = DateTime.ParseExact(item["MATURITY_DATE"].ToString(), formatString, null);
// this.conterParty_ = item["COUNTERPARTY"].ToString();
// this.export_ItemCode_ = item["EXPORT_ITEMCODE"].ToString();
//}
this.dataContextRefersh();
}
public static Excel_instrumentViewModel loadInstrumentVM(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.ITEM_CODE_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
Excel_instrumentViewModel e_ivm =
CodeClassificationGenerator.CreateInstrument(mt_dao.ITEM_CODE_);
e_ivm.MasterInformationViewModel_.setFromDAO(mt_dao);
return(e_ivm);
}
public static Excel_instrumentViewModel loadInstrumentVM(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.ITEM_CODE_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
Excel_instrumentViewModel e_ivm =
CodeClassificationGenerator.CreateInstrument(mt_dao.ITEM_CODE_);
e_ivm.MasterInformationViewModel_.setFromDAO(mt_dao);
return e_ivm;
}
// 메모리에 어디까지 올릴건가
// 지금은 그냥 db access함
public void loadMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
mt_dao.select(DataBaseConnectManager.ConnectionFactory("myDB"));
try
{
this.setFromDAO(mt_dao);
}
catch (Exception)
{
OutputLogViewModel.addResult("favor not implemeted");
}
//DataTable tb = new DataTable();
//using (SqlCeConnection connection = new SqlCeConnection(connectionStr_))
//using (SqlCeCommand command = connection.CreateCommand())
//{
// string itemCodeWrap = QueryStr.wrapComma(itemCode);
// command.CommandText = "SELECT TRADE_ID, ITEM_CODE , ITEM_NAME , NOTIONAL , TYPE, " +
// " TRADE_DATE , MATURITY_DATE , COUNTERPARTY , EXPORT_ITEMCODE FROM MASTERINFORMATION WHERE ITEM_CODE =" + itemCodeWrap;
// connection.Open();
// SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);
// dataAdapter.Fill(tb);
//}
//DataRow[] resultRows = tb.Select();
//string formatString = "yyyyMMdd";
//foreach (DataRow item in resultRows)
//{
// this.tradeID_ = item["TRADE_ID"].ToString();
// this.itemCode_ = item["ITEM_CODE"].ToString();
// this.name_ = item["ITEM_NAME"].ToString();
// this.notional_ = item["NOTIONAL"].ToString();
// this.type_ = item["TYPE"].ToString();
// this.tradeDate_ = DateTime.ParseExact(item["TRADE_DATE"].ToString(), formatString,null);
// this.maturityDate_ = DateTime.ParseExact(item["MATURITY_DATE"].ToString(), formatString, null);
// this.conterParty_ = item["COUNTERPARTY"].ToString();
// this.export_ItemCode_ = item["EXPORT_ITEMCODE"].ToString();
//}
this.dataContextRefersh();
}
