1*1d2dbeb0SAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*1d2dbeb0SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*1d2dbeb0SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*1d2dbeb0SAndrew Rist * distributed with this work for additional information 6*1d2dbeb0SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*1d2dbeb0SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*1d2dbeb0SAndrew Rist * "License"); you may not use this file except in compliance 9*1d2dbeb0SAndrew Rist * with the License. You may obtain a copy of the License at 10*1d2dbeb0SAndrew Rist * 11*1d2dbeb0SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*1d2dbeb0SAndrew Rist * 13*1d2dbeb0SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*1d2dbeb0SAndrew Rist * software distributed under the License is distributed on an 15*1d2dbeb0SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*1d2dbeb0SAndrew Rist * KIND, either express or implied. See the License for the 17*1d2dbeb0SAndrew Rist * specific language governing permissions and limitations 18*1d2dbeb0SAndrew Rist * under the License. 19*1d2dbeb0SAndrew Rist * 20*1d2dbeb0SAndrew Rist *************************************************************/ 21*1d2dbeb0SAndrew Rist 22*1d2dbeb0SAndrew Rist 23cdf0e10cSrcweir #ifndef _SWDBMGR_HXX 24cdf0e10cSrcweir #define _SWDBMGR_HXX 25cdf0e10cSrcweir 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include <tools/string.hxx> 28cdf0e10cSrcweir #include <tools/link.hxx> 29cdf0e10cSrcweir #include <svl/svarray.hxx> 30cdf0e10cSrcweir #include <com/sun/star/util/Date.hpp> 31cdf0e10cSrcweir #include "swdllapi.h" 32cdf0e10cSrcweir #include <swdbdata.hxx> 33cdf0e10cSrcweir #include <com/sun/star/uno/Reference.h> 34cdf0e10cSrcweir #include <com/sun/star/uno/Sequence.hxx> 35cdf0e10cSrcweir #include <com/sun/star/lang/Locale.hpp> 36cdf0e10cSrcweir #include <com/sun/star/beans/PropertyValue.hpp> 37cdf0e10cSrcweir namespace com{namespace sun{namespace star{ 38cdf0e10cSrcweir namespace sdbc{ 39cdf0e10cSrcweir class XConnection; 40cdf0e10cSrcweir class XStatement; 41cdf0e10cSrcweir class XDataSource; 42cdf0e10cSrcweir class XResultSet; 43cdf0e10cSrcweir } 44cdf0e10cSrcweir namespace beans{ 45cdf0e10cSrcweir 46cdf0e10cSrcweir class XPropertySet; 47cdf0e10cSrcweir struct PropertyValue; 48cdf0e10cSrcweir } 49cdf0e10cSrcweir namespace sdbcx{ 50cdf0e10cSrcweir class XColumnsSupplier; 51cdf0e10cSrcweir } 52cdf0e10cSrcweir namespace util{ 53cdf0e10cSrcweir class XNumberFormatter; 54cdf0e10cSrcweir } 55cdf0e10cSrcweir namespace mail{ 56cdf0e10cSrcweir class XSmtpService; 57cdf0e10cSrcweir } 58cdf0e10cSrcweir }}} 59cdf0e10cSrcweir namespace svx { 60cdf0e10cSrcweir class ODataAccessDescriptor; 61cdf0e10cSrcweir } 62cdf0e10cSrcweir 63cdf0e10cSrcweir struct SwDBFormatData 64cdf0e10cSrcweir { 65cdf0e10cSrcweir com::sun::star::util::Date aNullDate; 66cdf0e10cSrcweir com::sun::star::uno::Reference< com::sun::star::util::XNumberFormatter> xFormatter; 67cdf0e10cSrcweir com::sun::star::lang::Locale aLocale; 68cdf0e10cSrcweir }; 69cdf0e10cSrcweir 70cdf0e10cSrcweir class SwView; 71cdf0e10cSrcweir class SwWrtShell; 72cdf0e10cSrcweir class SfxProgress; 73cdf0e10cSrcweir class ListBox; 74cdf0e10cSrcweir class Button; 75cdf0e10cSrcweir class SvNumberFormatter; 76cdf0e10cSrcweir class SwDbtoolsClient; 77cdf0e10cSrcweir class SwXMailMerge; 78cdf0e10cSrcweir class SwMailMergeConfigItem; 79cdf0e10cSrcweir 80cdf0e10cSrcweir // ----------------------------------------------------------------------- 81cdf0e10cSrcweir 82cdf0e10cSrcweir enum DBMgrOptions 83cdf0e10cSrcweir { 84cdf0e10cSrcweir DBMGR_MERGE, // Datensaetze in Felder 85cdf0e10cSrcweir DBMGR_INSERT, // Datensaetze in Text 86cdf0e10cSrcweir DBMGR_MERGE_MAILMERGE, // Serienbriefe drucken 87cdf0e10cSrcweir DBMGR_MERGE_MAILING, // Serienbriefe als email versenden 88cdf0e10cSrcweir DBMGR_MERGE_MAILFILES, // Serienbriefe als Datei(en) speichern 89cdf0e10cSrcweir DBMGR_MERGE_DOCUMENTS, // Print merged documents 90cdf0e10cSrcweir DBMGR_MERGE_SINGLE_FILE // save merge as single file 91cdf0e10cSrcweir }; 92cdf0e10cSrcweir 93cdf0e10cSrcweir // ----------------------------------------------------------------------- 94cdf0e10cSrcweir 95cdf0e10cSrcweir /*-------------------------------------------------------------------- 96cdf0e10cSrcweir Beschreibung: (neue) Logische Datenbanken verwalten 97cdf0e10cSrcweir --------------------------------------------------------------------*/ 98cdf0e10cSrcweir #define SW_DB_SELECT_UNKNOWN 0 99cdf0e10cSrcweir #define SW_DB_SELECT_TABLE 1 100cdf0e10cSrcweir #define SW_DB_SELECT_QUERY 2 101cdf0e10cSrcweir 102cdf0e10cSrcweir struct SwDSParam : public SwDBData 103cdf0e10cSrcweir { 104cdf0e10cSrcweir com::sun::star::util::Date aNullDate; 105cdf0e10cSrcweir 106cdf0e10cSrcweir ::com::sun::star::uno::Reference<com::sun::star::util::XNumberFormatter> xFormatter; 107cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> xConnection; 108cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XStatement> xStatement; 109cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet> xResultSet; 110cdf0e10cSrcweir ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any > aSelection; 111cdf0e10cSrcweir sal_Bool bScrollable; 112cdf0e10cSrcweir sal_Bool bEndOfDB; 113cdf0e10cSrcweir sal_Bool bAfterSelection; 114cdf0e10cSrcweir long nSelectionIndex; 115cdf0e10cSrcweir SwDSParamSwDSParam116cdf0e10cSrcweir SwDSParam(const SwDBData& rData) : 117cdf0e10cSrcweir SwDBData(rData), 118cdf0e10cSrcweir bScrollable(sal_False), 119cdf0e10cSrcweir bEndOfDB(sal_False), 120cdf0e10cSrcweir bAfterSelection(sal_False), 121cdf0e10cSrcweir nSelectionIndex(0) 122cdf0e10cSrcweir {} 123cdf0e10cSrcweir SwDSParamSwDSParam124cdf0e10cSrcweir SwDSParam(const SwDBData& rData, 125cdf0e10cSrcweir const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet>& xResSet, 126cdf0e10cSrcweir const ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any >& rSelection) : 127cdf0e10cSrcweir SwDBData(rData), 128cdf0e10cSrcweir xResultSet(xResSet), 129cdf0e10cSrcweir aSelection(rSelection), 130cdf0e10cSrcweir bScrollable(sal_True), 131cdf0e10cSrcweir bEndOfDB(sal_False), 132cdf0e10cSrcweir bAfterSelection(sal_False), 133cdf0e10cSrcweir nSelectionIndex(0) 134cdf0e10cSrcweir {} 135cdf0e10cSrcweir CheckEndOfDBSwDSParam136cdf0e10cSrcweir void CheckEndOfDB() 137cdf0e10cSrcweir { 138cdf0e10cSrcweir if(bEndOfDB) 139cdf0e10cSrcweir bAfterSelection = sal_True; 140cdf0e10cSrcweir } 141cdf0e10cSrcweir }; 142cdf0e10cSrcweir typedef SwDSParam* SwDSParamPtr; 143cdf0e10cSrcweir SV_DECL_PTRARR_DEL(SwDSParamArr, SwDSParamPtr, 0, 5) 144cdf0e10cSrcweir 145cdf0e10cSrcweir struct SwMergeDescriptor 146cdf0e10cSrcweir { 147cdf0e10cSrcweir sal_uInt16 nMergeType; 148cdf0e10cSrcweir SwWrtShell& rSh; 149cdf0e10cSrcweir const ::svx::ODataAccessDescriptor& rDescriptor; 150cdf0e10cSrcweir String sSaveToFilter; //export filter to save resulting files 151cdf0e10cSrcweir String sSaveToFilterOptions; // 152cdf0e10cSrcweir com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > aSaveToFilterData; 153cdf0e10cSrcweir 154cdf0e10cSrcweir String sSubject; 155cdf0e10cSrcweir String sAddressFromColumn; 156cdf0e10cSrcweir String sMailBody; 157cdf0e10cSrcweir String sAttachmentName; 158cdf0e10cSrcweir ::com::sun::star::uno::Sequence< ::rtl::OUString > aCopiesTo; 159cdf0e10cSrcweir ::com::sun::star::uno::Sequence< ::rtl::OUString > aBlindCopiesTo; 160cdf0e10cSrcweir 161cdf0e10cSrcweir ::com::sun::star::uno::Reference< com::sun::star::mail::XSmtpService > xSmtpServer; 162cdf0e10cSrcweir 163cdf0e10cSrcweir sal_Bool bSendAsHTML; 164cdf0e10cSrcweir sal_Bool bSendAsAttachment; 165cdf0e10cSrcweir 166cdf0e10cSrcweir sal_Bool bPrintAsync; 167cdf0e10cSrcweir sal_Bool bCreateSingleFile; 168cdf0e10cSrcweir 169cdf0e10cSrcweir SwMailMergeConfigItem* pMailMergeConfigItem; 170cdf0e10cSrcweir 171cdf0e10cSrcweir ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > aPrintOptions; 172cdf0e10cSrcweir SwMergeDescriptorSwMergeDescriptor173cdf0e10cSrcweir SwMergeDescriptor( sal_uInt16 nType, SwWrtShell& rShell, ::svx::ODataAccessDescriptor& rDesc ) : 174cdf0e10cSrcweir nMergeType(nType), 175cdf0e10cSrcweir rSh(rShell), 176cdf0e10cSrcweir rDescriptor(rDesc), 177cdf0e10cSrcweir bSendAsHTML( sal_True ), 178cdf0e10cSrcweir bSendAsAttachment( sal_False ), 179cdf0e10cSrcweir bPrintAsync( sal_False ), 180cdf0e10cSrcweir bCreateSingleFile( sal_False ), 181cdf0e10cSrcweir pMailMergeConfigItem(0) 182cdf0e10cSrcweir {} 183cdf0e10cSrcweir 184cdf0e10cSrcweir }; 185cdf0e10cSrcweir 186cdf0e10cSrcweir struct SwNewDBMgr_Impl; 187cdf0e10cSrcweir class SwConnectionDisposedListener_Impl; 188cdf0e10cSrcweir class AbstractMailMergeDlg; 189cdf0e10cSrcweir 190cdf0e10cSrcweir class SW_DLLPUBLIC SwNewDBMgr 191cdf0e10cSrcweir { 192cdf0e10cSrcweir friend class SwConnectionDisposedListener_Impl; 193cdf0e10cSrcweir 194cdf0e10cSrcweir static SwDbtoolsClient* pDbtoolsClient; 195cdf0e10cSrcweir 196cdf0e10cSrcweir String sEMailAddrFld; // Mailing: Spaltenname der E-Mail Adresse 197cdf0e10cSrcweir String sSubject; // Mailing: Subject 198cdf0e10cSrcweir String sAttached; // Mailing: Attachte Files 199cdf0e10cSrcweir sal_uInt16 nMergeType; 200cdf0e10cSrcweir sal_Bool bInitDBFields : 1; // sal_True: Datenbank an Feldern beim Mergen 201cdf0e10cSrcweir sal_Bool bSingleJobs : 1; // Einzelne Druckjobs bei Aufruf aus Basic 202cdf0e10cSrcweir sal_Bool bCancel : 1; // Serienbrief-Save abgebrochen 203cdf0e10cSrcweir 204cdf0e10cSrcweir sal_Bool bInMerge : 1; //merge process active 205cdf0e10cSrcweir sal_Bool bMergeSilent : 1; // suppress display of dialogs/boxes (used when called over API) 206cdf0e10cSrcweir sal_Bool bMergeLock : 1; // prevent update of database fields while document is 207cdf0e10cSrcweir // actually printed at the ViewShell 208cdf0e10cSrcweir SwDSParamArr aDataSourceParams; 209cdf0e10cSrcweir SwNewDBMgr_Impl* pImpl; 210cdf0e10cSrcweir const SwXMailMerge* pMergeEvtSrc; // != 0 if mail merge events are to be send 211cdf0e10cSrcweir 212cdf0e10cSrcweir SW_DLLPRIVATE SwDSParam* FindDSData(const SwDBData& rData, sal_Bool bCreate); 213cdf0e10cSrcweir SW_DLLPRIVATE SwDSParam* FindDSConnection(const ::rtl::OUString& rSource, sal_Bool bCreate); 214cdf0e10cSrcweir 215cdf0e10cSrcweir 216cdf0e10cSrcweir SW_DLLPRIVATE DECL_LINK( PrtCancelHdl, Button * ); 217cdf0e10cSrcweir 218cdf0e10cSrcweir // Datensaetze als Text ins Dokument einfuegen 219cdf0e10cSrcweir SW_DLLPRIVATE void ImportFromConnection( SwWrtShell* pSh); 220cdf0e10cSrcweir 221cdf0e10cSrcweir // Einzelnen Datensatz als Text ins Dokument einfuegen 222cdf0e10cSrcweir SW_DLLPRIVATE void ImportDBEntry(SwWrtShell* pSh); 223cdf0e10cSrcweir 224cdf0e10cSrcweir // merge to file _and_ merge to e-Mail 225cdf0e10cSrcweir SW_DLLPRIVATE sal_Bool MergeMailFiles(SwWrtShell* pSh, 226cdf0e10cSrcweir const SwMergeDescriptor& rMergeDescriptor ); 227cdf0e10cSrcweir SW_DLLPRIVATE sal_Bool ToNextRecord(SwDSParam* pParam); 228cdf0e10cSrcweir 229cdf0e10cSrcweir public: 230cdf0e10cSrcweir SwNewDBMgr(); 231cdf0e10cSrcweir ~SwNewDBMgr(); 232cdf0e10cSrcweir 233cdf0e10cSrcweir // Art des aktellen Mergens. Siehe DBMgrOptions-enum GetMergeType() const234cdf0e10cSrcweir inline sal_uInt16 GetMergeType() const { return nMergeType; } SetMergeType(sal_uInt16 nTyp)235cdf0e10cSrcweir inline void SetMergeType( sal_uInt16 nTyp ) { nMergeType = nTyp; } 236cdf0e10cSrcweir 237cdf0e10cSrcweir // MailMergeEvent source GetMailMergeEvtSrc() const238cdf0e10cSrcweir const SwXMailMerge * GetMailMergeEvtSrc() const { return pMergeEvtSrc; } SetMailMergeEvtSrc(const SwXMailMerge * pSrc)239cdf0e10cSrcweir void SetMailMergeEvtSrc( const SwXMailMerge *pSrc ) { pMergeEvtSrc = pSrc; } 240cdf0e10cSrcweir IsMergeSilent() const241cdf0e10cSrcweir inline sal_Bool IsMergeSilent() const { return bMergeSilent != 0; } SetMergeSilent(sal_Bool bVal)242cdf0e10cSrcweir inline void SetMergeSilent( sal_Bool bVal ) { bMergeSilent = bVal; } 243cdf0e10cSrcweir 244cdf0e10cSrcweir // Mischen von Datensaetzen in Felder 245cdf0e10cSrcweir sal_Bool MergeNew( const SwMergeDescriptor& rMergeDesc ); 246cdf0e10cSrcweir sal_Bool Merge(SwWrtShell* pSh); 247cdf0e10cSrcweir 248cdf0e10cSrcweir // Datenbankfelder mit fehlendem Datenbankname initialisieren IsInitDBFields() const249cdf0e10cSrcweir inline sal_Bool IsInitDBFields() const { return bInitDBFields; } SetInitDBFields(sal_Bool b)250cdf0e10cSrcweir inline void SetInitDBFields(sal_Bool b) { bInitDBFields = b; } 251cdf0e10cSrcweir 252cdf0e10cSrcweir // Serienbriefe einzelnd oder alle zusammen drucken/speichern IsSingleJobs() const253cdf0e10cSrcweir inline sal_Bool IsSingleJobs() const { return bSingleJobs; } SetSingleJobs(sal_Bool b)254cdf0e10cSrcweir inline void SetSingleJobs(sal_Bool b) { bSingleJobs = b; } 255cdf0e10cSrcweir 256cdf0e10cSrcweir // Mailing 257cdf0e10cSrcweir // email-Daten setzen SetEMailColumn(const String & sColName)258cdf0e10cSrcweir inline void SetEMailColumn(const String& sColName) { sEMailAddrFld = sColName; } SetSubject(const String & sSbj)259cdf0e10cSrcweir inline void SetSubject(const String& sSbj) { sSubject = sSbj; } SetAttachment(const String & sAtt)260cdf0e10cSrcweir inline void SetAttachment(const String& sAtt) { sAttached = sAtt; } 261cdf0e10cSrcweir 262cdf0e10cSrcweir 263cdf0e10cSrcweir // Listbox mit allen Tabellennamen einer Datenbank fuellen 264cdf0e10cSrcweir sal_Bool GetTableNames(ListBox* pListBox, const String& rDBName ); 265cdf0e10cSrcweir 266cdf0e10cSrcweir // Listbox mit allen Spaltennamen einer Datenbanktabelle fuellen 267cdf0e10cSrcweir sal_Bool GetColumnNames(ListBox* pListBox, 268cdf0e10cSrcweir const String& rDBName, const String& rTableName, sal_Bool bAppend = sal_False); 269cdf0e10cSrcweir sal_Bool GetColumnNames(ListBox* pListBox, 270cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> xConnection, 271cdf0e10cSrcweir const String& rTableName, sal_Bool bAppend = sal_False); 272cdf0e10cSrcweir 273cdf0e10cSrcweir sal_uLong GetColumnFmt( ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDataSource> xSource, 274cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> xConnection, 275cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet> xColumn, 276cdf0e10cSrcweir SvNumberFormatter* pNFmtr, 277cdf0e10cSrcweir long nLanguage ); 278cdf0e10cSrcweir 279cdf0e10cSrcweir sal_uLong GetColumnFmt( const String& rDBName, 280cdf0e10cSrcweir const String& rTableName, 281cdf0e10cSrcweir const String& rColNm, 282cdf0e10cSrcweir SvNumberFormatter* pNFmtr, 283cdf0e10cSrcweir long nLanguage ); 284cdf0e10cSrcweir sal_Int32 GetColumnType( const String& rDBName, 285cdf0e10cSrcweir const String& rTableName, 286cdf0e10cSrcweir const String& rColNm ); 287cdf0e10cSrcweir IsInMerge() const288cdf0e10cSrcweir inline sal_Bool IsInMerge() const { return bInMerge; } 289cdf0e10cSrcweir void EndMerge(); 290cdf0e10cSrcweir 291cdf0e10cSrcweir void ExecuteFormLetter(SwWrtShell& rSh, 292cdf0e10cSrcweir const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue>& rProperties, 293cdf0e10cSrcweir sal_Bool bWithDataSourceBrowser = sal_False); 294cdf0e10cSrcweir 295cdf0e10cSrcweir void InsertText(SwWrtShell& rSh, 296cdf0e10cSrcweir const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue>& rProperties); 297cdf0e10cSrcweir 298cdf0e10cSrcweir // check if a data source is open 299cdf0e10cSrcweir sal_Bool IsDataSourceOpen(const String& rDataSource, 300cdf0e10cSrcweir const String& rTableOrQuery, sal_Bool bMergeOnly); 301cdf0e10cSrcweir 302cdf0e10cSrcweir // open the source while fields are updated - for the calculator only! 303cdf0e10cSrcweir sal_Bool OpenDataSource(const String& rDataSource, const String& rTableOrQuery, 304cdf0e10cSrcweir sal_Int32 nCommandType = -1, bool bCreate = false); 305cdf0e10cSrcweir sal_uInt32 GetSelectedRecordId(const String& rDataSource, const String& rTableOrQuery, sal_Int32 nCommandType = -1); 306cdf0e10cSrcweir sal_Bool GetColumnCnt(const String& rSourceName, const String& rTableName, 307cdf0e10cSrcweir const String& rColumnName, sal_uInt32 nAbsRecordId, long nLanguage, 308cdf0e10cSrcweir String& rResult, double* pNumber); 309cdf0e10cSrcweir //create and store or find an already stored connection to a data source for use 310cdf0e10cSrcweir //in SwFldMgr and SwDBTreeList 311cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> 312cdf0e10cSrcweir RegisterConnection(::rtl::OUString& rSource); 313cdf0e10cSrcweir CreateDSData(const SwDBData & rData)314cdf0e10cSrcweir const SwDSParam* CreateDSData(const SwDBData& rData) 315cdf0e10cSrcweir {return FindDSData(rData, sal_True);} GetDSParamArray() const316cdf0e10cSrcweir const SwDSParamArr& GetDSParamArray() const {return aDataSourceParams;} 317cdf0e10cSrcweir 318cdf0e10cSrcweir 319cdf0e10cSrcweir //close all data sources - after fields were updated 320cdf0e10cSrcweir void CloseAll(sal_Bool bIncludingMerge = sal_True); 321cdf0e10cSrcweir 322cdf0e10cSrcweir sal_Bool GetMergeColumnCnt(const String& rColumnName, sal_uInt16 nLanguage, 323cdf0e10cSrcweir String &rResult, double *pNumber, sal_uInt32 *pFormat); 324cdf0e10cSrcweir sal_Bool ToNextMergeRecord(); 325cdf0e10cSrcweir sal_Bool ToNextRecord(const String& rDataSource, const String& rTableOrQuery, sal_Int32 nCommandType = -1); 326cdf0e10cSrcweir 327cdf0e10cSrcweir sal_Bool ExistsNextRecord()const; 328cdf0e10cSrcweir sal_uInt32 GetSelectedRecordId(); 329cdf0e10cSrcweir sal_Bool ToRecordId(sal_Int32 nSet); 330cdf0e10cSrcweir 331cdf0e10cSrcweir const SwDBData& GetAddressDBName(); 332cdf0e10cSrcweir 333cdf0e10cSrcweir static String GetDBField( 334cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > xColumnProp, 335cdf0e10cSrcweir const SwDBFormatData& rDBFormatData, 336cdf0e10cSrcweir double *pNumber = NULL); 337cdf0e10cSrcweir 338cdf0e10cSrcweir static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> 339cdf0e10cSrcweir GetConnection(const String& rDataSource, 340cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDataSource>& rxSource); 341cdf0e10cSrcweir 342cdf0e10cSrcweir static ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XColumnsSupplier> 343cdf0e10cSrcweir GetColumnSupplier(::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>, 344cdf0e10cSrcweir const String& rTableOrQuery, 345cdf0e10cSrcweir sal_uInt8 eTableOrQuery = SW_DB_SELECT_UNKNOWN); 346cdf0e10cSrcweir 347cdf0e10cSrcweir static ::com::sun::star::uno::Sequence<rtl::OUString> GetExistingDatabaseNames(); 348cdf0e10cSrcweir 349cdf0e10cSrcweir /** 350cdf0e10cSrcweir Loads a data source from file and registers it. Returns the registered name. 351cdf0e10cSrcweir */ 352cdf0e10cSrcweir static String LoadAndRegisterDataSource(); 353cdf0e10cSrcweir 354cdf0e10cSrcweir static SwDbtoolsClient& GetDbtoolsClient(); 355cdf0e10cSrcweir // has to be called from _FinitUI() 356cdf0e10cSrcweir static void RemoveDbtoolsClient(); 357cdf0e10cSrcweir 358cdf0e10cSrcweir /** try to get the data source from the given connection through the XChild interface. 359cdf0e10cSrcweir If this is not possible, the data source will be created through its name. 360cdf0e10cSrcweir @param _xConnection 361cdf0e10cSrcweir The connection which should support the XChild interface. (not a must) 362cdf0e10cSrcweir @param _sDataSourceName 363cdf0e10cSrcweir The data source name will be used to create the data source when the connection can not be used for it. 364cdf0e10cSrcweir @return 365cdf0e10cSrcweir The data source. 366cdf0e10cSrcweir */ 367cdf0e10cSrcweir static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDataSource> 368cdf0e10cSrcweir getDataSourceAsParent(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _xConnection,const ::rtl::OUString& _sDataSourceName); 369cdf0e10cSrcweir 370cdf0e10cSrcweir /** creates a RowSet, which must be disposed after use. 371cdf0e10cSrcweir @param _sDataSourceName 372cdf0e10cSrcweir The data source name 373cdf0e10cSrcweir @param _sCommand 374cdf0e10cSrcweir The command. 375cdf0e10cSrcweir @param _nCommandType 376cdf0e10cSrcweir The type of the command. 377cdf0e10cSrcweir @param _xConnection 378cdf0e10cSrcweir The active connection which may be <NULL/>. 379cdf0e10cSrcweir @return 380cdf0e10cSrcweir The new created RowSet. 381cdf0e10cSrcweir 382cdf0e10cSrcweir */ 383cdf0e10cSrcweir static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet> 384cdf0e10cSrcweir createCursor( const ::rtl::OUString& _sDataSourceName, 385cdf0e10cSrcweir const ::rtl::OUString& _sCommand, 386cdf0e10cSrcweir sal_Int32 _nCommandType, 387cdf0e10cSrcweir const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _xConnection 388cdf0e10cSrcweir ); 389cdf0e10cSrcweir //merge into one document - returns the number of merged docs 390cdf0e10cSrcweir sal_Int32 MergeDocuments( SwMailMergeConfigItem& rMMConfig, SwView& rSourceView ); 391cdf0e10cSrcweir }; 392cdf0e10cSrcweir 393cdf0e10cSrcweir #endif 394cdf0e10cSrcweir 395