1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
|
Public Sub MajMateriel(ByVal IDmat As Integer, refMat As String, DesMat As String, LieuMat As String, MarQMat As String, ModMat As String, Idfou As Integer, IdMai As Integer, IdAmdec As Integer)
' Construction de la requête selon les variables renseignées
Dim R1str As String = "IDmateriel =" & CStr(IDmat)
Dim R2str As String = ""
Dim R3str As String = ""
Dim R4str As String = ""
Dim R5str As String = ""
Dim R6str As String = ""
Dim R7str As String = ""
Dim R8str As String = ""
Dim R9str As String = ""
If refMat = "" Then
R2str = ""
ElseIf refMat <> "" Then
R2str = " , RéferenceMat ='" & refMat & "'"
End If
If DesMat = "" Then
R3str = ""
ElseIf DesMat <> "" Then
R3str = " , DesignationMat ='" & DesMat & "'"
End If
If LieuMat = "" Then
R4str = ""
ElseIf LieuMat <> "" Then
R4str = " , LieuMat ='" & LieuMat & "'"
End If
If ModMat = "" Then
R5str = ""
ElseIf ModMat <> "" Then
R5str = " , ModeleMat ='" & ModMat & "'"
End If
If MarQMat = "" Then
R6str = ""
ElseIf MarQMat <> "" Then
R6str = " , MarqueMat='" & MarQMat & "'"
End If
If Idfou = 0 Then
R7str = ""
ElseIf Idfou <> 0 Then
R7str = " , Idfournisseur= " & CStr(Idfou)
End If
If IdMai = 0 Then
R8str = ""
ElseIf IdMai <> 0 Then
R8str = " , Idmaintenance = " & CStr(IdMai)
End If
If IdAmdec = 0 Then
R9str = ""
ElseIf IdAmdec <> 0 Then
R9str = " , Idamdec =" & CStr(IdAmdec)
End If
Dim Request = R1str & R2str & R3str & R4str & R5str & R6str & R7str & R8str & R9str
Dim Requete As String = " INSERT INTO Materiel SET " & request
Dim Slcommand As String = "SELECT * FROM Materiel"
Dim Cn As New Odbc.OdbcConnection
Dim Cnstring As String = "Dsn=localhost;uid=root"
Cn.ConnectionString = Cnstring
Dim Cmd As New Odbc.OdbcCommand(Requete, Cn)
Cn.Open()
Cmd.ExecuteNonQuery()
Cn.Close()
End Sub |
Partager