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.
136 lines
6.8 KiB
136 lines
6.8 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>frmAuswertungsParameter.get_where -Methode</TITLE>
|
|
<xml>
|
|
<MSHelp:TOCTitle Title="frmAuswertungsParameter.get_where -Methode"/>
|
|
<MSHelp:RLTitle Title="frmAuswertungsParameter.get_where -Methode"/>
|
|
<MSHelp:Keyword Index="A" Term="topic_0000000000000D23"/>
|
|
<MSHelp:Keyword Index="K" Term="frmAuswertungsParameter.get_where -Methode"/>
|
|
<MSHelp:Keyword Index="K" Term="Vertragsverwaltung.frmAuswertungsParameter.get_where -Methode"/>
|
|
<MSHelp:Keyword Index="F" Term="Vertragsverwaltung.frmAuswertungsParameter.get_where"/>
|
|
<MSHelp:Keyword Index="F" Term="frmAuswertungsParameter.get_where"/>
|
|
<MSHelp:Keyword Index="F" Term="Vertragsverwaltung.frmAuswertungsParameter.frmAuswertungsParameter.get_where"/>
|
|
<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(" ");
|
|
}
|
|
}
|
|
</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> </TD>
|
|
</TR>
|
|
</TABLE>
|
|
</div>
|
|
<div id="TitleRow">
|
|
<H1 class="dtH1"><A NAME="topic_0000000000000D23"></A>frmAuswertungsParameter.get_where -Methode</H1>
|
|
</div></div>
|
|
<!--NONSCROLLING BANNER END-->
|
|
|
|
<DIV id="nstext" valign="bottom"><!---->
|
|
|
|
|
|
|
|
|
|
|
|
<PRE class="syntax"><SPAN class="lang">[Visual Basic]
|
|
</SPAN><B>Private Function get_where( _ <br> ByVal <i>nr</i> As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a> _ <br>) As <a href="ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic.htm">String</a></B></PRE>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<H4 class="dtH4">Parameter</H4>
|
|
<dl>
|
|
<dt><i>nr</i></dt>
|
|
<dd></dd>
|
|
|
|
</dl>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<H4 class="dtH4">Quellcode</H4>
|
|
<pre class="code"><SPAN class="lang">[Visual Basic]</SPAN>
|
|
Private Function get_where(ByVal nr As Integer) As String <br> Dim param As New ComboBox <br> Dim op As New ComboBox <br> Dim val As New ComboBox <br> <br> l.Clear() <br> Dim feld As String <br> Dim dr As DataRow <br> feld = "cbparam" + Trim(Str(nr)) <br> Me.GetControl(Me, feld, l) <br> param = l.Item(0) <br> <br> l.Clear() <br> feld = "cbop" + Trim(Str(nr)) <br> Me.GetControl(Me, feld, l) <br> op = l.Item(0) <br> <br> l.Clear() <br> feld = "cbvalue" + Trim(Str(nr)) <br> Me.GetControl(Me, feld, l) <br> val = l.Item(0) <br> <br> dr = Me.Findrow(param.Text) <br> <br> Dim wertvalue As String = "" <br> Dim wertdbfeld As String = "" <br> Dim wertop As String = op.Text <br> <br> wertop = op.Text <br> <br> Dim paramtyp As String = "" <br> Dim paramsplit() As String = dr.Item("Paramtype").ToString.Split(";") <br> <br> Dim dbfeldsplit() As String = dr.Item("dbfeldname").ToString.Split(";") <br> If dbfeldsplit.Length > 1 And val.SelectedIndex > -1 Then <br> wertvalue = val.SelectedValue <br> wertdbfeld = dbfeldsplit(0) <br> paramtyp = paramsplit(0) <br> Else <br> wertvalue = val.Text <br> If dbfeldsplit.Length > 1 Then <br> wertdbfeld = dbfeldsplit(1) <br> paramtyp = paramsplit(1) <br> Else <br> wertdbfeld = dbfeldsplit(0) <br> paramtyp = paramsplit(0) <br> End If <br> End If <br> <br> <br> <br> <br> <br> <br> <br> Select Case UCase(paramtyp) <br> Case "VARCHAR", "STRING", "CHAR" <br> Return wertdbfeld + " " + wertop + " '" + wertvalue + "'" <br> Case "INTEGER", "INT" <br> Return wertdbfeld + " " + wertop + " " + wertvalue + "" <br> Case "DATUM" <br> Return wertdbfeld + " " + wertop + " '" + wertvalue + " 00:00:00'" <br> Case "DATUM+1" <br> Dim d As DateTime = wertvalue <br> d = DateAdd(DateInterval.Day, 1, d) <br> wertvalue = d.ToString <br> Return wertdbfeld + " " + wertop + " '" + wertvalue + " 00:00:00'" <br> Case "BOOLEAN" <br> If UCase(wertvalue) = "TRUE" Or UCase(wertvalue) = "JA" Then <br> Return wertdbfeld + " " + wertop + " 1" <br> Else <br> Return wertdbfeld + " " + wertop + " 0" <br> End If <br> Case Else <br> <br> End Select <br> <br> End Function
|
|
</pre>
|
|
|
|
|
|
|
|
<H4 class="dtH4">Forderungen</H4>
|
|
<P><b class="le">Plattformen: </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_0000000000000D14.html">frmAuswertungsParameter</a>
|
|
|
|
|
|
|
|
|
|
|
|
</p>
|
|
|
|
|
|
<DIV CLASS="footer">
|
|
<HR>
|
|
Generated by VBdocman .NET
|
|
<p>
|
|
</div></div>
|
|
</BODY>
|
|
</HTML>
|
|
|