private void AddTable_Load(object sender, EventArgs e)
{
Utils.DriverLinkToSQL.LinkToSQL linkToSql = new AdvancedScada.Utils.DriverLinkToSQL.LinkToSQL();
try
{
if (db == null)
{
Text = "Add Table";
txtServerId.Text = Convert.ToString(ch.ServerId);
txtServerName.Text = ch.ServerName;
txtDataBaseId.Text = Convert.ToString(dv.DataBaseId);
txtDataBaseName.Text = dv.DataBaseName;
txtTableId.Text = Convert.ToString(dv.Tables.Count + 1);
txtTableName.Items.AddRange(linkToSql.AddTable(ch.ServerName, dv.DataBaseName).ToArray());
}
else
{
Text = "Edit Table";
txtServerId.Text = Convert.ToString(ch.ServerId);
txtServerName.Text = ch.ServerName;
txtDataBaseId.Text = Convert.ToString(dv.DataBaseId);
txtDataBaseName.Text = dv.DataBaseName;
txtTableId.Text = Convert.ToString(db.TableId);
txtTableName.Items.AddRange(linkToSql.AddTable(ch.ServerName, dv.DataBaseName).ToArray());
txtTableName.Text = db.TableName;
txtDescription.Text = db.Description;
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(GetType().Name, ex.Message);
}
}
private void AddColumn_Load(object sender, EventArgs e)
{
try
{
txtSQLDataBase.Text = DBS.DataBaseName;
txtSQLTable.Text = Tb.TableName;
txtChannel.DataSource = objChannelManager.Channels.ToList();
txtChannel.DisplayMember = "ChannelName";
txtChannel.ValueMember = "ChannelId";
Utils.DriverLinkToSQL.LinkToSQL linkToSql = new AdvancedScada.Utils.DriverLinkToSQL.LinkToSQL();
txtColumnName.DataSource = linkToSql.AddColumn(txtSQLTable.Text, SQL.ServerName, DBS.DataBaseName);
txtColumnName.DisplayMember = "ColumnName";
txtColumnName.ValueMember = "ColumnName";
if (Co == null)
{
Text = "Add Column";
}
else
{
Text = "Edit Column";
txtTagName.Text = Co.TagName;
txtChannel.Text = Co.Channel;
txtColumnName.Text = Co.ColumnName;
txtDataBlock.Text = Co.DataBlock;
txtDevice.Text = Co.Device;
txtDesc.Text = Co.Description;
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(GetType().Name, ex.Message);
}
}
