public TimeSeriesDatabaseDataSet.parametercatalogDataTable Parameters()
{
var rval = new TimeSeriesDatabaseDataSet.parametercatalogDataTable();
var sql = "select * from parametercatalog where id in ( "
+ "select parameter from seriescatalog where "
+ "isfolder =0 and siteid='" + m_siteID + "' )";
m_db.Server.FillTable(rval, sql);
return rval;
}
public TimeSeriesDatabaseDataSet.parametercatalogDataTable Parameters()
{
var rval = new TimeSeriesDatabaseDataSet.parametercatalogDataTable();
var sql = "select * from parametercatalog where id in ( "
+ "select parameter from seriescatalog where "
+ "isfolder =0 and siteid='" + m_siteID + "' )";
m_db.Server.FillTable(rval, sql);
return(rval);
}
public TimeSeriesDatabaseDataSet.parametercatalogDataTable GetParameterCatalog()
{
var tbl = new TimeSeriesDatabaseDataSet.parametercatalogDataTable();
m_server.FillTable(tbl, "select * from parametercatalog order by id");
return tbl;
}
public TimeSeriesDatabaseDataSet.parametercatalogDataTable GetParameterCatalog(string filter="1=1")
{
var tbl = new TimeSeriesDatabaseDataSet.parametercatalogDataTable();
m_server.FillTable(tbl, "select * from parametercatalog where "
+ filter +" order by id");
return tbl;
}
