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
|
var results = from table1 in GetTable2().AsEnumerable()
join table2 in GetTable1().AsEnumerable() on (int)table1["NumeroBug"] equals (int)table2["NumeroBug"]
join table3 in GetTable3().AsEnumerable() on (int)table1["NumeroBug"] equals (int)table3["NumeroBug"]
where table2["Vers"].ToString() == "CS CAP GEMINI"
where table1["Severite"].ToString() == valeur
where (table3["NouveauStatut"].ToString().Contains("fermé")) || (table3["NouveauStatut"].ToString().Contains("affecté"))
select new
{
NumeroBug = (int)table1["NumeroBug"],
Projet = (String)table1["projet"],
Severite = (String)table1["Severite"],
DateModification = (DateTime)table3["dateModification"],
statut = (String)table3["NouveauStatut"],
};
table.Columns.Add(NumeroBugColumn);
table.Columns.Add(projetColumn);
table.Columns.Add(SeveriteColumn);
table.Columns.Add(dateModificationColumn);
table.Columns.Add(NouveauStatutColumn);
foreach (var item in results)
{
DataRow dr = table.NewRow();
dr["Numero bug"] = item.NumeroBug;
dr["Projet"] = item.Projet;
dr["Severite"] = item.Severite;
dr["Date"] = item.DateModification;
dr["Statut"] = item.statut;
table.Rows.Add(dr);
} |
Partager