| /************************************************************** |
| * |
| * 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. |
| * |
| *************************************************************/ |
| |
| |
| |
| // MARKER(update_precomp.py): autogen include statement, do not remove |
| #include "precompiled_sw.hxx" |
| |
| #ifdef SW_DLLIMPLEMENTATION |
| #undef SW_DLLIMPLEMENTATION |
| #endif |
| |
| |
| #include <swtypes.hxx> |
| #include <selectdbtabledialog.hxx> |
| #include <dbtablepreviewdialog.hxx> |
| #include <com/sun/star/sdbcx/XTablesSupplier.hpp> |
| #include <com/sun/star/sdb/XQueriesSupplier.hpp> |
| #include <com/sun/star/beans/XPropertySet.hpp> |
| #include <com/sun/star/beans/PropertyValue.hpp> |
| #include <com/sun/star/container/XChild.hpp> |
| #include <com/sun/star/sdbc/XDataSource.hpp> |
| |
| #include <unomid.h> |
| |
| #include <selectdbtabledialog.hrc> |
| #include <dbui.hrc> |
| #include <helpid.h> |
| |
| using namespace ::com::sun::star; |
| using namespace ::com::sun::star::sdbcx; |
| using namespace ::com::sun::star::sdbc; |
| using namespace ::com::sun::star::sdb; |
| using namespace ::com::sun::star::uno; |
| using namespace ::com::sun::star::container; |
| using namespace ::com::sun::star::beans; |
| |
| /*-- 08.04.2004 14:33:56--------------------------------------------------- |
| |
| -----------------------------------------------------------------------*/ |
| SwSelectDBTableDialog::SwSelectDBTableDialog(Window* pParent, |
| const uno::Reference< sdbc::XConnection>& rConnection) : |
| SfxModalDialog(pParent, SW_RES(DLG_MM_SELECTDBTABLEDDIALOG)), |
| #ifdef MSC |
| #pragma warning (disable : 4355) |
| #endif |
| m_aSelectFI( this, SW_RES( FI_SELECT )), |
| m_aTableHB( this, WB_BUTTONSTYLE | WB_BOTTOMBORDER), |
| m_aTableLB( this, SW_RES( LB_TABLE )), |
| m_aPreviewPB( this, SW_RES( PB_PREVIEW )), |
| m_aSeparatorFL(this, SW_RES( FL_SEPARATOR )), |
| m_aOK( this, SW_RES( PB_OK )), |
| m_aCancel( this, SW_RES( PB_CANCEL )), |
| m_aHelp( this, SW_RES( PB_HELP )), |
| #ifdef MSC |
| #pragma warning (default : 4355) |
| #endif |
| m_sName( SW_RES( ST_NAME )), |
| m_sType( SW_RES( ST_TYPE )), |
| m_sTable( SW_RES( ST_TABLE )), |
| m_sQuery( SW_RES( ST_QUERY )), |
| m_xConnection(rConnection) |
| { |
| FreeResource(); |
| |
| Size aLBSize(m_aTableLB.GetSizePixel()); |
| m_aTableHB.SetSizePixel(aLBSize); |
| Size aHeadSize(m_aTableHB.CalcWindowSizePixel()); |
| aHeadSize.Width() = aLBSize.Width(); |
| m_aTableHB.SetSizePixel(aHeadSize); |
| Point aLBPos(m_aTableLB.GetPosPixel()); |
| m_aTableHB.SetPosPixel(aLBPos); |
| aLBPos.Y() += aHeadSize.Height(); |
| aLBSize.Height() -= aHeadSize.Height(); |
| m_aTableLB.SetPosSizePixel(aLBPos, aLBSize); |
| |
| Size aSz(m_aTableHB.GetOutputSizePixel()); |
| m_aTableHB.InsertItem( 1, m_sName, |
| aSz.Width()/2, |
| HIB_LEFT | HIB_VCENTER /*| HIB_CLICKABLE | HIB_UPARROW */); |
| m_aTableHB.InsertItem( 2, m_sType, |
| aSz.Width()/2, |
| HIB_LEFT | HIB_VCENTER /*| HIB_CLICKABLE | HIB_UPARROW */); |
| m_aTableHB.SetHelpId(HID_MM_ADDRESSLIST_HB ); |
| m_aTableHB.Show(); |
| |
| static long nTabs[] = {3, 0, aSz.Width()/2, aSz.Width() }; |
| m_aTableLB.SetTabs(&nTabs[0], MAP_PIXEL); |
| m_aTableLB.SetHelpId(HID_MM_SELECTDBTABLEDDIALOG_LISTBOX); |
| m_aTableLB.SetStyle( m_aTableLB.GetStyle() | WB_CLIPCHILDREN ); |
| m_aTableLB.SetSpaceBetweenEntries(3); |
| m_aTableLB.SetSelectionMode( SINGLE_SELECTION ); |
| m_aTableLB.SetDragDropMode( 0 ); |
| m_aTableLB.EnableAsyncDrag(sal_False); |
| |
| m_aPreviewPB.SetClickHdl(LINK(this, SwSelectDBTableDialog, PreviewHdl)); |
| |
| Reference<XTablesSupplier> xTSupplier(m_xConnection, UNO_QUERY); |
| if(xTSupplier.is()) |
| { |
| Reference<XNameAccess> xTbls = xTSupplier->getTables(); |
| Sequence<rtl::OUString> aTbls = xTbls->getElementNames(); |
| const rtl::OUString* pTbls = aTbls.getConstArray(); |
| for(long i = 0; i < aTbls.getLength(); i++) |
| { |
| String sEntry = pTbls[i]; |
| sEntry += '\t'; |
| sEntry += m_sTable; |
| SvLBoxEntry* pEntry = m_aTableLB.InsertEntry(sEntry); |
| pEntry->SetUserData((void*)0); |
| } |
| } |
| Reference<XQueriesSupplier> xQSupplier(m_xConnection, UNO_QUERY); |
| if(xQSupplier.is()) |
| { |
| Reference<XNameAccess> xQueries = xQSupplier->getQueries(); |
| Sequence<rtl::OUString> aQueries = xQueries->getElementNames(); |
| const rtl::OUString* pQueries = aQueries.getConstArray(); |
| for(long i = 0; i < aQueries.getLength(); i++) |
| { |
| String sEntry = pQueries[i]; |
| sEntry += '\t'; |
| sEntry += m_sQuery; |
| SvLBoxEntry* pEntry = m_aTableLB.InsertEntry(sEntry); |
| pEntry->SetUserData((void*)1); |
| } |
| } |
| } |
| /*-- 08.04.2004 14:33:57--------------------------------------------------- |
| |
| -----------------------------------------------------------------------*/ |
| SwSelectDBTableDialog::~SwSelectDBTableDialog() |
| { |
| } |
| /*-- 08.04.2004 14:33:57--------------------------------------------------- |
| |
| -----------------------------------------------------------------------*/ |
| IMPL_LINK(SwSelectDBTableDialog, PreviewHdl, PushButton*, pButton) |
| { |
| SvLBoxEntry* pEntry = m_aTableLB.FirstSelected(); |
| if(pEntry) |
| { |
| ::rtl::OUString sTableOrQuery = m_aTableLB.GetEntryText(pEntry, 0); |
| sal_Int32 nCommandType = 0 == pEntry->GetUserData() ? 0 : 1; |
| |
| ::rtl::OUString sDataSourceName; |
| Reference<XChild> xChild(m_xConnection, UNO_QUERY); |
| if(xChild.is()) |
| { |
| Reference<XDataSource> xSource(xChild->getParent(), UNO_QUERY); |
| Reference<XPropertySet> xPrSet(xSource, UNO_QUERY); |
| xPrSet->getPropertyValue(C2U("Name")) >>= sDataSourceName; |
| } |
| DBG_ASSERT(sDataSourceName.getLength(), "no data source found"); |
| Sequence<PropertyValue> aProperties(5); |
| PropertyValue* pProperties = aProperties.getArray(); |
| pProperties[0].Name = C2U("DataSourceName"); |
| pProperties[0].Value <<= sDataSourceName; |
| pProperties[1].Name = C2U("Command"); |
| pProperties[1].Value <<= sTableOrQuery; |
| pProperties[2].Name = C2U("CommandType"); |
| pProperties[2].Value <<= nCommandType; |
| pProperties[3].Name = C2U("ShowTreeView"); |
| sal_Bool bFalse = sal_False; |
| pProperties[3].Value <<= bFalse; |
| pProperties[4].Name = C2U("ShowTreeViewButton"); |
| pProperties[4].Value <<= bFalse; |
| |
| SwDBTablePreviewDialog* pDlg = new SwDBTablePreviewDialog(pButton, aProperties); |
| pDlg->Execute(); |
| delete pDlg; |
| } |
| |
| return 0; |
| } |
| /*-- 19.04.2004 10:03:26--------------------------------------------------- |
| |
| -----------------------------------------------------------------------*/ |
| String SwSelectDBTableDialog::GetSelectedTable(bool& bIsTable) |
| { |
| SvLBoxEntry* pEntry = m_aTableLB.FirstSelected(); |
| bIsTable = pEntry->GetUserData() ? false : true; |
| return pEntry ? m_aTableLB.GetEntryText(pEntry, 0) : String(); |
| } |
| /*-- 13.05.2004 12:58:26--------------------------------------------------- |
| |
| -----------------------------------------------------------------------*/ |
| void SwSelectDBTableDialog::SetSelectedTable(const String& rTable, bool bIsTable) |
| { |
| SvLBoxEntry* pEntry = m_aTableLB.First(); |
| while(pEntry) |
| { |
| if((m_aTableLB.GetEntryText(pEntry, 0) == rTable) && |
| ((pEntry->GetUserData() == 0 ) == bIsTable)) |
| { |
| m_aTableLB.Select(pEntry); |
| break; |
| } |
| pEntry = m_aTableLB.Next( pEntry ); |
| } |
| } |