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
| Dim Message As String
Dim TitreMessage As String
Dim Bouton As MessageBoxButtons
Dim Icone As MessageBoxIcon
Dim Resultat As DialogResult
Message = "Atention vous n'aurez plus le droit de modifier ce rapport!!"
TitreMessage = "Avertissement"
Bouton = MessageBoxButtons.OKCancel
Icone = MessageBoxIcon.Question
Resultat = MessageBox.Show(Message, TitreMessage, Bouton, Icone)
Select Case Resultat
Case Windows.Forms.DialogResult.OK
con.Open()
cmd = New SqlCommand("insert into RprtValidé(n_rapport,n_ligne_rapport,semaine,id_pers,date_deb_dep,date_fin_dep,nom_clt,ville,libelle,prix) values('" & Me.DataGridView1.CurrentRow.Cells.Item(0).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(0).Value & "' , '" & Me.DataGridView1.CurrentRow.Cells.Item(1).Value & "' , '" & Me.txtdersonnel.Text & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(2).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(3).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(4).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(5).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(6).Value & "' , '" & Me.DataGridView2.CurrentRow.Cells.Item(7).Value & "')")
cmd.Connection = con
cmd.ExecuteNonQuery()
cmd = New SqlCommand("delete from fraisDeplacement where n_ligne_rapport='" & Me.DataGridView2.CurrentRow.Cells.Item(0).Value & "'")
cmd.Connection = con
cmd.ExecuteNonQuery()
cmd = New SqlCommand("delete from clients where n_ligne_rapport='" & Me.DataGridView2.CurrentRow.Cells.Item(0).Value & "'")
cmd.Connection = con
cmd.ExecuteNonQuery()
cmd = New SqlCommand("delete from ligneRapport where n_ligne_rapport='" & Me.DataGridView2.CurrentRow.Cells.Item(0).Value & "'")
cmd.Connection = con
cmd.ExecuteNonQuery()
cmd = New SqlCommand("delete from rapport where n_rapport='" & Me.DataGridView1.CurrentRow.Cells.Item(0).Value & "'")
cmd.Connection = con
cmd.ExecuteNonQuery()
MsgBox("voulez vous l'imprimer?", MsgBoxStyle.OkCancel)
Case Windows.Forms.DialogResult.Cancel
'et là je veux annuler l'exécution de ces commandes
End Select |
Partager