/// <summary> /// Recompute selected points /// Required: selected point must have calculation /// </summary> public void Undo() { DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells(); try { foreach (DataGridViewCell cell in x) { if (cell.ColumnIndex != 0) // not date column { DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row; MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable; DateTime t = Convert.ToDateTime(row[0]); string interval = tbl.TableName; HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex); if (s.IsComputed) { Hdb.Instance.Calculate_Series(s.hdb_site_datatype_id, interval, t, dataSet.GraphRow.TimeZone); } else { Logger.WriteLine("Warning series is not computed " + s.SiteName + " " + s.hdb_site_datatype_id); } } } } catch (OracleException ex) { MessageBox.Show(ex.Message); } }
private MultipleSeriesDataTable IntervalTable(int seriesIndex) { var sr = SeriesRows.Skip(seriesIndex).First(); MultipleSeriesDataTable tbl = Tables[sr.Interval] as MultipleSeriesDataTable; return(tbl); }
public TimeSeriesCommitChanges(MultipleSeriesDataTable table, string[] validationList, string colorColumnName) { InitializeComponent(); this.timeSeriesSpreadsheet1.SetTable(table, colorColumnName); this.timeSeriesSpreadsheet1.DataViewRowState = DataViewRowState.ModifiedCurrent; SetupValidationList(validationList); }
internal void SetTable(MultipleSeriesDataTable table, string colorColumnName) { this.dataGrid1.DataSource = null; m_colorColumnName = colorColumnName; this.msDataTable = table; this.dataGrid1.DataSource = msDataTable; FormatDataGridView(); }
internal void BuildIntervalTables() { string[] intervals = IntervalList(); foreach (string interval in intervals) { NormalizeDates(interval); } // build table for each interval. // using interval name for table name for (int j = 0; j < intervals.Length; j++) { if (Tables.IndexOf(intervals[j]) >= 0) { Tables.Remove(intervals[j]); } MultipleSeriesDataTable msTable = new MultipleSeriesDataTable(this, intervals[j]); Tables.Add(msTable); } }
public void SetFlagForSelectedCells(bool overwrite) { // List<string> msgList = new List<string>(); string msg = "Overwrite Flag will be set for all selected cells"; if (!overwrite) { msg = "Overwrite Flag will be cleared for all selected cells"; } if (MessageBox.Show(msg, "Confirm Setting of Overwrite Flag", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells(); try { foreach (DataGridViewCell cell in x) { if (cell.ColumnIndex != 0) // no date column { DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row; MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable; DateTime t = Convert.ToDateTime(row[0]); string interval = tbl.TableName; HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex); Hdb.Instance.SetOverwriteFlag(s.hdb_site_datatype_id, interval, t, overwrite, dataSet.GraphRow.TimeZone); } } } catch (OracleException ex) { MessageBox.Show(ex.Message); } }
private void menuDetails_Click(object sender, EventArgs e) { DataGridViewCell cell = dataGrid1.SelectedCells[0]; if (cell.ColumnIndex != 0 && cell.Value != DBNull.Value) { DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row; MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable; DateTime t = Convert.ToDateTime(row[0]); string interval = tbl.TableName; HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex); var info = Hdb.Instance.BaseInfo(t, s.hdb_site_datatype_id, interval); info = DataTableUtility.Transpose(info); TableViewer tv = new TableViewer(info); tv.Show(); //msDataTable //row[cell.ColumnIndex] = DBNull.Value; } }
internal void SetValidationFlagForSelectedCells(string flag) { string msg = "Validation flag will be set to '" + flag + "' for all selected cells"; if (flag.Trim() == "") { msg = "Validation flag will be set to 'null' (cleared) for all selected cells"; } if (MessageBox.Show(msg, "Confirm Setting of Validation Flag", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells(); try { foreach (DataGridViewCell cell in x) { if (cell.ColumnIndex != 0) // no date column { DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row; MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable; DateTime t = Convert.ToDateTime(row[0]); string interval = tbl.TableName; HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex); Hdb.Instance.SetValidationFlag(s.hdb_site_datatype_id, interval, t, flag, dataSet.GraphRow.TimeZone); } } } catch (OracleException ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Updates specified value in MultipleSeriesDataTable /// used when you drag a point on the Chart /// </summary> public void UpdateIntervalTable(int seriesIndex, DateTime t, object value) { MultipleSeriesDataTable tbl = IntervalTable(seriesIndex); tbl.UpdateValue(seriesIndex, t, value); }
public ExcelReportTemplate(MultipleSeriesDataTable msDataTable) { this.msDataTable = msDataTable; xlsFilename = CreateTemporaryExcelFile(); }