]>
Commit | Line | Data |
---|---|---|
1 | /////////////////////////////////////////////////////////////////////////////// | |
2 | // Name: dbgrid.h | |
3 | // Purpose: Displays a wxDbTable in a wxGrid. | |
4 | // Author: Roger Gammans, Paul Gammans | |
5 | // Modified by: | |
6 | // Created: | |
7 | // RCS-ID: $Id$ | |
8 | // Copyright: (c) 1999 The Computer Surgery (roger@computer-surgery.co.uk) | |
9 | // Licence: wxWindows licence | |
10 | /////////////////////////////////////////////////////////////////////////////// | |
11 | // Branched From : dbgrid.h,v 1.19 2001/03/28 11:16:01 | |
12 | /////////////////////////////////////////////////////////////////////////////// | |
13 | ||
14 | #ifndef _WX_GENERIC_DBGRID_H_ | |
15 | #define _WX_GENERIC_DBGRID_H_ | |
16 | ||
17 | #if wxUSE_ODBC | |
18 | #if wxUSE_GRID | |
19 | ||
20 | #include "wx/log.h" | |
21 | #include "wx/dbtable.h" | |
22 | #include "wx/dynarray.h" | |
23 | #include "wx/grid.h" | |
24 | #include "wx/dbkeyg.h" | |
25 | ||
26 | #define wxGRID_VALUE_DBAUTO _T("dbauto") | |
27 | ||
28 | WX_DECLARE_USER_EXPORTED_OBJARRAY(GenericKey,keyarray,WXDLLIMPEXP_DBGRID); | |
29 | ||
30 | static const int wxUSE_QUERY = -1; | |
31 | ||
32 | class WXDLLIMPEXP_DBGRID wxDbGridColInfoBase | |
33 | { | |
34 | public: | |
35 | //Default ctor | |
36 | wxDbGridColInfoBase() { } | |
37 | wxDbGridColInfoBase(int colNo, | |
38 | wxString type, wxString title) : | |
39 | DbCol(colNo), | |
40 | wxtypename(type), | |
41 | Title(title) | |
42 | { } | |
43 | //Copy Ctor | |
44 | wxDbGridColInfoBase(const wxDbGridColInfoBase& ref) | |
45 | { | |
46 | DbCol = ref.DbCol; | |
47 | wxtypename = ref.wxtypename; | |
48 | Title = ref.Title; | |
49 | } | |
50 | //Empty destructor for member obj's | |
51 | ~wxDbGridColInfoBase() {} | |
52 | ||
53 | int DbCol; | |
54 | wxString wxtypename; | |
55 | wxString Title; | |
56 | }; | |
57 | ||
58 | ||
59 | class WXDLLIMPEXP_DBGRID wxDbGridColInfo | |
60 | { | |
61 | public: | |
62 | wxDbGridColInfo(int colNo, | |
63 | wxString type, | |
64 | wxString title, | |
65 | wxDbGridColInfo *next) : | |
66 | m_data(colNo,type,title) | |
67 | { | |
68 | m_next=next; | |
69 | } | |
70 | ||
71 | //Empty List | |
72 | ~wxDbGridColInfo() { delete m_next; } | |
73 | ||
74 | //Recurse to find length. | |
75 | int Length() { return (m_next ? m_next->Length() +1 : 1); } | |
76 | ||
77 | // Adds a new column info (2 step creation) | |
78 | void AddColInfo (int colNo, | |
79 | wxString type, | |
80 | wxString title) | |
81 | { | |
82 | GetLast()->m_next = new wxDbGridColInfo (colNo, type, title, NULL); | |
83 | } | |
84 | ||
85 | // Searches last | |
86 | wxDbGridColInfo *GetLast() { return (m_next ? m_next->GetLast() : this); } | |
87 | ||
88 | ||
89 | protected: | |
90 | wxDbGridColInfoBase m_data; | |
91 | wxDbGridColInfo *m_next; | |
92 | ||
93 | friend class wxDbGridTableBase; | |
94 | }; | |
95 | ||
96 | ||
97 | class WXDLLIMPEXP_DBGRID wxDbGridCellAttrProvider : public wxGridCellAttrProvider | |
98 | { | |
99 | public: | |
100 | wxDbGridCellAttrProvider(); | |
101 | wxDbGridCellAttrProvider(wxDbTable *tab, wxDbGridColInfoBase* ColInfo); | |
102 | virtual ~wxDbGridCellAttrProvider(); | |
103 | ||
104 | virtual wxGridCellAttr *GetAttr(int row, int col, | |
105 | wxGridCellAttr::wxAttrKind kind) const; | |
106 | virtual void AssignDbTable(wxDbTable *tab); | |
107 | private: | |
108 | wxDbTable *m_data; | |
109 | wxDbGridColInfoBase *m_ColInfo; | |
110 | }; | |
111 | ||
112 | ||
113 | class WXDLLIMPEXP_DBGRID wxDbGridTableBase : public wxGridTableBase | |
114 | { | |
115 | public: | |
116 | wxDbGridTableBase(wxDbTable *tab, wxDbGridColInfo *ColInfo, | |
117 | int count = wxUSE_QUERY, bool takeOwnership = true); | |
118 | virtual ~wxDbGridTableBase(); | |
119 | ||
120 | virtual int GetNumberRows() | |
121 | { | |
122 | wxLogDebug(_T(" GetNumberRows() = %i"),m_rowtotal); | |
123 | return m_rowtotal; | |
124 | } | |
125 | virtual int GetNumberCols() | |
126 | { | |
127 | wxLogDebug(_T(" GetNumberCols() = %i"),m_nocols); | |
128 | return m_nocols; | |
129 | } | |
130 | virtual bool IsEmptyCell(int row, int col) ; | |
131 | virtual wxString GetValue(int row, int col) ; | |
132 | virtual void SetValue(int row, int col, const wxString& value); | |
133 | virtual bool CanHaveAttributes(); | |
134 | virtual wxString GetTypeName(int row, int col); | |
135 | virtual bool CanGetValueAs(int row, int col, const wxString& typeName); | |
136 | virtual bool CanSetValueAs(int row, int col, const wxString& typeName); | |
137 | virtual long GetValueAsLong(int row, int col); | |
138 | virtual double GetValueAsDouble(int row, int col); | |
139 | virtual bool GetValueAsBool(int row, int col); | |
140 | virtual void SetValueAsLong(int row, int col, long value); | |
141 | virtual void SetValueAsDouble(int row, int col, double value); | |
142 | virtual void SetValueAsBool(int row, int col, bool value); | |
143 | virtual void *GetValueAsCustom(int row, int col, const wxString& typeName); | |
144 | virtual void SetValueAsCustom(int row, int col, const wxString& typeName, void* value); | |
145 | ||
146 | ||
147 | virtual wxString GetColLabelValue(int col); | |
148 | ||
149 | virtual bool AssignDbTable(wxDbTable *tab, int count = wxUSE_QUERY, bool takeOwnership=true); | |
150 | virtual void ValidateRow(int row); | |
151 | virtual bool UpdateRow(int row) const | |
152 | { | |
153 | if (m_row != row) | |
154 | return true; | |
155 | else | |
156 | return Writeback(); | |
157 | } | |
158 | ||
159 | private: | |
160 | //Operates on the current row | |
161 | bool Writeback() const; | |
162 | ||
163 | typedef wxGridTableBase inherited; | |
164 | keyarray m_keys; | |
165 | wxDbTable *m_data; | |
166 | bool m_dbowner; | |
167 | int m_rowtotal; | |
168 | int m_nocols; | |
169 | int m_row; | |
170 | wxDbGridColInfoBase *m_ColInfo; | |
171 | bool m_rowmodified; | |
172 | }; | |
173 | ||
174 | #endif // #if wxUSE_GRID | |
175 | #endif // #if wxUSE_ODBC | |
176 | ||
177 | #endif // _WX_GENERIC_DBGRID_H_ |