private void MetaData_Load(object sender, EventArgs e) { DataSensitivityCombo.Items.AddRange(Model.DataSensitivityCode.DisplayOptions()); using (AdoDataConnection connection = new AdoDataConnection("systemSettings")) { GSF.Data.Model.TableOperations <PQds.Model.DataSensitivity> dataSensitivityTable = new GSF.Data.Model.TableOperations <PQds.Model.DataSensitivity>(connection); if (PQds.Model.DataSensitivity.CodeisGlobal()) { int?dataSensitivity = null; dataSensitivity = dataSensitivityTable.QueryRecords().First().DataSensitivityCode; if (dataSensitivity != null) { DataSensitivityCombo.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(), item => item == Model.DataSensitivityCode.ToDisplay((int)dataSensitivity)); } else { DataSensitivityCombo.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(), item => item == Model.DataSensitivityCode.ToDisplay(-1)); } } else { DataSensitivityCombo.Enabled = false; } if (PQds.Model.DataSensitivity.NoteisGlobal()) { string dataSensitivityNote = null; dataSensitivityNote = dataSensitivityTable.QueryRecordsWhere("Note <> ''").First().Note; DataSensitivityNoteText.Text = dataSensitivityNote; } else { DataSensitivityNoteText.Enabled = false; } } this.MouseDown += new MouseEventHandler(OnClick); }
private void GenereateDataSensitivities(string note, int code) { // If we overwrite we need to create a set of Asset and event IDs that need to create a Data Sesitivity Code List <Tuple <int, int> > combinations = new List <Tuple <int, int> >(); using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider)) { GSF.Data.Model.TableOperations <PQio.Model.Channel> channelTbl = new GSF.Data.Model.TableOperations <PQio.Model.Channel>(connection); GSF.Data.Model.TableOperations <PQio.Model.Asset> assetTbl = new GSF.Data.Model.TableOperations <PQio.Model.Asset>(connection); GSF.Data.Model.TableOperations <PQio.Model.DataSeries> seriesTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSeries>(connection); GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity> sensitivityTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity>(connection); foreach (int assetID in assetTbl.QueryRecords().Select(item => item.ID)) { foreach (int channelID in channelTbl.QueryRecordsWhere("AssetID = {0}", assetID).Select(item => item.ID)) { foreach (int evtID in seriesTbl.QueryRecordsWhere("ChannelID = {0}", channelID).Select(item => item.EventID)) { combinations.Add(new Tuple <int, int>(assetID, evtID)); } } } combinations = combinations.Distinct().ToList(); foreach (Tuple <int, int> item in combinations) { if (sensitivityTbl.QueryRecordCountWhere("Event = {0} AND Asset = {1}", item.Item2, item.Item1) == 0) { sensitivityTbl.AddNewRecord(new Model.DataSensitivity() { Asset = item.Item1, Event = item.Item2, DataSensitivityCode = code, Note = note }); } } } }
private void PQioChannel_Load(object sender, EventArgs e) { // Populate Combo Boxes comboBox1.Items.AddRange(Model.SignalType.DisplayOptions()); comboBox2.Items.AddRange(Model.MeasurementType.DisplayOptions()); comboBox3.Items.AddRange(Model.DataSensitivityCode.DisplayOptions()); if (m_channel.SignalType != null) { comboBox1.SelectedIndex = Array.FindIndex(Model.SignalType.DisplayOptions(), item => item == Model.SignalType.ToDisplay((int)m_channel.SignalType)); } else { comboBox1.SelectedIndex = Array.FindIndex(Model.SignalType.DisplayOptions(), item => item == Model.SignalType.ToDisplay(-1)); } if (m_channel.MeasurementType != null) { comboBox2.SelectedIndex = Array.FindIndex(Model.MeasurementType.DisplayOptions(), item => item == Model.MeasurementType.ToDisplay(m_channel.MeasurementType)); } else { comboBox2.SelectedIndex = Array.FindIndex(Model.MeasurementType.DisplayOptions(), item => item == Model.MeasurementType.ToDisplay("")); } using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider)) { GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity> dataSensitivityTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity>(connection); GSF.Data.Model.TableOperations <PQio.Model.Meter> deviceTbl = new GSF.Data.Model.TableOperations <PQio.Model.Meter>(connection); if (this.m_channel.AssetID != null) { // Make sure we check if there is any Data Sensitivity associated with this event if (dataSensitivityTbl.QueryRecordCountWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID) > 0) { PQio.Model.DataSensitivity dataSensitivity = dataSensitivityTbl.QueryRecordsWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID).First(); comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(), item => item == Model.DataSensitivityCode.ToDisplay((int)dataSensitivity.DataSensitivityCode)); DataSensitivityNoteText.Text = dataSensitivity.Note; } else { comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(), item => item == Model.DataSensitivityCode.ToDisplay(-1)); DataSensitivityNoteText.Text = ""; } } else { comboBox3.Enabled = false; comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(), item => item == Model.DataSensitivityCode.ToDisplay(-1)); tabControl1.Enabled = false; } comboDevice.DisplayMember = "Text"; comboDevice.ValueMember = "Value"; PQio.Model.Meter[] meters = deviceTbl.QueryRecords("").ToArray(); comboDevice.Items.AddRange(meters.Select(item => new { Text = item.DeviceName, Value = item.ID }).ToArray()); comboDevice.SelectedIndex = Array.FindIndex(meters, item => item.ID == this.m_channel.MeterID); } if (this.m_evt != null) { UpdateCustomFields(); } else { this.tabControl1.Enabled = false; } this.MouseDown += new MouseEventHandler(OnClick); }