private void updateDerivedValue(string s_info_windcode,
string trade_dt)
{
double[] clvArray = new double[6];
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "select s_info_windcode, clv "
+ "from Result where s_info_windcode = '"
+ s_info_windcode + "' and trade_dt <= '"
+ trade_dt + "' order by trade_dt desc";
List <double> dataList = SQLHelper.FetchQueryResultToDouble(sqlCmd);
clvArray = AttributeCalculator.MACalculator(dataList); // calculate the value
SQLHelper.UpdateMultipleValueIntoTable(clvArray, "clv", s_info_windcode, trade_dt);
}
private void updateDerivedValue(string s_info_windcode, string trade_dt)
{
//fetch
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select s_info_windcode, so"
+ " from Result" + " where s_info_windcode = '" + s_info_windcode
+ "' and trade_dt <= '" + trade_dt
+ "' order by trade_dt desc";
List <double> dataList = SQLHelper.FetchQueryResultToDouble(cmd);
//update
double[] soArray = new double[6];
soArray = AttributeCalculator.MACalculator(dataList);
SQLHelper.UpdateMultipleValueIntoTable(soArray, "so",
s_info_windcode, trade_dt);
}
/// <summary>
/// update the derived attributes
/// </summary>
/// <param name="s_info_windcode"></param>
/// <param name="trade_dt"></param>
/// <param name="length"></param>
private void updateDerivedValue(string s_info_windcode, string trade_dt)
{
//fetch
double[] ADArray = new double[ADLength];
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select s_info_windcode, AD_" + ADLength.ToString()
+ " from dbo.Result where s_info_windcode = '"
+ s_info_windcode + "' and trade_dt <= '"
+ trade_dt + "' order by trade_dt desc";
List <double> dataList = SQLHelper.FetchQueryResultToDouble(cmd);
//update
double[] adArray = new double[6];
adArray = AttributeCalculator.MACalculator(dataList);
SQLHelper.UpdateMultipleValueIntoTable(adArray,
"ad_" + ADLength.ToString(), s_info_windcode, trade_dt);
}
