[FogBugz #119] mTryInteger : Tester les valeurs Null #181

Open
opened 2023-07-03 23:37:15 +02:00 by fbenoist68 · 4 comments

Assigned To: Frederik Benoist
Project: CAISSE
Area: awcaisse
Category: Fonctionnalité
Priority: Ce serait bien !

Assigned To: Frederik Benoist Project: CAISSE Area: awcaisse Category: Fonctionnalité Priority: Ce serait bien !
Poster
Owner

Event ID: 504
Date: 2013-03-28T14:52:59Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 504 Date: 2013-03-28T14:52:59Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
Poster
Owner

Event ID: 503
Date: 2013-03-28T14:51:42Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

cDataReader.vb

Public Function mTryGetInteger(ByVal nomChamp As String) As Nullable(Of Integer) Implements iReader.mTryGetInteger

Dim pos As Integer = mLireIndexColonne(nomChamp)

If (pos <> -1) Then

If vReader.GetFieldType(pos).Name.Equals("Decimal") Then

    if vReader.isDbNull(pos) then
        return 0
    else

        Return CType(vReader.GetDecimal(pos), Global.System.Nullable(Of Integer))

    end if

End If

Return vReader.GetInt32(pos)

End If

Return Nothing

End Function

Event ID: 503 Date: 2013-03-28T14:51:42Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> cDataReader.vb</p> <p> Public Function mTryGetInteger(ByVal nomChamp As String) As Nullable(Of Integer) Implements iReader.mTryGetInteger</p> <p> Dim pos As Integer = mLireIndexColonne(nomChamp)</p> <p> If (pos &lt;&gt; -1) Then</p> <p> If vReader.GetFieldType(pos).Name.Equals(&quot;Decimal&quot;) Then</p> <p> &nbsp;&nbsp;&nbsp; <strong>if vReader.isDbNull(pos) then<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return 0<br /> &nbsp;&nbsp;&nbsp;&nbsp;else</strong></p> <p> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return CType(vReader.GetDecimal(pos), Global.System.Nullable(Of Integer))</p> <p> &nbsp;&nbsp;&nbsp; <strong>end if </strong></p> <p> End If</p> <p> Return vReader.GetInt32(pos)</p> <p> End If</p> <p> Return Nothing</p> <p> End Function</p>
Poster
Owner

Event ID: 502
Date: 2013-03-28T14:43:33Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 502 Date: 2013-03-28T14:43:33Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
Poster
Owner

Event ID: 501
Date: 2013-03-28T14:43:33Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 501 Date: 2013-03-28T14:43:33Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Label
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#181
There is no content yet.