8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from a in db.MM_STORAGE_TYPE
join b in db.MM_SAVETYPE on a.STORAGE_TYPE equals b.type
where
(
a.WERKS.Contains(DropDownList_WERKS.SelectedItem.Value) &&
a.LGORT.Contains(DropDownList_LGORT.SelectedItem.Value)
)
select new
{
STORAGE_TYPE = a.STORAGE_TYPE,
STORAGE_TYPE_NAME = b.descride,
NEGAT = b.negetive
};
var other = from b in db.MM_SAVETYPE
where !(from t1 in query select t1.STORAGE_TYPE).Contains(b.type)
select b;
other.ToList()
先查一个var 虚对象出来,再用结果加入第二个查询查不同的数据出来, other.ToList()是到数据库取数据了。。。。。