/// <summary>
/// Returns the total sample group records count in table
/// </summary>
/// <returns>No of Sample group configured</returns>
public int GetRowCount()
{
string Function_Name = "GetRowCount";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL;
int nRowCount = 0;
localSQL = "SELECT COUNT(SAMPLE_GRP_NAME) AS MAXROWS FROM OPC_DT_SAMPLE_GRP";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(0))
{
LogHelper.Debug(CLASS_NAME, Function_Name, "Function_Exited");
nRowCount = Convert.ToInt32(drReader["MAXROWS"]);
}
}
}
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(nRowCount);
}
public bool GetOPCDataPointByName(string dataPoint)
{
string Function_Name = "GetOPCDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = "SELECT PKEY FROM DATALOG_DP_TREND WHERE DP_NAME = '" + dataPoint + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
bool bFound = false;
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY)))
{
bFound = true;
}
}
}
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(bFound);
}
/// <summary>
/// Updates the datapoints of specified name
/// </summary>
/// <param name="EtyDataLogDPTrend"></param>
public bool UpdateOPCDataPointByName(EtyDataLogDPTrend etyDPTrend)
{
const string Function_Name = "UpdateOPCDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string sEnabled = DAOHelper.GetEnabledStr(DAOHelper.ChangeBoolToStr(etyDPTrend.Disabled));
if (GetOPCDataPointByName(etyDPTrend.OPCDataPointName))
{
List <string> sqlStrings = new List <string>();
for (int i = 0; i < 2; i++)
{
string sql = " UPDATE DATALOG_DP_TREND "
+ " SET DP_GRP_ID = " + etyDPTrend.OPCSampleGrpId.ToString()
+ ",ENABLED = '" + sEnabled + "'"
+ " WHERE DP_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(etyDPTrend.OPCDataPointName.Trim()) + "'";
sqlStrings.Add(sql);
}
List <SqlParameter> parameters = DAOHelper.CreateEnqueneParameters(sqlStrings);
return(SimpleDatabase.GetInstance().ExecuteEnqueneProcedure(parameters));
}
else
{
return(InsertOPCDataPoint(etyDPTrend));
}
}
/// <summary>
/// Returns the value of the specified variable name
/// </summary>
/// <param name="varName">Variable name</param>
/// <returns>variable value</returns>
public string GetVarValue(string varName)
{
string Function_Name = "GetVarValue";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string varValue = "null";
string localSQL = "SELECT VAR_VALUE FROM CONFIG_VARS WHERE VAR_NAME = '" + varName + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
if (!drReader.IsDBNull(0))
{
varValue = drReader.GetString(0).ToString();
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(varValue);
}
public bool InsertOPCDataPoint(EtyDataLogDPTrend etyDPTrend)
{
const string Function_Name = "InsertOPCDataPoint";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string sEnabled = DAOHelper.GetEnabledStr(DAOHelper.ChangeBoolToStr(etyDPTrend.Disabled));
string dpName = etyDPTrend.OPCDataPointName.Trim();
if (dpName.Contains(".Value"))
{
dpName = dpName.Remove(dpName.Length - 6);
}
List <string> sqlStrings = new List <string>();
for (int i = 0; i < 2; i++)
{
string sql = "INSERT INTO DATALOG_DP_TREND (PKEY, ENTITY_KEY, DP_NAME, DP_GRP_ID,ENABLED)"
+ " (SELECT PKEY,PKEY,CONCAT(NAME,'.Value'),"
+ etyDPTrend.OPCSampleGrpId.ToString()
+ ",'" + sEnabled + "'"
+ " FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint' )"
+ " AND NAME = '" + dpName + "')";
sqlStrings.Add(sql);
}
List <SqlParameter> parameters = DAOHelper.CreateEnqueneParameters(sqlStrings);
return(SimpleDatabase.GetInstance().ExecuteEnqueneProcedure(parameters));
}
public void UpdateDataPoints(EtyDataLogDPTrend sampleGrpEty, List <EtyDataLogDPTrend> selectedDataPoints)
{
SimpleDatabase.GetInstance().BeginTransaction();
bool bResult = UpdateOPCDataPointByGrpId(sampleGrpEty.Disabled, sampleGrpEty.OPCSampleGrpId);
if (bResult)
{
for (int i = 0; i < selectedDataPoints.Count; i++)
{
bResult = UpdateOPCDataPointByName(selectedDataPoints[i]);
}
}
if (bResult)
{
bResult = DatalogConfigSettingsDAO.GetInstance().UpdateTrendVersionNum();
}
if (bResult)
{
SimpleDatabase.GetInstance().CommitTransaction();
}
else
{
SimpleDatabase.GetInstance().RollbackTransaction();
}
return;
}
/// <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 marker list to a marker group
/// </summary>
/// <param name="markerList">marker list</param>
/// <param name="grpName">marker group name</param>
public bool InsertMarkerListToGrp(List <EtyMarker> markerList, string grpName)
{
const string Function_Name = "InsertMarkerListToGrp";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
bool executeOK = false;
string localSQL = " INSERT INTO TRENDVIEWER_MARKER(CONFIG_NAME,MARKER_NAME,MARKER_WIDTH,MARKER_BCOLOR,MARKER_VALUE,MARKER_ENABLED,MARKER_FCOLOR) " +
" VALUES( '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(grpName) + "'";
foreach (EtyMarker marker in markerList)
{
string markerEnabledStr = "Y";
if (!marker.MarkerEnabled)
{
markerEnabledStr = "N";
}
executeOK = SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL
+ ",'" + DAOHelper.convertEscapeStringAndGB2312To8859P1(marker.MarkerName) + "'"
+ ", " + marker.MarkerWidth.ToString()
+ ",'" + marker.MarkerBColor + "'"
+ ", " + marker.MarkerValue.ToString()
+ ",'" + markerEnabledStr + "'"
+ ",'" + marker.MarkerFColor + "'"
+ " ) ");
if (executeOK == false)
{
break;
}
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(executeOK);
}
/// <summary>
/// retrieve all the configuration name for real-time charting.
/// </summary>
/// <returns></returns>
public List <string> GetAllDPGrpNames()
{
string Function_Name = "GetAllDPGrpNames";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <string> dpGrpNames = new List <string>();
string localSQL = " SELECT DISTINCT CONFIG_NAME FROM TRENDVIEWER_CONFIG order by config_name ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
if (!drReader.IsDBNull(0))
{
dpGrpNames.Add(DAOHelper.convert8859P1ToGB2312(drReader["CONFIG_NAME"].ToString()));
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(dpGrpNames);
}
public string GetLocationNameFromKey(double locationKey)
{
string Function_Name = "GetLocationNameFromKey";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string locationName = "";
string localSQL = "SELECT NAME FROM LOCATION WHERE PKEY = " + locationKey.ToString();
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal("NAME")))
{
locationName = DAOHelper.convert8859P1ToGB2312(drReader["NAME"].ToString());
}
}
}
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(locationName);
}
public void TestCreateCommand()
{
SimpleDatabase.GetInstance().BeginTransaction();
SimpleDatabase.GetInstance().ExecuteNonQuery("select * from entity");
SimpleDatabase.GetInstance().RollbackTransaction();
}
/// <summary>
/// Updates the datapoints of specified name
/// </summary>
/// <param name="disabled">true-disabled , false - enabled</param>
/// <param name="opcServerName">datapoint server name</param>
/// <param name="sampleGrpId">sample group key</param>
/// <param name="DataPointName">datapoint name to be updated</param>
public void UpdateOPCDataPointByName(EtyOPCDataPoint etyDataPoint) //bool disabled, string opcServerName, double sampleGrpId,string DataPointName)
{
const string Function_Name = "UpdateOPCDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = " UPDATE OPC_DT_PT "
+ " SET SAMPLE_GRP_ID = " + etyDataPoint.OPCSampleGrpId.ToString()
+ ",DISABLE = '" + DAOHelper.ChangeBoolToStr(etyDataPoint.Disabled) + "'"
+ " WHERE DATA_PT_NAME = '" + DAOHelper.convertGB2312To8859P1(etyDataPoint.OPCDataPointName.Trim()) + "'"
+ " AND DATA_PT_SERVER = '" + DAOHelper.convertGB2312To8859P1(etyDataPoint.OPCDataPointServer.Trim()) + "'";
//DBConnection.getInstance().ExecuteOracleNonQuery(localSQL, dbConn);
if (!SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL))
{
string dpName = etyDataPoint.OPCDataPointName.Trim();
if (dpName.Contains(".Value"))
{
dpName = dpName.Remove(dpName.Length - 6);
}
//insert the datapoint into the OPC_dt_pt table.
localSQL = "INSERT INTO OPC_DT_PT (DATA_PT_HOST, DATA_PT_SERVER, KEYID, DATA_PT_NAME, DATA_PT_DESC, PKEYID,SAMPLE_GRP_ID,DISABLE)"
+ " (SELECT '127.0.0.1', 'TransActiveDataSource', PKEY,CONCAT(NAME,'.Value'),DESCRIPTION , PARENTKEY,"
+ etyDataPoint.OPCSampleGrpId.ToString()
+ ",'" + DAOHelper.ChangeBoolToStr(etyDataPoint.Disabled) + "'"
+ " FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint' )"
+ " AND NAME = '" + dpName + "')";
SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
}
/// <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);
}
public void TestUpdateDataPointDB01()
{
OPCSampleGrpConfigStartModel oPCSampleGrpConfigStartModel = OPCSampleGrpConfigStartModelFactory.CreateOPCSampleGrpConfigStartModel01();
double sampleGrpID = double.MinValue;
oPCSampleGrpConfigStartModel.UpdateDataPointDB(sampleGrpID);
//Test2---Valid input
#region TestSetup
//insert testing group
EtyDataLogDPGroupTrend etySampleGrp = new EtyDataLogDPGroupTrend();
etySampleGrp.NewData = true;
etySampleGrp.SampleGrpName = "DOTTestParasoftTesting123";
etySampleGrp.Interval = 1;
etySampleGrp.IntervalType = "M";
etySampleGrp.Disabled = false;
oPCSampleGrpConfigStartModel.InsertOPCSampleGrp(etySampleGrp);
//getSampleId from DB
List <EtyDataLogDPGroupTrend> list = oPCSampleGrpConfigStartModel.GetAllOPCSampelGrp(OPCSampleGrpConfigStart.OPCSAMPLEGRPDESC_COL_NAME, OPCSampleGrpConfigStart.OPCSAMPLEGRP_SORT_ASC);
foreach (var item in list)
{
if (item.SampleGrpName.Equals("DOTTestParasoftTesting123"))
{
etySampleGrp = item;
break;
}
}
//insert testing Datapoint
EtyDataLogDPTrend etyOPCDP = new EtyDataLogDPTrend();
etyOPCDP.OPCDataPointName = "DOTTestParasoftDP1.Value";
etyOPCDP.EntityKey = 20099999;
etyOPCDP.OPCSampleGrpId = etySampleGrp.SampleGrpID;
etyOPCDP.Disabled = false;
DatalogDPTrendDAO.GetInstance().InsertOPCDataPoint(etyOPCDP);
#endregion
//Test Procedure Call
oPCSampleGrpConfigStartModel.UpdateDataPointDB(etySampleGrp.SampleGrpID);
//Post Condition Check
#region PostConditionCheck
bool bDisable = false;
string sampleGrpIDstr = etySampleGrp.SampleGrpID.ToString();
//Get DataPoint from DB
double sampleid = DatalogDPTrendDAO.GetInstance().GetGrpIDByDPName("DOTTestParasoftDP1.Value");
//Assert.IsTrue(bDisable);
Assert.AreEqual(sampleid, -1);
#endregion
#region CleanUp
//Clean up inserted test data in DB
//Delete testing DP
string localSQL = "Delete from OPC_DT_PT where DATA_PT_NAME = 'DOTTestParasoftDP1.Value'";
SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
//Delete Testing sampleGrp
DatalogDPGroupTrendDAO.GetInstance().DeleteOPCSampleGroupById(etySampleGrp.SampleGrpID.ToString());
#endregion
}
/// <summary>
/// Returns the DataPoints based specified datapoint name substring.
/// </summary>
/// <param name="opcServerName">Datapoint server name</param>
/// <param name="DataPointNameSubstr"> Datapoint name substring to be queried</param>
/// <returns>Datapoints</returns>
public List <EtyDataLogDPTrend> GetDataPointByName(string opcServerName, string DataPointNameSubstr)
{
const string Function_Name = "GetDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataLogDPTrend> etyDPTrendList = new List <EtyDataLogDPTrend>();
string localSQL = "SELECT et.PKEY AS ENTITY_KEY,CONCAT(et.NAME,'.Value')as DP_NAME ,DP.DP_GRP_ID AS DP_GRP_ID FROM ENTITY et LEFT JOIN DATALOG_DP_TREND DP" +
" ON et.PKEY = DP.ENTITY_KEY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint')" +
" AND UPPER(et.NAME) LIKE '%" + DAOHelper.convertEscapeStringAndGB2312To8859P1(DataPointNameSubstr) + "%'";
string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_ENTITY_LOCATIONKEY);
if (LocationClauseStr.Length != 0)
{
localSQL += " AND" + LocationClauseStr;
}
localSQL += " ORDER BY DP_NAME ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyDataLogDPTrend etyDPTrend = new EtyDataLogDPTrend();
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENTITY_KEY)))
{
etyDPTrend.EntityKey = Convert.ToDouble(drReader[COLUMN_ENTITY_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDPTrend.OPCDataPointName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_GRP_ID)))
{
etyDPTrend.OPCSampleGrpId = Convert.ToDouble(drReader[COLUMN_SAMPLE_GRP_ID]);
}
etyDPTrendList.Add(etyDPTrend);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDPTrendList);
}
/// <summary>
/// Returns all the Root Data Nodes.
/// </summary>
/// <returns>Root Data Nodes</returns>
public List <EtyOPCDataNode> GetAllOPCDataNode(string serverRootName, string opcServerName)
{
const string Function_Name = "GetAllOPCDataNode";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyOPCDataNode> OPCDataNodeList = new List <EtyOPCDataNode>();
string localSQL = " SELECT KEYID,DT_NODE_NAME,DT_NODE_DESC " +
" FROM OPC_DT_NODE WHERE PKEYID IN (SELECT DISTINCT PKEY FROM ENTITY WHERE NAME = '" + serverRootName + "') AND DISABLE = 'N' AND DATA_PT_SERVER = '" + opcServerName
+ "' ORDER BY DT_NODE_NAME";
//sql for getting from entity table
/*string localSQL = " SELECT PKEY,NAME,DESCRIPTION" +
* " FROM ENTITY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataNode')"+
* " AND PARENTKEY IN (SELECT DISTINCT PKEY FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'SCADAROOT'))"+
* " ORDER BY NAME";*/
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyOPCDataNode etyOPCDataNode = new EtyOPCDataNode();
if (!drReader.IsDBNull(drReader.GetOrdinal("KEYID")))
{
etyOPCDataNode.OPCDataNodeId = Convert.ToDouble(drReader["KEYID"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_NAME")))
{
etyOPCDataNode.OPCDataNodeName = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_DESC")))
{
etyOPCDataNode.OPCDataNodeDesc = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_DESC"].ToString());
}
OPCDataNodeList.Add(etyOPCDataNode);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(OPCDataNodeList);
}
public void FixtureSetUp()
{
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.OPCDataSelector, TestConst.TEST_VIEW_ID);
oPCDataSelectorController = (OPCDataSelectorController)(view.getController());
//oPCDataSelectorController.InitDataNodeList();
}
/// <summary>
/// Updates the value of the variable name.
/// </summary>
/// <param name="VarName">varaible name </param>
/// <param name="VarValue">varaible value</param>
public void UpdateValue(string VarName, string VarValue)
{
string Function_Name = "UpdateValue";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = "UPDATE CONFIG_VARS SET VAR_VALUE = '" + VarValue + "' WHERE VAR_NAME = '" + VarName + "'";
SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
}
/// <summary>
/// Returns the DataPoints based on the filterstring for specified server name.
/// e.g. for filterstring can include substring datapoint name to search.
/// </summary>
/// <param name="opcServerName">datapoint server name</param>
/// <param name="filterString">Where clause query string</param>
/// <returns>Datapoints</returns>
public List <EtyDataLogDPTrend> GetOPCDataPoint(string opcServerName, string filterString)
{
const string Function_Name = "GetOPCDataPoint";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataLogDPTrend> etyDPTrendList = new List <EtyDataLogDPTrend>();
string localSQL = "SELECT et.PKEY AS ENTITY_KEY,CONCAT(et.NAME,'.Value') as DP_NAME ,DP.DP_GRP_ID as DP_GRP_ID FROM ENTITY et LEFT JOIN DATALOG_DP_TREND DP"
+ " ON et.PKEY = DP.ENTITY_KEY WHERE et.TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint')";
if (filterString.Trim() != "")
{
localSQL += filterString;
}
localSQL += " ORDER BY DP_NAME ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyDataLogDPTrend etyDPTrend = new EtyDataLogDPTrend();
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENTITY_KEY)))
{
etyDPTrend.EntityKey = Convert.ToDouble(drReader[COLUMN_ENTITY_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDPTrend.OPCDataPointName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_GRP_ID)))
{
etyDPTrend.OPCSampleGrpId = Convert.ToDouble(drReader[COLUMN_SAMPLE_GRP_ID]);
}
etyDPTrendList.Add(etyDPTrend);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDPTrendList);
}
public void FixtureSetUp()
{
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.TrendView, TestConst.TEST_VIEW_ID); //viewID is ""
trendView = (TrendView)view;
ConfigureFileHelper.GetInstance().init();
viewAccessor = ReflectionAccessor.Wrap(trendView);
}
public void FixtureSetUp()
{
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.TrendView, TestConst.TEST_VIEW_ID);
trendViewController = (TrendViewController)view.getController();
if (DBConnectionStrings.GetInstance().GetConnectionStrings().Count < 1)
{
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
}
}
/// <summary>
/// Disables and clears the sample group link of the datapoints belonging to specified sample group
/// </summary>
/// <param name="sampleGrpId">datapoint sample group key</param>
public void DisableGrpDataPoint(double sampleGrpId)
{
const string Function_Name = "DisableGrpDataPoint";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = "UPDATE OPC_DT_PT SET DISABLE = 'Y',SAMPLE_GRP_ID = '' WHERE SAMPLE_GRP_ID = " + sampleGrpId;
SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
}
public bool SaveDPListToGrp(List <EtyDataPoint> datapointList, string grpName)
{
SimpleDatabase.GetInstance().BeginTransaction();
if (DeleteAllDPInGrp(grpName))
{
if (InsertDPListToGrp(datapointList, grpName))
{
SimpleDatabase.GetInstance().CommitTransaction();
return(true);
}
}
SimpleDatabase.GetInstance().RollbackTransaction();
return(false);
}
/// <summary>
/// delete formula configuration by the configuration name.
/// </summary>
/// <param name="grpName">the formula configuration name</param>
public bool DeleteAllFormulaInGrp(string grpName)
{
string Function_Name = "DeleteAllFormulaInGrp";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
bool executeOK = false;
string localSQL = " DELETE FROM TRENDVIEWER_FORMULA_CONFIG WHERE CONFIG_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(grpName) + "'";
executeOK = SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(executeOK);
}
/// <summary>
/// Updates HAS_DT_PT flag of the specified sample Group
/// </summary>
/// <param name="opcGrpId">sample group key</param>
/// <param name="hasDP">flag value</param>
public void UpdateGrpDataPointFlag(double opcGrpId, bool hasDP)
{
string Function_Name = "UpdateGrpDataPointFlag";
LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - SampleGroup ID = {0}, Flag = {1}", opcGrpId, hasDP));
string localSQL = "UPDATE OPC_DT_SAMPLE_GRP SET HAS_DT_PT = '" + DAOHelper.ChangeBoolToStr(hasDP) + "'"
+ " WHERE SAMPLE_GRP_ID = " + opcGrpId.ToString();
SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL);
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
}
public void FixtureSetUp()
{
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.ChangeTrendTitle, "Test_ViewID");
changeTrendTitleController = (ChangeTrendTitleController)(view.getController());
string[] titles = new string[3];
titles[0] = "";
titles[1] = "";
titles[2] = "";
changeTrendTitleController.InitData(titles);
changeTrendTitleController.AttachCallBack(null, view);
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
}
public bool SaveMarkerListToGrp(List <EtyMarker> markerList, string grpName)
{
SimpleDatabase.GetInstance().BeginTransaction();
if (DeleteAllMarkerInGrp(grpName))
{
if (InsertMarkerListToGrp(markerList, grpName))
{
SimpleDatabase.GetInstance().CommitTransaction();
return(true);
}
}
SimpleDatabase.GetInstance().RollbackTransaction();
return(false);
}
public bool SaveFormulaListToGrp(List <EtyFormula> formulaList, string grpName)
{
SimpleDatabase.GetInstance().BeginTransaction();
if (DeleteAllFormulaInGrp(grpName))
{
if (InsertFormulaListToGrp(formulaList, grpName))
{
SimpleDatabase.GetInstance().CommitTransaction();
return(true);
}
}
SimpleDatabase.GetInstance().RollbackTransaction();
return(false);
}
public void FixtureSetUp()
{
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.LoadConfigHistDataPoint, TestConst.TEST_VIEW_ID);
histDataPointGroupController = (HistDataPointGroupController)(view.getController());
histDataPointGroupController.SetFormType(FormType.Load);
histDataPointGroupController.InitHistDPGrp();
((HistDataPointGroup)(view)).SetFormType(FormType.Load);
((HistDataPointGroup)view).FillConfigNameBox(histDataPointGroupController.GetHistDataPointGrpNames());
((HistDataPointGroup)view).SetCurrentGrpName(TestConst.HIST_GROUP_NAME);
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
}
public void FixtureSetUp()
{
if (DBConnectionStrings.GetInstance().GetConnectionStrings().Count < 1)
{
DBConnectionStrings.GetInstance().AddConnectionString(TestConst.CONNECTION_STR);
SimpleDatabase.GetInstance().OpenConnection();
}
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.LoadConfigFormula, TestConst.TEST_VIEW_ID);
formulaGroupController = (FormulaGroupController)(view.getController());
formulaGroupController.SetFormType(FormType.Load);
formulaGroupController.InitFormulaGrp();
}
