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
| Private Sub RequeteAjoutPcHistorique()
Dim Status As Int32
Dim Motif As String
If Me.TB_SecId.Text = "" Then
Status = 0
Motif = "Reception de la commande"
Else
Status = 1
Motif = "Mise en stock du PC"
End If
If Me.TB_SecId.Text = "" Then
MsgBox("Attention veuillez remplir le champs SecID")
Exit Sub
Else
maCmd = maCnx.CreateCommand
maCmd.CommandType = CommandType.StoredProcedure
maCmd.CommandText = "PS_PC_Insert_Historique2"
Try
'Creation et déclaration des parmétres
With maCmd.Parameters
.Add(New SqlParameter("@SecID", SqlDbType.NChar, 20))
.Add(New SqlParameter("@Serial", SqlDbType.NChar, 20))
.Add(New SqlParameter("@Date_Acte", SqlDbType.DateTime))
.Add(New SqlParameter("@Motif", SqlDbType.VarChar, 500))
.Add(New SqlParameter("@AncienStatus", SqlDbType.Int))
.Add(New SqlParameter("@NouveauStatus", SqlDbType.Int))
.Add(New SqlParameter("@User", SqlDbType.NChar, 10))
End With
'Attribution des valeurs aux paramètres
With maCmd
.Parameters("@SecID").Value = TB_Serial.Text
.Parameters("@Serial").Value = TB_Serial.Text
.Parameters("@Date_Acte").Value = TB_DateLivraison.Text
.Parameters("@Motif").Value = motif
.Parameters("@AncienStatus").Value = "0"
.Parameters("@NouveauStatus").Value = Status
.Parameters("@User").Value = "stock"
End With
Catch ex As Exception
MsgBox("Erreur retournée : " & ex.ToString)
End Try
'Try
'Creation et déclaration des parmètres
' maCmd.Parameters.Add(New SqlParameter("@SecID", SqlDbType.NVarChar, 20))
' maCmd.Parameters("@SecID").Value = Me.TB_SecId.Text
'Catch ex As Exception
'MsgBox("Erreur retournée : " & ex.ToString)
'End Try
Try
'Execution de la requete
maCmd.ExecuteNonQuery()
Catch ex As SqlException
MsgBox("Erreur retournée : " & ex.ToString)
End Try
End If
End Sub |
Partager