public MATSER_INFO_Table_DAO buildDAO()
{
// bussiness logic here
MATSER_INFO_Table_DAO insertDao = new MATSER_INFO_Table_DAO();
insertDao.ITEM_CODE_ = this.Item_code_;
insertDao.ITEM_NAME_ = this.Item_name_;
insertDao.NOTIONAL_ = this.Notional_;
insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_;
insertDao.CURRENCY_ = this.Currency_.CurrencyCode_;
insertDao.TRADE_DATE_ = this.Trade_date_.ToString("yyyyMMdd");
insertDao.MATURITY_DATE_ = this.Maturity_date_.ToString("yyyyMMdd");
insertDao.COUNTERPARTY_ = this.Counterparty_;
insertDao.EXPORT_ITEMCODE_ = this.Export_itemcode_;
insertDao.TRADE_ID_ = this.Trade_id_;
insertDao.TRADE_STATUS_ = this.Trade_status_;
insertDao.INSTRUMENT_TYPE_ = this.Instrument_type_;
insertDao.UNDERLYING_TYPE_ = this.Underlying_type_.UnderlyingComboCode_;
insertDao.UNDERLYING_DETAIL_TYPE_ = this.Underlying_detail_type_;
insertDao.CONTRACT_TYPE_ = this.Contract_type_.ContractComboCode_;
insertDao.CONTRACT_SUBTYPE_ = this.Contract_subtype_.ContractSubComboCode_;
insertDao.CONTRACT_DETAIL_TYPE_ = this.Contract_detail_type_;
insertDao.BOOKING_TYPE_ = this.Booking_type_;
return(insertDao);
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
DataTable tb = new DataTable();
this.DAOList_ = new List<MATSER_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = MATSER_INFO_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
MATSER_INFO_Table_DAO dao = new MATSER_INFO_Table_DAO();
dao.ITEM_CODE_ = item[0].ToString();
dao.ITEM_NAME_ = item[1].ToString();
dao.NOTIONAL_ = item[2].ToString();
dao.REMAIN_NOTIONAL_ = item[3].ToString();
dao.CURRENCY_ = item[4].ToString();
dao.TRADE_DATE_ = item[5].ToString();
dao.MATURITY_DATE_ = item[6].ToString();
dao.COUNTERPARTY_ = item[7].ToString();
dao.EXPORT_ITEMCODE_ = item[8].ToString();
dao.TRADE_ID_ = item[9].ToString();
dao.TRADE_STATUS_ = item[10].ToString();
dao.INSTRUMENT_TYPE_ = item[11].ToString();
dao.UNDERLYING_TYPE_ = item[12].ToString();
dao.UNDERLYING_DETAIL_TYPE_ = item[13].ToString();
dao.CONTRACT_TYPE_ = item[14].ToString();
dao.CONTRACT_SUBTYPE_ = item[15].ToString();
dao.CONTRACT_DETAIL_TYPE_ = item[16].ToString();
dao.BOOKING_TYPE_ = item[17].ToString();
this.DAOList_.Add(dao);
}
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <MATSER_INFO_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = MATSER_INFO_Table_DAOManager.SelectQuery_;
//selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
MATSER_INFO_Table_DAO dao = new MATSER_INFO_Table_DAO();
dao.ITEM_CODE_ = item[0].ToString();
dao.ITEM_NAME_ = item[1].ToString();
dao.NOTIONAL_ = item[2].ToString();
dao.REMAIN_NOTIONAL_ = item[3].ToString();
dao.CURRENCY_ = item[4].ToString();
dao.TRADE_DATE_ = item[5].ToString();
dao.MATURITY_DATE_ = item[6].ToString();
dao.COUNTERPARTY_ = item[7].ToString();
dao.EXPORT_ITEMCODE_ = item[8].ToString();
dao.TRADE_ID_ = item[9].ToString();
dao.TRADE_STATUS_ = item[10].ToString();
dao.INSTRUMENT_TYPE_ = item[11].ToString();
dao.UNDERLYING_TYPE_ = item[12].ToString();
dao.UNDERLYING_DETAIL_TYPE_ = item[13].ToString();
dao.CONTRACT_TYPE_ = item[14].ToString();
dao.CONTRACT_SUBTYPE_ = item[15].ToString();
dao.CONTRACT_DETAIL_TYPE_ = item[16].ToString();
dao.BOOKING_TYPE_ = item[17].ToString();
this.DAOList_.Add(dao);
}
}
// 메모리에 어디까지 올릴건가
// 지금은 그냥 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 void removeMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
try
{
mt_dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
}
catch (Exception)
{
throw;
}
}
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 void removeMasterInfo(string itemCode)
{
MATSER_INFO_Table_DAO mt_dao = new MATSER_INFO_Table_DAO();
mt_dao.KeyColumn_ = itemCode;
try
{
mt_dao.delete(DataBaseConnectManager.ConnectionFactory("myDB"));
}
catch (Exception)
{
throw;
}
}
public void setFromDAO(MATSER_INFO_Table_DAO dao)
{
// bussiness logic here
this.item_code_ = dao.ITEM_CODE_;
this.item_name_ = dao.ITEM_NAME_;
this.notional_ = dao.NOTIONAL_;
this.remain_notional_ = dao.REMAIN_NOTIONAL_;
this.currency_ = CurrencyViewModel.CreateCurrencyComboViewModel(dao.CURRENCY_);
this.Trade_date_ = DateTime.ParseExact(dao.TRADE_DATE_, "yyyyMMdd", null);
this.Maturity_date_ = DateTime.ParseExact(dao.MATURITY_DATE_, "yyyyMMdd", null);
this.counterparty_ = dao.COUNTERPARTY_;
this.export_itemcode_ = dao.EXPORT_ITEMCODE_;
this.trade_id_ = dao.TRADE_ID_;
this.trade_status_ = dao.TRADE_STATUS_;
this.instrument_type_ = dao.INSTRUMENT_TYPE_;
this.underlying_type_ = UnderlyingComboViewModel.CreateContractComboViewModel(dao.UNDERLYING_TYPE_);
this.underlying_detail_type_ = dao.UNDERLYING_DETAIL_TYPE_;
this.contract_type_ = ContractComboViewModel.CreateContractComboViewModel(dao.CONTRACT_TYPE_);
this.contract_subtype_ = ContractSubComboViewModel.CreateContractSubComboViewModel(dao.CONTRACT_SUBTYPE_);
this.contract_detail_type_ = dao.CONTRACT_DETAIL_TYPE_;
this.booking_type_ = dao.BOOKING_TYPE_;
}
public void bookingMasterInfo()
{
MATSER_INFO_Table_DAO dao = this.buildDAO();
dao.insert(DataBaseConnectManager.ConnectionFactory("myDB"));
}
// 메모리에 어디까지 올릴건가
// 지금은 그냥 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 MATSER_INFO_Table_DAO buildDAO()
{
// bussiness logic here
MATSER_INFO_Table_DAO insertDao = new MATSER_INFO_Table_DAO();
insertDao.ITEM_CODE_ = this.Item_code_;
insertDao.ITEM_NAME_ = this.Item_name_;
insertDao.NOTIONAL_ = this.Notional_;
insertDao.REMAIN_NOTIONAL_ = this.Remain_notional_;
insertDao.CURRENCY_ = this.Currency_.CurrencyCode_;
insertDao.TRADE_DATE_ = this.Trade_date_.ToString("yyyyMMdd");
insertDao.MATURITY_DATE_ = this.Maturity_date_.ToString("yyyyMMdd");
insertDao.COUNTERPARTY_ = this.Counterparty_;
insertDao.EXPORT_ITEMCODE_ = this.Export_itemcode_;
insertDao.TRADE_ID_ = this.Trade_id_;
insertDao.TRADE_STATUS_ = this.Trade_status_;
insertDao.INSTRUMENT_TYPE_ = this.Instrument_type_;
insertDao.UNDERLYING_TYPE_ = this.Underlying_type_.UnderlyingComboCode_;
insertDao.UNDERLYING_DETAIL_TYPE_ = this.Underlying_detail_type_;
insertDao.CONTRACT_TYPE_ = this.Contract_type_.ContractComboCode_;
insertDao.CONTRACT_SUBTYPE_ = this.Contract_subtype_.ContractSubComboCode_;
insertDao.CONTRACT_DETAIL_TYPE_ = this.Contract_detail_type_;
insertDao.BOOKING_TYPE_ = this.Booking_type_;
return insertDao;
}
public void setFromDAO(MATSER_INFO_Table_DAO dao)
{
// bussiness logic here
this.item_code_ = dao.ITEM_CODE_;
this.item_name_ = dao.ITEM_NAME_;
this.notional_ = dao.NOTIONAL_;
this.remain_notional_ = dao.REMAIN_NOTIONAL_;
this.currency_ = CurrencyViewModel.CreateCurrencyComboViewModel(dao.CURRENCY_);
this.Trade_date_ = DateTime.ParseExact(dao.TRADE_DATE_, "yyyyMMdd", null);
this.Maturity_date_ = DateTime.ParseExact(dao.MATURITY_DATE_, "yyyyMMdd", null);
this.counterparty_ = dao.COUNTERPARTY_;
this.export_itemcode_ = dao.EXPORT_ITEMCODE_;
this.trade_id_ = dao.TRADE_ID_;
this.trade_status_ = dao.TRADE_STATUS_;
this.instrument_type_ = dao.INSTRUMENT_TYPE_;
this.underlying_type_ = UnderlyingComboViewModel.CreateContractComboViewModel(dao.UNDERLYING_TYPE_);
this.underlying_detail_type_ = dao.UNDERLYING_DETAIL_TYPE_;
this.contract_type_ = ContractComboViewModel.CreateContractComboViewModel(dao.CONTRACT_TYPE_);
this.contract_subtype_ = ContractSubComboViewModel.CreateContractSubComboViewModel(dao.CONTRACT_SUBTYPE_);
this.contract_detail_type_ = dao.CONTRACT_DETAIL_TYPE_;
this.booking_type_ = dao.BOOKING_TYPE_;
}