private void updateTableAndChart() { tableView1.DataTable = null; outputDisplayChart1.ObservedData = null; yearCtrl1.ObservedData = null; _observedData = null; _statistics = ""; if (_col != null && _id > 0) { _observedData = _prj.Observation(_interval).getObservedData(_unitType, _id, _col); if (_observedData != null) { //show the data ArcSWAT.SWATUnitColumnYearObservationData observedData = _observedData.getObservedData(_year); tableView1.ObservedData = observedData; outputDisplayChart1.ObservedData = observedData; yearCtrl1.ObservedData = _observedData.getObservedData(-1); if (onDataStatisticsChanged != null) { _statistics = observedData.Statistics.ToString(); onDataStatisticsChanged(this, new EventArgs()); } } } }
/// <summary> /// Used to get observed data corresponding to specific result /// </summary> /// <param name="result"></param> /// <returns></returns> public SWATUnitColumnYearObservationData getObservedData(SWATUnitColumnYearResult result) { //check if the database is there if (!_exist) { return(null); } //see if the column has correponding observed data string[] columns = getObservationDataColumns(result.UnitResult.Unit.Type); if (columns == null) { return(null); } if (System.Array.IndexOf(columns, getObservationColumnFromSWAT(result.Column)) == -1) { return(null); } //find the data string uniqueID = getUniqueId(result.UnitResult.Unit.Type, result.UnitResult.Unit.ID, result.Column); if (_allData.ContainsKey(uniqueID)) { uniqueID = getUniqueId(result); if (!_allData.ContainsKey(uniqueID)) { _allData.Add(uniqueID, new SWATUnitObservationData(result, this)); } SWATUnitObservationData unitData = _allData[uniqueID]; return(unitData.getObservedData(result.Year)); } return(null); }
private void loadData(SWATUnitType type, int id, string col) { if (!_exist) { return; } string tableName = getTableName(type, id, col); DataTable dt = GetDataTable( string.Format("select name from sqlite_master where type = 'table' and name = '{0}'", tableName)); if (dt.Rows.Count > 0) { //see if there are some data //don't consider empty tables dt = GetDataTable( string.Format("select count(*) from [{0}]", tableName)); if (dt.Rows.Count == 0) { return; } RowItem item = new RowItem(dt.Rows[0]); if (item.getColumnValue_Int(0) == 0) { return; } //read data string dataUniqueId = getUniqueId(type, id, col); //remove previous one _allData.Remove(dataUniqueId); _allData_display.Remove(dataUniqueId); //add new one SWATUnitObservationData data = new SWATUnitObservationData( id, type, col, -1, -1, this); //add to all data _allData.Add(dataUniqueId, data); //add to display data string display_id = string.Format("{0}_{1}", type, id); if (!_allData_display.ContainsKey(display_id)) { _allData_display.Add(display_id, new List <SWATUnitObservationData>()); } _allData_display[display_id].Add(data); } }
private void loadData(SWATUnitType type) { if (!_exist) return; DataTable dt = GetDataTable("select name from sqlite_master where type = 'table'"); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { //get table name string tableName = r[0].ToString(); if(!tableName.Contains(type.ToString())) continue; //see if there are some data //don't consider empty tables dt = GetDataTable( string.Format("select count(*) from [{0}]", tableName)); RowItem item = new RowItem(dt.Rows[0]); if (item.getColumnValue_Int(0) == 0) continue; //extract the id from table name string[] all_in_tableName = tableName.Split(OBSERVATION_TABLE_NAME_DELIMITER); if (all_in_tableName.Length < 3) continue; int id = -1; if (int.TryParse(all_in_tableName[1], out id)) { string col = all_in_tableName[2]; string dataUniqueId = getUniqueId(type, id, col); if (!_allData.ContainsKey(dataUniqueId)) { SWATUnitObservationData data = new SWATUnitObservationData( id, type, col, -1, -1, this); //add to all data _allData.Add(dataUniqueId,data); //add to display data string display_id = string.Format("{0}_{1}",type,id); if (!_allData_display.ContainsKey(display_id)) _allData_display.Add(display_id, new List<SWATUnitObservationData>()); _allData_display[display_id].Add(data); } } } } }
private void loadData(SWATUnitType type, int id, string col) { if (!_exist) return; string tableName = getTableName(type, id, col); DataTable dt = GetDataTable( string.Format("select name from sqlite_master where type = 'table' and name = '{0}'", tableName)); if (dt.Rows.Count > 0) { //see if there are some data //don't consider empty tables dt = GetDataTable( string.Format("select count(*) from [{0}]", tableName)); if (dt.Rows.Count == 0) return; RowItem item = new RowItem(dt.Rows[0]); if (item.getColumnValue_Int(0) == 0) return; //read data string dataUniqueId = getUniqueId(type, id, col); //remove previous one _allData.Remove(dataUniqueId); _allData_display.Remove(dataUniqueId); //add new one SWATUnitObservationData data = new SWATUnitObservationData( id, type, col, -1, -1, this); //add to all data _allData.Add(dataUniqueId, data); //add to display data string display_id = string.Format("{0}_{1}", type, id); if (!_allData_display.ContainsKey(display_id)) _allData_display.Add(display_id, new List<SWATUnitObservationData>()); _allData_display[display_id].Add(data); } }
public SWATUnitColumnYearObservationData(string col, int year, SWATUnitObservationData data) : base(col, year) { _parentData = data; _colCompare = string.Format("{0}_Observed", _col); }
private void loadData(SWATUnitType type) { if (!_exist) { return; } DataTable dt = GetDataTable("select name from sqlite_master where type = 'table'"); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { //get table name string tableName = r[0].ToString(); if (!tableName.Contains(type.ToString())) { continue; } //see if there are some data //don't consider empty tables dt = GetDataTable( string.Format("select count(*) from [{0}]", tableName)); RowItem item = new RowItem(dt.Rows[0]); if (item.getColumnValue_Int(0) == 0) { continue; } //extract the id from table name string[] all_in_tableName = tableName.Split(OBSERVATION_TABLE_NAME_DELIMITER); if (all_in_tableName.Length < 3) { continue; } int id = -1; if (int.TryParse(all_in_tableName[1], out id)) { string col = all_in_tableName[2]; string dataUniqueId = getUniqueId(type, id, col); if (!_allData.ContainsKey(dataUniqueId)) { SWATUnitObservationData data = new SWATUnitObservationData( id, type, col, -1, -1, this); //add to all data _allData.Add(dataUniqueId, data); //add to display data string display_id = string.Format("{0}_{1}", type, id); if (!_allData_display.ContainsKey(display_id)) { _allData_display.Add(display_id, new List <SWATUnitObservationData>()); } _allData_display[display_id].Add(data); } } } } }
public SWATUnitColumnYearObservationData(string col, int year,SWATUnitObservationData data) : base(col,year) { _parentData = data; _colCompare = string.Format("{0}_Observed", _col); }