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
| For k = 0 To nbrref - 1
requete2 = "select count(distinct kanban) from BOM where PN='" & ListBox2.Items.Item(k) & "' and process='Joint';"
requete3 = "select distinct kanban from BOM where PN='" & ListBox2.Items.Item(k) & "' and process='Joint';"
Dim mycommand2 As New MySqlClient.MySqlCommand(requete2, oConn)
Dim mycommand3 As New MySqlClient.MySqlCommand(requete3, oConn)
mycommand2.ExecuteNonQuery()
mycommand3.ExecuteNonQuery()
Dim dr3 As MySqlClient.MySqlDataReader
'retourner le nombre de joints vérifiant la condition
compteur = mycommand2.ExecuteScalar
dr3 = mycommand3.ExecuteReader()
'déclaration d'un tableau pour contenir les codes kanban des joints
Dim tab(compteur - 1) As String
'remplissage du tableau
While (dr3.Read())
ListBox10.Items.Add(dr3.GetValue(l))
End While
dr3.Close()
For i = 0 To compteur - 1
tab(i) = ListBox10.Items.Item(i)
Next
'comparaison de la liste des joints totale avec les joints relatifs uniquement à la réference en cours
For m = 0 To nbrj
For n = 0 To compteur - 1
If ListBox3.Items.Item(m) = tab(n) Then
matrice(m, k) = 1
Else
matrice(m, k) = 0
End If
Next
Next
Next |
Partager