8,497
社区成员
发帖
与我相关
我的任务
分享
System.Collections.Generic.IEnumerable<DataRow> query;
DataTable dt = new DataTable();
query.ToList().ForEach((dr) => dt.ImportRow(dr));
DataView dv = dt.DefaultView;
EnumerableRowCollection <Temp> query =
from TsUp in Dt.AsEnumerable()
join TsM in DtM.AsEnumerable() on TsUp.Field <string> ( "MenuID ") equals TsM.Field <string> ( "MenuID ") into TsMJoin
from TsMJoinT in TsMJoin.DefaultIfEmpty()
join TsU in DtU.AsEnumerable() on TsUp.Field <string> ( "UserID ") equals TsU.Field <string> ( "UserID ") into TsUJoin
from TsUJoinT in TsUJoin.DefaultIfEmpty()
select new Temp
{
UserID=TsUp.Field <string> ( "UserID "),
MenuID = TsUp.Field <string> ( "MenuID "),
Purview = TsUp.Field <string> ( "Purview "),
UserName = TsUJoinT.Field <string> ( "UserName "),
MenuPath = TsMJoinT.Field <string> ( "MenuPath "),
SortID = TsMJoinT.Field <string> ( "SortID ")
};
class Temp
{
public string UserID{get;set;}
public string MenuID {get;set;}
public string Purview {get;set;}
public string UserName {get;set;}
public string MenuPath {get;set;}
public string SortID {get;set;}
}