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; }