1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef _DBINSDLG_HXX 25 #define _DBINSDLG_HXX 26 27 28 #ifndef _BUTTON_HXX //autogen 29 #include <vcl/button.hxx> 30 #endif 31 #ifndef _GROUP_HXX //autogen 32 #include <vcl/group.hxx> 33 #endif 34 #ifndef _FIXED_HXX //autogen 35 #include <vcl/fixed.hxx> 36 #endif 37 #ifndef _EDIT_HXX //autogen 38 #include <vcl/edit.hxx> 39 #endif 40 #include <vcl/lstbox.hxx> 41 #include <svtools/svmedit.hxx> 42 #include <sfx2/basedlgs.hxx> 43 #include <svl/svarray.hxx> 44 #include <unotools/configitem.hxx> 45 #include <numfmtlb.hxx> 46 #include <swdbdata.hxx> 47 #include <com/sun/star/uno/Reference.h> 48 #include <com/sun/star/uno/Sequence.h> 49 namespace com{namespace sun{namespace star{ 50 namespace sdbcx{ 51 class XColumnsSupplier; 52 } 53 namespace sdbc{ 54 class XDataSource; 55 class XConnection; 56 class XResultSet; 57 } 58 }}} 59 60 class SwTableAutoFmt; 61 class SwView; 62 class SfxItemSet; 63 class SwTableRep; 64 class _DB_Columns; 65 66 struct SwInsDBColumn 67 { 68 rtl::OUString sColumn, sUsrNumFmt; 69 sal_Int32 nDBNumFmt; 70 sal_uInt32 nUsrNumFmt; 71 LanguageType eUsrNumFmtLng; 72 sal_uInt16 nCol; 73 sal_Bool bHasFmt : 1; 74 sal_Bool bIsDBFmt : 1; 75 SwInsDBColumnSwInsDBColumn76 SwInsDBColumn( const String& rStr, sal_uInt16 nColumn ) 77 : sColumn( rStr ), 78 nDBNumFmt( 0 ), 79 nUsrNumFmt( 0 ), 80 eUsrNumFmtLng( LANGUAGE_SYSTEM ), 81 nCol( nColumn ), 82 bHasFmt(sal_False), 83 bIsDBFmt(sal_True) 84 {} 85 operator ==SwInsDBColumn86 int operator==( const SwInsDBColumn& rCmp ) const 87 { return sColumn == rCmp.sColumn; } 88 int operator<( const SwInsDBColumn& rCmp ) const; 89 }; 90 91 typedef SwInsDBColumn* SwInsDBColumnPtr; 92 SV_DECL_PTRARR_SORT_DEL( SwInsDBColumns, SwInsDBColumnPtr, 32, 32 ) 93 94 95 class SwInsertDBColAutoPilot : public SfxModalDialog, public utl::ConfigItem 96 { 97 FixedText aFtInsertData; 98 RadioButton aRbAsTable; 99 RadioButton aRbAsField; 100 RadioButton aRbAsText; 101 102 FixedLine aFlHead; 103 FixedText aFtDbColumn; 104 105 ListBox aLbTblDbColumn; 106 ListBox aLbTxtDbColumn; 107 108 FixedLine aFlFormat; 109 RadioButton aRbDbFmtFromDb; 110 RadioButton aRbDbFmtFromUsr; 111 NumFormatListBox aLbDbFmtFromUsr; 112 113 /* ----- Page Text/Field ------- */ 114 ImageButton aIbDbcolToEdit; 115 MultiLineEdit aEdDbText; 116 FixedText aFtDbParaColl; 117 ListBox aLbDbParaColl; 118 119 /* ----- Page Table ------------ */ 120 ImageButton aIbDbcolAllTo; 121 ImageButton aIbDbcolOneTo; 122 ImageButton aIbDbcolOneFrom; 123 ImageButton aIbDbcolAllFrom; 124 FixedText aFtTableCol; 125 ListBox aLbTableCol; 126 CheckBox aCbTableHeadon; 127 RadioButton aRbHeadlColnms; 128 RadioButton aRbHeadlEmpty; 129 PushButton aPbTblFormat; 130 PushButton aPbTblAutofmt; 131 132 OKButton aBtOk; 133 CancelButton aBtCancel; 134 HelpButton aBtHelp; 135 136 FixedLine aFlBottom; 137 138 SwInsDBColumns aDBColumns; 139 const SwDBData aDBData; 140 141 Link aOldNumFmtLnk; 142 String sNoTmpl; 143 144 SwView* pView; 145 SwTableAutoFmt* pTAutoFmt; 146 147 SfxItemSet* pTblSet; 148 SwTableRep* pRep; 149 sal_uInt16 nGBFmtLen; 150 151 DECL_LINK( PageHdl, Button* ); 152 DECL_LINK( AutoFmtHdl, PushButton* ); 153 DECL_LINK( TblFmtHdl, PushButton* ); 154 DECL_LINK( DBFormatHdl, Button* ); 155 DECL_LINK( TblToFromHdl, Button* ); 156 DECL_LINK( SelectHdl, ListBox* ); 157 DECL_LINK( DblClickHdl, ListBox* ); 158 DECL_LINK( HeaderHdl, Button* ); 159 160 sal_Bool SplitTextToColArr( const String& rTxt, _DB_Columns& rColArr, sal_Bool bInsField ); 161 using SfxModalDialog::Notify; 162 virtual void Notify( const ::com::sun::star::uno::Sequence< rtl::OUString >& aPropertyNames ); 163 virtual void Commit(); 164 void Load(); 165 166 // setze die Tabellen - Eigenschaften 167 void SetTabSet(); 168 169 public: 170 SwInsertDBColAutoPilot( SwView& rView, 171 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDataSource> rxSource, 172 com::sun::star::uno::Reference<com::sun::star::sdbcx::XColumnsSupplier>, 173 const SwDBData& rData ); 174 175 virtual ~SwInsertDBColAutoPilot(); 176 177 void DataToDoc( const ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any >& rSelection, 178 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDataSource> rxSource, 179 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> xConnection, 180 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > xResultSet); 181 182 }; 183 184 #endif 185