public void TestModifyFormula() { string formulaName = TestConst.FORMULA_LBL_NAME; EtyFormula data = new EtyFormula(); formulaListController.ModifyFormula(formulaName, data); }
public void TestEtyFormula01() { EtyFormula etyFormula = new EtyFormula(); string s = etyFormula.ConfigName; etyFormula.ConfigName = s; s = etyFormula.DPColor; etyFormula.DPColor = s; bool b = etyFormula.DPEnabled; etyFormula.DPEnabled = b; s = etyFormula.DPEquation; etyFormula.DPEquation = s; b = etyFormula.DPLblEnabled; etyFormula.DPLblEnabled = b; s = etyFormula.DPLblName; etyFormula.DPLblName = s; LineType lineType = etyFormula.DPType; etyFormula.DPType = lineType; ulong pkey = etyFormula.PKey; etyFormula.PKey = pkey; }
public void TestInitializeChartForRealTime01() { List <EtyDataPoint> dpList = new List <EtyDataPoint>(); EtyDataPoint etyDP = new EtyDataPoint(); etyDP.DPColor = "-32704"; etyDP.DPName = TestConst.DP_NAME; etyDP.DPEnabled = true; etyDP.DPServer = "TransActiveDataSource"; etyDP.DPType = LineType.Line; etyDP.DPVisible = true; etyDP.DPHost = "127.0.0.1"; dpList.Add(etyDP); List <EtyFormula> formulaList = new List <EtyFormula>(); EtyFormula formula = new EtyFormula(); formula.DPColor = "-32704"; formula.DPEnabled = true; formula.DPLblName = "formulaLblName"; formula.DPType = LineType.Line; formulaList.Add(formula); trendView.InitializeChartForRealTime(dpList, formulaList); }
public void TestEditDataPointFormula_Load01() { Accessor formulaDataAccessor = ReflectionAccessor.Wrap(formulaData); formulaData.SetFormType(FormType.Add); formulaDataAccessor.Call("EditDataPointFormula_Load", null, null); formulaData.SetFormType(FormType.Edit); FormulaDataController ctl = (FormulaDataController)(formulaDataAccessor.GetField("m_controller")); ctl = new FormulaDataController(); Accessor ctlAccessor = ReflectionAccessor.Wrap(ctl); EtyFormula record = (EtyFormula)(ctlAccessor.GetField("m_formula")); record = new EtyFormula(); record.DPEquation = "::a+::b"; record.DPLblName = "TestFormula"; record.DPColor = "-32704"; ctlAccessor.SetField("m_formula", record); formulaDataAccessor.SetField("m_controller", ctl); formulaDataAccessor.Call("EditDataPointFormula_Load", null, null); }
public void SetFormulaEtyByRow(ref EtyFormula formula, DataRow formulaRow) { formula.DPLblName = formulaRow["DATA_PT_LBL_NAME"].ToString(); formula.DPType = TrendViewerHelper.convertLineTypeToEnum(formulaRow["DATA_PT_TYPE"].ToString()); formula.DPColor = formulaRow["DATA_PT_COLOR"].ToString(); formula.DPEnabled = TrendViewerHelper.ChangeStrToBool(formulaRow["DATA_PT_ENABLED"].ToString()); formula.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(formulaRow["DATA_PT_LBL_ENABLED"].ToString()); formula.DPEquation = formulaRow["DATA_PT_EQUATION"].ToString(); }
public void TestAddFormulaToList_DeleteByFormulaLblName_EditFormula() { EtyFormula ety = new EtyFormula(); ety.DPLblName = "tempName"; formulaListController.AddFormulaToList(ety); formulaListController.EditFormula("tempName"); formulaListController.DeleteByFormulaLblName("tempName"); }
public void TestUpdateChartForRealTimeOrMixedMode03() { //same as TestUpdateChartForRealTimeOrMixedMode01,but Eval(tempString) throw exception DateTime fromTime = new DateTime(2013, 1, 10); DateTime toTime = new DateTime(2013, 1, 12); EtyHistDataPoint histDP = new EtyHistDataPoint(); histDP.DPName = TestConst.HIST_DP_NAME; histDP.DPServer = TestConst.SERVER; histDP.DPStartDateTime = fromTime; histDP.DPEndDateTime = toTime; histDP.DPEnabled = true; histDP.DPHost = TestConst.HOST; histDP.DPType = LineType.Line; TrendViewModel trendViewModel = new TrendViewModel(); List <EtyDataLogDPLogTrend> logList = trendViewModel.GetHistDPLogList(histDP, fromTime, toTime); Dictionary <EtyHistDataPoint, List <EtyDataLogDPLogTrend> > histDPLogMap = new Dictionary <EtyHistDataPoint, List <EtyDataLogDPLogTrend> >(); histDPLogMap.Add(histDP, logList); //stub: //OPCServerProxy.GetInstance().IsOPCServerConnected() == true //make sure series has contents: List <EtyDataPoint> dpList = new List <EtyDataPoint>(); EtyDataPoint etyDP = new EtyDataPoint(); etyDP.DPColor = "-32704"; etyDP.DPName = TestConst.DP_NAME; etyDP.DPEnabled = true; etyDP.DPServer = "TransActiveDataSource"; etyDP.DPType = LineType.Line; etyDP.DPVisible = true; etyDP.DPHost = "127.0.0.1"; dpList.Add(etyDP); List <EtyFormula> formulaList = new List <EtyFormula>(); EtyFormula formula = new EtyFormula(); formula.DPColor = "-32704"; formula.DPEnabled = true; formula.DPLblName = "formulaLblName"; formula.DPType = LineType.Line; formulaList.Add(formula); trendView.InitializeChartForRealTime(dpList, formulaList); // (mixedModeCb.Checked && m_startDateRealTime.Date != DateTime.Now.Date) CheckBox cb = (CheckBox)viewAccessor.GetField("mixedModeCb"); cb.Checked = true; viewAccessor.SetField("mixedModeCb", cb); DateTime dt = new DateTime(2011, 1, 1); viewAccessor.SetField("m_startDateRealTime", dt); trendView.UpdateChartForRealTimeOrMixedMode(histDPLogMap); }
public void TestSetFormulaEtyByRow() { EtyFormula data = new EtyFormula(); Accessor ctlAccessor = ReflectionAccessor.Wrap(formulaListController); DataTable table = (DataTable)ctlAccessor.GetField("m_FormulaTable"); DataRow row = table.NewRow(); formulaListController.SetFormulaEtyByRow(ref data, row); }
public List<EtyFormula> ConvertDataTableToList() { List<EtyFormula> formulaList = new List<EtyFormula>(); foreach (DataRow formulaRow in m_FormulaTable.Rows) { EtyFormula formula = new EtyFormula(); SetFormulaEtyByRow(ref formula, formulaRow); formulaList.Add(formula); } return formulaList; }
public EtyFormula GetNewFormula() { EtyFormula formula = new EtyFormula(); formula.DPEquation = equationBox.Text; formula.DPType = TrendViewerHelper.convertLineTypeToEnum(seriesTypeBox.Text); formula.DPColor = colorPanel.BackColor.ToArgb().ToString(); formula.DPEnabled = dataPointEnabledCb.Checked; formula.DPLblEnabled = labelEnabledCb.Checked; formula.DPLblName = dataLegendBox.Text; return(formula); }
public void AddFormulaToList(EtyFormula formula) { DataRow formulaRow = m_FormulaTable.NewRow(); formulaRow["DATA_PT_LBL_NAME"] = formula.DPLblName; formulaRow["DATA_PT_TYPE"] = TrendViewerHelper.convertLineTypeToDispLan(formula.DPType); formulaRow["DATA_PT_COLOR"] = formula.DPColor; formulaRow["DATA_PT_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPEnabled); formulaRow["DATA_PT_LBL_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPLblEnabled); formulaRow["DATA_PT_EQUATION"] = formula.DPEquation; m_FormulaTable.Rows.Add(formulaRow); m_View.PopulateDataPointListDataGridView(1); }
public void ModifyFormula(string FormulaName, EtyFormula formula) { foreach (DataRow formulaRow in m_FormulaTable.Rows) //will only have 1 record { if (FormulaName == formulaRow["DATA_PT_LBL_NAME"].ToString()) { formulaRow["DATA_PT_LBL_NAME"] = formula.DPLblName; formulaRow["DATA_PT_TYPE"] = formula.DPType; formulaRow["DATA_PT_COLOR"] = formula.DPColor; formulaRow["DATA_PT_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPEnabled); formulaRow["DATA_PT_LBL_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPLblEnabled); formulaRow["DATA_PT_EQUATION"] = formula.DPEquation; } } m_View.PopulateDataPointListDataGridView(1); }
public void TestdataPointListDataGridView_CellDoubleClick02() { //exception Accessor formulaListAccessor = ReflectionAccessor.Wrap(formulaList); DataGridView formulaListDataGridView = (DataGridView)(formulaListAccessor.GetField("formulaListDataGridView")); FormulaListController ctl = (FormulaListController)(formulaList.getController()); EtyFormula formula = new EtyFormula(); formula.DPEquation = "::a::"; ctl.AddFormulaToList(formula); object sender = null; DataGridViewCellEventArgs e = new DataGridViewCellEventArgs(7, 0); formulaListAccessor.Call("dataPointListDataGridView_CellDoubleClick", sender, e); }
public void SetFormulaTable(List <EtyFormula> formulaList) { m_FormulaTable.Rows.Clear(); DataRow newDataPointFormulaRow = null; for (int i = 0; i < formulaList.Count; i++) { EtyFormula formula = formulaList[i]; newDataPointFormulaRow = m_FormulaTable.NewRow(); newDataPointFormulaRow["DATA_PT_LBL_NAME"] = formula.DPLblName; newDataPointFormulaRow["DATA_PT_TYPE"] = formula.DPType; newDataPointFormulaRow["DATA_PT_COLOR"] = formula.DPColor; newDataPointFormulaRow["DATA_PT_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPEnabled); newDataPointFormulaRow["DATA_PT_LBL_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(formula.DPLblEnabled); newDataPointFormulaRow["DATA_PT_EQUATION"] = formula.DPEquation; m_FormulaTable.Rows.Add(newDataPointFormulaRow); } }
public void SaveFormulaListToGroup(string grpName) { string Function_Name = "SaveFormulaListToGroup"; List <EtyFormula> formulaList = new List <EtyFormula>(); foreach (DataRow formulaRow in m_FormulaTable.Rows) { EtyFormula formula = new EtyFormula(); SetFormulaEtyByRow(ref formula, formulaRow); formulaList.Add(formula); } try { m_Model.SaveFormulaListToGroup(formulaList, grpName); } catch (Exception ex) { TrendViewerHelper.HandleEx(ex); } }
private void EditDataPointFormula_Load(object sender, EventArgs e) { string Function_Name = "EditDataPointFormula_Load"; try { colorPanel.BackColor = Color.Black; seriesTypeBox.Items.Add(StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_LintTypeLine, LanguageHelper.TrendViewer_LintTypeLine_EN)); seriesTypeBox.Items.Add(StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_LintTypeSpline, LanguageHelper.TrendViewer_LintTypeSpline_EN)); if (m_formType == FormType.Add) { seriesTypeBox.Text = StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_LintTypeLine, LanguageHelper.TrendViewer_LintTypeLine_EN); this.Text = StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_FormulaData_AddTitle, LanguageHelper.TrendViewer_FormulaData_AddTitle_EN); } else //for "Edit" { FormulaDataController ctl = (FormulaDataController)(getController()); EtyFormula formula = ctl.GetFormula(); equationBox.Text = formula.DPEquation; seriesTypeBox.Text = TrendViewerHelper.convertLineTypeToDispLan(formula.DPType); dataLegendBox.Text = formula.DPLblName; if (isNumeric(formula.DPColor, System.Globalization.NumberStyles.Number)) { colorPanel.BackColor = Color.FromArgb(Convert.ToInt32(formula.DPColor)); } dataPointEnabledCb.Checked = formula.DPEnabled; labelEnabledCb.Checked = formula.DPLblEnabled; this.Text = StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_FormulaData_EditTitle, LanguageHelper.TrendViewer_FormulaData_EditTitle_EN); } } catch (Exception localException) { LogHelper.Error(CLASS_NAME, Function_Name, localException.ToString()); } }
public void Test_Delete_Insert_Get_FormulaList() { string grpName = "UnitTestFormulaGrp"; formulaerDAO.DeleteAllFormulaInGrp(grpName); List <EtyFormula> formulaList = new List <EtyFormula>(); EtyFormula formula1 = new EtyFormula(); formula1.DPLblName = "Lbl1"; formula1.DPEquation = "equationStr1"; EtyFormula formula2 = new EtyFormula(); formula2.DPEquation = "equationStr2"; formula2.DPLblName = "Lbl2"; formulaList.Add(formula1); formulaList.Add(formula2); //formulaerDAO.InsertFormulaListToGrp(formulaList, grpName); formulaerDAO.SaveFormulaListToGrp(formulaList, grpName); formulaerDAO.GetFormulasByCfgName(grpName); }
/// <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); }