/// <summary> /// get all formulas by a configuration name. /// </summary> /// <param name="configName">formula configuration name</param> /// <returns>fomula list</returns> public List <EtyFormula> GetFormulasByCfgName(string configName) { string Function_Name = "GetFormulasByCfgName"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); List <EtyFormula> formulaList = new List <EtyFormula>(); string localSQL = " SELECT DATA_PT_EQUATION,DATA_PT_TYPE,DATA_PT_COLOR,DATA_PT_ENABLED,DATA_PT_LBL_ENABLED,DATA_PT_LBL_NAME " + " FROM TRENDVIEWER_FORMULA_CONFIG WHERE CONFIG_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(configName) + "'"; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); EtyFormula newEtyFormula = null; try { while (drReader != null && drReader.Read()) { newEtyFormula = new EtyFormula(); if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_EQUATION"))) { newEtyFormula.DPEquation = drReader["DATA_PT_EQUATION"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_TYPE"))) { newEtyFormula.DPType = DAOHelper.ConvertLineTypeToEnum(drReader["DATA_PT_TYPE"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_COLOR"))) { newEtyFormula.DPColor = drReader["DATA_PT_COLOR"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_ENABLED"))) { newEtyFormula.DPEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_ENABLED"))) { newEtyFormula.DPLblEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_LBL_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_NAME"))) { newEtyFormula.DPLblName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_LBL_NAME"].ToString()); } formulaList.Add(newEtyFormula); } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(formulaList); }
/// <summary> /// retrieve a configuration from TRENDVIEWER_CONFIG by configuration name. /// </summary> /// <param name="configName">configuration name</param> /// <returns></returns> public List <EtyDataPoint> GetDPByCfgName(string configName) { string Function_Name = "GetDPByCfgName"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); List <EtyDataPoint> dpList = new List <EtyDataPoint>(); string localSQL = " SELECT 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 " + " FROM TRENDVIEWER_CONFIG WHERE CONFIG_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(configName) + "'"; // string localSQL = " SELECT c.DATA_PT_NAME,c.DATA_PT_TYPE,c.DATA_PT_COLOR,c.DATA_PT_SERVER,c.DATA_PT_ENABLED,c.DATA_PT_LBL_ENABLED, c.DATA_PT_LBL_NAME, c.DATA_PT_HOST,c.DATA_PT_VISIBLE, " // + "o.keyid from trendviewer_config c, opc_dt_pt o where c.data_pt_name = o.data_pt_name " + // " and c.CONFIG_NAME = '" + DAOHelper.convertGB2312To8859P1(configName) + "'"; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); EtyDataPoint newEtyDP = null; try { while (drReader != null && drReader.Read()) { newEtyDP = new EtyDataPoint(); if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_NAME"))) { newEtyDP.DPName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_NAME"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_TYPE"))) { newEtyDP.DPType = DAOHelper.ConvertLineTypeToEnum(drReader["DATA_PT_TYPE"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_COLOR"))) { newEtyDP.DPColor = drReader["DATA_PT_COLOR"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_SERVER"))) { newEtyDP.DPServer = drReader["DATA_PT_SERVER"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_ENABLED"))) { newEtyDP.DPEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_ENABLED"))) { newEtyDP.DPLblEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_LBL_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_NAME"))) { newEtyDP.DPLblName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_LBL_NAME"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_HOST"))) { newEtyDP.DPHost = drReader["DATA_PT_HOST"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_VISIBLE"))) { newEtyDP.DPVisible = DAOHelper.ChangeStrToBool(drReader["DATA_PT_VISIBLE"].ToString()); } // if (!drOracle.IsDBNull(9)) // newEtyDP.PKey = (ulong)(drOracle.GetOracleDecimal(9).ToInt64()); dpList.Add(newEtyDP); } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(dpList); }
/// <summary> /// get historical datapoint configuration by config name /// </summary> /// <param name="configName">hist dp config name</param> /// <returns>hist dp list in one group</returns> public List <EtyHistDataPoint> GetHistDPByCfgName(string configName) { string Function_Name = "GetHistDPByCfgName"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); List <EtyHistDataPoint> histDPList = new List <EtyHistDataPoint>(); string localSQL = " SELECT 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 " + " FROM TRENDVIEWER_HIST_CONFIG WHERE CONFIG_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(configName) + "'"; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); EtyHistDataPoint newEtyHistDP = null; try { while (drReader != null && drReader.Read()) { newEtyHistDP = new EtyHistDataPoint(); if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_NAME"))) { newEtyHistDP.DPName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_NAME"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_TYPE"))) { newEtyHistDP.DPType = DAOHelper.ConvertLineTypeToEnum(drReader["DATA_PT_TYPE"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_COLOR"))) { newEtyHistDP.DPColor = drReader["DATA_PT_COLOR"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_SERVER"))) { newEtyHistDP.DPServer = drReader["DATA_PT_SERVER"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_ENABLED"))) { newEtyHistDP.DPEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_ENABLED"))) { newEtyHistDP.DPLblEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_LBL_ENABLED"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_NAME"))) { newEtyHistDP.DPLblName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_LBL_NAME"].ToString()); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_DT"))) { DateTime dt; if (DateTime.TryParse(drReader["DATA_PT_DT"].ToString(), out dt)) { newEtyHistDP.DPStartDateTime = dt; } } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_HOST"))) { newEtyHistDP.DPHost = drReader["DATA_PT_HOST"].ToString(); } if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_DT_END"))) { DateTime dt; if (DateTime.TryParse(drReader["DATA_PT_DT_END"].ToString(), out dt)) { newEtyHistDP.DPEndDateTime = dt; } } if (!drReader.IsDBNull((drReader.GetOrdinal("ENTITYKEY")))) { newEtyHistDP.EntityKey = Convert.ToUInt64(drReader["ENTITYKEY"]); } histDPList.Add(newEtyHistDP); } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } if (drReader != null) { drReader.Close(); drReader.Dispose(); //SimpleDatabase.GetInstance().CloseCurrentSession(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(histDPList); }