日期:2014-05-20 浏览次数:20899 次
var query=from c in db.CataLogDetail
where (c.GroupID==1 && c.Comany==66)
&&(c.LB=="身份" && new string[]{"合同工"}.Contains(c.LM))
------解决方案--------------------
(c.LB=="学历" && new string[]{"本科"}.Contains(c.LM))
group c by new {c.bh,c.GroupID} into g
where g.Count()==2
select new
{
g.Key.bh,
g.Key.GroupID,
Expr1=g.Count()
};
//代码手打,提供思路参考