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