/// <summary>
/// insert a new formula configuration to table TRENDVIEWER_FORMULA_CONFIG
/// </summary>
/// <param name="formulaList">the formula list included in the configuration</param>
/// <param name="grpName">the configuration name</param>
public bool InsertFormulaListToGrp(List <EtyFormula> formulaList, string grpName)
{
string Function_Name = "InsertFormulaListToGrp";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
bool executeOK = false;
string localSQL = " INSERT INTO TRENDVIEWER_FORMULA_CONFIG(CONFIG_NAME,DATA_PT_EQUATION,DATA_PT_TYPE, " +
" DATA_PT_COLOR,DATA_PT_ENABLED,DATA_PT_LBL_ENABLED,DATA_PT_LBL_NAME) " +
" VALUES( '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(grpName) + "'";
foreach (EtyFormula formula in formulaList)
{
executeOK = SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL
+ ",'" + formula.DPEquation.Replace("'", "''") + "'"
+ ",'" + DAOHelper.ConvertLineTypeToDBString(formula.DPType) + "'"
+ ",'" + formula.DPColor + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(formula.DPEnabled) + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(formula.DPLblEnabled) + "'"
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(formula.DPLblName) + "'"
+ " ) ");
if (executeOK == false)
{
break;
}
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(executeOK);
}
/// <summary>
/// insert a new configuration into TRENDVIEWER_CONFIG.
/// </summary>
/// <param name="datapointList">realtime dp list in a configuration</param>
/// <param name="grpName">configuration name</param>
public bool InsertDPListToGrp(List <EtyDataPoint> datapointList, string grpName)
{
string Function_Name = "InsertDPListToGrp";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
bool executeOK = false;
string localSQL = " INSERT INTO TRENDVIEWER_CONFIG(CONFIG_NAME,DATA_PT_NAME,DATA_PT_TYPE, " +
" DATA_PT_COLOR,DATA_PT_SERVER,DATA_PT_ENABLED,DATA_PT_LBL_ENABLED,DATA_PT_LBL_NAME,DATA_PT_HOST,DATA_PT_VISIBLE) " +
" VALUES( '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(grpName) + "'";
string fullSQL;
foreach (EtyDataPoint datapoint in datapointList)
{
fullSQL = localSQL
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(datapoint.DPName) + "'"
+ ",'" + DAOHelper.ConvertLineTypeToDBString(datapoint.DPType) + "'"
+ ",'" + datapoint.DPColor + "'"
+ ",'" + datapoint.DPServer + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(datapoint.DPEnabled) + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(datapoint.DPLblEnabled) + "'"
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(datapoint.DPLblName) + "'"
+ ",'" + datapoint.DPHost + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(datapoint.DPVisible) + "'"
+ " ) ";
executeOK = SimpleDatabase.GetInstance().ExecuteNonQuery(fullSQL);
fullSQL = "";
if (executeOK == false)
{
break;
}
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(executeOK);
}
/// <summary>
/// insert a historical datapoint configuration into table TRENDVIEWER_HIST_CONFIG,
/// if histDP.pkey=0, insert null into entitykey column (means no entity key is related to this datapoint)
/// </summary>
/// <param name="histDPList">the historical datapoint list included in a configuration</param>
/// <param name="grpName">the historical configuration name</param>
public bool InsertHistDPListToGrp(List <EtyHistDataPoint> histDPList, string grpName)
{
string Function_Name = "InsertHistDPListToGrp";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
bool executeOK = false;
string localSQL = " INSERT INTO TRENDVIEWER_HIST_CONFIG(CONFIG_NAME,DATA_PT_NAME,DATA_PT_TYPE,DATA_PT_COLOR,DATA_PT_SERVER " +
" ,DATA_PT_ENABLED,DATA_PT_LBL_ENABLED,DATA_PT_LBL_NAME,DATA_PT_DT,DATA_PT_HOST,DATA_PT_DT_END, ENTITYKEY) " +
" VALUES( '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(grpName) + "'";
string fullSQL;
foreach (EtyHistDataPoint datapoint in histDPList)
{
fullSQL = localSQL
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(datapoint.DPName) + "'"
+ ",'" + DAOHelper.ConvertLineTypeToDBString(datapoint.DPType) + "'"
+ ",'" + datapoint.DPColor + "'"
+ ",'" + datapoint.DPServer + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(datapoint.DPEnabled) + "'"
+ ",'" + DAOHelper.ChangeBoolToStr(datapoint.DPLblEnabled) + "'"
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(datapoint.DPLblName) + "'"
+ ", @StartDateValue"
+ ", '" + datapoint.DPHost + "'"
+ ", @EndDateValue"
+ ",";
if (datapoint.EntityKey != 0)
{
fullSQL = fullSQL + datapoint.EntityKey.ToString() + ")";
}
else
{
fullSQL = fullSQL + "NULL )";
}
SqlParameter parameter1 = new SqlParameter();
parameter1.ParameterName = "StartDateValue";
parameter1.DbType = DbType.DateTime;
DateTime dtStart = new DateTime(datapoint.DPStartDateTime.Year, datapoint.DPStartDateTime.Month, datapoint.DPStartDateTime.Day,
0, 0, 0);
parameter1.Value = dtStart;
parameter1.Direction = System.Data.ParameterDirection.Input;
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter();
parameter2.ParameterName = "EndDateValue";
parameter2.DbType = DbType.DateTime;
DateTime dtEnd = new DateTime(datapoint.DPEndDateTime.Year, datapoint.DPEndDateTime.Month, datapoint.DPEndDateTime.Day,
23, 59, 59);
parameter2.Value = dtEnd;
parameter2.Direction = System.Data.ParameterDirection.Input;
parameters.Add(parameter2);
executeOK = SimpleDatabase.GetInstance().ExecuteNonQueryWithParams(fullSQL, parameters);
fullSQL = "";
if (executeOK == false)
{
break;
}
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(executeOK);
}
