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