private string PrintHtmlReport(TimeRange r, string siteID, string parameter) { var s = db.GetSeriesFromTableName("daily_" + siteID + "_" + parameter); if (s == null) { return("Error: no data found: " + siteID + "/" + parameter); } var startYear = r.StartDate.Year; var endYear = r.EndDate.Year; DateTime t1 = r.StartDate; StringBuilder sb = new StringBuilder(); for (int i = startYear; i < endYear; i++) { s.Read(t1, t1.AddMonths(12)); DataTable wyTable = Usgs.WaterYearTable(s); var header = GetHeader(i + 1, siteID, parameter); var html = DataTableOutput.ToHTML(wyTable, true, "", header); sb.Append(html); sb.AppendLine(); t1 = t1.AddMonths(12); } return(sb.ToString()); }
private void PrintHtmlReport(TimeRange r, string siteID, string parameter) { Console.Write("Content-type: text/html\n\n"); var s = new HydrometDailySeries(siteID, parameter, HydrometHost.PNLinux); var startYear = r.StartDate.Year; var endYear = r.EndDate.Year; DateTime t1 = r.StartDate; for (int i = startYear; i < endYear; i++) { s.Read(t1, t1.AddMonths(12)); DataTable wyTable = Usgs.WaterYearTable(s); var header = GetHeader(i + 1, siteID, parameter); var html = DataTableOutput.ToHTML(wyTable, true, "", header); Console.WriteLine(html); t1 = t1.AddMonths(12); } }
internal void Run() { Console.Write("Content-type: text/html\n\n"); if (query == "") { query = HydrometWebUtility.GetQuery(); } var collection = HttpUtility.ParseQueryString(query); TimeRange r = GetDateRange(collection); var siteID = ""; if (collection.AllKeys.Contains("site")) { siteID = collection["site"]; } var parameter = ""; if (collection.AllKeys.Contains("parameter")) { parameter = collection["parameter"]; } var s = new HydrometDailySeries(siteID, parameter); var startYear = r.StartDate.Year; var endYear = r.EndDate.Year; DateTime t1 = r.StartDate; for (int i = startYear; i < endYear; i++) { s.Read(t1, t1.AddMonths(12)); DataTable wyTable = Usgs.WaterYearTable(s); var header = GetHeader(i + 1, siteID, parameter); var html = DataTableOutput.ToHTML(wyTable, true, "", header); Console.WriteLine(html); t1 = t1.AddMonths(12); } }