public void TestChangeStrToBool01()
{
string str = string.Empty;
bool b = TrendViewerHelper.ChangeStrToBool(str);
str = "Y";
b = TrendViewerHelper.ChangeStrToBool(str);
}
public void TestconvertLineTypeToDispLan01()
{
LineType lineType = LineType.Line;
string str = TrendViewerHelper.convertLineTypeToDispLan(lineType);
lineType = LineType.Spline;
str = TrendViewerHelper.convertLineTypeToDispLan(lineType);
}
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 InitFormulaData(DataRow formulaRow, List <string> formulaNameList) // for "Edit"
{
m_otherFormulaNames = formulaNameList;
m_formula.DPLblName = formulaRow["DATA_PT_LBL_NAME"].ToString();
m_formula.DPType = TrendViewerHelper.convertLineTypeToEnum(formulaRow["DATA_PT_TYPE"].ToString());
m_formula.DPColor = formulaRow["DATA_PT_COLOR"].ToString();
m_formula.DPEnabled = TrendViewerHelper.ChangeStrToBool(formulaRow["DATA_PT_ENABLED"].ToString());
m_formula.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(formulaRow["DATA_PT_LBL_ENABLED"].ToString());
m_formula.DPEquation = formulaRow["DATA_PT_EQUATION"].ToString();
}
public void TestconvertLineTypeToEnum01()
{
string lineType = string.Empty;
LineType lineType1 = TrendViewerHelper.convertLineTypeToEnum(lineType);
lineType = "Line";
lineType1 = TrendViewerHelper.convertLineTypeToEnum(lineType);
lineType = "Spline";
lineType1 = TrendViewerHelper.convertLineTypeToEnum(lineType);
}
/// <summary>
/// set datapoint row by a given datapoint entity
/// </summary>
/// <param name="dpRow">the datarow to be set</param>
/// <param name="dataPoint">the datapoint entiy</param>
private void setDataPointRowByEty(ref DataRow dpRow, EtyDataPoint dataPoint)
{
dpRow["DATA_PT_HOST"] = dataPoint.DPHost;
dpRow["DATA_PT_NAME"] = dataPoint.DPName;
dpRow["DATA_PT_TYPE"] = TrendViewerHelper.convertLineTypeToDispLan(dataPoint.DPType);
dpRow["DATA_PT_COLOR"] = dataPoint.DPColor;
dpRow["DATA_PT_SERVER"] = dataPoint.DPServer;
dpRow["DATA_PT_LBL_NAME"] = dataPoint.DPLblName;
dpRow["DATA_PT_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(dataPoint.DPEnabled);
dpRow["DATA_PT_LBL_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(dataPoint.DPLblEnabled);
dpRow["DATA_PT_VISIBLE"] = TrendViewerHelper.ChangeBoolToStr(dataPoint.DPVisible);
}
/// <summary>
/// set a datapoint entity by a datarow
/// </summary>
/// <param name="dataPoint">the datapoint entity to be set</param>
/// <param name="dpRow">the datarow</param>
public void SetDataPointEtyByRow(ref EtyDataPoint dataPoint, DataRow dpRow)
{
dataPoint.DPHost = dpRow["DATA_PT_HOST"].ToString();
dataPoint.DPName = dpRow["DATA_PT_NAME"].ToString();
dataPoint.DPType = TrendViewerHelper.convertLineTypeToEnum(dpRow["DATA_PT_TYPE"].ToString());
dataPoint.DPColor = dpRow["DATA_PT_COLOR"].ToString();
dataPoint.DPServer = dpRow["DATA_PT_SERVER"].ToString();
dataPoint.DPLblName = dpRow["DATA_PT_LBL_NAME"].ToString();
dataPoint.DPEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_ENABLED"].ToString());
dataPoint.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_LBL_ENABLED"].ToString());
dataPoint.DPVisible = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_VISIBLE"].ToString());
}
/// <summary>
/// save datapoint list to a configuration
/// </summary>
/// <param name="grpName">configuration name</param>
public void SaveDataPointListToGroup(string grpName)
{
string Function_Name = "SaveDataPointListToGroup";
try
{
m_Model.SaveDPListToGroup(ConvertDataTableToList(), grpName);
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
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 TestisBoolean01()
{
string val = string.Empty;
bool b = TrendViewerHelper.isBoolean(val);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record(b);
recorder.FinishRecording();
#endregion
#region Assertions
Assert.IsFalse(b);
#endregion
}
public void TestconvertLineTypeToDispLan02()
{
LineType lineType = LineType.Spline;
string str = TrendViewerHelper.convertLineTypeToDispLan(lineType);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record(str);
recorder.FinishRecording();
#endregion
#region Assertions
Assert.AreEqual("Spline", str);
#endregion
}
public void TestChangeBoolToStr02()
{
bool b = false;
string str = TrendViewerHelper.ChangeBoolToStr(b);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record(str);
recorder.FinishRecording();
#endregion
#region Assertions
Assert.AreEqual("N", str);
#endregion
}
private void SetHistDataPointRowByEty(ref DataRow dpRow, EtyHistDataPoint dataPoint)
{
dpRow["DATA_PT_NAME"] = dataPoint.DPName;
dpRow["DATA_PT_TYPE"] = TrendViewerHelper.convertLineTypeToDispLan(dataPoint.DPType);
dpRow["DATA_PT_COLOR"] = dataPoint.DPColor;
dpRow["DATA_PT_SERVER"] = dataPoint.DPServer;
dpRow["DATA_PT_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(dataPoint.DPEnabled);
dpRow["DATA_PT_LBL_ENABLED"] = TrendViewerHelper.ChangeBoolToStr(dataPoint.DPLblEnabled);
dpRow["DATA_PT_LBL_NAME"] = dataPoint.DPLblName;
dpRow["DATA_PT_DT"] = dataPoint.DPStartDateTime;
dpRow["DATA_PT_HOST"] = dataPoint.DPHost;
dpRow["DATA_PT_DT_END"] = dataPoint.DPEndDateTime;
dpRow["ENTITYKEY"] = dataPoint.EntityKey;
}
public void SetHistDataPointEtyByRow(ref EtyHistDataPoint dataPoint, DataRow dpRow)
{
dataPoint.DPHost = dpRow["DATA_PT_HOST"].ToString();
dataPoint.DPName = dpRow["DATA_PT_NAME"].ToString();
dataPoint.DPType = TrendViewerHelper.convertLineTypeToEnum(dpRow["DATA_PT_TYPE"].ToString());
dataPoint.DPColor = dpRow["DATA_PT_COLOR"].ToString();
dataPoint.DPServer = dpRow["DATA_PT_SERVER"].ToString();
dataPoint.DPLblName = dpRow["DATA_PT_LBL_NAME"].ToString();
dataPoint.DPEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_ENABLED"].ToString());
dataPoint.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_LBL_ENABLED"].ToString());
dataPoint.DPStartDateTime = (DateTime)(dpRow["DATA_PT_DT"]);
dataPoint.DPEndDateTime = (DateTime)(dpRow["DATA_PT_DT_END"]);
dataPoint.EntityKey = Convert.ToUInt64(dpRow["ENTITYKEY"]);
}
public void TestCheckValidVariables01()
{
string statement = string.Empty;
string str = TrendViewerHelper.CheckValidVariables(statement);
statement = "aaa";
str = TrendViewerHelper.CheckValidVariables(statement);
statement = "a::b";
str = TrendViewerHelper.CheckValidVariables(statement);
statement = "::a::b";
str = TrendViewerHelper.CheckValidVariables(statement);
statement = "::a";
str = TrendViewerHelper.CheckValidVariables(statement);
}
public void TestgetETrendingChartType01()
{
string displayName = string.Empty;
ETrendingChartType eTrendingChartType = TrendViewer.View.TrendViewerHelper.getETrendingChartType(displayName);
TrendViewerHelper helper = new TrendViewerHelper();
Accessor trendingHelperAc = ReflectionAccessor.Wrap(helper);
displayName = (string)trendingHelperAc.GetField("FORMULA_PRE");
eTrendingChartType = TrendViewerHelper.getETrendingChartType(displayName);
displayName = (string)trendingHelperAc.GetField("HIST_PRE");
eTrendingChartType = TrendViewerHelper.getETrendingChartType(displayName);
}
public void TestisNumeric01()
{
string val = string.Empty;
NumberStyles numberStyle = NumberStyles.AllowTrailingSign;
bool b = TrendViewerHelper.isNumeric(val, numberStyle);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record(b);
recorder.FinishRecording();
#endregion
#region Assertions
Assert.IsFalse(b);
#endregion
}
public void TestgetDisplayName03()
{
ETrendingChartType trendingCType = ETrendingChartType.RealTime;
string inputName = string.Empty;
string str = TrendViewerHelper.getDisplayName(trendingCType, inputName);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record(str);
recorder.FinishRecording();
#endregion
#region Assertions
Assert.AreEqual("", str);
#endregion
}
public void InitHistDPGrp()
{
string Function_Name = "InitHistDPGrp";
try
{
if (null == m_HistDataPointCfgNameList)
{
m_HistDataPointCfgNameList = m_Model.GetAllHistDPGrp();
}
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
public void InitFormulaGrp()
{
string Function_Name = "InitFormulaGrp";
try
{
if (null == m_formulaCfgNameList)
{
m_formulaCfgNameList = m_Model.GetAllFormulaGrp();
}
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
/// <summary>
/// init the current datapoint for "Edit" function.
/// </summary>
/// <param name="dpRow">dataRow of a datapoint detail</param>
/// <param name="dpNameList">other datapoint name list except the current one in the group</param>
public void Init(DataRow dpRow, List <string> dpNameList) // for "Edit"
{
m_otherDataPointNames = dpNameList;
m_originalName = dpRow["DATA_PT_NAME"].ToString();
m_dp.DPHost = dpRow["DATA_PT_HOST"].ToString();
m_dp.DPName = dpRow["DATA_PT_NAME"].ToString();
m_dp.DPType = TrendViewerHelper.convertLineTypeToEnum(dpRow["DATA_PT_TYPE"].ToString());
m_dp.DPColor = dpRow["DATA_PT_COLOR"].ToString();
m_dp.DPServer = dpRow["DATA_PT_SERVER"].ToString();
m_dp.DPLblName = dpRow["DATA_PT_LBL_NAME"].ToString();
m_dp.DPEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_ENABLED"].ToString());
m_dp.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_LBL_ENABLED"].ToString());
m_dp.DPVisible = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_VISIBLE"].ToString());
}
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 InitMarkerData(DataRow markerRow, List <string> markerNameList) // for "Edit"
{
m_otherMarkerNames = markerNameList;
m_marker.MarkerName = markerRow["MARKER_NAME"].ToString();
if (TrendViewerHelper.isNumeric(markerRow["MARKER_BCOLOR"].ToString(), System.Globalization.NumberStyles.Number))
{
m_marker.MarkerBColor = markerRow["MARKER_BCOLOR"].ToString();
}
if (TrendViewerHelper.isNumeric(markerRow["MARKER_FCOLOR"].ToString(), System.Globalization.NumberStyles.Number))
{
m_marker.MarkerFColor = markerRow["MARKER_FCOLOR"].ToString();
}
m_marker.MarkerEnabled = TrendViewerHelper.ChangeStrToBool(markerRow["MARKER_ENABLED"].ToString());
m_marker.MarkerWidth = Convert.ToDouble(markerRow["MARKER_WIDTH"].ToString());
m_marker.MarkerValue = Convert.ToDouble(markerRow["MARKER_VALUE"].ToString());
}
public void Init(DataRow dpRow, List <string> dpNameList) // for "Edit"
{
m_otherHistDataPointNames = dpNameList;
m_originalName = dpRow["DATA_PT_NAME"].ToString();
m_dp.DPHost = dpRow["DATA_PT_HOST"].ToString();
m_dp.DPName = dpRow["DATA_PT_NAME"].ToString();
m_dp.DPType = TrendViewerHelper.convertLineTypeToEnum(dpRow["DATA_PT_TYPE"].ToString());
m_dp.DPColor = dpRow["DATA_PT_COLOR"].ToString();
m_dp.DPServer = dpRow["DATA_PT_SERVER"].ToString();
m_dp.DPLblName = dpRow["DATA_PT_LBL_NAME"].ToString();
m_dp.DPEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_ENABLED"].ToString());
m_dp.DPLblEnabled = TrendViewerHelper.ChangeStrToBool(dpRow["DATA_PT_LBL_ENABLED"].ToString());
m_dp.DPStartDateTime = (DateTime)(dpRow["DATA_PT_DT"]);
m_dp.DPEndDateTime = (DateTime)(dpRow["DATA_PT_DT_END"]);
m_dp.EntityKey = Convert.ToUInt64(dpRow["ENTITYKEY"]);
//m_dp. = TrendingHelper.ChangeStrToBool(dpRow["DATA_PT_VISIBLE"].ToString());
}
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 SaveMarkerListToGroup(string grpName)
{
string Function_Name = "SaveMarkerListToGroup";
List <EtyMarker> markList = new List <EtyMarker>();
foreach (DataRow markerRow in m_markerTable.Rows)
{
EtyMarker marker = new EtyMarker();
SetMarkerEtyByRow(ref marker, markerRow);
markList.Add(marker);
}
try
{
m_Model.SaveMarkerListToGroup(markList, grpName);
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
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);
}
}
public void SaveHistDataPointListToGroup(string grpName)
{
string Function_Name = "SaveHistDataPointListToGroup";
List <EtyHistDataPoint> dataPointList = new List <EtyHistDataPoint>();
foreach (DataRow dataPointRow in m_DataPointTable.Rows)
{
EtyHistDataPoint DataPoint = new EtyHistDataPoint();
SetHistDataPointEtyByRow(ref DataPoint, dataPointRow);
dataPointList.Add(DataPoint);
}
try
{
m_Model.SaveHistDPListToGroup(dataPointList, grpName);
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
private void ExportHistoryData(string filename)
{
string Function_Name = "ExportHistoryData";
try
{
// Open Stream for Writing
System.IO.StreamWriter SW;
SW = System.IO.File.AppendText(filename);
EtyHistDataPoint histDP = null;
string originalMsg = "";
string messageData = "";
DateTime startTime = m_View.GetStartTime();
DateTime endTime = m_View.GetEndTime();
bool hasData = false;
for (int i = 0; i < m_trendCache.m_histDataPointList.Count; i++)
{
histDP = m_trendCache.m_histDataPointList[i];
if (histDP.DPEnabled == false)
{
continue;
}
if (histDP.DPName.Trim() != "")
{
List <EtyDataLogDPLogTrend> histDPLogList = m_Model.GetHistDPLogList(m_trendCache.m_histDataPointList[i], startTime, endTime);
originalMsg = histDP.DPName + "," + histDP.DPServer;
foreach (EtyDataLogDPLogTrend dpLog in histDPLogList)
{
messageData = originalMsg;
messageData += "," + dpLog.Value.ToString();
messageData += "," + dpLog.CreateTime.ToString("dd'/'MM'/'yyyy hh:mm:ss tt"); // ("dd-MM-yyyy HH:mm:ss");
messageData += "," + "127.0.0.1"; //histDP.DPHost.ToString();
SW.WriteLine(messageData);
hasData = true;
}
}
}
SW.Close();
if (!hasData)
{
File.Delete(filename);
MessageBoxDialog.Show(
StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_Msg_ExportNoData, LanguageHelper.TrendViewer_Msg_ExportNoData_EN),
StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_Msg_WarningTitle, LanguageHelper.TrendViewer_Msg_WarningTitle_EN),
MessageBoxButtons.OK,
MessageBoxIcon.Warning);
LogHelper.Error(CLASS_NAME, Function_Name, "No Data for current Datapoint History.");
return;
}
MessageBoxDialog.Show(StringHelper.GetInstance().getStringValue(LanguageHelper.TrendViewer_Msg_ExportOK, LanguageHelper.TrendViewer_Msg_ExportOK_EN));
}
catch (Exception ex)
{
TrendViewerHelper.HandleEx(ex);
}
}
public void TestConvertLineTypeFromEnumToEn01()
{
LineType linetype = LineType.Line;
string str = TrendViewerHelper.ConvertLineTypeFromEnumToEn(linetype);
}
