public HydrographyDataSet.rating_tablesDataTable SaveToTable(HydrographyDataSet.rating_tablesDataTable tbl) { foreach (var item in UniqueTables()) { AppendToTable(item,tbl); } /* BLEWGD 060677 BLEWGD 0.00 0.00 0.10 0.16 0.20 0.32 0.30 0.67 BLEWGD 0.40 1.12 0.50 1.68 0.60 2.37 0.70 3.18 BLEWGD 0.80 4.09 0.90 5.12 1.00 6.28 1.10 7.57 BLEWGD 1.20 8.97 1.30 10.50 1.40 12.10 1.50 13.70 BLEWGD 1.60 15.35 1.70 16.95 1.80 18.60 1.90 20.30 BLEWGD 2.00 22.10 2.10 24.00 2.20 26.00 2.30 28.00 BOCWGD 061677 BOCWGD 0.00 0.00 0.10 0.35 0.20 0.70 0.30 1.20 BOCWGD 0.40 1.70 0.50 2.70 0.60 3.70 0.70 5.35 BOCWGD 0.80 7.00 0.90 9.30 1.00 12.10 1.10 16.80 BOCWGD 1.20 20.40 1.30 25.85 1.40 31.30 1.50 37.00 BOCWGD 1.60 42.75 1.70 48.55 1.80 54.40 1.90 60.30 BOCWGD 2.00 66.20 2.10 72.15 2.20 78.15 2.30 84.20 BOCWGD 2.40 90.30 2.50 96.50 2.60 102.80 2.70 109.20 BOCWGD 2.80 115.60 2.90 122.10 3.00 128.65 BUM GD 011375 */ return tbl; }
public RatingEquationBuilder(HydrographyDataSet ds,int equation_id) { InitializeComponent(); m_ds = ds; }
public int AddMeasurement(HydrographyDataSet.measurementRow m) { int folderID = GetOrCreateFolder( GetRootFolderNames()[0], //"Untitled" m.siteid, // SouthBend "Flow Measurements"); // "Flow Measurements" int id = NextID(); var r = AddSeriesCatalogRow(id, folderID, 0, 100, "measurement", m.date_measured.ToString(Hydrography.MeasurementDateFormat), //" ("+m.stage.ToString("F2")+","+m.discharge.ToString("F2")+")" , m.siteid, "", "Instant", "", "", "BasicMeasurement", "id=" + m.id, "", "", 1); return r.id; }
internal int AddRatingTable(HydrographyDataSet.rating_tablesRow m) { int folderID = GetOrCreateFolder( GetRootFolderNames()[0], //"Untitled" m.siteid, // NACW "Rating Tables"); // "Flow Measurements" int id = NextID(); var r = AddSeriesCatalogRow(id, folderID, 0, 100, "rating", m.version, m.siteid, "", "Instant", "", "", "BasicRating", "id=" + m.id, "", "", 1); return r.id; }
HydrographyDataSet.rating_tablesDataTable AppendToTable(string tableName, HydrographyDataSet.rating_tablesDataTable tbl) { var rt = new Dictionary<double, double>(); int idx = tf.IndexBeginningWith(tableName, 0); string cbtt = tf[idx].Substring(0, 4).Trim(); string pc = tf[idx].Substring(4, 2); string version = tf[idx].Substring(7).Trim(); for (int i = idx; i < tf.Length; i++) { if (tf[i].Trim() == "") continue; string c = tf[i].Substring(0, 4).Trim(); string p = tf[i].Substring(4, 2); if (c != cbtt || p != pc) break; var tokens = tf[i].Substring(6).Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); if (tokens.Length >= 2) { for (int j = 0; j < tokens.Length; j += 2) { double x, y; if (double.TryParse(tokens[j], out x) && double.TryParse(tokens[j + 1], out y)) { if( rt.ContainsKey(x)) { Console.WriteLine("duplicate entry skipped "+x+", "+y); } else rt.Add(x, y); } else { Console.WriteLine("Error parsing: " + tf[i]); } } } else { Console.WriteLine("skipping :"+ tf[i]); } } string s = string.Join("\n", rt.Select(x => x.Key + "," + x.Value).ToArray()); if (Regex.IsMatch(version, "^([0-9]){6}$")) { //050586 int yr = int.Parse(version.Substring(4)); int fourDigitYear = CultureInfo.CurrentCulture.Calendar.ToFourDigitYear(yr); version = fourDigitYear.ToString()+"-"+ version.Substring(0,2)+"-"+version.Substring(2,2); } if (version == "") version = "untitled"; var discharge_variable = "XX"; if (pc == "GD") discharge_variable = "QD"; if (pc == "GJ") discharge_variable = "QJ"; tbl.Addrating_tablesRow(tbl.NextID(), version, cbtt, pc,discharge_variable, s); return tbl; }
public RatingEquationBuilder(HydrographyDataSet ds, int equation_id) { InitializeComponent(); m_ds = ds; }