You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ITSM/.svn/pristine/f4/f4eb16c6cf97e934bf9fff5a5ee...

145 lines
7.0 KiB

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML xmlns:MSHelp="http://msdn.microsoft.com/mshelp" DIR="LTR"><HEAD>
<meta name="GENERATOR" content="VBdocman .NET - documentation generator; http://www.vbdocman.com">
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=UTF-8">
<TITLE>clsVertragsuebersicht_Strukturen.Get_Treedata -Methode</TITLE>
<xml>
<MSHelp:TOCTitle Title="clsVertragsuebersicht_Strukturen.Get_Treedata -Methode"/>
<MSHelp:RLTitle Title="clsVertragsuebersicht_Strukturen.Get_Treedata -Methode"/>
<MSHelp:Keyword Index="A" Term="topic_0000000000001020"/>
<MSHelp:Keyword Index="K" Term="clsVertragsuebersicht_Strukturen.Get_Treedata -Methode"/>
<MSHelp:Keyword Index="K" Term="Vertragsverwaltung.TKB.VV.Vertrag.clsVertragsuebersicht_Strukturen.Get_Treedata -Methode"/>
<MSHelp:Keyword Index="F" Term="Vertragsverwaltung.TKB.VV.Vertrag.clsVertragsuebersicht_Strukturen.Get_Treedata"/>
<MSHelp:Keyword Index="F" Term="clsVertragsuebersicht_Strukturen.Get_Treedata"/>
<MSHelp:Keyword Index="F" Term="Vertragsverwaltung.TKB.VV.Vertrag.clsVertragsuebersicht_Strukturen.clsVertragsuebersicht_Strukturen.Get_Treedata"/>
<MSHelp:Attr Name="DevLang" Value="VB"/>
<MSHelp:Attr Name="DevLangVers" Value="kbLangVB"/>
<MSHelp:Attr Name="DocSet" Value="Visual Basic"/>
<MSHelp:Attr Name="DocSet" Value="Visual Studio"/>
<MSHelp:Attr Name="DocSet" Value="VSM"/>
<MSHelp:Attr Name="Product" Value="VB"/>
<MSHelp:Attr Name="ProductVers" Value="kbVBp700"/>
<MSHelp:Attr Name="Product" Value="VSA"/>
<MSHelp:Attr Name="ProductVers" Value="kbVSA"/>
<MSHelp:Attr Name="Technology" Value="ManagedCode"/>
<MSHelp:Attr Name="TechnologyVers" Value="kbManagedCode"/>
<MSHelp:Attr Name="TopicType" Value="kbSyntax"/>
<MSHelp:Attr Name="TargetOS" Value="Windows"/>
<MSHelp:Attr Name="Locale" Value="kbEnglish"/>
</xml>
<META name="rtfFileName" content="">
<META NAME="save" CONTENT="history">
<!--CSS_START-->
<SCRIPT SRC="MSHelp/scripts/dtuelink.js"></SCRIPT>
<!--CSS_END-->
<SCRIPT language="JavaScript">
function indent(level) {
for (i=1; i<=level; i++) {
document.write("&nbsp;&nbsp;&nbsp;");
}
}
</SCRIPT>
</HEAD>
<body topmargin=0 id="bodyID" class = "dtBODY"><!--NONSCROLLING BANNER START-->
<div id="nsbanner">
<div id="bannerrow1">
<TABLE CLASS="bannerparthead" CELLSPACING=0>
<TR ID="hdr">
<TD CLASS="runninghead" nowrap>Vertragsverwaltung-Klassenbibliothek</TD>
<TD CLASS="product" nowrap>&nbsp;</TD>
</TR>
</TABLE>
</div>
<div id="TitleRow">
<H1 class="dtH1"><A NAME="topic_0000000000001020"></A>clsVertragsuebersicht_Strukturen.Get_Treedata -Methode</H1>
</div></div>
<!--NONSCROLLING BANNER END-->
<DIV id="nstext" valign="bottom"><!---->
<P>Auslesen der Partner für die Vertragsuebersicht</P>
<PRE class="syntax"><SPAN class="lang">[Visual&nbsp;Basic]
</SPAN><B>Private Function Get_Treedata( _&nbsp;<br> ByVal <i>Selectiontype</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a>, _&nbsp;<br> ByVal <i>aktiv</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemBooleanClassTopic.htm">Boolean</a>, _&nbsp;<br> Optional ByVal <i>suchtype</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a> = 0, _&nbsp;<br> Optional ByVal <i>suchstring</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic.htm">String</a> = &quot;&quot;, _&nbsp;<br> Optional ByVal <i>Partnernr</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a> = 0 _&nbsp;<br>) As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemDataDataTableClassTopic.htm">DataTable</a></B></PRE>
<H4 class="dtH4">Parameter</H4>
<dl>
<dt><i>Selectiontype</i></dt>
<dd>Vertragspartner oder Vertragstyp</dd>
<dt><i>aktiv</i></dt>
<dd>Aktiv=0</dd>
<dt><i>suchtype</i></dt>
<dd>Optional. Der Standardwert ist 0.</dd>
<dt><i>suchstring</i></dt>
<dd>Optional. Der Standardwert ist &quot;&quot;.</dd>
<dt><i>Partnernr</i></dt>
<dd>Optional. Der Standardwert ist 0.</dd>
</dl>
<H4 class="dtH4">Quellcode</H4>
<pre class="code"><SPAN class="lang">[Visual&nbsp;Basic]</SPAN>
Private Function Get_Treedata(ByVal Selectiontype As Integer, ByVal aktiv As Boolean, Optional ByVal suchtype As Integer = 0, Optional ByVal suchstring As String = &quot;&quot;, Optional ByVal Partnernr As Integer = 0) As DataTable&nbsp;<br> Dim scmCmdToExecute As SqlCommand = New SqlCommand()&nbsp;<br> Dim dtToReturn As DataTable = New DataTable()&nbsp;<br> Dim sdaAdapter As SqlDataAdapter = New SqlDataAdapter(scmCmdToExecute)&nbsp;<br> scmCmdToExecute.CommandText = &quot;dbo.sp_vertragsuebersicht_get_TreeRoot&quot;&nbsp;<br> scmCmdToExecute.CommandType = CommandType.StoredProcedure&nbsp;<br> scmCmdToExecute.Connection = conn.scoDBConnection&nbsp;<br> Try&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@mitarbeiternr&quot;, SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, Globals.clsmitarbeiter.iMitarbeiternr.Value))&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@SelectionType&quot;, SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, Selectiontype))&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@Aktiv&quot;, SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, aktiv))&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@Suchtype&quot;, SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, suchtype))&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@SuchString&quot;, SqlDbType.VarChar, 255, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, suchstring))&nbsp;<br> scmCmdToExecute.Parameters.Add(New SqlParameter(&quot;@partnernr&quot;, SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, &quot;&quot;, DataRowVersion.Proposed, partnernr))&nbsp;<br> sdaAdapter.Fill(dtToReturn)&nbsp;<br> Return dtToReturn&nbsp;<br> Catch ex As Exception&nbsp;<br> Throw New Exception(&quot;clsVertragsuebersicht::&quot; &amp; scmCmdToExecute.CommandText &amp; &quot;::Error occured.&quot; &amp; ex.Message, ex)&nbsp;<br> Finally&nbsp;<br> scmCmdToExecute.Dispose()&nbsp;<br> sdaAdapter.Dispose()&nbsp;<br> End Try&nbsp;<br> End Function
</pre>
<H4 class="dtH4">Forderungen</H4>
<P><b class="le">Plattformen:&nbsp;</b>Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition</P>
<H4 class="dtH4">Siehe auch</H4>
<p>
<a href="topic_000000000000101A.html">clsVertragsuebersicht_Strukturen</a>
</p>
<DIV CLASS="footer">
<HR>
Generated by VBdocman .NET
<p>
</div></div>
</BODY>
</HTML>