xref: /AOO41X/main/dbaccess/source/ui/control/ColumnControlWindow.cxx (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_dbaccess.hxx"
30*cdf0e10cSrcweir #ifndef DBAUI_COLUMNCONTROLWINDOW_HXX
31*cdf0e10cSrcweir #include "ColumnControlWindow.hxx"
32*cdf0e10cSrcweir #endif
33*cdf0e10cSrcweir #ifndef DBAUI_FIELDCONTROLS_HXX
34*cdf0e10cSrcweir #include "FieldControls.hxx"
35*cdf0e10cSrcweir #endif
36*cdf0e10cSrcweir #ifndef INCLUDED_SVTOOLS_SYSLOCALE_HXX
37*cdf0e10cSrcweir #include <unotools/syslocale.hxx>
38*cdf0e10cSrcweir #endif
39*cdf0e10cSrcweir #ifndef _CONNECTIVITY_DBTOOLS_HXX_
40*cdf0e10cSrcweir #include <connectivity/dbtools.hxx>
41*cdf0e10cSrcweir #endif
42*cdf0e10cSrcweir #ifndef DBAUI_TOOLS_HXX
43*cdf0e10cSrcweir #include "UITools.hxx"
44*cdf0e10cSrcweir #endif
45*cdf0e10cSrcweir #ifndef _DBU_RESOURCE_HRC_
46*cdf0e10cSrcweir #include "dbu_resource.hrc"
47*cdf0e10cSrcweir #endif
48*cdf0e10cSrcweir 
49*cdf0e10cSrcweir 
50*cdf0e10cSrcweir using namespace ::dbaui;
51*cdf0e10cSrcweir using namespace ::com::sun::star::uno;
52*cdf0e10cSrcweir using namespace ::com::sun::star::beans;
53*cdf0e10cSrcweir using namespace ::com::sun::star::container;
54*cdf0e10cSrcweir using namespace ::com::sun::star::util;
55*cdf0e10cSrcweir using namespace ::com::sun::star::sdbc;
56*cdf0e10cSrcweir using namespace ::com::sun::star::lang;
57*cdf0e10cSrcweir 
58*cdf0e10cSrcweir //========================================================================
59*cdf0e10cSrcweir // OColumnControlWindow
60*cdf0e10cSrcweir DBG_NAME(OColumnControlWindow)
61*cdf0e10cSrcweir //========================================================================
62*cdf0e10cSrcweir OColumnControlWindow::OColumnControlWindow(Window* pParent
63*cdf0e10cSrcweir 										   ,const Reference<XMultiServiceFactory>& _rxFactory)
64*cdf0e10cSrcweir 			: OFieldDescControl(pParent,NULL)
65*cdf0e10cSrcweir 			, m_xORB(_rxFactory)
66*cdf0e10cSrcweir 			, m_sTypeNames(ModuleRes(STR_TABLEDESIGN_DBFIELDTYPES))
67*cdf0e10cSrcweir 			, m_bAutoIncrementEnabled(sal_True)
68*cdf0e10cSrcweir {
69*cdf0e10cSrcweir     DBG_CTOR(OColumnControlWindow,NULL);
70*cdf0e10cSrcweir 
71*cdf0e10cSrcweir 	setRightAligned();
72*cdf0e10cSrcweir 	m_aLocale = SvtSysLocale().GetLocaleData().getLocale();
73*cdf0e10cSrcweir }
74*cdf0e10cSrcweir // -----------------------------------------------------------------------------
75*cdf0e10cSrcweir OColumnControlWindow::~OColumnControlWindow()
76*cdf0e10cSrcweir {
77*cdf0e10cSrcweir 
78*cdf0e10cSrcweir     DBG_DTOR(OColumnControlWindow,NULL);
79*cdf0e10cSrcweir }
80*cdf0e10cSrcweir // -----------------------------------------------------------------------
81*cdf0e10cSrcweir void OColumnControlWindow::ActivateAggregate( EControlType eType )
82*cdf0e10cSrcweir {
83*cdf0e10cSrcweir 	switch(eType )
84*cdf0e10cSrcweir 	{
85*cdf0e10cSrcweir 		case tpFormat:
86*cdf0e10cSrcweir 		case tpDefault:
87*cdf0e10cSrcweir //		case tpAutoIncrement:
88*cdf0e10cSrcweir 		case tpColumnName:
89*cdf0e10cSrcweir 			break;
90*cdf0e10cSrcweir 		default:
91*cdf0e10cSrcweir 			OFieldDescControl::ActivateAggregate( eType );
92*cdf0e10cSrcweir 	}
93*cdf0e10cSrcweir }
94*cdf0e10cSrcweir // -----------------------------------------------------------------------
95*cdf0e10cSrcweir void OColumnControlWindow::DeactivateAggregate( EControlType eType )
96*cdf0e10cSrcweir {
97*cdf0e10cSrcweir 	switch(eType )
98*cdf0e10cSrcweir 	{
99*cdf0e10cSrcweir 		case tpFormat:
100*cdf0e10cSrcweir 		case tpDefault:
101*cdf0e10cSrcweir //		case tpAutoIncrement:
102*cdf0e10cSrcweir 		case tpColumnName:
103*cdf0e10cSrcweir 			break;
104*cdf0e10cSrcweir 		default:
105*cdf0e10cSrcweir 			OFieldDescControl::DeactivateAggregate( eType );
106*cdf0e10cSrcweir 	}
107*cdf0e10cSrcweir }
108*cdf0e10cSrcweir // -----------------------------------------------------------------------------
109*cdf0e10cSrcweir void OColumnControlWindow::CellModified(long /*nRow*/, sal_uInt16 /*nColId*/ )
110*cdf0e10cSrcweir {
111*cdf0e10cSrcweir 	saveCurrentFieldDescData();
112*cdf0e10cSrcweir }
113*cdf0e10cSrcweir // -----------------------------------------------------------------------------
114*cdf0e10cSrcweir ::com::sun::star::lang::Locale	OColumnControlWindow::GetLocale() const
115*cdf0e10cSrcweir {
116*cdf0e10cSrcweir 	return m_aLocale;
117*cdf0e10cSrcweir }
118*cdf0e10cSrcweir // -----------------------------------------------------------------------------
119*cdf0e10cSrcweir Reference< XNumberFormatter > OColumnControlWindow::GetFormatter() const
120*cdf0e10cSrcweir {
121*cdf0e10cSrcweir 	if ( !m_xFormatter.is() )
122*cdf0e10cSrcweir 		try
123*cdf0e10cSrcweir 		{
124*cdf0e10cSrcweir 			Reference< XNumberFormatsSupplier >  xSupplier(::dbtools::getNumberFormats(m_xConnection, sal_True,m_xORB));
125*cdf0e10cSrcweir 
126*cdf0e10cSrcweir 			if ( xSupplier.is() )
127*cdf0e10cSrcweir 			{
128*cdf0e10cSrcweir 				// create a new formatter
129*cdf0e10cSrcweir 				m_xFormatter.set( m_xORB->createInstance(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.util.NumberFormatter"))), UNO_QUERY);
130*cdf0e10cSrcweir 				if (m_xFormatter.is())
131*cdf0e10cSrcweir 					m_xFormatter->attachNumberFormatsSupplier(xSupplier);
132*cdf0e10cSrcweir 			}
133*cdf0e10cSrcweir 		}
134*cdf0e10cSrcweir 		catch(Exception&)
135*cdf0e10cSrcweir 		{
136*cdf0e10cSrcweir 		}
137*cdf0e10cSrcweir 	return m_xFormatter;
138*cdf0e10cSrcweir }
139*cdf0e10cSrcweir // -----------------------------------------------------------------------------
140*cdf0e10cSrcweir TOTypeInfoSP OColumnControlWindow::getTypeInfo(sal_Int32 _nPos)
141*cdf0e10cSrcweir {
142*cdf0e10cSrcweir 	return ( _nPos >= 0 && _nPos < static_cast<sal_Int32>(m_aDestTypeInfoIndex.size())) ? m_aDestTypeInfoIndex[_nPos]->second : TOTypeInfoSP();
143*cdf0e10cSrcweir }
144*cdf0e10cSrcweir // -----------------------------------------------------------------------------
145*cdf0e10cSrcweir const OTypeInfoMap*	OColumnControlWindow::getTypeInfo() const
146*cdf0e10cSrcweir {
147*cdf0e10cSrcweir 	return &m_aDestTypeInfo;
148*cdf0e10cSrcweir }
149*cdf0e10cSrcweir // -----------------------------------------------------------------------------
150*cdf0e10cSrcweir Reference< XDatabaseMetaData> OColumnControlWindow::getMetaData()
151*cdf0e10cSrcweir {
152*cdf0e10cSrcweir 	if ( m_xConnection.is() )
153*cdf0e10cSrcweir 		return m_xConnection->getMetaData();
154*cdf0e10cSrcweir 	return Reference< XDatabaseMetaData>();
155*cdf0e10cSrcweir }
156*cdf0e10cSrcweir // -----------------------------------------------------------------------------
157*cdf0e10cSrcweir Reference< XConnection> OColumnControlWindow::getConnection()
158*cdf0e10cSrcweir {
159*cdf0e10cSrcweir 	return m_xConnection;
160*cdf0e10cSrcweir }
161*cdf0e10cSrcweir // -----------------------------------------------------------------------------
162*cdf0e10cSrcweir void OColumnControlWindow::setConnection(const Reference< XConnection>& _xCon)
163*cdf0e10cSrcweir {
164*cdf0e10cSrcweir 	m_xConnection = _xCon;
165*cdf0e10cSrcweir 	m_xFormatter = NULL;
166*cdf0e10cSrcweir 	m_aDestTypeInfoIndex.clear();
167*cdf0e10cSrcweir 	m_aDestTypeInfo.clear();
168*cdf0e10cSrcweir 
169*cdf0e10cSrcweir 	if ( m_xConnection.is() )
170*cdf0e10cSrcweir 	{
171*cdf0e10cSrcweir 		Init();
172*cdf0e10cSrcweir 
173*cdf0e10cSrcweir 		::dbaui::fillTypeInfo(m_xConnection,m_sTypeNames,m_aDestTypeInfo,m_aDestTypeInfoIndex);
174*cdf0e10cSrcweir         // read autoincrement value set in the datasource
175*cdf0e10cSrcweir 		::dbaui::fillAutoIncrementValue(m_xConnection,m_bAutoIncrementEnabled,m_sAutoIncrementValue);
176*cdf0e10cSrcweir 	}
177*cdf0e10cSrcweir }
178*cdf0e10cSrcweir // -----------------------------------------------------------------------------
179*cdf0e10cSrcweir sal_Bool OColumnControlWindow::isAutoIncrementValueEnabled() const
180*cdf0e10cSrcweir {
181*cdf0e10cSrcweir 	return m_bAutoIncrementEnabled;
182*cdf0e10cSrcweir }
183*cdf0e10cSrcweir // -----------------------------------------------------------------------------
184*cdf0e10cSrcweir ::rtl::OUString OColumnControlWindow::getAutoIncrementValue() const
185*cdf0e10cSrcweir {
186*cdf0e10cSrcweir 	return m_sAutoIncrementValue;
187*cdf0e10cSrcweir }
188*cdf0e10cSrcweir // -----------------------------------------------------------------------------
189*cdf0e10cSrcweir TOTypeInfoSP OColumnControlWindow::getDefaultTyp() const
190*cdf0e10cSrcweir {
191*cdf0e10cSrcweir 	if ( !m_pTypeInfo.get() )
192*cdf0e10cSrcweir 	{
193*cdf0e10cSrcweir 		m_pTypeInfo = TOTypeInfoSP(new OTypeInfo());
194*cdf0e10cSrcweir 		m_pTypeInfo->aUIName = m_sTypeNames.GetToken(TYPE_OTHER);
195*cdf0e10cSrcweir 	}
196*cdf0e10cSrcweir 	return m_pTypeInfo;
197*cdf0e10cSrcweir }
198*cdf0e10cSrcweir // -----------------------------------------------------------------------------
199