var query = from a in MasterDataHelper.OrganizationTree.AsEnumerable()
where
a.Field<string>("ID") == dr["Company"].ToString()
&& a.Field<string>("Type") == "C"
select a;
if (query != null)
{
DataTable dt = query.AsDataView().ToTable();
if (dt.Rows.Count > 0)
dr["Company"] = dt.Rows[0]["Name"];
}
上面是筛选代码
var order = from a in dtCompanyStatistics.AsEnumerable()
orderby a.Field<int>("Num") descending
select a;
dtCompanyStatistics = order.AsDataView().ToTable();
上面是排序代码