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); } }