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
|
Public Sub affichage_dgv_act()
dgv_art_act.Rows.Clear()
'Instancier un objet Commande
Obj_Command = New OleDbCommand()
'initialiser l'objet Command
Obj_Command.Connection = laConnection
Obj_Command.CommandText = "SELECT TYPE_ART_ID,TYPE_REF_FOURN,TYPE_REF_CONST,TYPE_ART_LIB,TYPE_ART_PV_HT,TYPE_ART_ECO_PART,TAXE_TAUX,TYPE_ART_PV_TTC,TYPE_ART_PA,TYPE_ART_QTE FROM TYPE_ARTICLE,TAXE WHERE TYPE_ARTICLE.TAXE_ID=TAXE.TAXE_ID AND TYPE_ART_TYP='Actuel' AND (TYPE_REF_FOURN LIKE '" + Replace(tbx_art_rec_act_ref.Text, "'", "''") + "%' OR TYPE_REF_FOURN IS NULL) AND (TYPE_REF_CONST LIKE '" + Replace(tbx_art_rec_act_rec.Text, "'", "''") + "%' OR TYPE_REF_CONST IS NULL) AND (TYPE_ART_LIB LIKE '" + Replace(tbx_art_rec_act_design.Text, "'", "''") + "%' OR TYPE_ART_LIB IS NULL) AND (TYPE_ART_PV_HT LIKE '" + Replace(tbx_art_rec_act_ht.Text, "'", "''") + "%' OR TYPE_ART_PV_HT IS NULL) AND (TYPE_ART_ECO_PART LIKE '" + Replace(tbx_art_rec_act_ecopart.Text, "'", "''") + "%' OR TYPE_ART_ECO_PART IS NULL) AND (TAXE_TAUX LIKE '" + Replace(tbx_art_rec_act_tva.Text, "'", "''") + "%' OR TAXE_TAUX IS NULL) AND (TYPE_ART_PV_TTC LIKE '" + Replace(tbx_art_rec_act_ttc.Text, "'", "''") + "%' OR TYPE_ART_PV_TTC IS NULL) AND (TYPE_ART_QTE LIKE '" + Replace(tbx_art_rec_act_qte.Text, "'", "''") + "%' OR TYPE_ART_QTE IS NULL)"
Obj_Reader = Obj_Command.ExecuteReader()
While Obj_Reader.Read()
If Obj_Reader.GetValue(3).ToString().Contains(tbx_art_rec_act_design.Text) = True Then
dgv_art_act.Rows.Add(Obj_Reader.GetValue(0).ToString(), Obj_Reader.GetValue(1).ToString(), Obj_Reader.GetValue(2).ToString(), Obj_Reader.GetValue(3).ToString(), toMoney(Obj_Reader.GetValue(4).ToString()), toMoney(Obj_Reader.GetValue(5).ToString()), toPercent(Obj_Reader.GetValue(6).ToString()), toMoney(Obj_Reader.GetValue(7).ToString()), toMoney(Obj_Reader.GetValue(8).ToString()), Obj_Reader.GetValue(9).ToString())
End If
End While
Obj_Reader.Close()
End Sub
'Fonctions de recherche dans le DataGridView des articles actuels
Private Sub tbx_art_rec_act_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tbx_art_rec_act_ref.TextChanged, tbx_art_rec_act_rec.TextChanged, tbx_art_rec_act_design.TextChanged, tbx_art_rec_act_ht.TextChanged, tbx_art_rec_act_ecopart.TextChanged, tbx_art_rec_act_tva.TextChanged, tbx_art_rec_act_ttc.TextChanged, tbx_art_rec_act_qte.TextChanged
affichage_dgv_act()
lbl_nb_art.Text = dgv_art_act.RowCount
End Sub |
Partager