/// <summary>
/// Returns Sample Group details of the specified Sample group Key.
/// </summary>
/// <param name="opcGrpID">Sample group key</param>
/// <returns>Sample Group entity</returns>
public EtyOPCSampleGroup GetOPCGrpByID(string opcGrpID)
{
string Function_Name = "GetOPCGrpByID";
LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - {0}", opcGrpID));
EtyOPCSampleGroup etyOPCSampleGrp = new EtyOPCSampleGroup();
string localSQL = " SELECT SAMPLE_GRP_NAME,SAMPLE_GRP_DESC,SAMPLE_INTERVAL,INTERVAL_TYPE,START_TIME,DELTA_VALUE,DISABLE "
+ " FROM OPC_DT_SAMPLE_GRP WHERE SAMPLE_GRP_ID = " + opcGrpID;
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
while (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_GRP_NAME")))
{
etyOPCSampleGrp.SampleGrpName = DAOHelper.convert8859P1ToGB2312(drReader["SAMPLE_GRP_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_GRP_DESC")))
{
etyOPCSampleGrp.SampleGrpDescription = DAOHelper.convert8859P1ToGB2312(drReader["SAMPLE_GRP_DESC"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_INTERVAL")))
{
etyOPCSampleGrp.Interval = Convert.ToInt32(drReader["SAMPLE_INTERVAL"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("INTERVAL_TYPE")))
{
etyOPCSampleGrp.IntervalType = drReader["INTERVAL_TYPE"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("START_TIME")))
{
etyOPCSampleGrp.StartTime = drReader["START_TIME"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DELTA_VALUE")))
{
etyOPCSampleGrp.DeltaValue = Convert.ToDouble(drReader["DELTA_VALUE"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DISABLE")))
{
etyOPCSampleGrp.Disabled = DAOHelper.ChangeStrToBool(drReader["DISABLE"].ToString());
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyOPCSampleGrp);
}
/// <summary>
/// Returns Sample Group details of the specified Sample group Key.
/// </summary>
/// <param name="opcGrpID">Sample group key</param>
/// <returns>Sample Group entity</returns>
public EtyDataLogDPGroupTrend GetOPCGrpByID(double opcGrpID)
{
string Function_Name = "GetOPCGrpByID";
LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - {0}", opcGrpID));
EtyDataLogDPGroupTrend etyDpGroupTrend = new EtyDataLogDPGroupTrend();
string localSQL = " SELECT DP.NAME,DP.DESCRIPTION,DP.SAMPLE_INTERVAL,DP.INTERVAL_TYPE,DP.START_TIME,DP.DELTA_VALUE,DP.ENABLED,DP.LOCATION_KEY,LOC.NAME AS LOCATION_NAME"
+ " FROM DATALOG_DP_GROUP_TREND DP,LOCATION LOC WHERE DP.PKEY = " + opcGrpID.ToString() + "AND LOC.PKEY = DP.LOCATION_KEY";
/* string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_LOCATION_KEY);
* if (LocationClauseStr.Length != 0)
* {
* localSQL += " AND" + LocationClauseStr;
* }*/
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
while (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDpGroupTrend.SampleGrpName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DESCRIPTION)))
{
etyDpGroupTrend.SampleGrpDescription = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_DESCRIPTION].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_INTERVAL)))
{
etyDpGroupTrend.Interval = Convert.ToInt32(drReader[COLUMN_SAMPLE_INTERVAL]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_INTERVAL_TYPE)))
{
etyDpGroupTrend.IntervalType = drReader[COLUMN_INTERVAL_TYPE].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_START_TIME)))
{
etyDpGroupTrend.StartTime = drReader[COLUMN_START_TIME].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_DELTA_VALUE)))
{
etyDpGroupTrend.DeltaValue = Convert.ToDouble(drReader[COLUMN_DELTA_VALUE]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENABLED)))
{
etyDpGroupTrend.Disabled = !(DAOHelper.ChangeStrToBool(drReader[COLUMN_ENABLED].ToString()));
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_LOCATION_KEY)))
{
etyDpGroupTrend.LocationKey = Convert.ToDouble(drReader[COLUMN_LOCATION_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(LOCATION_NAME)))
{
etyDpGroupTrend.LocationName = DAOHelper.convert8859P1ToGB2312(drReader[LOCATION_NAME].ToString());
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDpGroupTrend);
}
/// <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 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>
/// 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);
}
