private void checkStatus()
{
if (DatabasePath == null || !File.Exists(DatabasePath))
{
_status = ScenarioResultStatus.NO_EXIST; return;
}
DataTable dt = Query.GetDataTable("select * from " + ScenarioResultStructure.TABLE_NAME_WATERSHED_AVERAGE_ANNUAL, DatabasePath);
if (dt.Rows.Count == 0)
{
_status = ScenarioResultStatus.UNSUCCESS; return;
}
foreach (DataRow r in dt.Rows)
{
RowItem item = new RowItem(r);
string name = item.getColumnValue_String("NAME");
if (name.Equals(ScenarioResultStructure.NAME_STATUS_START_YEAR))
{
_startYear = item.getColumnValue_Int("VALUE");
}
else if (name.Equals("END_YEAR"))
{
_endYear = item.getColumnValue_Int("VALUE");
}
else if (name.Equals("OUTPUT_INTERVAL"))
{
_interval = (SWATResultIntervalType)(item.getColumnValue_Int("VALUE"));
}
else if (name.Equals("SUCCESS"))
{
_status = ScenarioResultStatus.NORMAL;
}
}
//some version don't have this output, need to upgrade
if (_startYear == ScenarioResultStructure.UNKONWN_ID)
{
throw new Exception("Missing output starting year. Please upgrade your SWAT executable.");
}
_generationTime = (new System.IO.FileInfo(DatabasePath)).LastWriteTime;
}
private void checkStatus()
{
if (DatabasePath == null || !File.Exists(DatabasePath)) { _status = ScenarioResultStatus.NO_EXIST; return; }
DataTable dt = Query.GetDataTable("select * from " + ScenarioResultStructure.TABLE_NAME_WATERSHED_AVERAGE_ANNUAL, DatabasePath);
if (dt.Rows.Count == 0) { _status = ScenarioResultStatus.UNSUCCESS; return; }
foreach (DataRow r in dt.Rows)
{
RowItem item = new RowItem(r);
string name = item.getColumnValue_String("NAME");
if (name.Equals(ScenarioResultStructure.NAME_STATUS_START_YEAR))
_startYear = item.getColumnValue_Int("VALUE");
else if (name.Equals("END_YEAR"))
_endYear = item.getColumnValue_Int("VALUE");
else if (name.Equals("OUTPUT_INTERVAL"))
_interval = (SWATResultIntervalType)(item.getColumnValue_Int("VALUE"));
else if (name.Equals("SUCCESS"))
_status = ScenarioResultStatus.NORMAL;
}
//some version don't have this output, need to upgrade
if (_startYear == ScenarioResultStructure.UNKONWN_ID)
throw new Exception("Missing output starting year. Please upgrade your SWAT executable.");
_generationTime = (new System.IO.FileInfo(DatabasePath)).LastWriteTime;
}
