var query =
(from a in dtFollow.AsEnumerable()
join b in dtLis.AsEnumerable() on a.Field<string>("IDNumber") equals b.Field<string>("IDCardNumber") into abjoin
from x in abjoin.DefaultIfEmpty()
select new
{
PatListID = a["PatListID"],
PatName = a["PatName"].ToString(),
Mobile = a["Mobile"],
ItemID = a["ItemID"],
ItemName = a["ItemName"],
surPlusdays = a["surPlusdays"],
PresHeadID = a["PresHeadID"],
PresDetailID = a["PresDetailID"],
IDNumber = a["IDNumber"],
follower = a["follower"],
followInfo = a["followInfo"],
followTime = a["followTime"],
Result = x == null ? "" : x["Result"],
Testtime = x == null ? "" : x["Testtime"],
IdCardNumber = x == null ? "" : x["IdCardNumber"]
}).ToList();
dtAll = ConvertDataExtend.ToDataTable(query);
}
C# linq left join两个datatable
于 2022-03-29 14:10:52 首次发布