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
|
Dim HeureDebutCuis1, HeureDebutCuis2, HeureDebutCuis3, HeureDebutAss1, HeureDebutAss2, HeureDebutAss3, HeureDebutLiv1, HeureDebutLiv2, HeureDebutLiv3, HeureDebutLiv4, HeureDebutLiv5, HeureDebutLiv6, HeureDebutLiv7, HeureDebutLiv8 As DateTime
Dim HeureFinC1, HeureFinC2, HeureFinC3, HeureFinA1, HeureFinA2, HeureFinA3, HeureFinL1, HeureFinL2, HeureFinL3, HeureFinL4, HeureFinL5, HeureFinL6, HeureFinL7, HeureFinL8 As DateTime
Private Sub RemplirPrestation(ByVal DatePrestation As DateTime, ByVal dispo As Integer)
Dim Employe As Integer
Dim HeureDebAss, HeureFinA, HeureAccueil As String
MonJeuDeDonnees.Tables.Clear()
MaRequete = "Select Employe.identifiant from Employe,EstDispo where Employe.identifiant = EstDispo.identifiant and fonction = 'Accueil' and dispo = " & dispo & ""
MaCommandeSpecialRequete.CommandText = MaRequete
MonRemplisseur.SelectCommand = MaCommandeSpecialRequete
MonRemplisseur.Fill(MonJeuDeDonnees, "MesAccueilsDispos")
For cnt = 1 To NbAccueil
Employe = MonJeuDeDonnees.Tables("MesAccueilsDispos").Rows(cnt - 1).Item(0)
HeureDebAss = "HeurDebAss" & cnt
HeureFinA = "HeureFinA" & cnt
HeureAccueil = "HeureAccueil" & cnt
DateCa = DateCa.Date
MaRequete = "Insert into Prestation Values (" & DateCa & "," & dispo & "," & Employe & "," & HeureDebAss & "," & HeureFinA & ", " & HeureAccueil & ")"
MaCommandeSpecialRequete.CommandText = MaRequete
MaCommandeSpecialRequete.ExecuteNonQuery() |
Partager