public static string[] GetNames()
{
DataTable tbl = new CsvFile(LookupFile("ControlPoints"));
tbl = DataTableUtility.Select(tbl, " Enabled = true", "");
return(DataTableUtility.Strings(tbl, "", "Name"));
}
public string[] GetPhoneNumbers(string list)
{
string sql = "select phone from alarm_recipient where list='" + list + "' order by call_order";
var tbl = m_server.Table("alarm_recipient", sql);
return(DataTableUtility.Strings(tbl, "", "phone"));
}
public static string[] GetNames()
{
var tbl = ExcelUtility.Read(xlsFileName(), "ControlPoints");
tbl = DataTableUtility.Select(tbl, " Enabled = true", "");
return(DataTableUtility.Strings(tbl, "", "Name"));
}
public string[] GetEmailList(string list)
{
string sql = "select email from alarm_recipient where list='" + list + "' order by call_order";
var tbl = m_server.Table("alarm_recipient", sql);
return(DataTableUtility.Strings(tbl, "", "email"));
}
private string[] GetDistinct(string colName)
{
string sql = "Select Distinct [" + colName + "] from [" + TableName + "]";
DataTable tbl = db.Table(TableName, sql);
return(DataTableUtility.Strings(tbl, "", colName));
}
private static void AddSitesToDecodes(string serverIP, DataTable tbl)
{
var siteFilter = String.Join(",", DataTableUtility.Strings(tbl, "", "cbtt"));
siteFilter = siteFilter.ToUpper();
McfToDecodes.Import(serverIP, "hydromet_decodes", siteFilter, "owrd");
}
private static void CacheAllParametersForSite(CalculationSeries s, DateTime t1, DateTime t2)
{
// if we need instant data for this site
// get all instant parameters in memory for future use.
string tag = s.TimeInterval.ToString() + s.SiteID;
if (visitedSites.Contains(tag))
{
return;
}
if (s.TimeInterval != TimeInterval.Daily)
{
return;
}
var t2a = t2.AddDays(1); // extra data when midnight next day is needed.
if (s.Expression.IndexOf("instant") >= 0)
{ // Instant to Daily Calculation
var tbl = s.TimeSeriesDatabase.GetSeriesCatalog("siteid = '" + s.SiteID + "' and timeinterval = 'Irrregular'");
var pcodes = DataTableUtility.Strings(tbl, "", "Parameter");
var query = s.SiteID + " " + String.Join("," + s.SiteID + " ", pcodes);
var pairs = query.Split(',');
//
HydrometInstantSeries.Cache.Add(pairs, t1, t2a, HydrometHost.PNLinux, TimeInterval.Irregular);
visitedSites.Add(tag);
Console.WriteLine(s.SiteID + " added to the cache");
}
else if (s.Expression.IndexOf("instant") < 0)
{ // Daily to Daily type calculation..
var tbl = s.TimeSeriesDatabase.GetSeriesCatalog("siteid = '" + s.SiteID + "' and timeinterval = 'Daily'");
var pcodes = DataTableUtility.Strings(tbl, "", "Parameter");
var query = s.SiteID + " " + String.Join("," + s.SiteID + " ", pcodes);
var pairs = query.Split(',');
//HydrometDailySeries.Cache = new HydrometDataCache(); // clear out and make new cache.
HydrometDailySeries.Cache.Add(pairs, t1, t2a, HydrometHost.PNLinux, TimeInterval.Daily);
visitedSites.Add(tag);
Console.WriteLine(s.SiteID + " added to the cache");
}
}
public string[] GetEmailList(string list)
{
string sql = "select email from alarm_recipient where list='" + list + "' order by call_order";
var tbl = m_server.Table("alarm_recipient", sql);
var a = DataTableUtility.Strings(tbl, "", "email");
var rval = new List <string>();
for (int i = 0; i < a.Length; i++)
{
if (a[i].Trim() != "")
{
rval.Add(a[i].Trim());
}
}
return(rval.ToArray());
}
public TimeSeriesDatabaseDataSet.SeriesCatalogDataTable CreateTree()
{
seriesCatalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable();
int bpaRoot = AddFolder(ID++, m_parentID, Path.GetFileNameWithoutExtension(m_mdbFileName));
// read access file
mdb = new AccessDB(m_mdbFileName);
// get table of distinct Plant Names and Data Types to create Tree
string sql = "SELECT DISTINCT Working_Set.PlantName, Working_Set.DataType FROM Working_Set";
DataTable tbl = mdb.Table("Working_Set", sql);
// create folder for each Plant Name and a row for each Data Type
DataTable tblPlantNames = DataTableUtility.SelectDistinct(tbl, "PlantName");
for (int i = 0; i < tblPlantNames.Rows.Count; i++)
{
string plantName = tblPlantNames.Rows[i][0].ToString().Trim();
int siteID = AddFolder(ID++, bpaRoot, plantName);
string[] dataTypes = DataTableUtility.Strings(tbl, "[PlantName]='" + plantName + "'", "DataType");
for (int j = 0; j < dataTypes.Count(); j++)
{
string dataType = dataTypes[j].Trim();
string[] dTksfd = { "ENDSTO", "ECC", "URC" };
if (dTksfd.Contains(dataType) == true)
{
CreateSeries(mdb, plantName, dataType, siteID);
CreateSeriesAF(mdb, plantName, dataType, siteID);
}
else
{
CreateSeries(mdb, plantName, dataType, siteID);
}
}
}
return(seriesCatalog);
}
public static string[] GetSnowggGroupList()
{
var tbl = DataTableUtility.SelectDistinct(SnowggGroups, "Group");
return(DataTableUtility.Strings(tbl, "", "Group"));
}
