private void ReadSeriesProperties() { textBoxName.Text = m_series.Name; textBoxSiteName.Text = m_series.SiteID; textBoxConnectString.Text = m_series.ConnectionString; textBoxProvider.Text = m_series.Provider; textBoxNotes.Text = m_series.Notes; textBoxExpression.Text = m_series.Expression; checkBoxActive.Checked = m_series.Enabled == 1; textBoxSource.Text = m_series.Source; if (m_series.Table == null) { textBoxDBTableName.Text = ""; } else { textBoxDBTableName.Text = m_series.SeriesCatalogRow.TableName; } textBoxParameter.Text = m_series.Parameter; textBoxParentID.Text = m_series.Parent.ID.ToString(); PeriodOfRecord por = m_series.GetPeriodOfRecord(); textBoxPOR1.Text = por.T1.ToString(); textBoxPOR2.Text = por.T2.ToString(); textBoxRecordCount.Text = por.Count.ToString(); textBoxSiteID.Text = m_series.ID.ToString(); textBoxSortOrder.Text = m_series.SortOrder.ToString(); //textBoxAlias.Text = s.Alias; comboBoxUnits.SelectedItem = m_series.Units; //comboBoxDisplayUnits.Items.Clear(); //comboBoxDisplayUnits.Items.Add(""); //comboBoxDisplayUnits.Items.Add("degrees C"); //comboBoxDisplayUnits.SelectedItem = s.DisplayUnits; //this.textBoxMath.Text = m_series.Expression; comboBoxTimeInterval.SelectedIndex = 0; comboBoxTimeInterval.SelectedItem = m_series.TimeInterval.ToString(); tblSeriesProperties = m_db.GetSeriesProperties(); tblSeriesProperties.Columns["id"].AutoIncrement = true; tblSeriesProperties.Columns["id"].AutoIncrementSeed = tblSeriesProperties.NextID(); tblSeriesProperties.Columns["seriesid"].DefaultValue = m_series.ID; dgvProperties.DataSource = tblSeriesProperties; tblSeriesProperties.DefaultView.RowFilter = "seriesid=" + m_series.ID; dgvProperties.Columns["id"].Visible = false; dgvProperties.Columns["seriesid"].Visible = false; }
public override PeriodOfRecord GetPeriodOfRecord() { string sql = "select min(start_date_time),max(end_date_time),count(*) from " + hdb_r_table + " where site_datatype_id = " + hdb_site_datatype_id; var hdb1 = HdbPoet.Hdb.GetInstance(hdb_host_name); var tbl = hdb1.Server.Table("stat", sql); if (tbl.Rows[0][0] == DBNull.Value || tbl.Rows[0][1] == DBNull.Value) { return(base.GetPeriodOfRecord()); } var t1 = Convert.ToDateTime(tbl.Rows[0][0]); var t2 = Convert.ToDateTime(tbl.Rows[0][1]); var count = Convert.ToInt32(tbl.Rows[0][2]); var rval = new PeriodOfRecord(t1, t2, count); return(rval); }
private void ProcessSelectedSeries(SeriesProcess process, Series[] list) { DateTime t1 = DateTime.Now.AddDays(-7); DateTime t2 = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); //Series[] list = tree1.GetSelectedSeries(); // Causing stange results when using Hydromet years 9999, 7170, // added extract check (not into the future) PeriodOfRecord p = list[0].GetPeriodOfRecord(); if (list.Length > 0 && p.Count > 0 && p.T2 < DateTime.Now.Date) // begin at the end of data { t1 = p.T2; } for (int i = 1; i < list.Length; i++) { PeriodOfRecord por = list[i].GetPeriodOfRecord(); if (por.Count > 0 && por.T2 < t1 && por.T2 < DateTime.Now.Date) { t1 = por.T2; } } try { Update u = new Update(t1, t2, process); if (u.ShowDialog() == DialogResult.OK) { ShowAsBusy(""); Logger.WriteLine(process + " t1 = " + u.T1 + " t2= " + u.T2); for (int i = 0; i < list.Length; i++) { Logger.WriteLine(process.ToString() + " " + list[i].Name); Application.DoEvents(); if (process == SeriesProcess.Update && !(list[i] is CalculationSeries)) { list[i].Update(u.T1, u.T2); } if (process == SeriesProcess.Calculate || list[i] is CalculationSeries) { var cs = list[i] as CalculationSeries; if (DB.Settings.ReadBoolean("HydrometVariableResolver", false)) { // this reads data from hydromet server, over http, instead of 'this' database var svr = HydrometInfoUtility.HydrometServerFromPreferences(); cs.Parser.VariableResolver = new HydrometVariableResolver(svr); } if (u.FullPeriodOfRecord) { cs.Calculate(); } else { cs.Calculate(u.T1, u.T2); } } } } } catch (Exception e) { MessageBox.Show(e.Message); } finally { ShowAsReady(""); } }