private string getOutputFile(bool isQueryEachYear, OutputIntervalType interval, UnitType source, DataReadingMethodType method) { return(Path.Combine(getOutputFolder(isQueryEachYear, interval), string.Format("{0}_{1}_{2}_{3}.csv", source, method, isQueryEachYear ? "each_year" : "all_year", interval))); }
private string getOutputFolder(bool isQueryEachYear, OutputIntervalType interval) { string workingpath = Path.Combine(Directory.GetCurrentDirectory(), "extract_test"); if (!Directory.Exists(workingpath)) { Directory.CreateDirectory(workingpath); } string yearOption = isQueryEachYear ? "each_year" : "all_year"; workingpath = Path.Combine(workingpath, yearOption); if (!Directory.Exists(workingpath)) { Directory.CreateDirectory(workingpath); } workingpath = Path.Combine(workingpath, interval.ToString()); if (!Directory.Exists(workingpath)) { Directory.CreateDirectory(workingpath); } return(workingpath); }
public ExtractSWAT_SQLite(string txtinoutPath, OutputIntervalType interval) { _db3Path = System.IO.Path.Combine(txtinoutPath, getDatabaseName(interval)); if (!System.IO.File.Exists(_db3Path)) { _db3Path = ""; } }
public ExtractSWAT_SQLite(string scenariosDir, string scenarioName, OutputIntervalType interval) { _db3Path = System.IO.Path.Combine(scenariosDir, scenarioName, "txtinout", getDatabaseName(interval)); if (!System.IO.File.Exists(_db3Path)) { _db3Path = ""; } }
public SQLiteValidation(string scenariosDir, string scenarioName, OutputIntervalType interval) { _extractSQLite = new ExtractSWAT_SQLite(scenariosDir, scenarioName,interval); _extractText = new ExtractSWAT_Text_SWATPlot(scenariosDir,scenarioName); _startYear = _extractText.StartYear; _endYear = _extractText.EndYear; }
public SQLiteValidation(string scenariosDir, string scenarioName, OutputIntervalType interval) { _extractSQLite = new ExtractSWAT_SQLite(scenariosDir, scenarioName, interval); _extractText = new ExtractSWAT_Text_SWATPlot(scenariosDir, scenarioName); _startYear = _extractText.StartYear; _endYear = _extractText.EndYear; }
/// <summary> /// Retrieve data columns for given result interval /// </summary> /// <param name="type"></param> /// <returns></returns> public static string getDateColumns(OutputIntervalType type) { switch (type) { case OutputIntervalType.DAY: return(DATE_COLUMNS_DAILY); case OutputIntervalType.MON: return(DATE_COLUMNS_MONTHLY); case OutputIntervalType.YEAR: return(DATE_COLUMNS_YEARLY); default: return(""); } }
public static string getDatabaseName(OutputIntervalType interval) { switch (interval) { case OutputIntervalType.DAY: return("result_627_daily.db3"); case OutputIntervalType.MON: return("result_627_monthly.db3"); case OutputIntervalType.YEAR: return("result_627_yearly.db3"); default: return(""); } }
private void getBasicInformation() { DataTable dt = Extract("select * from ave_annual_basin"); if (dt.Rows.Count == 0) { return; } foreach (DataRow r in dt.Rows) { RowItem item = new RowItem(r); string name = item.getColumnValue_String("NAME"); if (name.Equals("START_YEAR_OUTPUT")) { _startYear = item.getColumnValue_Int("VALUE"); } else if (name.Equals("END_YEAR")) { _endYear = item.getColumnValue_Int("VALUE"); } else if (name.Equals("OUTPUT_INTERVAL")) { _interval = (OutputIntervalType)(item.getColumnValue_Int("VALUE")); } } dt = Extract("select * from hru_info"); _numofHRU = dt.Rows.Count; dt = Extract("select * from sub_info"); _numofSub = dt.Rows.Count; dt = Extract("select * from sqlite_master where name = 'rsv_info'"); if (dt.Rows.Count > 0) { dt = Extract("select * from rsv_info"); _numofSub = dt.Rows.Count; } }
protected void getModelSettings() { //get start year and output interval string cioFile = this.getFilePath("file.cio"); string line; // get number of records int numYears; using (StreamReader sr = new StreamReader(cioFile)) { // skip 7 lines for (int i = 1; i <= 7; i++) { sr.ReadLine(); } line = sr.ReadLine(); numYears = Int32.Parse(line.Substring(0, 16)); line = sr.ReadLine(); _startYear = Int32.Parse(line.Substring(0, 16)); _endYear = _startYear + numYears - 1; line = sr.ReadLine(); line = sr.ReadLine(); // skip 47 lines, so next is line 59 for (int i = 1; i <= 47; i++) { sr.ReadLine(); } line = sr.ReadLine(); _interval = (OutputIntervalType)(Int32.Parse(line.Substring(0, 16))); line = sr.ReadLine(); int NYSKIP = Int32.Parse(line.Substring(0, 16)); _startYear += NYSKIP; } //get number of hru, subbasin and reservoir from the output file _numofHRU = getNumberOfUnit(UnitType.HRU); _numofSub = getNumberOfUnit(UnitType.SUB); _numofRes = getNumberOfUnit(UnitType.RSV); }
protected void getModelSettings() { //get start year and output interval string cioFile = this.getFilePath("file.cio"); string line; // get number of records int numYears; using (StreamReader sr = new StreamReader(cioFile)) { // skip 7 lines for (int i = 1; i <= 7; i++) sr.ReadLine(); line = sr.ReadLine(); numYears = Int32.Parse(line.Substring(0, 16)); line = sr.ReadLine(); _startYear = Int32.Parse(line.Substring(0, 16)); _endYear = _startYear + numYears - 1; line = sr.ReadLine(); line = sr.ReadLine(); // skip 47 lines, so next is line 59 for (int i = 1; i <= 47; i++) sr.ReadLine(); line = sr.ReadLine(); _interval = (OutputIntervalType)(Int32.Parse(line.Substring(0, 16))); line = sr.ReadLine(); int NYSKIP = Int32.Parse(line.Substring(0, 16)); _startYear += NYSKIP; } //get number of hru, subbasin and reservoir from the output file _numofHRU = getNumberOfUnit(UnitType.HRU); _numofSub = getNumberOfUnit(UnitType.SUB); _numofRes = getNumberOfUnit(UnitType.RSV); }
private void getBasicInformation() { DataTable dt = Extract("select * from ave_annual_basin"); if (dt.Rows.Count == 0) return; foreach (DataRow r in dt.Rows) { RowItem item = new RowItem(r); string name = item.getColumnValue_String("NAME"); if (name.Equals("START_YEAR_OUTPUT")) _startYear = item.getColumnValue_Int("VALUE"); else if (name.Equals("END_YEAR")) _endYear = item.getColumnValue_Int("VALUE"); else if (name.Equals("OUTPUT_INTERVAL")) _interval = (OutputIntervalType)(item.getColumnValue_Int("VALUE")); } dt = Extract("select * from hru_info"); _numofHRU = dt.Rows.Count; dt = Extract("select * from sub_info"); _numofSub = dt.Rows.Count; dt = Extract("select * from sqlite_master where name = 'rsv_info'"); if (dt.Rows.Count > 0) { dt = Extract("select * from rsv_info"); _numofSub = dt.Rows.Count; } }
/// <summary> /// Retrieve data columns for given result interval /// </summary> /// <param name="type"></param> /// <returns></returns> public static string getDateColumns(OutputIntervalType type) { switch (type) { case OutputIntervalType.DAY: return DATE_COLUMNS_DAILY; case OutputIntervalType.MON: return DATE_COLUMNS_MONTHLY; case OutputIntervalType.YEAR: return DATE_COLUMNS_YEARLY; default: return ""; } }
public static string getDatabaseName(OutputIntervalType interval) { switch (interval) { case OutputIntervalType.DAY: return "result_627_daily.db3"; case OutputIntervalType.MON: return "result_627_monthly.db3"; case OutputIntervalType.YEAR: return "result_627_yearly.db3"; default: return ""; } }
public ExtractSWAT_SQLite(string txtinoutPath, OutputIntervalType interval) { _db3Path = System.IO.Path.Combine(txtinoutPath, getDatabaseName(interval)); if (!System.IO.File.Exists(_db3Path)) _db3Path = ""; }
public ExtractSWAT_SQLite(string scenariosDir, string scenarioName, OutputIntervalType interval) { _db3Path = System.IO.Path.Combine( scenariosDir, scenarioName,"txtinout", getDatabaseName(interval)); if (!System.IO.File.Exists(_db3Path)) _db3Path = ""; }