| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| #ifndef DBUI_TABLECOPYHELPER_HXX |
| #define DBUI_TABLECOPYHELPER_HXX |
| |
| #ifndef DBAUI_APPELEMENTTYPE_HXX |
| #include "AppElementType.hxx" |
| #endif |
| #ifndef _DBAUI_COMMON_TYPES_HXX_ |
| #include "commontypes.hxx" |
| #endif |
| #ifndef _SVX_DATACCESSDESCRIPTOR_HXX_ |
| #include <svx/dataaccessdescriptor.hxx> |
| #endif |
| #ifndef _SOT_STORAGE_HXX |
| #include <sot/storage.hxx> |
| #endif |
| #ifndef _TRANSFER_HXX |
| #include <svtools/transfer.hxx> |
| #endif |
| #ifndef _COM_SUN_STAR_SDBC_XCONNECTION_HPP_ |
| #include <com/sun/star/sdbc/XConnection.hpp> |
| #endif |
| #ifndef _COM_SUN_STAR_SDBC_XRESULTSET_HPP_ |
| #include <com/sun/star/sdbc/XResultSet.hpp> |
| #endif |
| #include <functional> |
| |
| class SvLBoxEntry; |
| //........................................................................ |
| namespace dbaui |
| { |
| //........................................................................ |
| class OGenericUnoController; |
| /// unary_function Functor object for class DataFlavorExVector::value_type returntype is bool |
| struct TAppSupportedSotFunctor : ::std::unary_function<DataFlavorExVector::value_type,bool> |
| { |
| ElementType eEntryType; |
| sal_Bool bQueryDrop; |
| TAppSupportedSotFunctor(const ElementType& _eEntryType,sal_Bool _bQueryDrop) |
| : eEntryType(_eEntryType) |
| , bQueryDrop(_bQueryDrop) |
| { |
| } |
| |
| inline bool operator()(const DataFlavorExVector::value_type& _aType) |
| { |
| switch (_aType.mnSotId) |
| { |
| case SOT_FORMAT_RTF: // RTF data descriptions |
| case SOT_FORMATSTR_ID_HTML: // HTML data descriptions |
| case SOT_FORMATSTR_ID_DBACCESS_TABLE: // table descriptor |
| return (E_TABLE == eEntryType); |
| case SOT_FORMATSTR_ID_DBACCESS_QUERY: // query descriptor |
| case SOT_FORMATSTR_ID_DBACCESS_COMMAND: // SQL command |
| return ((E_QUERY == eEntryType) || ( !bQueryDrop && E_TABLE == eEntryType)); |
| } |
| return false; |
| } |
| }; |
| |
| class OTableCopyHelper |
| { |
| private: |
| OGenericUnoController* m_pController; |
| ::rtl::OUString m_sTableNameForAppend; |
| |
| public: |
| // is needed to describe the drop target |
| struct DropDescriptor |
| { |
| ::svx::ODataAccessDescriptor aDroppedData; |
| //dyf add 20070601 |
| //for transfor the tablename |
| ::rtl::OUString sDefaultTableName; |
| //dyf add end |
| String aUrl; |
| SotStorageStreamRef aHtmlRtfStorage; |
| ElementType nType; |
| SvLBoxEntry* pDroppedAt; |
| sal_Int8 nAction; |
| sal_Bool bHtml; |
| sal_Bool bError; |
| |
| DropDescriptor() : nType(E_TABLE),pDroppedAt(NULL),nAction(DND_ACTION_NONE) { } |
| }; |
| |
| OTableCopyHelper(OGenericUnoController* _pControler); |
| |
| /** pastes a table into the data source |
| @param _rPasteData |
| The data helper. |
| @param _sDestDataSourceName |
| The name of the dest data source. |
| */ |
| void pasteTable( const TransferableDataHelper& _rTransData |
| ,const ::rtl::OUString& _sDestDataSourceName |
| ,const SharedConnection& _xConnection); |
| |
| /** pastes a table into the data source |
| @param _nFormatId |
| The format which should be copied. |
| @param _rPasteData |
| The data helper. |
| @param _sDestDataSourceName |
| The name of the dest data source. |
| */ |
| void pasteTable( SotFormatStringId _nFormatId |
| ,const TransferableDataHelper& _rTransData |
| ,const ::rtl::OUString& _sDestDataSourceName |
| ,const SharedConnection& _xConnection); |
| |
| /** copies a table which was constructed by tags like HTML or RTF |
| @param _rDesc |
| The Drop descriptor |
| @param _bCheck |
| If set to <TRUE/> than the controller checks only if a copy is possible. |
| @param _xConnection |
| The connection |
| */ |
| sal_Bool copyTagTable( DropDescriptor& _rDesc, |
| sal_Bool _bCheck, |
| const SharedConnection& _xConnection); |
| |
| /** copies a table which was constructed by tags like HTML or RTF |
| @param _rDesc |
| The Drop descriptor |
| @param _bCheck |
| If set to <TRUE/> than the controller checks only if a copy is possible. |
| @param _xConnection |
| The connection |
| */ |
| void asyncCopyTagTable( DropDescriptor& _rDesc |
| ,const ::rtl::OUString& _sDestDataSourceName |
| ,const SharedConnection& _xConnection); |
| |
| /** copies a table which was constructed by tags like HTML or RTF |
| @param _aDroppedData |
| The dropped data |
| @param _rDesc |
| IN/OUT parameter |
| @param _xConnection |
| The connection |
| */ |
| sal_Bool copyTagTable(const TransferableDataHelper& _aDroppedData, |
| DropDescriptor& _rAsyncDrop, |
| const SharedConnection& _xConnection); |
| |
| /// returns <TRUE/> if the clipboard supports a table format, otherwise <FALSE/>. |
| sal_Bool isTableFormat(const TransferableDataHelper& _rClipboard) const; |
| |
| inline void SetTableNameForAppend( const ::rtl::OUString& _rDefaultTableName ) { m_sTableNameForAppend = _rDefaultTableName; } |
| inline void ResetTableNameForAppend() { SetTableNameForAppend( ::rtl::OUString() ); } |
| inline const ::rtl::OUString& GetTableNameForAppend() const { return m_sTableNameForAppend ;} |
| |
| private: |
| /** pastes a table into the data source |
| @param _rPasteData |
| The data descriptor. |
| @param _sDestDataSourceName |
| The name of the dest data source. |
| */ |
| void pasteTable( |
| const ::svx::ODataAccessDescriptor& _rPasteData, |
| const ::rtl::OUString& _sDestDataSourceName, |
| const SharedConnection& _xDestConnection |
| ); |
| |
| /** insert a table into the data source. The source can eihter be a table or a query |
| */ |
| void insertTable( |
| const ::rtl::OUString& i_rSourceDataSource, |
| const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& i_rSourceConnection, |
| const ::rtl::OUString& i_rCommand, |
| const sal_Int32 i_nCommandType, |
| const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet >& i_rSourceRows, |
| const ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any >& i_rSelection, |
| const sal_Bool i_bBookmarkSelection, |
| const ::rtl::OUString& i_rDestDataSource, |
| const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& i_rDestConnection |
| ); |
| |
| }; |
| //........................................................................ |
| } // namespace dbaui |
| //........................................................................ |
| #endif // DBUI_TABLECOPYHELPER_HXX |
| |
