public void TestAddDPToOPCServer02()
{
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);
//Excetpion caught
viewAccessor.Call("AddDPToOPCServer", dpList);
}
public void TestInsertDPListToGrp_Get_Delete_01()
{
List <EtyDataPoint> datapointList = new List <EtyDataPoint>();
EtyDataPoint dp = new EtyDataPoint();
dp.DisplayName = "test_DispName";
dp.Description = "test_desc";
dp.DPName = "test_DP_Name";
string grpName = "test_grpName";
dp.DPServer = "TransActiveDataSource";
dp.DPHost = TestDBInit.HOST_NAME;
dp.DPLblName = "LblName";
datapointList.Add(dp);
dataPointDao.SaveDPListToGrp(datapointList, grpName);
//dataPointDao.InsertDPListToGrp(datapointList, grpName);
dataPointDao.GetDPByCfgName(grpName);
dataPointDao.DeleteAllDPInGrp(grpName);
}
public void UpdateDPNameAndLabel(EtyDataPoint dp)
{
dataPointBox.Text = dp.DPName.ToString();
dataLegendBox.Text = dp.DPLblName;
}
public void TestUpdateDPNameAndLabel01()
{
EtyDataPoint dp = new EtyDataPoint(); /* TODO: Implement me */;
dp.DPName = "name";
dp.DPLblName = "lblName";
dataPointData.UpdateDPNameAndLabel(dp);
#region Record State
ValueRecorder recorder = new ValueRecorder();
recorder.Record((string)dataPointData.AccessibleDefaultActionDescription);
recorder.Record((string)dataPointData.AccessibleDescription);
recorder.Record((string)dataPointData.AccessibleName);
recorder.Record((AccessibleRole)dataPointData.AccessibleRole);
recorder.Record((bool)dataPointData.AllowDrop);
recorder.Record((bool)dataPointData.AllowTransparency);
recorder.Record((AnchorStyles)dataPointData.Anchor);
recorder.Record((AutoScaleMode)dataPointData.AutoScaleMode);
recorder.Record((bool)dataPointData.AutoScroll);
recorder.Record((bool)dataPointData.AutoSize);
recorder.Record((AutoSizeMode)dataPointData.AutoSizeMode);
recorder.Record((AutoValidate)dataPointData.AutoValidate);
recorder.Record((ImageLayout)dataPointData.BackgroundImageLayout);
recorder.Record((int)dataPointData.Bottom);
recorder.Record((bool)dataPointData.CanFocus);
recorder.Record((bool)dataPointData.CanSelect);
recorder.Record((bool)dataPointData.Capture);
recorder.Record((bool)dataPointData.CausesValidation);
recorder.Record((string)dataPointData.CompanyName);
recorder.Record((bool)dataPointData.ContainsFocus);
recorder.Record((bool)dataPointData.ControlBox);
recorder.Record((bool)dataPointData.Created);
recorder.Record((DialogResult)dataPointData.DialogResult);
recorder.Record((bool)dataPointData.Disposing);
recorder.Record((DockStyle)dataPointData.Dock);
recorder.Record((bool)dataPointData.Enabled);
recorder.Record((bool)dataPointData.Focused);
recorder.Record((FormBorderStyle)dataPointData.FormBorderStyle);
recorder.Record((bool)dataPointData.HasChildren);
recorder.Record((int)dataPointData.Height);
recorder.Record((bool)dataPointData.HelpButton);
recorder.Record((ImeMode)dataPointData.ImeMode);
recorder.Record((bool)dataPointData.InvokeRequired);
recorder.Record((bool)dataPointData.IsAccessible);
recorder.Record((bool)dataPointData.IsDisposed);
recorder.Record((bool)dataPointData.IsHandleCreated);
recorder.Record((bool)dataPointData.IsMdiChild);
recorder.Record((bool)dataPointData.IsMdiContainer);
recorder.Record((bool)dataPointData.IsMirrored);
recorder.Record((bool)dataPointData.IsRestrictedWindow);
recorder.Record((bool)dataPointData.KeyPreview);
recorder.Record((int)dataPointData.Left);
recorder.Record((bool)dataPointData.MaximizeBox);
recorder.Record((bool)dataPointData.MinimizeBox);
recorder.Record((bool)dataPointData.Modal);
recorder.Record((string)dataPointData.Name);
recorder.Record((double)dataPointData.Opacity);
recorder.Record((string)dataPointData.ProductName);
recorder.Record((string)dataPointData.ProductVersion);
recorder.Record((bool)dataPointData.RecreatingHandle);
recorder.Record((int)dataPointData.Right);
recorder.Record((RightToLeft)dataPointData.RightToLeft);
recorder.Record((bool)dataPointData.RightToLeftLayout);
recorder.Record((bool)dataPointData.ShowIcon);
recorder.Record((bool)dataPointData.ShowInTaskbar);
recorder.Record((SizeGripStyle)dataPointData.SizeGripStyle);
recorder.Record((FormStartPosition)dataPointData.StartPosition);
recorder.Record((bool)ReflectionAccessor.Wrap(dataPointData).GetProperty("System.Windows.Forms.Layout.IArrangedElement.ParticipatesInLayout"));
recorder.Record((int)dataPointData.TabIndex);
recorder.Record((bool)dataPointData.TabStop);
recorder.Record((string)dataPointData.Text);
recorder.Record((int)dataPointData.Top);
recorder.Record((bool)dataPointData.TopLevel);
recorder.Record((bool)dataPointData.TopMost);
recorder.Record((bool)dataPointData.UseWaitCursor);
recorder.Record((string)dataPointData.ViewID);
recorder.Record((string)dataPointData.ViewType);
recorder.Record((bool)dataPointData.Visible);
recorder.Record((int)dataPointData.Width);
recorder.Record((FormWindowState)dataPointData.WindowState);
recorder.Record <string>(delegate { return((string)dp.ConfigName); });
recorder.Record <string>(delegate { return((string)dp.Description); });
recorder.Record <string>(delegate { return((string)dp.DisplayName); });
recorder.Record <string>(delegate { return((string)dp.DPColor); });
recorder.Record <bool>(delegate { return((bool)dp.DPEnabled); });
recorder.Record <string>(delegate { return((string)dp.DPHost); });
recorder.Record <bool>(delegate { return((bool)dp.DPLblEnabled); });
recorder.Record <string>(delegate { return((string)dp.DPLblName); });
recorder.Record <string>(delegate { return((string)dp.DPName); });
recorder.Record <string>(delegate { return((string)dp.DPServer); });
recorder.Record <bool>(delegate { return((bool)dp.DPVisible); });
recorder.Record <ulong>(delegate { return((ulong)dp.PKey); });
recorder.FinishRecording();
#endregion
#region Assertions
Assert.IsNull((string)dataPointData.AccessibleDefaultActionDescription);
Assert.IsFalse((bool)dataPointData.AllowTransparency);
Assert.IsFalse((bool)dataPointData.AutoSize);
Assert.AreEqual(303, (int)dataPointData.Bottom);
Assert.IsTrue((bool)dataPointData.CausesValidation);
Assert.IsFalse((bool)dataPointData.Created);
Assert.IsTrue((bool)dataPointData.Enabled);
Assert.AreEqual(303, (int)dataPointData.Height);
Assert.IsFalse((bool)dataPointData.IsAccessible);
Assert.IsFalse((bool)dataPointData.IsMdiContainer);
Assert.IsFalse((bool)dataPointData.MaximizeBox);
Assert.AreEqual(1.0, (double)dataPointData.Opacity, 1E-7);
Assert.AreEqual(717, (int)dataPointData.Right);
Assert.IsTrue((bool)dataPointData.ShowInTaskbar);
Assert.AreEqual(0, (int)dataPointData.TabIndex);
Assert.IsTrue((bool)dataPointData.TopLevel);
Assert.IsNull((string)dataPointData.ViewType);
Assert.AreEqual("", (string)dp.ConfigName);
Assert.IsTrue((bool)dp.DPEnabled);
Assert.AreEqual("name", (string)dp.DPName);
#endregion
}
public void TestEtyDataPointConstructor01()
{
EtyDataPoint etyDataPoint = new EtyDataPoint();
}
public void FixtureSetUp()
{
etyDataPoint = new EtyDataPoint();
}
/// <summary>
/// retrieve a configuration from TRENDVIEWER_CONFIG by configuration name.
/// </summary>
/// <param name="configName">configuration name</param>
/// <returns></returns>
public List <EtyDataPoint> GetDPByCfgName(string configName)
{
string Function_Name = "GetDPByCfgName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataPoint> dpList = new List <EtyDataPoint>();
string localSQL = " SELECT DATA_PT_NAME,DATA_PT_TYPE,DATA_PT_COLOR,DATA_PT_SERVER,DATA_PT_ENABLED,DATA_PT_LBL_ENABLED,DATA_PT_LBL_NAME,DATA_PT_HOST,DATA_PT_VISIBLE " +
" FROM TRENDVIEWER_CONFIG WHERE CONFIG_NAME = '" + DAOHelper.convertEscapeStringAndGB2312To8859P1(configName) + "'";
// string localSQL = " SELECT c.DATA_PT_NAME,c.DATA_PT_TYPE,c.DATA_PT_COLOR,c.DATA_PT_SERVER,c.DATA_PT_ENABLED,c.DATA_PT_LBL_ENABLED, c.DATA_PT_LBL_NAME, c.DATA_PT_HOST,c.DATA_PT_VISIBLE, "
// + "o.keyid from trendviewer_config c, opc_dt_pt o where c.data_pt_name = o.data_pt_name " +
// " and c.CONFIG_NAME = '" + DAOHelper.convertGB2312To8859P1(configName) + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
EtyDataPoint newEtyDP = null;
try
{
while (drReader != null && drReader.Read())
{
newEtyDP = new EtyDataPoint();
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_NAME")))
{
newEtyDP.DPName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_TYPE")))
{
newEtyDP.DPType = DAOHelper.ConvertLineTypeToEnum(drReader["DATA_PT_TYPE"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_COLOR")))
{
newEtyDP.DPColor = drReader["DATA_PT_COLOR"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_SERVER")))
{
newEtyDP.DPServer = drReader["DATA_PT_SERVER"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_ENABLED")))
{
newEtyDP.DPEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_ENABLED"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_ENABLED")))
{
newEtyDP.DPLblEnabled = DAOHelper.ChangeStrToBool(drReader["DATA_PT_LBL_ENABLED"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_LBL_NAME")))
{
newEtyDP.DPLblName = DAOHelper.convert8859P1ToGB2312(drReader["DATA_PT_LBL_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_HOST")))
{
newEtyDP.DPHost = drReader["DATA_PT_HOST"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DATA_PT_VISIBLE")))
{
newEtyDP.DPVisible = DAOHelper.ChangeStrToBool(drReader["DATA_PT_VISIBLE"].ToString());
}
// if (!drOracle.IsDBNull(9))
// newEtyDP.PKey = (ulong)(drOracle.GetOracleDecimal(9).ToInt64());
dpList.Add(newEtyDP);
}
}
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(dpList);
}
