1*9b5730f6SAndrew Rist /**************************************************************
2cdf0e10cSrcweir *
3*9b5730f6SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
4*9b5730f6SAndrew Rist * or more contributor license agreements. See the NOTICE file
5*9b5730f6SAndrew Rist * distributed with this work for additional information
6*9b5730f6SAndrew Rist * regarding copyright ownership. The ASF licenses this file
7*9b5730f6SAndrew Rist * to you under the Apache License, Version 2.0 (the
8*9b5730f6SAndrew Rist * "License"); you may not use this file except in compliance
9*9b5730f6SAndrew Rist * with the License. You may obtain a copy of the License at
10*9b5730f6SAndrew Rist *
11*9b5730f6SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0
12*9b5730f6SAndrew Rist *
13*9b5730f6SAndrew Rist * Unless required by applicable law or agreed to in writing,
14*9b5730f6SAndrew Rist * software distributed under the License is distributed on an
15*9b5730f6SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*9b5730f6SAndrew Rist * KIND, either express or implied. See the License for the
17*9b5730f6SAndrew Rist * specific language governing permissions and limitations
18*9b5730f6SAndrew Rist * under the License.
19*9b5730f6SAndrew Rist *
20*9b5730f6SAndrew Rist *************************************************************/
21*9b5730f6SAndrew Rist
22*9b5730f6SAndrew Rist
23cdf0e10cSrcweir
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
26cdf0e10cSrcweir
27cdf0e10cSrcweir #ifndef _CONNECTIVITY_ADABAS_GROUP_HXX_
28cdf0e10cSrcweir #include "adabas/BGroup.hxx"
29cdf0e10cSrcweir #endif
30cdf0e10cSrcweir #include "adabas/BUsers.hxx"
31cdf0e10cSrcweir #include <com/sun/star/sdbc/XRow.hpp>
32cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSet.hpp>
33cdf0e10cSrcweir #include "adabas/BConnection.hxx"
34cdf0e10cSrcweir #include <comphelper/types.hxx>
35cdf0e10cSrcweir
36cdf0e10cSrcweir using namespace connectivity::adabas;
37cdf0e10cSrcweir using namespace ::com::sun::star::uno;
38cdf0e10cSrcweir using namespace ::com::sun::star::beans;
39cdf0e10cSrcweir // using namespace ::com::sun::star::sdbcx;
40cdf0e10cSrcweir using namespace ::com::sun::star::sdbc;
41cdf0e10cSrcweir using namespace ::com::sun::star::container;
42cdf0e10cSrcweir using namespace ::com::sun::star::lang;
43cdf0e10cSrcweir
44cdf0e10cSrcweir // -------------------------------------------------------------------------
OAdabasGroup(OAdabasConnection * _pConnection)45cdf0e10cSrcweir OAdabasGroup::OAdabasGroup( OAdabasConnection* _pConnection) : connectivity::sdbcx::OGroup(sal_True)
46cdf0e10cSrcweir ,m_pConnection(_pConnection)
47cdf0e10cSrcweir {
48cdf0e10cSrcweir construct();
49cdf0e10cSrcweir TStringVector aVector;
50cdf0e10cSrcweir m_pUsers = new OUsers(*this,m_aMutex,aVector,m_pConnection,this);
51cdf0e10cSrcweir }
52cdf0e10cSrcweir // -------------------------------------------------------------------------
OAdabasGroup(OAdabasConnection * _pConnection,const::rtl::OUString & _Name)53cdf0e10cSrcweir OAdabasGroup::OAdabasGroup( OAdabasConnection* _pConnection,
54cdf0e10cSrcweir const ::rtl::OUString& _Name
55cdf0e10cSrcweir ) : connectivity::sdbcx::OGroup(_Name,sal_True)
56cdf0e10cSrcweir ,m_pConnection(_pConnection)
57cdf0e10cSrcweir {
58cdf0e10cSrcweir construct();
59cdf0e10cSrcweir refreshUsers();
60cdf0e10cSrcweir }
61cdf0e10cSrcweir // -------------------------------------------------------------------------
refreshUsers()62cdf0e10cSrcweir void OAdabasGroup::refreshUsers()
63cdf0e10cSrcweir {
64cdf0e10cSrcweir if(!m_pConnection)
65cdf0e10cSrcweir return;
66cdf0e10cSrcweir
67cdf0e10cSrcweir TStringVector aVector;
68cdf0e10cSrcweir Reference< XStatement > xStmt = m_pConnection->createStatement( );
69cdf0e10cSrcweir
70cdf0e10cSrcweir ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("SELECT DISTINCT USERNAME FROM DOMAIN.USERS WHERE USERNAME IS NOT NULL AND USERNAME <> ' ' AND USERNAME <> 'CONTROL' AND GROUPNAME = '");
71cdf0e10cSrcweir aSql += getName( );
72cdf0e10cSrcweir aSql += ::rtl::OUString::createFromAscii("'");
73cdf0e10cSrcweir
74cdf0e10cSrcweir Reference< XResultSet > xResult = xStmt->executeQuery(aSql);
75cdf0e10cSrcweir if(xResult.is())
76cdf0e10cSrcweir {
77cdf0e10cSrcweir Reference< XRow > xRow(xResult,UNO_QUERY);
78cdf0e10cSrcweir while(xResult->next())
79cdf0e10cSrcweir aVector.push_back(xRow->getString(1));
80cdf0e10cSrcweir ::comphelper::disposeComponent(xResult);
81cdf0e10cSrcweir }
82cdf0e10cSrcweir ::comphelper::disposeComponent(xStmt);
83cdf0e10cSrcweir
84cdf0e10cSrcweir if(m_pUsers)
85cdf0e10cSrcweir m_pUsers->reFill(aVector);
86cdf0e10cSrcweir else
87cdf0e10cSrcweir m_pUsers = new OUsers(*this,m_aMutex,aVector,m_pConnection,this);
88cdf0e10cSrcweir }
89cdf0e10cSrcweir
90cdf0e10cSrcweir
91