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
|
Dim rq = From element In GesBourseDataset.TransacView.AsEnumerable _
Where (element.StatuTrsc = "En attente") _
Select NomClt = If(element.IsNomCltNull, Nothing, element.NomClt), element.CodeClt, element.CodeCpteClt, element.CodeTrsc, element.NomTitre, TypeTrsc = If(element.IsTypeTrscNull, Nothing, element.TypeTrsc), StatuTrsc = If(element.IsStatuTrscNull, Nothing, element.StatuTrsc), DateTrsc = If(element.IsDateTrscNull, Nothing, element.DateTrsc), Score = DateDiff(DateInterval.Day, Now, If(element.IsDateTrscNull, Now, element.DateTrsc)) Order By Score Descending
Dim rwa As GesBourse.GesBourseDataSet.AttenteTRow
For Each lgn In rq
rwa = GesBourseDataset.AttenteT.NewAttenteTRow
rwa.CodeClt = lgn.CodeClt
If lgn.NomClt = Nothing Then
rwa.SetNomCltNull()
Else
rwa.NomClt = lgn.NomClt
End If
rwa.CodeCpteClt = lgn.CodeCpteClt
rwa.CodeTrsc = lgn.CodeTrsc
rwa.NomTitre = lgn.NomTitre
If lgn.TypeTrsc = Nothing Then
rwa.SetTypeTrscNull()
Else
rwa.TypeTrsc = lgn.TypeTrsc
End If
If lgn.StatuTrsc = Nothing Then
rwa.SetStatuTrscNull()
Else
rwa.StatuTrsc = lgn.StatuTrsc
End If
If lgn.DateTrsc = Nothing Then
rwa.SetDateTrscNull()
Else
rwa.DateTrsc = lgn.DateTrsc
End If
rwa.ScoreT1 = lgn.Score
GesBourseDataset.AttenteT.AddAttenteTRow(rwa)
End If
Next |
Partager