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