1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| public static List<PrestationInfo> GetListAnalysePrestationFiltree(string Prestataire, string Tiers, string Activite, DateTime Deb_Periode, DateTime Fin_Periode
, int Duree_Min,int Duree_Max, bool Facturable, string Etat, string Remarque)
{
return (from table in ManagerBD.ContexteDonnees.Prestations
where table.Debut > Deb_Periode && table.Debut < Fin_Periode && table.Prestataires.Nom == Prestataire &&
table.Tiers.Nom == Tiers && table.Activites.Nom == Activite && table.Facturable == Facturable && table.Remarque == Remarque
select new PrestationInfo
{
NumClient = table.Tiers.NumClient,
NomClient = table.Tiers.Nom,
NumPrestation = table.NumPrestation,
Remarque = table.Remarque,
Debut = table.Debut,
Fin = table.Fin,
NomActivite = table.Activites.Nom,
NumActivite = table.Activites.NumActivite,
NomMission = table.Missions.Nom,
NomPrestataire = table.Prestataires.Nom
}).ToList();
} |
Partager