private void ItemAddDataBlock_Click(object sender, EventArgs e)
{
try
{
Server chCurrent = null;
DataBase dvCurrent = null;
XAddTable dbFrm = null;
if (treeViewSI.SelectedNode == null)
{
return;
}
int Level = treeViewSI.SelectedNode.Level;
switch (Level)
{
case 1:
chCurrent = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Text);
dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, treeViewSI.SelectedNode.Text);
break;
case 2:
chCurrent = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Parent.Text);
dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, treeViewSI.SelectedNode.Parent.Text);
break;
}
dbFrm = new XAddTable(chCurrent, dvCurrent);
dbFrm.eventTableChanged += db =>
{
try
{
TreeNode dbNode = new TreeNode(db.TableName)
{
StateImageIndex = 2
};
switch (Level)
{
case 1:
treeViewSI.SelectedNode.Nodes.Add(dbNode);
IsDataChanged = true;
break;
case 2:
treeViewSI.SelectedNode.Parent.Nodes.Add(dbNode);
IsDataChanged = true;
break;
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(GetType().Name, ex.Message);
}
};
dbFrm.ShowDialog();
}
catch (Exception ex)
{
EventscadaException?.Invoke(GetType().Name, ex.Message);
}
}
private void treeViewSI_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
try
{
if (e.Button != System.Windows.Forms.MouseButtons.Left)
{
return;
}
int Level = treeViewSI.SelectedNode.Level;
string selectedNode = treeViewSI.SelectedNode.Text;
Server chCurrent = null;
DataBase dvCurrent = null;
Table dbCurrent = null;
switch (Level)
{
case 0:
chCurrent = objServerManager.GetBySQLServerName(selectedNode);
XAddServer chFrm = new XAddServer(objServerManager, chCurrent);
chFrm.eventSQLServerChanged += ch =>
{
treeViewSI.SelectedNode.Text = ch.ServerName;
};
chFrm.StartPosition = FormStartPosition.CenterScreen;
chFrm.ShowDialog();
break;
case 1:
chCurrent = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Text);
dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, selectedNode);
XAddDataBase dvFrm = new XAddDataBase(chCurrent, dvCurrent);
dvFrm.eventDataBaseChanged += dv =>
{
treeViewSI.SelectedNode.Text = dv.DataBaseName;
};
dvFrm.StartPosition = FormStartPosition.CenterScreen;
dvFrm.ShowDialog();
break;
case 2:
chCurrent = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Parent.Text);
dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, treeViewSI.SelectedNode.Parent.Text);
dbCurrent = TableManager.GetByTableName(dvCurrent, selectedNode);
XAddTable dbFrm = new XAddTable(chCurrent, dvCurrent, dbCurrent);
dbFrm.eventTableChanged += db =>
{
treeViewSI.SelectedNode.Text = db.TableName;
DGMonitorForm.Rows.Clear();
foreach (Column item in dbCurrent.Columns)
{
string[] row = { string.Format("{0}", item.ColumnId), item.ColumnName, item.TagName, item.DataBlock, item.Device, item.Channel, item.Cycle, item.Description };
DGMonitorForm.Rows.Add(row);
}
};
dbFrm.StartPosition = FormStartPosition.CenterScreen;
dbFrm.ShowDialog();
break;
default:
break;
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(GetType().Name, ex.Message);
}
}