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
|
Private Sub form_load()
Ouverture 'ouverture du B.D
with listview1.ColumnHeaders
.Add="Code Article"
.Add="Designation"
.Add="Quantité"
.Add="Prix Unitaire"
.view=3
end with
end sub
''''''''''''''
Private Sub Listview_load()
Dim L As ListItem
tm = 0 'total Mt
mt = Val(Text2) * Val(Text1)
tm = tm + mt
Set L = ListView1.ListItems.Add(, , Combo4)
L.SubItems(1) = Combo5
L.SubItems(2) = Text1
L.SubItems(3) = Text2
L.SubItems(4) = mt
end sub
'''''''''''''
Private Sub Ajout_Click()
va = MsgBox("Voulez_vous Vraiment Valider La Commande??", vbYesNo + vbInformation, "VALIDATION")
If va = 6 Then
SQL = "insert into contient(numc_cont, datec_cont, codea_cont, desig_cont, pu_cont, qtc_cont)" & _
" values('" & Combo1 & "' , #" & MaskEdBox1 & "# , '" & Combo4 & "' , '" & Combo5 & "' ," & _
" " & Text1 & " , " & Text2 & ")"
base.Execute SQL
Call Listview_load
Call Effacer1
End If
End Sub
'''''''''''''''
Private Sub ListView1_ItemClick(ByVal Item As MSComctlLib.ListItem)
Combo4 = ListView1.ListItems(item.Index) 'code Article
Combo5 = ListView1.ListItems(item.Index) 'Designation
Text2 = ListView1.ListItems(item.Index) 'Quantité
Text1 = ListView1.ListItems(item.Index) 'Prix unitaire
End Sub |
Partager