1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_forms.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski #include "ComboBox.hxx"
28*b1cdbd2cSJim Jagielski #include "property.hxx"
29*b1cdbd2cSJim Jagielski #include "property.hrc"
30*b1cdbd2cSJim Jagielski #include "services.hxx"
31*b1cdbd2cSJim Jagielski
32*b1cdbd2cSJim Jagielski #include "frm_resource.hxx"
33*b1cdbd2cSJim Jagielski #include "frm_resource.hrc"
34*b1cdbd2cSJim Jagielski #include "BaseListBox.hxx"
35*b1cdbd2cSJim Jagielski
36*b1cdbd2cSJim Jagielski /** === begin UNO includes === **/
37*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/SQLErrorEvent.hpp>
38*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XRowSet.hpp>
39*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/DataType.hpp>
40*b1cdbd2cSJim Jagielski #include <com/sun/star/container/XIndexAccess.hpp>
41*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/XSQLQueryComposerFactory.hpp>
42*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/XQueriesSupplier.hpp>
43*b1cdbd2cSJim Jagielski #include <com/sun/star/util/NumberFormat.hpp>
44*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XConnection.hpp>
45*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/SQLContext.hpp>
46*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/CommandType.hpp>
47*b1cdbd2cSJim Jagielski /** === end UNO includes === **/
48*b1cdbd2cSJim Jagielski
49*b1cdbd2cSJim Jagielski #include <comphelper/numbers.hxx>
50*b1cdbd2cSJim Jagielski #include <comphelper/basicio.hxx>
51*b1cdbd2cSJim Jagielski #include <connectivity/dbtools.hxx>
52*b1cdbd2cSJim Jagielski #include <connectivity/dbconversion.hxx>
53*b1cdbd2cSJim Jagielski #include <cppuhelper/queryinterface.hxx>
54*b1cdbd2cSJim Jagielski #include <rtl/ustrbuf.hxx>
55*b1cdbd2cSJim Jagielski #include <tools/debug.hxx>
56*b1cdbd2cSJim Jagielski #include <tools/diagnose_ex.h>
57*b1cdbd2cSJim Jagielski #include <unotools/sharedunocomponent.hxx>
58*b1cdbd2cSJim Jagielski
59*b1cdbd2cSJim Jagielski #include <limits.h>
60*b1cdbd2cSJim Jagielski
61*b1cdbd2cSJim Jagielski using namespace dbtools;
62*b1cdbd2cSJim Jagielski
63*b1cdbd2cSJim Jagielski //.........................................................................
64*b1cdbd2cSJim Jagielski namespace frm
65*b1cdbd2cSJim Jagielski {
66*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
67*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdb;
68*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
69*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbcx;
70*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans;
71*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container;
72*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::form;
73*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::awt;
74*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::io;
75*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
76*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::util;
77*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::form::binding;
78*b1cdbd2cSJim Jagielski
79*b1cdbd2cSJim Jagielski //========================================================================
80*b1cdbd2cSJim Jagielski // class OComboBoxModel
81*b1cdbd2cSJim Jagielski //========================================================================
82*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
OComboBoxModel_CreateInstance(const Reference<XMultiServiceFactory> & _rxFactory)83*b1cdbd2cSJim Jagielski InterfaceRef SAL_CALL OComboBoxModel_CreateInstance(const Reference<XMultiServiceFactory>& _rxFactory) throw (RuntimeException)
84*b1cdbd2cSJim Jagielski {
85*b1cdbd2cSJim Jagielski return (*new OComboBoxModel(_rxFactory));
86*b1cdbd2cSJim Jagielski }
87*b1cdbd2cSJim Jagielski
88*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
_getTypes()89*b1cdbd2cSJim Jagielski Sequence<Type> OComboBoxModel::_getTypes()
90*b1cdbd2cSJim Jagielski {
91*b1cdbd2cSJim Jagielski return ::comphelper::concatSequences(
92*b1cdbd2cSJim Jagielski OBoundControlModel::_getTypes(),
93*b1cdbd2cSJim Jagielski OEntryListHelper::getTypes(),
94*b1cdbd2cSJim Jagielski OErrorBroadcaster::getTypes()
95*b1cdbd2cSJim Jagielski );
96*b1cdbd2cSJim Jagielski }
97*b1cdbd2cSJim Jagielski
98*b1cdbd2cSJim Jagielski // XServiceInfo
99*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
getSupportedServiceNames()100*b1cdbd2cSJim Jagielski StringSequence SAL_CALL OComboBoxModel::getSupportedServiceNames() throw(RuntimeException)
101*b1cdbd2cSJim Jagielski {
102*b1cdbd2cSJim Jagielski StringSequence aSupported = OBoundControlModel::getSupportedServiceNames();
103*b1cdbd2cSJim Jagielski
104*b1cdbd2cSJim Jagielski sal_Int32 nOldLen = aSupported.getLength();
105*b1cdbd2cSJim Jagielski aSupported.realloc( nOldLen + 8 );
106*b1cdbd2cSJim Jagielski ::rtl::OUString* pStoreTo = aSupported.getArray() + nOldLen;
107*b1cdbd2cSJim Jagielski
108*b1cdbd2cSJim Jagielski *pStoreTo++ = BINDABLE_CONTROL_MODEL;
109*b1cdbd2cSJim Jagielski *pStoreTo++ = DATA_AWARE_CONTROL_MODEL;
110*b1cdbd2cSJim Jagielski *pStoreTo++ = VALIDATABLE_CONTROL_MODEL;
111*b1cdbd2cSJim Jagielski
112*b1cdbd2cSJim Jagielski *pStoreTo++ = BINDABLE_DATA_AWARE_CONTROL_MODEL;
113*b1cdbd2cSJim Jagielski *pStoreTo++ = VALIDATABLE_BINDABLE_CONTROL_MODEL;
114*b1cdbd2cSJim Jagielski
115*b1cdbd2cSJim Jagielski *pStoreTo++ = FRM_SUN_COMPONENT_COMBOBOX;
116*b1cdbd2cSJim Jagielski *pStoreTo++ = FRM_SUN_COMPONENT_DATABASE_COMBOBOX;
117*b1cdbd2cSJim Jagielski *pStoreTo++ = BINDABLE_DATABASE_COMBO_BOX;
118*b1cdbd2cSJim Jagielski
119*b1cdbd2cSJim Jagielski return aSupported;
120*b1cdbd2cSJim Jagielski }
121*b1cdbd2cSJim Jagielski
122*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
queryAggregation(const Type & _rType)123*b1cdbd2cSJim Jagielski Any SAL_CALL OComboBoxModel::queryAggregation(const Type& _rType) throw (RuntimeException)
124*b1cdbd2cSJim Jagielski {
125*b1cdbd2cSJim Jagielski Any aReturn = OBoundControlModel::queryAggregation( _rType );
126*b1cdbd2cSJim Jagielski if ( !aReturn.hasValue() )
127*b1cdbd2cSJim Jagielski aReturn = OEntryListHelper::queryInterface( _rType );
128*b1cdbd2cSJim Jagielski if ( !aReturn.hasValue() )
129*b1cdbd2cSJim Jagielski aReturn = OErrorBroadcaster::queryInterface( _rType );
130*b1cdbd2cSJim Jagielski return aReturn;
131*b1cdbd2cSJim Jagielski }
132*b1cdbd2cSJim Jagielski
133*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
DBG_NAME(OComboBoxModel)134*b1cdbd2cSJim Jagielski DBG_NAME( OComboBoxModel )
135*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
136*b1cdbd2cSJim Jagielski OComboBoxModel::OComboBoxModel(const Reference<XMultiServiceFactory>& _rxFactory)
137*b1cdbd2cSJim Jagielski :OBoundControlModel( _rxFactory, VCL_CONTROLMODEL_COMBOBOX, FRM_SUN_CONTROL_COMBOBOX, sal_True, sal_True, sal_True )
138*b1cdbd2cSJim Jagielski // use the old control name for compytibility reasons
139*b1cdbd2cSJim Jagielski ,OEntryListHelper( (OControlModel&)*this )
140*b1cdbd2cSJim Jagielski ,OErrorBroadcaster( OComponentHelper::rBHelper )
141*b1cdbd2cSJim Jagielski ,m_aListRowSet( getContext() )
142*b1cdbd2cSJim Jagielski ,m_eListSourceType(ListSourceType_TABLE)
143*b1cdbd2cSJim Jagielski ,m_bEmptyIsNull(sal_True)
144*b1cdbd2cSJim Jagielski {
145*b1cdbd2cSJim Jagielski DBG_CTOR( OComboBoxModel, NULL );
146*b1cdbd2cSJim Jagielski
147*b1cdbd2cSJim Jagielski m_nClassId = FormComponentType::COMBOBOX;
148*b1cdbd2cSJim Jagielski initValueProperty( PROPERTY_TEXT, PROPERTY_ID_TEXT );
149*b1cdbd2cSJim Jagielski }
150*b1cdbd2cSJim Jagielski
151*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
OComboBoxModel(const OComboBoxModel * _pOriginal,const Reference<XMultiServiceFactory> & _rxFactory)152*b1cdbd2cSJim Jagielski OComboBoxModel::OComboBoxModel( const OComboBoxModel* _pOriginal, const Reference<XMultiServiceFactory>& _rxFactory )
153*b1cdbd2cSJim Jagielski :OBoundControlModel( _pOriginal, _rxFactory )
154*b1cdbd2cSJim Jagielski ,OEntryListHelper( *_pOriginal, (OControlModel&)*this )
155*b1cdbd2cSJim Jagielski ,OErrorBroadcaster( OComponentHelper::rBHelper )
156*b1cdbd2cSJim Jagielski ,m_aListRowSet( getContext() )
157*b1cdbd2cSJim Jagielski ,m_aListSource( _pOriginal->m_aListSource )
158*b1cdbd2cSJim Jagielski ,m_aDefaultText( _pOriginal->m_aDefaultText )
159*b1cdbd2cSJim Jagielski ,m_eListSourceType( _pOriginal->m_eListSourceType )
160*b1cdbd2cSJim Jagielski ,m_bEmptyIsNull( _pOriginal->m_bEmptyIsNull )
161*b1cdbd2cSJim Jagielski {
162*b1cdbd2cSJim Jagielski DBG_CTOR( OComboBoxModel, NULL );
163*b1cdbd2cSJim Jagielski }
164*b1cdbd2cSJim Jagielski
165*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
~OComboBoxModel()166*b1cdbd2cSJim Jagielski OComboBoxModel::~OComboBoxModel()
167*b1cdbd2cSJim Jagielski {
168*b1cdbd2cSJim Jagielski if (!OComponentHelper::rBHelper.bDisposed)
169*b1cdbd2cSJim Jagielski {
170*b1cdbd2cSJim Jagielski acquire();
171*b1cdbd2cSJim Jagielski dispose();
172*b1cdbd2cSJim Jagielski }
173*b1cdbd2cSJim Jagielski
174*b1cdbd2cSJim Jagielski DBG_DTOR( OComboBoxModel, NULL );
175*b1cdbd2cSJim Jagielski }
176*b1cdbd2cSJim Jagielski
177*b1cdbd2cSJim Jagielski // XCloneable
178*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
IMPLEMENT_DEFAULT_CLONING(OComboBoxModel)179*b1cdbd2cSJim Jagielski IMPLEMENT_DEFAULT_CLONING( OComboBoxModel )
180*b1cdbd2cSJim Jagielski
181*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
182*b1cdbd2cSJim Jagielski void OComboBoxModel::disposing()
183*b1cdbd2cSJim Jagielski {
184*b1cdbd2cSJim Jagielski OBoundControlModel::disposing();
185*b1cdbd2cSJim Jagielski OEntryListHelper::disposing();
186*b1cdbd2cSJim Jagielski OErrorBroadcaster::disposing();
187*b1cdbd2cSJim Jagielski m_xFormatter = NULL;
188*b1cdbd2cSJim Jagielski }
189*b1cdbd2cSJim Jagielski
190*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
getFastPropertyValue(Any & _rValue,sal_Int32 _nHandle) const191*b1cdbd2cSJim Jagielski void OComboBoxModel::getFastPropertyValue(Any& _rValue, sal_Int32 _nHandle) const
192*b1cdbd2cSJim Jagielski {
193*b1cdbd2cSJim Jagielski switch (_nHandle)
194*b1cdbd2cSJim Jagielski {
195*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCETYPE:
196*b1cdbd2cSJim Jagielski _rValue <<= m_eListSourceType;
197*b1cdbd2cSJim Jagielski break;
198*b1cdbd2cSJim Jagielski
199*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCE:
200*b1cdbd2cSJim Jagielski _rValue <<= m_aListSource;
201*b1cdbd2cSJim Jagielski break;
202*b1cdbd2cSJim Jagielski
203*b1cdbd2cSJim Jagielski case PROPERTY_ID_EMPTY_IS_NULL:
204*b1cdbd2cSJim Jagielski _rValue <<= m_bEmptyIsNull;
205*b1cdbd2cSJim Jagielski break;
206*b1cdbd2cSJim Jagielski
207*b1cdbd2cSJim Jagielski case PROPERTY_ID_DEFAULT_TEXT:
208*b1cdbd2cSJim Jagielski _rValue <<= m_aDefaultText;
209*b1cdbd2cSJim Jagielski break;
210*b1cdbd2cSJim Jagielski
211*b1cdbd2cSJim Jagielski case PROPERTY_ID_STRINGITEMLIST:
212*b1cdbd2cSJim Jagielski _rValue <<= getStringItemList();
213*b1cdbd2cSJim Jagielski break;
214*b1cdbd2cSJim Jagielski
215*b1cdbd2cSJim Jagielski default:
216*b1cdbd2cSJim Jagielski OBoundControlModel::getFastPropertyValue(_rValue, _nHandle);
217*b1cdbd2cSJim Jagielski }
218*b1cdbd2cSJim Jagielski }
219*b1cdbd2cSJim Jagielski
220*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
setFastPropertyValue_NoBroadcast(sal_Int32 _nHandle,const Any & _rValue)221*b1cdbd2cSJim Jagielski void OComboBoxModel::setFastPropertyValue_NoBroadcast(sal_Int32 _nHandle, const Any& _rValue)
222*b1cdbd2cSJim Jagielski throw (Exception)
223*b1cdbd2cSJim Jagielski {
224*b1cdbd2cSJim Jagielski switch (_nHandle)
225*b1cdbd2cSJim Jagielski {
226*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCETYPE :
227*b1cdbd2cSJim Jagielski DBG_ASSERT(_rValue.getValueType().equals(::getCppuType(reinterpret_cast<ListSourceType*>(NULL))),
228*b1cdbd2cSJim Jagielski "OComboBoxModel::setFastPropertyValue_NoBroadcast : invalid type !" );
229*b1cdbd2cSJim Jagielski _rValue >>= m_eListSourceType;
230*b1cdbd2cSJim Jagielski break;
231*b1cdbd2cSJim Jagielski
232*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCE :
233*b1cdbd2cSJim Jagielski DBG_ASSERT(_rValue.getValueType().getTypeClass() == TypeClass_STRING,
234*b1cdbd2cSJim Jagielski "OComboBoxModel::setFastPropertyValue_NoBroadcast : invalid type !" );
235*b1cdbd2cSJim Jagielski _rValue >>= m_aListSource;
236*b1cdbd2cSJim Jagielski // die ListSource hat sich geaendert -> neu laden
237*b1cdbd2cSJim Jagielski if (ListSourceType_VALUELIST != m_eListSourceType)
238*b1cdbd2cSJim Jagielski {
239*b1cdbd2cSJim Jagielski if ( m_xCursor.is() && !hasField() && !hasExternalListSource() )
240*b1cdbd2cSJim Jagielski // combo box is already connected to a database, and no external list source
241*b1cdbd2cSJim Jagielski // data source changed -> refresh
242*b1cdbd2cSJim Jagielski loadData( false );
243*b1cdbd2cSJim Jagielski }
244*b1cdbd2cSJim Jagielski break;
245*b1cdbd2cSJim Jagielski
246*b1cdbd2cSJim Jagielski case PROPERTY_ID_EMPTY_IS_NULL :
247*b1cdbd2cSJim Jagielski DBG_ASSERT(_rValue.getValueType().getTypeClass() == TypeClass_BOOLEAN,
248*b1cdbd2cSJim Jagielski "OComboBoxModel::setFastPropertyValue_NoBroadcast : invalid type !" );
249*b1cdbd2cSJim Jagielski _rValue >>= m_bEmptyIsNull;
250*b1cdbd2cSJim Jagielski break;
251*b1cdbd2cSJim Jagielski
252*b1cdbd2cSJim Jagielski case PROPERTY_ID_DEFAULT_TEXT :
253*b1cdbd2cSJim Jagielski DBG_ASSERT(_rValue.getValueType().getTypeClass() == TypeClass_STRING,
254*b1cdbd2cSJim Jagielski "OComboBoxModel::setFastPropertyValue_NoBroadcast : invalid type !" );
255*b1cdbd2cSJim Jagielski _rValue >>= m_aDefaultText;
256*b1cdbd2cSJim Jagielski resetNoBroadcast();
257*b1cdbd2cSJim Jagielski break;
258*b1cdbd2cSJim Jagielski
259*b1cdbd2cSJim Jagielski case PROPERTY_ID_STRINGITEMLIST:
260*b1cdbd2cSJim Jagielski {
261*b1cdbd2cSJim Jagielski ControlModelLock aLock( *this );
262*b1cdbd2cSJim Jagielski setNewStringItemList( _rValue, aLock );
263*b1cdbd2cSJim Jagielski // TODO: this is bogus. setNewStringItemList expects a guard which has the *only*
264*b1cdbd2cSJim Jagielski // lock to the mutex, but setFastPropertyValue_NoBroadcast is already called with
265*b1cdbd2cSJim Jagielski // a lock - so we effectively has two locks here, of which setNewStringItemList can
266*b1cdbd2cSJim Jagielski // only control one.
267*b1cdbd2cSJim Jagielski }
268*b1cdbd2cSJim Jagielski break;
269*b1cdbd2cSJim Jagielski
270*b1cdbd2cSJim Jagielski default:
271*b1cdbd2cSJim Jagielski OBoundControlModel::setFastPropertyValue_NoBroadcast(_nHandle, _rValue);
272*b1cdbd2cSJim Jagielski }
273*b1cdbd2cSJim Jagielski }
274*b1cdbd2cSJim Jagielski
275*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
convertFastPropertyValue(Any & _rConvertedValue,Any & _rOldValue,sal_Int32 _nHandle,const Any & _rValue)276*b1cdbd2cSJim Jagielski sal_Bool OComboBoxModel::convertFastPropertyValue(
277*b1cdbd2cSJim Jagielski Any& _rConvertedValue, Any& _rOldValue, sal_Int32 _nHandle, const Any& _rValue)
278*b1cdbd2cSJim Jagielski throw (IllegalArgumentException)
279*b1cdbd2cSJim Jagielski {
280*b1cdbd2cSJim Jagielski sal_Bool bModified(sal_False);
281*b1cdbd2cSJim Jagielski switch (_nHandle)
282*b1cdbd2cSJim Jagielski {
283*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCETYPE :
284*b1cdbd2cSJim Jagielski bModified = tryPropertyValueEnum(_rConvertedValue, _rOldValue, _rValue, m_eListSourceType);
285*b1cdbd2cSJim Jagielski break;
286*b1cdbd2cSJim Jagielski
287*b1cdbd2cSJim Jagielski case PROPERTY_ID_LISTSOURCE :
288*b1cdbd2cSJim Jagielski bModified = tryPropertyValue(_rConvertedValue, _rOldValue, _rValue, m_aListSource);
289*b1cdbd2cSJim Jagielski break;
290*b1cdbd2cSJim Jagielski
291*b1cdbd2cSJim Jagielski case PROPERTY_ID_EMPTY_IS_NULL :
292*b1cdbd2cSJim Jagielski bModified = tryPropertyValue(_rConvertedValue, _rOldValue, _rValue, m_bEmptyIsNull);
293*b1cdbd2cSJim Jagielski break;
294*b1cdbd2cSJim Jagielski
295*b1cdbd2cSJim Jagielski case PROPERTY_ID_DEFAULT_TEXT :
296*b1cdbd2cSJim Jagielski bModified = tryPropertyValue(_rConvertedValue, _rOldValue, _rValue, m_aDefaultText);
297*b1cdbd2cSJim Jagielski break;
298*b1cdbd2cSJim Jagielski
299*b1cdbd2cSJim Jagielski case PROPERTY_ID_STRINGITEMLIST:
300*b1cdbd2cSJim Jagielski bModified = convertNewListSourceProperty( _rConvertedValue, _rOldValue, _rValue );
301*b1cdbd2cSJim Jagielski break;
302*b1cdbd2cSJim Jagielski
303*b1cdbd2cSJim Jagielski default:
304*b1cdbd2cSJim Jagielski bModified = OBoundControlModel::convertFastPropertyValue(_rConvertedValue, _rOldValue, _nHandle, _rValue);
305*b1cdbd2cSJim Jagielski break;
306*b1cdbd2cSJim Jagielski }
307*b1cdbd2cSJim Jagielski return bModified;
308*b1cdbd2cSJim Jagielski }
309*b1cdbd2cSJim Jagielski
310*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
describeFixedProperties(Sequence<Property> & _rProps) const311*b1cdbd2cSJim Jagielski void OComboBoxModel::describeFixedProperties( Sequence< Property >& _rProps ) const
312*b1cdbd2cSJim Jagielski {
313*b1cdbd2cSJim Jagielski BEGIN_DESCRIBE_PROPERTIES( 6, OBoundControlModel )
314*b1cdbd2cSJim Jagielski DECL_PROP1(TABINDEX, sal_Int16, BOUND);
315*b1cdbd2cSJim Jagielski DECL_PROP1(LISTSOURCETYPE, ListSourceType, BOUND);
316*b1cdbd2cSJim Jagielski DECL_PROP1(LISTSOURCE, ::rtl::OUString, BOUND);
317*b1cdbd2cSJim Jagielski DECL_BOOL_PROP1(EMPTY_IS_NULL, BOUND);
318*b1cdbd2cSJim Jagielski DECL_PROP1(DEFAULT_TEXT, ::rtl::OUString, BOUND);
319*b1cdbd2cSJim Jagielski DECL_PROP1(STRINGITEMLIST, Sequence< ::rtl::OUString >,BOUND);
320*b1cdbd2cSJim Jagielski END_DESCRIBE_PROPERTIES();
321*b1cdbd2cSJim Jagielski }
322*b1cdbd2cSJim Jagielski
323*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
describeAggregateProperties(Sequence<Property> & _rAggregateProps) const324*b1cdbd2cSJim Jagielski void OComboBoxModel::describeAggregateProperties( Sequence< Property >& _rAggregateProps ) const
325*b1cdbd2cSJim Jagielski {
326*b1cdbd2cSJim Jagielski OBoundControlModel::describeAggregateProperties( _rAggregateProps );
327*b1cdbd2cSJim Jagielski
328*b1cdbd2cSJim Jagielski // superseded properties:
329*b1cdbd2cSJim Jagielski RemoveProperty( _rAggregateProps, PROPERTY_STRINGITEMLIST );
330*b1cdbd2cSJim Jagielski }
331*b1cdbd2cSJim Jagielski
332*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
getServiceName()333*b1cdbd2cSJim Jagielski ::rtl::OUString SAL_CALL OComboBoxModel::getServiceName() throw(RuntimeException)
334*b1cdbd2cSJim Jagielski {
335*b1cdbd2cSJim Jagielski return FRM_COMPONENT_COMBOBOX; // old (non-sun) name for compatibility !
336*b1cdbd2cSJim Jagielski }
337*b1cdbd2cSJim Jagielski
338*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
write(const Reference<stario::XObjectOutputStream> & _rxOutStream)339*b1cdbd2cSJim Jagielski void SAL_CALL OComboBoxModel::write(const Reference<stario::XObjectOutputStream>& _rxOutStream)
340*b1cdbd2cSJim Jagielski throw(stario::IOException, RuntimeException)
341*b1cdbd2cSJim Jagielski {
342*b1cdbd2cSJim Jagielski OBoundControlModel::write(_rxOutStream);
343*b1cdbd2cSJim Jagielski
344*b1cdbd2cSJim Jagielski // Version
345*b1cdbd2cSJim Jagielski // Version 0x0002: EmptyIsNull
346*b1cdbd2cSJim Jagielski // Version 0x0003: ListSource->Seq
347*b1cdbd2cSJim Jagielski // Version 0x0004: DefaultText
348*b1cdbd2cSJim Jagielski // Version 0x0005: HelpText
349*b1cdbd2cSJim Jagielski _rxOutStream->writeShort(0x0006);
350*b1cdbd2cSJim Jagielski
351*b1cdbd2cSJim Jagielski // Maskierung fuer any
352*b1cdbd2cSJim Jagielski sal_uInt16 nAnyMask = 0;
353*b1cdbd2cSJim Jagielski if (m_aBoundColumn.getValueType().getTypeClass() == TypeClass_SHORT)
354*b1cdbd2cSJim Jagielski nAnyMask |= BOUNDCOLUMN;
355*b1cdbd2cSJim Jagielski _rxOutStream << nAnyMask;
356*b1cdbd2cSJim Jagielski
357*b1cdbd2cSJim Jagielski StringSequence aListSourceSeq(&m_aListSource, 1);
358*b1cdbd2cSJim Jagielski _rxOutStream << aListSourceSeq;
359*b1cdbd2cSJim Jagielski _rxOutStream << (sal_Int16)m_eListSourceType;
360*b1cdbd2cSJim Jagielski
361*b1cdbd2cSJim Jagielski if ((nAnyMask & BOUNDCOLUMN) == BOUNDCOLUMN)
362*b1cdbd2cSJim Jagielski {
363*b1cdbd2cSJim Jagielski sal_Int16 nBoundColumn = 0;
364*b1cdbd2cSJim Jagielski m_aBoundColumn >>= nBoundColumn;
365*b1cdbd2cSJim Jagielski _rxOutStream << nBoundColumn;
366*b1cdbd2cSJim Jagielski }
367*b1cdbd2cSJim Jagielski
368*b1cdbd2cSJim Jagielski _rxOutStream << (sal_Bool)m_bEmptyIsNull;
369*b1cdbd2cSJim Jagielski _rxOutStream << m_aDefaultText;
370*b1cdbd2cSJim Jagielski writeHelpTextCompatibly(_rxOutStream);
371*b1cdbd2cSJim Jagielski
372*b1cdbd2cSJim Jagielski // from version 0x0006 : common properties
373*b1cdbd2cSJim Jagielski writeCommonProperties(_rxOutStream);
374*b1cdbd2cSJim Jagielski }
375*b1cdbd2cSJim Jagielski
376*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
read(const Reference<stario::XObjectInputStream> & _rxInStream)377*b1cdbd2cSJim Jagielski void SAL_CALL OComboBoxModel::read(const Reference<stario::XObjectInputStream>& _rxInStream) throw(stario::IOException, RuntimeException)
378*b1cdbd2cSJim Jagielski {
379*b1cdbd2cSJim Jagielski OBoundControlModel::read(_rxInStream);
380*b1cdbd2cSJim Jagielski ControlModelLock aLock( *this );
381*b1cdbd2cSJim Jagielski
382*b1cdbd2cSJim Jagielski // since we are "overwriting" the StringItemList of our aggregate (means we have
383*b1cdbd2cSJim Jagielski // an own place to store the value, instead of relying on our aggregate storing it),
384*b1cdbd2cSJim Jagielski // we need to respect what the aggregate just read for the StringItemList property.
385*b1cdbd2cSJim Jagielski try
386*b1cdbd2cSJim Jagielski {
387*b1cdbd2cSJim Jagielski if ( m_xAggregateSet.is() )
388*b1cdbd2cSJim Jagielski setNewStringItemList( m_xAggregateSet->getPropertyValue( PROPERTY_STRINGITEMLIST ), aLock );
389*b1cdbd2cSJim Jagielski }
390*b1cdbd2cSJim Jagielski catch( const Exception& )
391*b1cdbd2cSJim Jagielski {
392*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "OComboBoxModel::read: caught an exception while examining the aggregate's string item list!" );
393*b1cdbd2cSJim Jagielski }
394*b1cdbd2cSJim Jagielski
395*b1cdbd2cSJim Jagielski // Version
396*b1cdbd2cSJim Jagielski sal_uInt16 nVersion = _rxInStream->readShort();
397*b1cdbd2cSJim Jagielski DBG_ASSERT(nVersion > 0, "OComboBoxModel::read : version 0 ? this should never have been written !");
398*b1cdbd2cSJim Jagielski
399*b1cdbd2cSJim Jagielski if (nVersion > 0x0006)
400*b1cdbd2cSJim Jagielski {
401*b1cdbd2cSJim Jagielski DBG_ERROR("OComboBoxModel::read : invalid (means unknown) version !");
402*b1cdbd2cSJim Jagielski m_aListSource = ::rtl::OUString();
403*b1cdbd2cSJim Jagielski m_aBoundColumn <<= (sal_Int16)0;
404*b1cdbd2cSJim Jagielski m_aDefaultText = ::rtl::OUString();
405*b1cdbd2cSJim Jagielski m_eListSourceType = ListSourceType_TABLE;
406*b1cdbd2cSJim Jagielski m_bEmptyIsNull = sal_True;
407*b1cdbd2cSJim Jagielski defaultCommonProperties();
408*b1cdbd2cSJim Jagielski return;
409*b1cdbd2cSJim Jagielski }
410*b1cdbd2cSJim Jagielski
411*b1cdbd2cSJim Jagielski // Maskierung fuer any
412*b1cdbd2cSJim Jagielski sal_uInt16 nAnyMask;
413*b1cdbd2cSJim Jagielski _rxInStream >> nAnyMask;
414*b1cdbd2cSJim Jagielski
415*b1cdbd2cSJim Jagielski // ListSource
416*b1cdbd2cSJim Jagielski if (nVersion < 0x0003)
417*b1cdbd2cSJim Jagielski {
418*b1cdbd2cSJim Jagielski ::rtl::OUString sListSource;
419*b1cdbd2cSJim Jagielski _rxInStream >> m_aListSource;
420*b1cdbd2cSJim Jagielski }
421*b1cdbd2cSJim Jagielski else // nVersion == 4
422*b1cdbd2cSJim Jagielski {
423*b1cdbd2cSJim Jagielski m_aListSource = ::rtl::OUString();
424*b1cdbd2cSJim Jagielski StringSequence aListSource;
425*b1cdbd2cSJim Jagielski _rxInStream >> aListSource;
426*b1cdbd2cSJim Jagielski const ::rtl::OUString* pToken = aListSource.getConstArray();
427*b1cdbd2cSJim Jagielski sal_Int32 nLen = aListSource.getLength();
428*b1cdbd2cSJim Jagielski for (sal_Int32 i = 0; i < nLen; ++i, ++pToken)
429*b1cdbd2cSJim Jagielski m_aListSource += *pToken;
430*b1cdbd2cSJim Jagielski }
431*b1cdbd2cSJim Jagielski
432*b1cdbd2cSJim Jagielski sal_Int16 nListSourceType;
433*b1cdbd2cSJim Jagielski _rxInStream >> nListSourceType;
434*b1cdbd2cSJim Jagielski m_eListSourceType = (ListSourceType)nListSourceType;
435*b1cdbd2cSJim Jagielski
436*b1cdbd2cSJim Jagielski if ((nAnyMask & BOUNDCOLUMN) == BOUNDCOLUMN)
437*b1cdbd2cSJim Jagielski {
438*b1cdbd2cSJim Jagielski sal_Int16 nValue;
439*b1cdbd2cSJim Jagielski _rxInStream >> nValue;
440*b1cdbd2cSJim Jagielski m_aBoundColumn <<= nValue;
441*b1cdbd2cSJim Jagielski }
442*b1cdbd2cSJim Jagielski
443*b1cdbd2cSJim Jagielski if (nVersion > 0x0001)
444*b1cdbd2cSJim Jagielski {
445*b1cdbd2cSJim Jagielski sal_Bool bNull;
446*b1cdbd2cSJim Jagielski _rxInStream >> bNull;
447*b1cdbd2cSJim Jagielski m_bEmptyIsNull = bNull;
448*b1cdbd2cSJim Jagielski }
449*b1cdbd2cSJim Jagielski
450*b1cdbd2cSJim Jagielski if (nVersion > 0x0003) // nVersion == 4
451*b1cdbd2cSJim Jagielski _rxInStream >> m_aDefaultText;
452*b1cdbd2cSJim Jagielski
453*b1cdbd2cSJim Jagielski // Stringliste muss geleert werden, wenn eine Listenquelle gesetzt ist
454*b1cdbd2cSJim Jagielski // dieses kann der Fall sein wenn im alive modus gespeichert wird
455*b1cdbd2cSJim Jagielski if ( m_aListSource.getLength()
456*b1cdbd2cSJim Jagielski && !hasExternalListSource()
457*b1cdbd2cSJim Jagielski )
458*b1cdbd2cSJim Jagielski {
459*b1cdbd2cSJim Jagielski setFastPropertyValue( PROPERTY_ID_STRINGITEMLIST, makeAny( StringSequence() ) );
460*b1cdbd2cSJim Jagielski }
461*b1cdbd2cSJim Jagielski
462*b1cdbd2cSJim Jagielski if (nVersion > 0x0004)
463*b1cdbd2cSJim Jagielski readHelpTextCompatibly(_rxInStream);
464*b1cdbd2cSJim Jagielski
465*b1cdbd2cSJim Jagielski if (nVersion > 0x0005)
466*b1cdbd2cSJim Jagielski readCommonProperties(_rxInStream);
467*b1cdbd2cSJim Jagielski
468*b1cdbd2cSJim Jagielski // Nach dem Lesen die Defaultwerte anzeigen
469*b1cdbd2cSJim Jagielski if ( getControlSource().getLength() )
470*b1cdbd2cSJim Jagielski {
471*b1cdbd2cSJim Jagielski // (not if we don't have a control source - the "State" property acts like it is persistent, then
472*b1cdbd2cSJim Jagielski resetNoBroadcast();
473*b1cdbd2cSJim Jagielski }
474*b1cdbd2cSJim Jagielski }
475*b1cdbd2cSJim Jagielski
476*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
loadData(bool _bForce)477*b1cdbd2cSJim Jagielski void OComboBoxModel::loadData( bool _bForce )
478*b1cdbd2cSJim Jagielski {
479*b1cdbd2cSJim Jagielski DBG_ASSERT(m_eListSourceType != ListSourceType_VALUELIST, "OComboBoxModel::loadData : do not call for a value list !");
480*b1cdbd2cSJim Jagielski DBG_ASSERT( !hasExternalListSource(), "OComboBoxModel::loadData: cannot load from DB when I have an external list source!" );
481*b1cdbd2cSJim Jagielski
482*b1cdbd2cSJim Jagielski if ( hasExternalListSource() )
483*b1cdbd2cSJim Jagielski return;
484*b1cdbd2cSJim Jagielski
485*b1cdbd2cSJim Jagielski // Connection holen
486*b1cdbd2cSJim Jagielski Reference<XRowSet> xForm(m_xCursor, UNO_QUERY);
487*b1cdbd2cSJim Jagielski if (!xForm.is())
488*b1cdbd2cSJim Jagielski return;
489*b1cdbd2cSJim Jagielski Reference<XConnection> xConnection = getConnection(xForm);
490*b1cdbd2cSJim Jagielski if (!xConnection.is())
491*b1cdbd2cSJim Jagielski return;
492*b1cdbd2cSJim Jagielski
493*b1cdbd2cSJim Jagielski Reference<XServiceInfo> xServiceInfo(xConnection, UNO_QUERY);
494*b1cdbd2cSJim Jagielski if (!xServiceInfo.is() || !xServiceInfo->supportsService(SRV_SDB_CONNECTION))
495*b1cdbd2cSJim Jagielski {
496*b1cdbd2cSJim Jagielski DBG_ERROR("OComboBoxModel::loadData : invalid connection !");
497*b1cdbd2cSJim Jagielski return;
498*b1cdbd2cSJim Jagielski }
499*b1cdbd2cSJim Jagielski
500*b1cdbd2cSJim Jagielski if (!m_aListSource.getLength() || m_eListSourceType == ListSourceType_VALUELIST)
501*b1cdbd2cSJim Jagielski return;
502*b1cdbd2cSJim Jagielski
503*b1cdbd2cSJim Jagielski ::utl::SharedUNOComponent< XResultSet > xListCursor;
504*b1cdbd2cSJim Jagielski try
505*b1cdbd2cSJim Jagielski {
506*b1cdbd2cSJim Jagielski m_aListRowSet.setConnection( xConnection );
507*b1cdbd2cSJim Jagielski
508*b1cdbd2cSJim Jagielski bool bExecuteRowSet( false );
509*b1cdbd2cSJim Jagielski switch (m_eListSourceType)
510*b1cdbd2cSJim Jagielski {
511*b1cdbd2cSJim Jagielski case ListSourceType_TABLEFIELDS:
512*b1cdbd2cSJim Jagielski // don't work with a statement here, the fields will be collected below
513*b1cdbd2cSJim Jagielski break;
514*b1cdbd2cSJim Jagielski case ListSourceType_TABLE:
515*b1cdbd2cSJim Jagielski {
516*b1cdbd2cSJim Jagielski // does the bound field belong to the table ?
517*b1cdbd2cSJim Jagielski // if we use an alias for the bound field, we won't find it
518*b1cdbd2cSJim Jagielski // in that case we use the first field of the table
519*b1cdbd2cSJim Jagielski
520*b1cdbd2cSJim Jagielski Reference<XNameAccess> xFieldsByName = getTableFields(xConnection, m_aListSource);
521*b1cdbd2cSJim Jagielski Reference<XIndexAccess> xFieldsByIndex(xFieldsByName, UNO_QUERY);
522*b1cdbd2cSJim Jagielski
523*b1cdbd2cSJim Jagielski ::rtl::OUString aFieldName;
524*b1cdbd2cSJim Jagielski if ( xFieldsByName.is() && xFieldsByName->hasByName( getControlSource() ) )
525*b1cdbd2cSJim Jagielski {
526*b1cdbd2cSJim Jagielski aFieldName = getControlSource();
527*b1cdbd2cSJim Jagielski }
528*b1cdbd2cSJim Jagielski else
529*b1cdbd2cSJim Jagielski {
530*b1cdbd2cSJim Jagielski // otherwise look for the alias
531*b1cdbd2cSJim Jagielski Reference<XPropertySet> xFormProp(xForm,UNO_QUERY);
532*b1cdbd2cSJim Jagielski Reference< XColumnsSupplier > xSupplyFields;
533*b1cdbd2cSJim Jagielski xFormProp->getPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("SingleSelectQueryComposer"))) >>= xSupplyFields;
534*b1cdbd2cSJim Jagielski
535*b1cdbd2cSJim Jagielski // search the field
536*b1cdbd2cSJim Jagielski DBG_ASSERT(xSupplyFields.is(), "OComboBoxModel::loadData : invalid query composer !");
537*b1cdbd2cSJim Jagielski
538*b1cdbd2cSJim Jagielski Reference< XNameAccess > xFieldNames = xSupplyFields->getColumns();
539*b1cdbd2cSJim Jagielski if ( xFieldNames->hasByName( getControlSource() ) )
540*b1cdbd2cSJim Jagielski {
541*b1cdbd2cSJim Jagielski Reference< XPropertySet > xComposerFieldAsSet;
542*b1cdbd2cSJim Jagielski xFieldNames->getByName( getControlSource() ) >>= xComposerFieldAsSet;
543*b1cdbd2cSJim Jagielski if (hasProperty(PROPERTY_FIELDSOURCE, xComposerFieldAsSet))
544*b1cdbd2cSJim Jagielski xComposerFieldAsSet->getPropertyValue(PROPERTY_FIELDSOURCE) >>= aFieldName;
545*b1cdbd2cSJim Jagielski }
546*b1cdbd2cSJim Jagielski }
547*b1cdbd2cSJim Jagielski
548*b1cdbd2cSJim Jagielski if (!aFieldName.getLength())
549*b1cdbd2cSJim Jagielski break;
550*b1cdbd2cSJim Jagielski
551*b1cdbd2cSJim Jagielski Reference<XDatabaseMetaData> xMeta = xConnection->getMetaData();
552*b1cdbd2cSJim Jagielski OSL_ENSURE(xMeta.is(),"No database meta data!");
553*b1cdbd2cSJim Jagielski if ( xMeta.is() )
554*b1cdbd2cSJim Jagielski {
555*b1cdbd2cSJim Jagielski ::rtl::OUString aQuote = xMeta->getIdentifierQuoteString();
556*b1cdbd2cSJim Jagielski
557*b1cdbd2cSJim Jagielski ::rtl::OUString sCatalog, sSchema, sTable;
558*b1cdbd2cSJim Jagielski qualifiedNameComponents( xMeta, m_aListSource, sCatalog, sSchema, sTable, eInDataManipulation );
559*b1cdbd2cSJim Jagielski
560*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer aStatement;
561*b1cdbd2cSJim Jagielski aStatement.appendAscii( "SELECT DISTINCT " );
562*b1cdbd2cSJim Jagielski aStatement.append ( quoteName( aQuote, aFieldName ) );
563*b1cdbd2cSJim Jagielski aStatement.appendAscii( " FROM " );
564*b1cdbd2cSJim Jagielski aStatement.append ( composeTableNameForSelect( xConnection, sCatalog, sSchema, sTable ) );
565*b1cdbd2cSJim Jagielski
566*b1cdbd2cSJim Jagielski m_aListRowSet.setEscapeProcessing( sal_False );
567*b1cdbd2cSJim Jagielski m_aListRowSet.setCommand( aStatement.makeStringAndClear() );
568*b1cdbd2cSJim Jagielski bExecuteRowSet = true;
569*b1cdbd2cSJim Jagielski }
570*b1cdbd2cSJim Jagielski } break;
571*b1cdbd2cSJim Jagielski case ListSourceType_QUERY:
572*b1cdbd2cSJim Jagielski {
573*b1cdbd2cSJim Jagielski m_aListRowSet.setCommandFromQuery( m_aListSource );
574*b1cdbd2cSJim Jagielski bExecuteRowSet = true;
575*b1cdbd2cSJim Jagielski }
576*b1cdbd2cSJim Jagielski break;
577*b1cdbd2cSJim Jagielski
578*b1cdbd2cSJim Jagielski default:
579*b1cdbd2cSJim Jagielski {
580*b1cdbd2cSJim Jagielski m_aListRowSet.setEscapeProcessing( ListSourceType_SQLPASSTHROUGH != m_eListSourceType );
581*b1cdbd2cSJim Jagielski m_aListRowSet.setCommand( m_aListSource );
582*b1cdbd2cSJim Jagielski bExecuteRowSet = true;
583*b1cdbd2cSJim Jagielski }
584*b1cdbd2cSJim Jagielski }
585*b1cdbd2cSJim Jagielski
586*b1cdbd2cSJim Jagielski if ( bExecuteRowSet )
587*b1cdbd2cSJim Jagielski {
588*b1cdbd2cSJim Jagielski if ( !_bForce && !m_aListRowSet.isDirty() )
589*b1cdbd2cSJim Jagielski {
590*b1cdbd2cSJim Jagielski // if none of the settings of the row set changed, compared to the last
591*b1cdbd2cSJim Jagielski // invocation of loadData, then don't re-fill the list. Instead, assume
592*b1cdbd2cSJim Jagielski // the list entries are the same.
593*b1cdbd2cSJim Jagielski return;
594*b1cdbd2cSJim Jagielski }
595*b1cdbd2cSJim Jagielski xListCursor.reset( m_aListRowSet.execute() );
596*b1cdbd2cSJim Jagielski }
597*b1cdbd2cSJim Jagielski }
598*b1cdbd2cSJim Jagielski catch(SQLException& eSQL)
599*b1cdbd2cSJim Jagielski {
600*b1cdbd2cSJim Jagielski onError(eSQL, FRM_RES_STRING(RID_BASELISTBOX_ERROR_FILLLIST));
601*b1cdbd2cSJim Jagielski return;
602*b1cdbd2cSJim Jagielski }
603*b1cdbd2cSJim Jagielski catch( const Exception& )
604*b1cdbd2cSJim Jagielski {
605*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
606*b1cdbd2cSJim Jagielski return;
607*b1cdbd2cSJim Jagielski }
608*b1cdbd2cSJim Jagielski
609*b1cdbd2cSJim Jagielski ::std::vector< ::rtl::OUString > aStringList;
610*b1cdbd2cSJim Jagielski aStringList.reserve(16);
611*b1cdbd2cSJim Jagielski try
612*b1cdbd2cSJim Jagielski {
613*b1cdbd2cSJim Jagielski OSL_ENSURE( xListCursor.is() || ( ListSourceType_TABLEFIELDS == m_eListSourceType ),
614*b1cdbd2cSJim Jagielski "OComboBoxModel::loadData: logic error!" );
615*b1cdbd2cSJim Jagielski if ( !xListCursor.is() && ( ListSourceType_TABLEFIELDS != m_eListSourceType ) )
616*b1cdbd2cSJim Jagielski return;
617*b1cdbd2cSJim Jagielski
618*b1cdbd2cSJim Jagielski switch (m_eListSourceType)
619*b1cdbd2cSJim Jagielski {
620*b1cdbd2cSJim Jagielski case ListSourceType_SQL:
621*b1cdbd2cSJim Jagielski case ListSourceType_SQLPASSTHROUGH:
622*b1cdbd2cSJim Jagielski case ListSourceType_TABLE:
623*b1cdbd2cSJim Jagielski case ListSourceType_QUERY:
624*b1cdbd2cSJim Jagielski {
625*b1cdbd2cSJim Jagielski // die XDatabaseVAriant der ersten Spalte
626*b1cdbd2cSJim Jagielski Reference<XColumnsSupplier> xSupplyCols(xListCursor, UNO_QUERY);
627*b1cdbd2cSJim Jagielski DBG_ASSERT(xSupplyCols.is(), "OComboBoxModel::loadData : cursor supports the row set service but is no column supplier?!");
628*b1cdbd2cSJim Jagielski Reference<XIndexAccess> xColumns;
629*b1cdbd2cSJim Jagielski if (xSupplyCols.is())
630*b1cdbd2cSJim Jagielski {
631*b1cdbd2cSJim Jagielski xColumns = Reference<XIndexAccess>(xSupplyCols->getColumns(), UNO_QUERY);
632*b1cdbd2cSJim Jagielski DBG_ASSERT(xColumns.is(), "OComboBoxModel::loadData : no columns supplied by the row set !");
633*b1cdbd2cSJim Jagielski }
634*b1cdbd2cSJim Jagielski Reference< XPropertySet > xDataField;
635*b1cdbd2cSJim Jagielski if ( xColumns.is() )
636*b1cdbd2cSJim Jagielski xColumns->getByIndex(0) >>= xDataField;
637*b1cdbd2cSJim Jagielski if ( !xDataField.is() )
638*b1cdbd2cSJim Jagielski return;
639*b1cdbd2cSJim Jagielski
640*b1cdbd2cSJim Jagielski ::dbtools::FormattedColumnValue aValueFormatter( getContext(), xForm, xDataField );
641*b1cdbd2cSJim Jagielski
642*b1cdbd2cSJim Jagielski // Listen fuellen
643*b1cdbd2cSJim Jagielski sal_Int16 i = 0;
644*b1cdbd2cSJim Jagielski // per definitionem the list cursor is positioned _before_ the first row at the moment
645*b1cdbd2cSJim Jagielski while (xListCursor->next() && (i++<SHRT_MAX)) // max anzahl eintraege
646*b1cdbd2cSJim Jagielski {
647*b1cdbd2cSJim Jagielski aStringList.push_back( aValueFormatter.getFormattedValue() );
648*b1cdbd2cSJim Jagielski }
649*b1cdbd2cSJim Jagielski }
650*b1cdbd2cSJim Jagielski break;
651*b1cdbd2cSJim Jagielski case ListSourceType_TABLEFIELDS:
652*b1cdbd2cSJim Jagielski {
653*b1cdbd2cSJim Jagielski Reference<XNameAccess> xFieldNames = getTableFields(xConnection, m_aListSource);
654*b1cdbd2cSJim Jagielski if (xFieldNames.is())
655*b1cdbd2cSJim Jagielski {
656*b1cdbd2cSJim Jagielski StringSequence seqNames = xFieldNames->getElementNames();
657*b1cdbd2cSJim Jagielski sal_Int32 nFieldsCount = seqNames.getLength();
658*b1cdbd2cSJim Jagielski const ::rtl::OUString* pustrNames = seqNames.getConstArray();
659*b1cdbd2cSJim Jagielski
660*b1cdbd2cSJim Jagielski for (sal_Int32 k=0; k<nFieldsCount; ++k)
661*b1cdbd2cSJim Jagielski aStringList.push_back(pustrNames[k]);
662*b1cdbd2cSJim Jagielski }
663*b1cdbd2cSJim Jagielski }
664*b1cdbd2cSJim Jagielski break;
665*b1cdbd2cSJim Jagielski default:
666*b1cdbd2cSJim Jagielski OSL_ENSURE( false, "OComboBoxModel::loadData: unreachable!" );
667*b1cdbd2cSJim Jagielski break;
668*b1cdbd2cSJim Jagielski }
669*b1cdbd2cSJim Jagielski }
670*b1cdbd2cSJim Jagielski catch(SQLException& eSQL)
671*b1cdbd2cSJim Jagielski {
672*b1cdbd2cSJim Jagielski onError(eSQL, FRM_RES_STRING(RID_BASELISTBOX_ERROR_FILLLIST));
673*b1cdbd2cSJim Jagielski return;
674*b1cdbd2cSJim Jagielski }
675*b1cdbd2cSJim Jagielski catch( const Exception& )
676*b1cdbd2cSJim Jagielski {
677*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
678*b1cdbd2cSJim Jagielski return;
679*b1cdbd2cSJim Jagielski }
680*b1cdbd2cSJim Jagielski
681*b1cdbd2cSJim Jagielski // String-Sequence fuer ListBox erzeugen
682*b1cdbd2cSJim Jagielski StringSequence aStringSeq(aStringList.size());
683*b1cdbd2cSJim Jagielski ::rtl::OUString* pStringAry = aStringSeq.getArray();
684*b1cdbd2cSJim Jagielski for (sal_Int32 i = 0; i<aStringSeq.getLength(); ++i)
685*b1cdbd2cSJim Jagielski pStringAry[i] = aStringList[i];
686*b1cdbd2cSJim Jagielski
687*b1cdbd2cSJim Jagielski // String-Sequence an ListBox setzen
688*b1cdbd2cSJim Jagielski setFastPropertyValue( PROPERTY_ID_STRINGITEMLIST, makeAny( aStringSeq ) );
689*b1cdbd2cSJim Jagielski }
690*b1cdbd2cSJim Jagielski
691*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
onConnectedDbColumn(const Reference<XInterface> & _rxForm)692*b1cdbd2cSJim Jagielski void OComboBoxModel::onConnectedDbColumn( const Reference< XInterface >& _rxForm )
693*b1cdbd2cSJim Jagielski {
694*b1cdbd2cSJim Jagielski Reference<XPropertySet> xField = getField();
695*b1cdbd2cSJim Jagielski if ( xField.is() )
696*b1cdbd2cSJim Jagielski m_pValueFormatter.reset( new ::dbtools::FormattedColumnValue( getContext(), Reference< XRowSet >( _rxForm, UNO_QUERY ), xField ) );
697*b1cdbd2cSJim Jagielski getPropertyValue( PROPERTY_STRINGITEMLIST ) >>= m_aDesignModeStringItems;
698*b1cdbd2cSJim Jagielski
699*b1cdbd2cSJim Jagielski // Daten nur laden, wenn eine Listenquelle angegeben wurde
700*b1cdbd2cSJim Jagielski if ( m_aListSource.getLength() && m_xCursor.is() && !hasExternalListSource() )
701*b1cdbd2cSJim Jagielski loadData( false );
702*b1cdbd2cSJim Jagielski }
703*b1cdbd2cSJim Jagielski
704*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
onDisconnectedDbColumn()705*b1cdbd2cSJim Jagielski void OComboBoxModel::onDisconnectedDbColumn()
706*b1cdbd2cSJim Jagielski {
707*b1cdbd2cSJim Jagielski m_pValueFormatter.reset();
708*b1cdbd2cSJim Jagielski
709*b1cdbd2cSJim Jagielski // reset the string item list
710*b1cdbd2cSJim Jagielski if ( !hasExternalListSource() )
711*b1cdbd2cSJim Jagielski setFastPropertyValue( PROPERTY_ID_STRINGITEMLIST, makeAny( m_aDesignModeStringItems ) );
712*b1cdbd2cSJim Jagielski
713*b1cdbd2cSJim Jagielski m_aListRowSet.dispose();
714*b1cdbd2cSJim Jagielski }
715*b1cdbd2cSJim Jagielski
716*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
reloaded(const EventObject & aEvent)717*b1cdbd2cSJim Jagielski void SAL_CALL OComboBoxModel::reloaded( const EventObject& aEvent ) throw(RuntimeException)
718*b1cdbd2cSJim Jagielski {
719*b1cdbd2cSJim Jagielski OBoundControlModel::reloaded(aEvent);
720*b1cdbd2cSJim Jagielski
721*b1cdbd2cSJim Jagielski // reload data if we have a list source
722*b1cdbd2cSJim Jagielski if ( m_aListSource.getLength() && m_xCursor.is() && !hasExternalListSource() )
723*b1cdbd2cSJim Jagielski loadData( false );
724*b1cdbd2cSJim Jagielski }
725*b1cdbd2cSJim Jagielski
726*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
resetNoBroadcast()727*b1cdbd2cSJim Jagielski void OComboBoxModel::resetNoBroadcast()
728*b1cdbd2cSJim Jagielski {
729*b1cdbd2cSJim Jagielski OBoundControlModel::resetNoBroadcast();
730*b1cdbd2cSJim Jagielski m_aLastKnownValue.clear();
731*b1cdbd2cSJim Jagielski }
732*b1cdbd2cSJim Jagielski
733*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------------
commitControlValueToDbColumn(bool _bPostReset)734*b1cdbd2cSJim Jagielski sal_Bool OComboBoxModel::commitControlValueToDbColumn( bool _bPostReset )
735*b1cdbd2cSJim Jagielski {
736*b1cdbd2cSJim Jagielski Any aNewValue( m_xAggregateFastSet->getFastPropertyValue( getValuePropertyAggHandle() ) );
737*b1cdbd2cSJim Jagielski
738*b1cdbd2cSJim Jagielski ::rtl::OUString sNewValue;
739*b1cdbd2cSJim Jagielski aNewValue >>= sNewValue;
740*b1cdbd2cSJim Jagielski
741*b1cdbd2cSJim Jagielski bool bModified = ( aNewValue != m_aLastKnownValue );
742*b1cdbd2cSJim Jagielski if ( bModified )
743*b1cdbd2cSJim Jagielski {
744*b1cdbd2cSJim Jagielski if ( !aNewValue.hasValue()
745*b1cdbd2cSJim Jagielski || ( !sNewValue.getLength() // an empty string
746*b1cdbd2cSJim Jagielski && m_bEmptyIsNull // which should be interpreted as NULL
747*b1cdbd2cSJim Jagielski )
748*b1cdbd2cSJim Jagielski )
749*b1cdbd2cSJim Jagielski {
750*b1cdbd2cSJim Jagielski m_xColumnUpdate->updateNull();
751*b1cdbd2cSJim Jagielski }
752*b1cdbd2cSJim Jagielski else
753*b1cdbd2cSJim Jagielski {
754*b1cdbd2cSJim Jagielski try
755*b1cdbd2cSJim Jagielski {
756*b1cdbd2cSJim Jagielski OSL_PRECOND( m_pValueFormatter.get(), "OComboBoxModel::commitControlValueToDbColumn: no value formatter!" );
757*b1cdbd2cSJim Jagielski if ( m_pValueFormatter.get() )
758*b1cdbd2cSJim Jagielski {
759*b1cdbd2cSJim Jagielski if ( !m_pValueFormatter->setFormattedValue( sNewValue ) )
760*b1cdbd2cSJim Jagielski return sal_False;
761*b1cdbd2cSJim Jagielski }
762*b1cdbd2cSJim Jagielski else
763*b1cdbd2cSJim Jagielski m_xColumnUpdate->updateString( sNewValue );
764*b1cdbd2cSJim Jagielski }
765*b1cdbd2cSJim Jagielski catch ( const Exception& )
766*b1cdbd2cSJim Jagielski {
767*b1cdbd2cSJim Jagielski return sal_False;
768*b1cdbd2cSJim Jagielski }
769*b1cdbd2cSJim Jagielski }
770*b1cdbd2cSJim Jagielski
771*b1cdbd2cSJim Jagielski m_aLastKnownValue = aNewValue;
772*b1cdbd2cSJim Jagielski }
773*b1cdbd2cSJim Jagielski
774*b1cdbd2cSJim Jagielski // add the new value to the list
775*b1cdbd2cSJim Jagielski sal_Bool bAddToList = bModified && !_bPostReset;
776*b1cdbd2cSJim Jagielski // (only if this is not the "commit" triggered by a "reset")
777*b1cdbd2cSJim Jagielski
778*b1cdbd2cSJim Jagielski if ( bAddToList )
779*b1cdbd2cSJim Jagielski {
780*b1cdbd2cSJim Jagielski StringSequence aStringItemList;
781*b1cdbd2cSJim Jagielski if ( getPropertyValue( PROPERTY_STRINGITEMLIST ) >>= aStringItemList )
782*b1cdbd2cSJim Jagielski {
783*b1cdbd2cSJim Jagielski const ::rtl::OUString* pStringItems = aStringItemList.getConstArray();
784*b1cdbd2cSJim Jagielski sal_Int32 i;
785*b1cdbd2cSJim Jagielski for (i=0; i<aStringItemList.getLength(); ++i, ++pStringItems)
786*b1cdbd2cSJim Jagielski {
787*b1cdbd2cSJim Jagielski if ( pStringItems->equals( sNewValue ) )
788*b1cdbd2cSJim Jagielski break;
789*b1cdbd2cSJim Jagielski }
790*b1cdbd2cSJim Jagielski
791*b1cdbd2cSJim Jagielski // not found -> add
792*b1cdbd2cSJim Jagielski if (i >= aStringItemList.getLength())
793*b1cdbd2cSJim Jagielski {
794*b1cdbd2cSJim Jagielski sal_Int32 nOldLen = aStringItemList.getLength();
795*b1cdbd2cSJim Jagielski aStringItemList.realloc( nOldLen + 1 );
796*b1cdbd2cSJim Jagielski aStringItemList.getArray()[ nOldLen ] = sNewValue;
797*b1cdbd2cSJim Jagielski
798*b1cdbd2cSJim Jagielski setFastPropertyValue( PROPERTY_ID_STRINGITEMLIST, makeAny( aStringItemList ) );
799*b1cdbd2cSJim Jagielski }
800*b1cdbd2cSJim Jagielski }
801*b1cdbd2cSJim Jagielski }
802*b1cdbd2cSJim Jagielski
803*b1cdbd2cSJim Jagielski return sal_True;
804*b1cdbd2cSJim Jagielski }
805*b1cdbd2cSJim Jagielski
806*b1cdbd2cSJim Jagielski // XPropertiesChangeListener
807*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
translateDbColumnToControlValue()808*b1cdbd2cSJim Jagielski Any OComboBoxModel::translateDbColumnToControlValue()
809*b1cdbd2cSJim Jagielski {
810*b1cdbd2cSJim Jagielski OSL_PRECOND( m_pValueFormatter.get(), "OComboBoxModel::translateDbColumnToControlValue: no value formatter!" );
811*b1cdbd2cSJim Jagielski if ( m_pValueFormatter.get() )
812*b1cdbd2cSJim Jagielski {
813*b1cdbd2cSJim Jagielski ::rtl::OUString sValue( m_pValueFormatter->getFormattedValue() );
814*b1cdbd2cSJim Jagielski if ( !sValue.getLength()
815*b1cdbd2cSJim Jagielski && m_pValueFormatter->getColumn().is()
816*b1cdbd2cSJim Jagielski && m_pValueFormatter->getColumn()->wasNull()
817*b1cdbd2cSJim Jagielski )
818*b1cdbd2cSJim Jagielski {
819*b1cdbd2cSJim Jagielski m_aLastKnownValue.clear();
820*b1cdbd2cSJim Jagielski }
821*b1cdbd2cSJim Jagielski else
822*b1cdbd2cSJim Jagielski {
823*b1cdbd2cSJim Jagielski
824*b1cdbd2cSJim Jagielski m_aLastKnownValue <<= sValue;
825*b1cdbd2cSJim Jagielski }
826*b1cdbd2cSJim Jagielski }
827*b1cdbd2cSJim Jagielski else
828*b1cdbd2cSJim Jagielski m_aLastKnownValue.clear();
829*b1cdbd2cSJim Jagielski
830*b1cdbd2cSJim Jagielski return m_aLastKnownValue.hasValue() ? m_aLastKnownValue : makeAny( ::rtl::OUString() );
831*b1cdbd2cSJim Jagielski // (m_aLastKnownValue is alllowed to be VOID, the control value isn't)
832*b1cdbd2cSJim Jagielski }
833*b1cdbd2cSJim Jagielski
834*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
getDefaultForReset() const835*b1cdbd2cSJim Jagielski Any OComboBoxModel::getDefaultForReset() const
836*b1cdbd2cSJim Jagielski {
837*b1cdbd2cSJim Jagielski return makeAny( m_aDefaultText );
838*b1cdbd2cSJim Jagielski }
839*b1cdbd2cSJim Jagielski
840*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
stringItemListChanged(ControlModelLock &)841*b1cdbd2cSJim Jagielski void OComboBoxModel::stringItemListChanged( ControlModelLock& /*_rInstanceLock*/ )
842*b1cdbd2cSJim Jagielski {
843*b1cdbd2cSJim Jagielski if ( m_xAggregateSet.is() )
844*b1cdbd2cSJim Jagielski m_xAggregateSet->setPropertyValue( PROPERTY_STRINGITEMLIST, makeAny( getStringItemList() ) );
845*b1cdbd2cSJim Jagielski }
846*b1cdbd2cSJim Jagielski
847*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
connectedExternalListSource()848*b1cdbd2cSJim Jagielski void OComboBoxModel::connectedExternalListSource( )
849*b1cdbd2cSJim Jagielski {
850*b1cdbd2cSJim Jagielski // TODO?
851*b1cdbd2cSJim Jagielski }
852*b1cdbd2cSJim Jagielski
853*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
disconnectedExternalListSource()854*b1cdbd2cSJim Jagielski void OComboBoxModel::disconnectedExternalListSource( )
855*b1cdbd2cSJim Jagielski {
856*b1cdbd2cSJim Jagielski // TODO?
857*b1cdbd2cSJim Jagielski }
858*b1cdbd2cSJim Jagielski
859*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
refreshInternalEntryList()860*b1cdbd2cSJim Jagielski void OComboBoxModel::refreshInternalEntryList()
861*b1cdbd2cSJim Jagielski {
862*b1cdbd2cSJim Jagielski DBG_ASSERT( !hasExternalListSource(), "OComboBoxModel::refreshInternalEntryList: invalid call!" );
863*b1cdbd2cSJim Jagielski
864*b1cdbd2cSJim Jagielski if ( !hasExternalListSource( )
865*b1cdbd2cSJim Jagielski && ( m_eListSourceType != ListSourceType_VALUELIST )
866*b1cdbd2cSJim Jagielski && ( m_xCursor.is() )
867*b1cdbd2cSJim Jagielski )
868*b1cdbd2cSJim Jagielski {
869*b1cdbd2cSJim Jagielski loadData( true );
870*b1cdbd2cSJim Jagielski }
871*b1cdbd2cSJim Jagielski }
872*b1cdbd2cSJim Jagielski
873*b1cdbd2cSJim Jagielski //--------------------------------------------------------------------
disposing(const EventObject & _rSource)874*b1cdbd2cSJim Jagielski void SAL_CALL OComboBoxModel::disposing( const EventObject& _rSource ) throw ( RuntimeException )
875*b1cdbd2cSJim Jagielski {
876*b1cdbd2cSJim Jagielski if ( !OEntryListHelper::handleDisposing( _rSource ) )
877*b1cdbd2cSJim Jagielski OBoundControlModel::disposing( _rSource );
878*b1cdbd2cSJim Jagielski }
879*b1cdbd2cSJim Jagielski
880*b1cdbd2cSJim Jagielski //========================================================================
881*b1cdbd2cSJim Jagielski //= OComboBoxControl
882*b1cdbd2cSJim Jagielski //========================================================================
883*b1cdbd2cSJim Jagielski
884*b1cdbd2cSJim Jagielski //------------------------------------------------------------------
OComboBoxControl_CreateInstance(const Reference<XMultiServiceFactory> & _rxFactory)885*b1cdbd2cSJim Jagielski InterfaceRef SAL_CALL OComboBoxControl_CreateInstance(const Reference<XMultiServiceFactory>& _rxFactory) throw (RuntimeException)
886*b1cdbd2cSJim Jagielski {
887*b1cdbd2cSJim Jagielski return *(new OComboBoxControl(_rxFactory));
888*b1cdbd2cSJim Jagielski }
889*b1cdbd2cSJim Jagielski
890*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
OComboBoxControl(const Reference<XMultiServiceFactory> & _rxFactory)891*b1cdbd2cSJim Jagielski OComboBoxControl::OComboBoxControl(const Reference<XMultiServiceFactory>& _rxFactory)
892*b1cdbd2cSJim Jagielski :OBoundControl(_rxFactory, VCL_CONTROL_COMBOBOX)
893*b1cdbd2cSJim Jagielski {
894*b1cdbd2cSJim Jagielski }
895*b1cdbd2cSJim Jagielski
896*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
getSupportedServiceNames()897*b1cdbd2cSJim Jagielski StringSequence SAL_CALL OComboBoxControl::getSupportedServiceNames() throw(RuntimeException)
898*b1cdbd2cSJim Jagielski {
899*b1cdbd2cSJim Jagielski StringSequence aSupported = OBoundControl::getSupportedServiceNames();
900*b1cdbd2cSJim Jagielski aSupported.realloc(aSupported.getLength() + 1);
901*b1cdbd2cSJim Jagielski
902*b1cdbd2cSJim Jagielski ::rtl::OUString* pArray = aSupported.getArray();
903*b1cdbd2cSJim Jagielski pArray[aSupported.getLength()-1] = FRM_SUN_CONTROL_COMBOBOX;
904*b1cdbd2cSJim Jagielski return aSupported;
905*b1cdbd2cSJim Jagielski }
906*b1cdbd2cSJim Jagielski
907*b1cdbd2cSJim Jagielski //.........................................................................
908*b1cdbd2cSJim Jagielski }
909*b1cdbd2cSJim Jagielski //.........................................................................
910*b1cdbd2cSJim Jagielski
911