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