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);
}
}
