public PiscesSeriesLoader(TimeSeriesDatabase db, string program = "")
{
this.db = db;
seriesCatalog = db.GetSeriesCatalog();
seriesProperties = db.GetSeriesProperties();
m_program = program;
}
public TimeSeriesDatabaseDataSet.seriespropertiesDataTable SeriesProperties()
{
var rval = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
var sql = "select * from seriesproperties where seriesid in ( "
+ "select seriesid from seriescatalog where "
+ " isfolder = 0 and siteid='" + m_siteID + "' )";
m_db.Server.FillTable(rval, sql);
return rval;
}
public TimeSeriesDatabaseDataSet.seriespropertiesDataTable SeriesProperties()
{
var rval = new TimeSeriesDatabaseDataSet.seriespropertiesDataTable();
var sql = "select * from seriesproperties where seriesid in ( "
+ "select seriesid from seriescatalog where "
+ " isfolder = 0 and siteid='" + m_siteID + "' )";
m_db.Server.FillTable(rval, sql);
return(rval);
}
/// <summary>
/// Add the following
///
/// cbtt_ch|gh = ""
/// cbtt_hh|hj = ConstantShift(...)
/// cbtt_(q|qc) = GenericWeir(....)
///
/// </summary>
/// <param name="sc"></param>
/// <param name="prop"></param>
/// <param name="cbtt"></param>
/// <param name="pc"></param>
/// <param name="width_factor"></param>
/// <param name="exponent"></param>
/// <param name="offset"></param>
/// <param name="shift"></param>
private static void AddGenericWeir(TimeSeriesDatabaseDataSet.SeriesCatalogDataTable sc,
TimeSeriesDatabaseDataSet.seriespropertiesDataTable prop,
string cbtt, string pc,
string width_factor, string exponent, string offset, string shift)
{
string shiftCode = "";
string flowCode = "";
if (pc == "ch")
{
shiftCode = "hh";
flowCode = "qc";
}
else
{
shiftCode = "hj";
flowCode = "q";
}
int parentID = 0; // TO DO.
// afci_qc = GenericWeir(afci_ch,width_factor,exponent) // smart to look for shift... in afci_ch.Properties.shift
// afci_hh = ConstantShift(afci_ch); // lookup shift from properties...
// afci_ch.shift=-0.41
var id = sc.AddInstantRow(cbtt, parentID, "feet", pc, "");
prop.Set("shift", shift, id); // save current shift in properties.
prop.Set("program", "hydromet", id);
sc.AddInstantRow(cbtt, parentID, "feet", shiftCode, "ConstantShift(%site%_" + pc + ")");
prop.Set("program", "hydromet", id);
string expression = "GenericWeir(%site%_" + pc + "," + offset + "," + width_factor + "," + exponent + ")";
id = sc.AddInstantRow(cbtt, parentID, "cfs", flowCode, expression);
prop.Set("program", "hydromet", id);
}
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;
if (m_db.Settings.GetDBVersion() >=3 )
{// alarms
var ac = new SeriesPropertiesAlarm();
ac.Parent = tabPageAlarm;
ac.Dock = DockStyle.Fill;
}
else
{
this.tabControl1.TabPages.Remove(this.tabPageAlarm);
}
}
