Free cookie consent management tool by TermsFeed Policy Generator

source: trunk/sources/HeuristicLab.DataAnalysis/3.3/DatasetView.cs @ 2305

Last change on this file since 2305 was 1529, checked in by gkronber, 16 years ago

Moved source files of plugins AdvancedOptimizationFrontEnd ... Grid into version-specific sub-folders. #576

File size: 6.8 KB
Line 
1#region License Information
2/* HeuristicLab
3 * Copyright (C) 2002-2008 Heuristic and Evolutionary Algorithms Laboratory (HEAL)
4 *
5 * This file is part of HeuristicLab.
6 *
7 * HeuristicLab is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation, either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * HeuristicLab is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with HeuristicLab. If not, see <http://www.gnu.org/licenses/>.
19 */
20#endregion
21
22using System;
23using System.Windows.Forms;
24using HeuristicLab.Core;
25using HeuristicLab.PluginInfrastructure;
26
27namespace HeuristicLab.DataAnalysis {
28  public partial class DatasetView : EditorBase {
29    public Dataset Dataset {
30      get { return (Dataset)Item; }
31      set {
32        Item = value;
33        Refresh();
34      }
35    }
36    public DatasetView()
37      : base() {
38      InitializeComponent();
39      DiscoveryService discovery = new DiscoveryService();
40      IDatasetManipulator[] manipuators = discovery.GetInstances<IDatasetManipulator>();
41      contextMenuStrip.Items.Add(new ToolStripSeparator());
42      foreach(IDatasetManipulator manipulator in manipuators) {
43        contextMenuStrip.Items.Add(new ToolStripButton(manipulator.Action,null , delegate(object source, EventArgs args)
44          {
45            manipulator.Execute(Dataset);
46            Refresh();
47          }));
48      }
49     
50      // format all cells with the round-trip formatter to make sure that values that are exported and imported to
51      // another C# app (HL2) have the same numeric value
52      dataGridView.DefaultCellStyle.Format = "r";
53    }
54
55    public DatasetView(Dataset dataset)
56      : this() {
57      this.Dataset = dataset;
58    }
59
60    protected override void UpdateControls() {
61      base.UpdateControls();
62      if (Dataset != null) {
63        // DataGridView is bitching around. When it's columnCount (maybe also rowCount) is changed it creates
64        // new column objects and they have SortMode set to 'automatic'. However this is not allowed if the
65        // selectionmode is set to 'ColumnHeaderSelect' at the same time, resulting in an exception.
66        // A solution is to set the SelectionMode to CellSelect before any changes. After the columns
67        // have been updated (and their SortMode set to 'NotSortable') we switch back to SelectionMode=ColumnHeaderSelect.
68        dataGridView.SelectionMode = DataGridViewSelectionMode.CellSelect;
69        dataGridView.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing;
70        int rows = Dataset.Rows;
71        int columns = Dataset.Columns;
72        nameTextBox.Text = Dataset.Name;
73        rowsTextBox.Text = rows + "";
74        columnsTextBox.Text = columns + "";
75        dataGridView.ColumnCount = columns;
76        dataGridView.RowCount = rows;
77        for (int i = 0; i < rows; i++) {
78          for (int j = 0; j < columns; j++) {
79            dataGridView.Rows[i].Cells[j].Value = Dataset.GetValue(i, j);
80            dataGridView.Rows[i].HeaderCell.Value = i.ToString();
81          }
82        }
83        for (int i = 0; i < columns; i++) {
84          dataGridView.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; // SortMode has to be NotSortable to allow ColumnHeaderSelect
85          dataGridView.Columns[i].Name = GetColumnName(i);
86        }
87        dataGridView.SelectionMode = DataGridViewSelectionMode.ColumnHeaderSelect; // switch back to column selection
88        dataGridView.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
89      } else {
90        rowsTextBox.Text = "1";
91        columnsTextBox.Text = "1";
92        dataGridView.ColumnCount = 1;
93        dataGridView.RowCount = 1;
94      }
95    }
96
97    private void dataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) {
98      if (ValidateData((string)e.FormattedValue)) {
99        SetArrayElement(e.RowIndex, e.ColumnIndex, (string)e.FormattedValue);
100        e.Cancel = false;
101      } else {
102        e.Cancel = true;
103      }
104    }
105
106
107    private void SetArrayElement(int row, int column, string element) {
108      double result;
109      double.TryParse(element, out result);
110      if (result != Dataset.GetValue(row, column)) {
111        Dataset.SetValue(row, column, result);
112      }
113    }
114
115    private bool ValidateData(string element) {
116      double result;
117      return element != null && double.TryParse(element, out result);
118    }
119
120    private void scaleValuesToolStripMenuItem_Click(object sender, EventArgs e) {
121      foreach(DataGridViewColumn column in dataGridView.SelectedColumns) {
122        Dataset.ScaleVariable(column.Index);
123        column.Name = GetColumnName(column.Index) + " [scaled]";
124      }
125      Refresh();
126    }
127
128    private void originalValuesToolStripMenuItem_Click(object sender, EventArgs e) {
129      foreach(DataGridViewColumn column in dataGridView.SelectedColumns) {
130        Dataset.UnscaleVariable(column.Index);
131        column.Name = GetColumnName(column.Index);
132      }
133      Refresh();     
134    }
135
136    private string GetColumnName(int index) {
137      if(Dataset.Columns == dataGridView.Columns.Count) {
138        return Dataset.GetVariableName(index);
139      } else {
140        return "Var " + index;
141      }
142    }
143
144    private void showScalingToolStripMenuItem_Click(object sender, EventArgs e) {
145      ManualScalingControl scalingControl = new ManualScalingControl(false);
146      double[,] scalingParameters = new double[2, Dataset.Columns];
147      for(int i = 0; i < Dataset.Columns; i++) {
148        scalingParameters[0, i] = Dataset.ScalingFactor[i];
149        scalingParameters[1, i] = Dataset.ScalingOffset[i];
150      }
151      scalingControl.Data = scalingParameters;
152      scalingControl.ShowDialog();
153    }
154
155    private void scaleValuesmanuallyToolStripMenuItem_Click(object sender, EventArgs e) {
156      ManualScalingControl scalingControl = new ManualScalingControl(true);
157      double[,] scalingParameters = new double[2, Dataset.Columns];
158      for(int i = 0; i < Dataset.Columns; i++) {
159        scalingParameters[0, i] = Dataset.ScalingFactor[i];
160        scalingParameters[1, i] = Dataset.ScalingOffset[i];
161      }
162      scalingControl.Data = scalingParameters;
163      if(scalingControl.ShowDialog() == DialogResult.OK) {
164        for(int i = 0; i < Dataset.Columns; i++) {
165          Dataset.ScaleVariable(i, scalingControl.Data[0, i], scalingControl.Data[1, i]);
166        }
167      }
168      Refresh();
169    }
170  }
171}
Note: See TracBrowser for help on using the repository browser.