public double loadData(string code, DateTime refDate) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = refDate.ToString(StringFormat.DbDateFormat_); dao.INDEX_CODE_ = code; double result = 0.0; try { dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); } catch (Exception) { OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } try { result = Convert.ToDouble(dao.INDEX_VALUE_); } catch (Exception) { OutputLogViewModel.addResult("data converting error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } return result; }
public double loadData(string code, DateTime refDate) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = refDate.ToString(StringFormat.DbDateFormat_); dao.INDEX_CODE_ = code; double result = 0.0; try { dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); } catch (Exception) { OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } try { result = Convert.ToDouble(dao.INDEX_VALUE_); } catch (Exception) { OutputLogViewModel.addResult("data converting error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } return(result); }
public void insertHistoryDB() { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_CODE_ = this.Code_; dao.INDEX_NAME_ = this.Name_; try { dao.deleteIndex(DataBaseConnectManager.ConnectionFactory("myDB")); foreach (var item in this.TimeSeries_) { dao.INDEX_DATE_ = QueryStr.wrapComma(item.Key); dao.INDEX_VALUE_ = QueryStr.wrapComma(item.Value); dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); } } catch (SqlCeException) { OutputLogViewModel.addResult("DataBase Connection Error : DB Load"); throw; } }
public void insertHistoryDB() { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_CODE_ = this.Code_; dao.INDEX_NAME_ = this.Name_; try { dao.deleteIndex(DataBaseConnectManager.ConnectionFactory("myDB")); foreach (var item in this.TimeSeries_) { dao.INDEX_DATE_ = QueryStr.wrapComma(item.Key); dao.INDEX_VALUE_ = QueryStr.wrapComma(item.Value); dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); } } catch (SqlCeException ) { OutputLogViewModel.addResult("DataBase Connection Error : DB Load"); throw; } }
public void insertDB() { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = this.Date_; dao.INDEX_CODE_ = this.Name_; dao.INDEX_NAME_ = this.Name_; dao.INDEX_VALUE_ = this.Value_; try { dao.delete(DataBaseConnectManager.ConnectionFactory("myDB")); dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); } catch (SqlCeException) { OutputLogViewModel.addResult("dataBase load error : " + this.Name_); } }
public void selectInterval(DbConnection conn, DateTime startDate, DateTime endDate) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <INDEX_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string SelectInterValQuery_ = INDEX_DATA_Table_DAOManager.SelectInterValQuery_; SelectInterValQuery_ = SelectInterValQuery_.Replace("@KeyColumnValue@", this.INDEX_CODE_); SelectInterValQuery_ = SelectInterValQuery_.Replace("@StartDateValue@", startDate.ToString(StringFormat.DbDateFormat_)); SelectInterValQuery_ = SelectInterValQuery_.Replace("@EndDateValue@", endDate.ToString(StringFormat.DbDateFormat_)); dbCommand.CommandText = SelectInterValQuery_; //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) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = item[0].ToString(); dao.INDEX_CODE_ = item[1].ToString(); dao.INDEX_NAME_ = item[2].ToString(); dao.INDEX_VALUE_ = item[3].ToString(); this.DAOList_.Add(dao); } }
public void insertDB() { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = this.Date_; dao.INDEX_CODE_ = this.Name_; dao.INDEX_NAME_ = this.Name_; dao.INDEX_VALUE_ = this.Value_; try { dao.delete(DataBaseConnectManager.ConnectionFactory("myDB")); dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); } catch (SqlCeException ) { OutputLogViewModel.addResult("dataBase load error : " + this.Name_); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) conn.Open(); DataTable tb = new DataTable(); this.DAOList_ = new List<INDEX_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = INDEX_DATA_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) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = item[0].ToString(); dao.INDEX_CODE_ = item[1].ToString(); dao.INDEX_NAME_ = item[2].ToString(); dao.INDEX_VALUE_ = item[3].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 <INDEX_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = INDEX_DATA_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) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = item[0].ToString(); dao.INDEX_CODE_ = item[1].ToString(); dao.INDEX_NAME_ = item[2].ToString(); dao.INDEX_VALUE_ = item[3].ToString(); this.DAOList_.Add(dao); } }
public void selectInterval(DbConnection conn, DateTime startDate, DateTime endDate) { if (conn.State != ConnectionState.Open) conn.Open(); DataTable tb = new DataTable(); this.DAOList_ = new List<INDEX_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string SelectInterValQuery_ = INDEX_DATA_Table_DAOManager.SelectInterValQuery_; SelectInterValQuery_ = SelectInterValQuery_.Replace("@KeyColumnValue@", this.INDEX_CODE_); SelectInterValQuery_ = SelectInterValQuery_.Replace("@StartDateValue@", startDate.ToString(StringFormat.DbDateFormat_)); SelectInterValQuery_ = SelectInterValQuery_.Replace("@EndDateValue@", endDate.ToString(StringFormat.DbDateFormat_)); dbCommand.CommandText = SelectInterValQuery_; //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) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = item[0].ToString(); dao.INDEX_CODE_ = item[1].ToString(); dao.INDEX_NAME_ = item[2].ToString(); dao.INDEX_VALUE_ = item[3].ToString(); this.DAOList_.Add(dao); } }