var query1 =
(from a in dtFollow.AsEnumerable()
from x in dtLis.AsEnumerable()
where a.Field<string>("IDNumber") == x.Field<string>("IDCardNumber")
select new
{
PatListID = a["PatListID"],
PatName = a["PatName"].ToString(),
Mobile = a["Mobile"],
PatRoute = a["PatRoute"],
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"],
followId = a["FollowId"],
MemberId = a["MemberId"],
CureDeptID = a["CureDeptID"],
RegDeptID = a["RegDeptID"],
Result = x == null ? "" : x["Result"],
Testtime = x == null ? "" : x["Testtime"],
IdCardNumber = x == null ? "" : x["IdCardNumber"]
}).ToList();
dtAll = ConvertDataExtend.ToDataTable(query1);
C# linq join两个datatable
最新推荐文章于 2023-04-03 21:37:15 发布