/// <summary> /// Saves the selected Datapoint of the specified Sample Grp and Server name in database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void okCmd_Click(object sender, EventArgs e) { string Function_Name = "okCmd_Click"; try { if (m_localIntervalGrpID == "") { return; } if (m_view.CheckSelectionListModified()) { EtyDataLogDPTrend SampleGrpEty = new EtyDataLogDPTrend(); SampleGrpEty.OPCSampleGrpId = Convert.ToDouble(m_localIntervalGrpID); SampleGrpEty.Disabled = true; List <string> selectedItems = m_view.GetSelectedDataPoints(); List <EtyDataLogDPTrend> selectedDataPoints = new List <EtyDataLogDPTrend>(); for (int i = 0; i < selectedItems.Count; i++) { EtyDataLogDPTrend etyDataPoint = new EtyDataLogDPTrend(); etyDataPoint.Disabled = false; etyDataPoint.OPCSampleGrpId = Convert.ToDouble(m_localIntervalGrpID); etyDataPoint.OPCDataPointName = selectedItems[i]; selectedDataPoints.Add(etyDataPoint); } m_model.UpdateDataPoints(SampleGrpEty, selectedDataPoints); } MessageBoxDialog.Show(StringHelper.GetInstance().getStringValue(FormCaptionHelper.OPCDATASELECTOR_SAVE_MSG, EnglishString.SAVE_SUSSCCESSFUL_MSG)); } catch (Exception localException) { LogHelper.Error(CLASS_NAME, Function_Name, localException.ToString()); } m_view.Close(); }
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; }
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)); }
/// <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)); } }
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); }
public void TestInsertOPCDataPoint_UpdateOPCDataPointByName() { EtyDataLogDPTrend etyDataLogDPTrend = new EtyDataLogDPTrend(); etyDataLogDPTrend.OPCDataPointName = "DT18.LV.MSB.LF211.diiPWRC-MSBCBNotcloseClose.Value"; etyDataLogDPTrend.OPCSampleGrpId = 6; etyDataLogDPTrend.Disabled = false; DatalogDPTrendDAO.GetInstance().InsertOPCDataPoint(etyDataLogDPTrend); DatalogDPTrendDAO.GetInstance().UpdateOPCDataPointByName(etyDataLogDPTrend); }
/// <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 TestUpdateDataPointDB01() { OPCDataSelectorModel oPCDataSelectorModel = new OPCDataSelectorModel(); EtyDataLogDPTrend etyDP = new EtyDataLogDPTrend(); //etyDP.OPCDataPointServer = "localserver"; etyDP.EntityKey = 1; oPCDataSelectorModel.UpdateDataPointDB(etyDP); //test2 etyDP.OPCDataPointName = "testing"; oPCDataSelectorModel.UpdateDataPointDB(etyDP); }
/// <summary> /// Updates DataPoint values in database based on either name or sample group id. /// </summary> /// <param name="etyDataPoint">DataPoint entity with updated values</param> public bool UpdateDataPointDB(EtyDataLogDPTrend etyDataPoint) { bool bResult = true; if (etyDataPoint.OPCDataPointName == null) { //clears the sample group and datapoint link for specified sample group bResult = DatalogDPTrendDAO.GetInstance().UpdateOPCDataPointByGrpId(etyDataPoint.Disabled, etyDataPoint.OPCSampleGrpId); } else { bResult = DatalogDPTrendDAO.GetInstance().UpdateOPCDataPointByName(etyDataPoint); } return(bResult); }
public void TestEtyDataLogDPTrendConstructor01() { EtyDataLogDPTrend etyDataLogDPTrend = new EtyDataLogDPTrend(); etyDataLogDPTrend.Disabled = false; etyDataLogDPTrend.EntityKey = 1; etyDataLogDPTrend.OPCDataPointDesc = "des"; etyDataLogDPTrend.OPCDataPointName = "name"; etyDataLogDPTrend.OPCSampleGrpId = 1; etyDataLogDPTrend.Pkey = 2; etyDataLogDPTrend.Disabled = etyDataLogDPTrend.Disabled; etyDataLogDPTrend.EntityKey = etyDataLogDPTrend.EntityKey; etyDataLogDPTrend.OPCDataPointDesc = etyDataLogDPTrend.OPCDataPointDesc; etyDataLogDPTrend.OPCDataPointName = etyDataLogDPTrend.OPCDataPointName; etyDataLogDPTrend.OPCSampleGrpId = etyDataLogDPTrend.OPCSampleGrpId; etyDataLogDPTrend.Pkey = etyDataLogDPTrend.Pkey; }
public void UpdateDataPoints(EtyDataLogDPTrend sampleGrpEty, List <EtyDataLogDPTrend> selectedDataPoints) { DatalogDPTrendDAO.GetInstance().UpdateDataPoints(sampleGrpEty, selectedDataPoints); }