]> git.saurik.com Git - wxWidgets.git/blame_incremental - demos/dbbrowse/dbgrid.cpp
projects / wxWidgets.git / blame_incremental
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (non-incremental) | history | HEAD
Simplified html reading because previous one caused conflicts in wxUSE_STL=1.
[wxWidgets.git] / demos / dbbrowse / dbgrid.cpp
... / ...
CommitLineData
1//----------------------------------------------------------------------------------------
2// Name: DBGrid.cpp
3// Purpose: wxGrid sample
4// Author: Mark Johnson
5// Modified by: 19990929.mj10777 a reuseable DBGrid
6// Created: 19990929
7// Copyright: (c)
8// Licence: wxWindows license
9// RCS-ID: $Id$
10//----------------------------------------------------------------------------------------
11//-- all #ifdefs that the whole Project needs. -------------------------------------------
12//----------------------------------------------------------------------------------------
13#ifdef __GNUG__
14#pragma implementation
15#pragma interface
16#endif
17//----------------------------------------------------------------------------------------
18// For compilers that support precompilation, includes "wx/wx.h".
19#include "wx/wxprec.h"
20//----------------------------------------------------------------------------------------
21#ifdef __BORLANDC__
22#pragma hdrstop
23#endif
24//----------------------------------------------------------------------------------------
25#ifndef WX_PRECOMP
26#include "wx/wx.h"
27#endif
28//----------------------------------------------------------------------------------------
29//-- all #includes that every .cpp needs --- 19990807.mj10777 ----------------
30//----------------------------------------------------------------------------------------
31#include "std.h" // sorgsam Pflegen !
32//----------------------------------------------------------------------------------------
33BEGIN_EVENT_TABLE(DBGrid, wxGrid)
34 EVT_MOTION (DBGrid::OnMouseMove)
35 // DBGrid
36 // ------------
37 EVT_GRID_CELL_CHANGE( DBGrid::OnCellChange )
38 EVT_GRID_CELL_LEFT_CLICK( DBGrid::OnCellLeftClick )
39 EVT_GRID_CELL_LEFT_DCLICK( DBGrid::OnCellLeftDClick )
40 EVT_GRID_CELL_RIGHT_CLICK( DBGrid::OnCellRightClick )
41 EVT_GRID_CELL_RIGHT_DCLICK( DBGrid::OnCellRightDClick )
42 // EVT_GRID_COL_SIZE( DBGrid::OnColSize )
43 // EVT_GRID_ROW_SIZE( DBGrid::OnRowSize )
44 EVT_GRID_EDITOR_SHOWN( DBGrid::OnEditorShown )
45 EVT_GRID_EDITOR_HIDDEN( DBGrid::OnEditorHidden )
46 EVT_GRID_LABEL_LEFT_CLICK( DBGrid::OnLabelLeftClick )
47 EVT_GRID_LABEL_LEFT_DCLICK( DBGrid::OnLabelLeftDClick )
48 EVT_GRID_LABEL_RIGHT_CLICK( DBGrid::OnLabelRightClick )
49 EVT_GRID_LABEL_RIGHT_DCLICK( DBGrid::OnLabelRightDClick )
50 EVT_GRID_RANGE_SELECT( DBGrid::OnRangeSelected )
51 EVT_GRID_ROW_SIZE( DBGrid::OnRowSize )
52 EVT_GRID_SELECT_CELL( DBGrid::OnSelectCell )
53 EVT_MENU(GRID_EDIT,DBGrid::OnModusEdit)
54 EVT_MENU(GRID_BROWSE,DBGrid::OnModusBrowse)
55END_EVENT_TABLE()
56
57//----------------------------------------------------------------------------------------
58// wxListCtrl(parent, id, pos, size, style)
59// wxGrid(parent,wxID_ANY,wxPoint( 0, 0 ), wxSize( 400, 300 ) );
60//----------------------------------------------------------------------------------------
61// DBGrid
62//----------------------------------------------------------------------------------------
63// DBGrid::DBGrid(wxWindow *parent, const wxWindowID id,const wxPoint& pos,const wxSize& size):
64// wxGrid(parent, id, pos, size)
65DBGrid::DBGrid(wxWindow *parent, const wxWindowID id,const wxPoint& pos,const wxSize& size, long style):
66wxGrid(parent, id, pos, size, style)
67{
68 b_EditModus = false;
69 //---------------------------------------------------------------------------------------
70 popupMenu1 = new wxMenu(_T(""));
71 popupMenu1->Append(GRID_EDIT, _("Edit Modus"));
72 popupMenu2 = new wxMenu(_T(""));
73 popupMenu2->Append(GRID_BROWSE, _("Browse Modus"));
74}
75
76//----------------------------------------------------------------------------------------
77DBGrid::~DBGrid()
78{
79 delete popupMenu1;
80 delete popupMenu2;
81}
82
83//----------------------------------------------------------------------------------------
84int DBGrid::OnTableView(wxString Table)
85{
86 wxStopWatch sw;
87 //---------------------------------------------------------------------------------------
88 int x,y,z;
89 wxString Temp0;
90 wxBeginBusyCursor();
91 SetDefaultCellFont(* pDoc->ft_Doc);
92 //---------------------------------------------------------------------------------------
93 ct_BrowserDB = (db_Br+i_Which)->ct_BrowserDB; // Get the DSN Pointer
94 //---------------------------------------------------------------------------------------
95 if (ct_BrowserDB) // Valid pointer (!= NULL) ?
96 { // Pointer is Valid, use the wxDatabase Information
97 for (x=0;x<ct_BrowserDB->numTables;x++) // go through the Tables
98 {
99 if (!wxStrcmp((ct_BrowserDB->pTableInf+x)->tableName,Table)) // is this our Table ?
100 { // Yes, the Data of this Table shall be put into the Grid
101 int ValidTable = x; // Save the Tablenumber
102 (db_Br+i_Which)->OnSelect(Table,false); // Select * from "table"
103 // Set the local Pointer to the Column Information we are going to use
104 (db_Br+i_Which)->cl_BrowserDB = (ct_BrowserDB->pTableInf+x)->pColInf;
105 if ((ct_BrowserDB->pTableInf+x)->pColInf) // Valid pointer (!= NULL) ?
106 { // Pointer is Valid, Column Informationen sind Vorhanden
107 int i = (db_Br+i_Which)->i_Records; // How many Records are there
108 (db_Br+i_Which)->i_Which = ValidTable; // Still used ???? mj10777
109 if (i == 0) // If the Table is empty, then show one empty row
110 i++;
111 // wxLogMessage(_("\n-I-> DBGrid::OnTableView() : Vor CreateGrid"));
112 CreateGrid(i,(ct_BrowserDB->pTableInf+x)->numCols); // Records , Columns
113 for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++) // Loop through the Fields
114 { // The Field / Column name is used here as Row Titel
115 SetColLabelValue(y,((ct_BrowserDB->pTableInf+x)->pColInf+y)->colName);
116 SetColSize(y,95);
117 } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
118 SetColSize(((ct_BrowserDB->pTableInf+x)->numCols-1),120); // Make the last Column Wider
119 // The Grid has been created, now fill it
120 for (z=0;z<(db_Br+i_Which)->i_Records;z++) // Loop through the Records
121 {
122 Temp0.Printf(_T("%06d"),z+1); SetRowLabelValue(z,Temp0); // Set Row Lable Value
123 (db_Br+i_Which)->OnGetNext((ct_BrowserDB->pTableInf+ValidTable)->numCols,false);
124 for (y=0;y<(ct_BrowserDB->pTableInf+ValidTable)->numCols;y++) // Loop through the Fields
125 { // BrowserDB::OnGetNext Formats the field Value into tablename
126 SetCellValue(z, y,((db_Br+i_Which)->cl_BrowserDB+y)->tableName);
127 }
128#if wxUSE_STATUSBAR
129 if (z % 50 == 0)
130 {
131 Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - Record %6d (from %d) has been read."),Table.c_str(),z,(db_Br+i_Which)->i_Records);
132 pDoc->p_MainFrame->SetStatusText(Temp0, 0);
133 }
134#endif // wxUSE_STATUSBAR
135 } // for (z=0;z<(db_Br+i_Which)->i_Records;z++)
136 Temp0.Printf(_("-I-> DBGrid::OnTableView(%s) - %6d Records have been read. - Time needed : %ld ms"),Table.c_str(),z,sw.Time());
137 wxLogMessage(Temp0);
138#if wxUSE_STATUSBAR
139 pDoc->p_MainFrame->SetStatusText(Temp0, 0);
140#endif // wxUSE_STATUSBAR
141 // The Grid has been filled, now leave
142 goto Weiter;
143 } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
144 else
145 wxLogMessage(_("\n-E-> DBGrid::OnTableView() : Invalid Column Pointer : Failed"));
146 } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE")
147 } // for (x=0;x<ct_BrowserDB->numTables;x++)
148 } // if (ct_BrowserDB)
149 else
150 wxLogMessage(_("\n-E-> DBGrid::OnTableView() : Invalid DSN Pointer : Failed"));
151 //---------------------------------------------------------------------------------------
152Weiter:
153 EnableEditing(b_EditModus); // Deactivate in-place Editing
154 wxEndBusyCursor();
155 //---------------------------------------------------------------------------------------
156 wxLogMessage(_("-I-> DBGrid::OnTableView() - End"));
157 return 0;
158}
159
160//----------------------------------------------------------------------------------------
161void DBGrid::OnModusEdit(wxCommandEvent& WXUNUSED(event))
162{
163 b_EditModus = true; // Needed by PopupMenu
164 EnableEditing(b_EditModus); // Activate in-place Editing
165 UpdateDimensions(); // Redraw the Grid
166 // wxLogMessage(_("-I-> DBGrid::OnModusEdit() - End"));
167}
168
169//----------------------------------------------------------------------------------------
170void DBGrid::OnModusBrowse(wxCommandEvent& WXUNUSED(event))
171{
172 b_EditModus = false; // Needed by PopupMenu
173 EnableEditing(b_EditModus); // Deactivate in-place Editing
174 UpdateDimensions(); // Redraw the Grid
175 // wxLogMessage(_("-I-> DBGrid::OnModusBrowse() - End"));
176}
177
178//----------------------------------------------------------------------------------------
179void DBGrid::OnEditorShown( wxGridEvent& ev )
180{
181 // wxLogMessage(_("-I-> DBGrid::OnEditorShown() - End"));
182 ev.Skip();
183}
184
185//----------------------------------------------------------------------------------------
186void DBGrid::OnEditorHidden( wxGridEvent& ev )
187{
188 // wxLogMessage(_("-I-> DBGrid::OnEditorHidden() - End"));
189 ev.Skip();
190}
191
192//----------------------------------------------------------------------------------------
193void DBGrid::OnSelectCell( wxGridEvent& ev )
194{
195 logBuf = _T("");
196 logBuf << _T("Selected cell at row ") << ev.GetRow()
197 << _T(" col ") << ev.GetCol();
198 wxLogMessage( _T("%s"), logBuf.c_str() );
199 // you must call Skip() if you want the default processing
200 // to occur in wxGrid
201 ev.Skip();
202}
203
204//----------------------------------------------------------------------------------------
205void DBGrid::OnMouseMove(wxMouseEvent &event)
206{
207 MousePos = event.GetPosition();
208}
209
210//----------------------------------------------------------------------------------------
211void DBGrid::OnLabelLeftClick( wxGridEvent& ev )
212{
213 logBuf = _T("DBGrid::OnLabelLeftClick : ");
214 if ( ev.GetRow() != -1 )
215 {
216 logBuf << _T("row label ") << ev.GetRow();
217 }
218 else if ( ev.GetCol() != -1 )
219 {
220 logBuf << _T("col label ") << ev.GetCol();
221 }
222 else
223 {
224 logBuf << _T("corner label");
225 }
226 if ( ev.ShiftDown() )
227 logBuf << _T(" (shift down)");
228
229 // wxLogMessage( "%s", logBuf.c_str() );
230 logBuf += _T("\n");
231 wxLogMessage(logBuf.c_str());
232 ev.Skip();
233}
234
235//----------------------------------------------------------------------------------------
236void DBGrid::OnLabelRightClick( wxGridEvent& ev )
237{
238 //-------------------------------------------------------
239 if (b_EditModus)
240 PopupMenu(popupMenu2,MousePos.x,MousePos.y);
241 else
242 PopupMenu(popupMenu1,MousePos.x,MousePos.y);
243 //-------------------
244 logBuf = _T("DBGrid::OnLabelRightClick : ");
245 if ( ev.GetRow() != -1 )
246 {
247 logBuf << _T("row label ") << ev.GetRow();
248 }
249 else if ( ev.GetCol() != -1 )
250 {
251 logBuf << _T("col label ") << ev.GetCol();
252 }
253 else
254 {
255 logBuf << _T("corner label");
256 }
257 if ( ev.ShiftDown() )
258 logBuf << _T(" (shift down)");
259
260 // wxLogMessage( "%s", logBuf.c_str() );
261 logBuf += _T("\n");
262 wxLogMessage(logBuf.c_str());
263 ev.Skip();
264}
265
266//----------------------------------------------------------------------------------------
267void DBGrid::OnLabelLeftDClick( wxGridEvent& ev )
268{
269 logBuf = _T("DBGrid::OnLabelLeftDClick : ");
270 if ( ev.GetRow() != -1 )
271 {
272 logBuf << _T("row label ") << ev.GetRow();
273 }
274 else if ( ev.GetCol() != -1 )
275 {
276 logBuf << _T("col label ") << ev.GetCol();
277 }
278 else
279 {
280 logBuf << _T("corner label");
281 }
282 if ( ev.ShiftDown() )
283 logBuf << _T(" (shift down)");
284
285 // wxLogMessage( _T("%s"), logBuf.c_str() );
286 logBuf += _T("\n");
287 wxLogMessage(logBuf.c_str());
288 ev.Skip();
289}
290
291//----------------------------------------------------------------------------------------
292void DBGrid::OnLabelRightDClick( wxGridEvent& ev )
293{
294 logBuf = _T("DBGrid::OnLabelRightDClick : ");
295 if ( ev.GetRow() != -1 )
296 {
297 logBuf << _T("row label ") << ev.GetRow();
298 }
299 else if ( ev.GetCol() != -1 )
300 {
301 logBuf << _T("col label ") << ev.GetCol();
302 }
303 else
304 {
305 logBuf << _T("corner label");
306 }
307 if ( ev.ShiftDown() )
308 logBuf << _T(" (shift down)");
309 // wxLogMessage( "%s", logBuf.c_str() );
310 logBuf += _T("\n");
311 wxLogMessage(logBuf.c_str());
312 ev.Skip();
313}
314
315//----------------------------------------------------------------------------------------
316void DBGrid::OnCellLeftClick( wxGridEvent& ev )
317{
318 logBuf = _T("DBGrid::OnCellLeftClick : ");
319 logBuf << _T("Cell at row ") << ev.GetRow()
320 << _T(" col ") << ev.GetCol();
321 // wxLogMessage( "%s", logBuf.c_str() );
322 // wxMessageBox(logBuf);
323 logBuf += _T("\n");
324 wxLogMessage(logBuf.c_str());
325 // you must call event skip if you want default grid processing
326 // (cell highlighting etc.)
327 //
328 ev.Skip();
329}
330
331//----------------------------------------------------------------------------------------
332void DBGrid::OnCellRightClick( wxGridEvent& ev )
333{
334 logBuf = _T("DBGrid::OnCellRightClick : ");
335 logBuf << _T("Cell at row ") << ev.GetRow()
336 << _T(" col ") << ev.GetCol();
337 // wxLogMessage( "%s", logBuf.c_str() );
338 // wxMessageBox(logBuf);
339 logBuf += _T("\n");
340 wxLogMessage(logBuf.c_str());
341 // you must call event skip if you want default grid processing
342 // (cell highlighting etc.)
343 //
344 ev.Skip();
345}
346
347//----------------------------------------------------------------------------------------
348void DBGrid::OnCellLeftDClick( wxGridEvent& ev )
349{
350 logBuf = _T("DBGrid::OnCellLeftDClick : ");
351 logBuf << _T("Cell at row ") << ev.GetRow()
352 << _T(" col ") << ev.GetCol();
353 // wxLogMessage( "%s", logBuf.c_str() );
354 // wxMessageBox(logBuf);
355 logBuf += _T("\n");
356 wxLogMessage(logBuf.c_str());
357 // you must call event skip if you want default grid processing
358 // (cell highlighting etc.)
359 //
360 ev.Skip();
361}
362
363//----------------------------------------------------------------------------------------
364void DBGrid::OnCellRightDClick( wxGridEvent& ev )
365{
366 logBuf = _T("DBGrid::OnCellRightDClick : ");
367 logBuf << _T("Cell at row ") << ev.GetRow()
368 << _T(" col ") << ev.GetCol();
369 // wxLogMessage( "%s", logBuf.c_str() );
370 // wxMessageBox(logBuf);
371 logBuf += _T("\n");
372 wxLogMessage(logBuf.c_str());
373 // you must call event skip if you want default grid processing
374 // (cell highlighting etc.)
375 //
376 ev.Skip();
377}
378
379//----------------------------------------------------------------------------------------
380void DBGrid::OnCellChange( wxGridEvent& ev )
381{
382 logBuf = _T("DBGrid::OnCellChange : ");
383 logBuf << _T("Cell at row ") << ev.GetRow()
384 << _T(" col ") << ev.GetCol();
385 // wxLogMessage( "%s", logBuf.c_str() );
386 // wxMessageBox(logBuf);
387 logBuf += _T("\n");
388 wxLogMessage(logBuf.c_str());
389 // you must call event skip if you want default grid processing
390 // (cell highlighting etc.)
391 //
392 ev.Skip();
393}
394
395//----------------------------------------------------------------------------------------
396void DBGrid::OnRowSize( wxGridSizeEvent& ev )
397{
398 logBuf = _T("DBGrid::OnRowSize : ");
399 logBuf << _T("Resized row ") << ev.GetRowOrCol();
400 // wxLogMessage( "%s", logBuf.c_str() );
401 logBuf += _T("\n");
402 wxLogMessage(logBuf.c_str());
403 ev.Skip();
404}
405
406//----------------------------------------------------------------------------------------
407void DBGrid::OnColSize( wxGridSizeEvent& ev )
408{
409 logBuf = _T("DBGrid::OnColSize : ");
410 logBuf << _T("Resized col ") << ev.GetRowOrCol();
411 // wxLogMessage( "%s", logBuf.c_str() );
412 logBuf += _T("\n");
413 wxLogMessage(logBuf.c_str());
414 ev.Skip();
415}
416
417//----------------------------------------------------------------------------------------
418void DBGrid::OnRangeSelected( wxGridRangeSelectEvent& ev )
419{
420 logBuf = _T("DBGrid::OnRangeSelected : ");
421 logBuf << _T("Selected cells from row ") << ev.GetTopRow()
422 << _T(" col ") << ev.GetLeftCol()
423 << _T(" to row ") << ev.GetBottomRow()
424 << _T(" col ") << ev.GetRightCol();
425 logBuf += _T("\n");
426 // wxLogMessage( "%s", logBuf.c_str() );
427 wxLogMessage(logBuf.c_str());
428 ev.Skip();
429}
430//----------------------------------------------------------------------------------------
wxWidgets (Impactor)