public TimeSeriesDatabaseUtility(TimeSeriesDatabase db) { m_db = db; m_seriesCatalog = m_db.GetSeriesCatalog(); m_siteCatalog = m_db.GetSiteCatalog(); }
public TimeSeriesDatabaseDataSet.sitecatalogDataTable GetSiteCatalog() { var tbl = new TimeSeriesDatabaseDataSet.sitecatalogDataTable(); m_server.FillTable(tbl, "select * from sitecatalog order by siteid"); return tbl; }
public TimeSeriesDatabaseDataSet.sitecatalogDataTable GetSiteCatalog(string filter="1=1", string propertyFilter="") { var tbl = new TimeSeriesDatabaseDataSet.sitecatalogDataTable(); string sql = "select * from sitecatalog where " + filter; sql += GetSitePropertySQL(propertyFilter); sql += " order by siteid"; m_server.FillTable(tbl, sql); return tbl; }
internal TimeSeriesDatabaseDataSet.sitecatalogRow GetSiteRow(string siteID) { Logger.WriteLine("GetSiteRow('"+siteID+"')"); string sql = "Select * from sitecatalog where lower(siteid) = '" + siteID.ToLower() + "'"; var tbl = new TimeSeriesDatabaseDataSet.sitecatalogDataTable(); m_server.FillTable(tbl, sql); if (tbl.Rows.Count == 0) { Logger.WriteLine("Error: GetSiteRow() Could not find site with ID = '" + siteID + "'"); return null; } var rval = tbl[0]; return rval; }