// 메모리에 어디까지 올릴건가 // 지금은 그냥 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(); }