//连接服务器
private void ConnectServer(object sender, RoutedEventArgs e)
{
SHHOPCServer node = tree.SelectedItem as SHHOPCServer;
if (node != null)
{
node.Connnect();
}
}
//移除服务端组
public static void RemoveGroup(SHHOPCServer server, SHHOPCGroup group)
{
foreach (SHHOPCItem item in group.ItemList)
{
RemovePoint(group, item);
}
server.RemoveGroup(group);
TB_TF_OPCGroups.DeleteOPCGroup(group.ID);
}
//删除服务
private void DeleteServer(object sender, RoutedEventArgs e)
{
SHHOPCServer node = tree.SelectedItem as SHHOPCServer;
if (node != null)
{
//确定删除
OPCManager.RemoveServer(node);
}
}
//新增服务
private void AddServer(object sender, RoutedEventArgs e)
{
FormServer form = new FormServer();
form.Owner = this;
if ((bool)form.ShowDialog())
{
SHHOPCServer server = new SHHOPCServer(Guid.NewGuid(), form.ServerIP, form.OPCServerName, form.Name);
//确定修改
OPCManager.AddServer(server);
}
}
public static void UpdateOPCServer(SHHOPCServer server)
{
SqlParameter[] parameterList = new SqlParameter[4]
{
new SqlParameter("OPCServerID", server.ID),
new SqlParameter("Name", server.Name),
new SqlParameter("MachineIP", server.IP.ToString()),
new SqlParameter("OPCServerName", server.OPCServerName)
};
SqlHelper.ExecuteReader(Database.sqlConStr, CommandType.StoredProcedure, "TF_UpdateOPCServer", parameterList);
}
//移除服务端及其子项
public static void RemoveServer(SHHOPCServer server)
{
foreach (SHHOPCGroup group in server.Groups)
{
foreach (SHHOPCItem item in group.ItemList)
{
RemovePoint(group, item);
}
RemoveGroup(server, group);
}
TB_TF_OPCServer.DeleteOPCServer(server.ID);
ServerList.Remove(server);
}
//加载参数
public static void Load()
{
SqlDataReader opcserver = TB_TF_OPCServer.GetServer();
while (opcserver.Read())
{
SHHOPCServer server = new SHHOPCServer(new Guid(opcserver["OPCServerID"].ToString()), IPAddress.Parse(opcserver["MachineIP"].ToString()), opcserver["OPCServerName"].ToString(), opcserver["Name"].ToString());
SqlDataReader opcgroup = TB_TF_OPCGroups.GetGroups();
while (opcgroup.Read())
{
if (opcserver["OPCServerID"].ToString() == opcgroup["OPCServerID"].ToString())
{
SHHOPCGroup group = new SHHOPCGroup(new Guid(opcgroup["OPCGroupID"].ToString()), opcgroup["Name"].ToString(), Int32.Parse(opcgroup["UpdateRate"].ToString()), float.Parse(opcgroup["DeadBend"].ToString()), Int32.Parse(opcgroup["TimeBias"].ToString()), (bool)opcgroup["IsActive"], (bool)opcgroup["IsSubscribed"]);
SqlDataReader opcpoint = TB_TF_Points.GetPoints();
while (opcpoint.Read())
{
if (opcgroup["OPCGroupID"].ToString() == opcpoint["OPCGroupID"].ToString())
{
SHHOPCItem item = new SHHOPCItem(new Guid(opcpoint["PointID"].ToString()), new SHHEquipment((SHHEquipmentID)Int32.Parse(opcpoint["EquipID"].ToString()), SHHEquipmentType.Analog, opcpoint["PointName"].ToString(), "MPa"), opcpoint["PointName"].ToString(), opcpoint["EquipPlace"].ToString(), opcpoint["PointAddress"].ToString());
group.AddItem(item);
/**********删除测试数据*******/
//RemovePoint(group, item);
/***************************/
}
}
//**********添加测试数据 * *********/
//for (int i = 0; i < 5; ++i)
//{
// string s = group.Name.Substring(group.Name.Length - 1, 1);
// SHHOPCItem testPoint = new SHHOPCItem(Guid.NewGuid(), new SHHEquipment((SHHEquipmentID)i, SHHEquipmentType.Analog, "测点" + i, "kpa"), "测点" + i, "地点" + i, "Channel_" + s + ".Device_" + 0 + ".Tag_" + i);
// AddPoint(group, testPoint);
//}
///******************************
server.AddGroup(group);
}
}
ServerList.Add(server);
}
}
//修改服务器
private void ModifyServer(object sender, RoutedEventArgs e)
{
SHHOPCServer node = tree.SelectedItem as SHHOPCServer;
FormServer form = new FormServer();
//载入参数
form.name.Text = node.Name;
form.serverIP.Text = node.IP.ToString();
form.serverName.Text = node.OPCServerName;
form.Owner = this;
if ((bool)form.ShowDialog())
{
node.Name = form.Name;
node.IP = form.ServerIP;
node.OPCServerName = form.OPCServerName;
//确定修改
OPCManager.ModifyServer(node);
}
}
//添加服务端组
public static void AddGroup(SHHOPCServer server, SHHOPCGroup group)
{
server.AddGroup(group);
TB_TF_OPCGroups.AddOPCGroups(group);
}
//修改服务
public static void ModifyServer(SHHOPCServer server)
{
TB_TF_OPCServer.UpdateOPCServer(server);
}
//添加服务端
public static void AddServer(SHHOPCServer server)
{
_serverList.Add(server);
TB_TF_OPCServer.AddOPCServer(server);
}
