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