public void Basic() { string fn = Path.Combine(TestData.DataPath, "RiverWare"); fn = Path.Combine(fn, "20120403_SHARP_MRM_Forecast-Mar-50pct.xlsx"); UrgwomSeries s = new UrgwomSeries(fn, "Run0","Heron.Storage"); s.Read(); }
public override Series CreateScenario(TimeSeriesDatabaseDataSet.ScenarioRow scenario) { var s = new UrgwomSeries(ConnectionStringUtility.GetFileName(scenario.Path, m_db.DataSource), ConnectionStringUtility.GetToken(scenario.Path, "SheetName", ""), valueColumn); s.ScenarioName = scenario.Name; s.Name = ""; s.Appearance.LegendText = scenario.Name; return s; }
public override Series CreateBaseline() { var fn = ConfigurationManager.AppSettings["UrgwomBaseLine"].ToString(); var dir = Path.GetDirectoryName(xlsFilename); fn = Path.Combine(dir, fn); var s = new UrgwomSeries(fn,"Run0",valueColumn); s.ScenarioName = "baseline"; s.Appearance.LegendText = "baseline"; return s; }
public override Series CreateScenario(TimeSeriesDatabaseDataSet.ScenarioRow scenario) { var s = new UrgwomSeries(ConnectionStringUtility.GetFileName(scenario.Path, m_db.DataSource), ConnectionStringUtility.GetToken(scenario.Path, "SheetName", ""), valueColumn); s.ScenarioName = scenario.Name; s.Name = ""; s.Appearance.LegendText = scenario.Name; return(s); }
public override Series CreateBaseline() { var fn = ConfigurationManager.AppSettings["UrgwomBaseLine"].ToString(); var dir = Path.GetDirectoryName(xlsFilename); fn = Path.Combine(dir, fn); var s = new UrgwomSeries(fn, "Run0", valueColumn); s.ScenarioName = "baseline"; s.Appearance.LegendText = "baseline"; return(s); }
public void LoadTree() { m_db.SuspendTreeUpdates(); var colNames = xls.ColumnNames("Run0"); var sc = m_db.GetSeriesCatalog(); var root = m_db.AddFolder("URGWOM"); var sr = m_db.GetNewSeriesRow(); int id = sr.id; foreach (var item in colNames) { Series s = new UrgwomSeries(excelFilename, "Run0", item); s.ConnectionString = ConnectionStringUtility.MakeFileNameRelative(s.ConnectionString, m_db.DataSource); s.Name = item; s.Parameter = item; sc.AddSeriesCatalogRow(s, id, root.ID, ""); id++; } m_db.Server.SaveTable(sc); m_db.ResumeTreeUpdates(); }