求ART002在此表中,有几个相同项即几行
var query = from p in tableView . AsEnumerable ( )
group p by new
{
p1 = p . Field<string> ( "ART002" )
} into m
select new
{
art002 = m . Key . p1 ,
count = m . Count ( )
};
求PRE008在此表中,同PRE002,PRE003,PRE004,PRE007的和
var query = from p in tableView . AsEnumerable ( )
group p by new
{
p1 = p . Field<string> ( "PRE002" ) ,
p2 = p . Field<string> ( "PRE003" ) ,
p3 = p . Field<string> ( "PRE004" ) ,
P4 = p . Field<int> ( "PRE007" )
} into m
let sum = m . Sum ( t => t . Field<int> ( "PRE008" ) )
orderby sum descending
select new
{
pre002 = m . Key . p1 ,
pre003 = m . Key . p2 ,
pre004 = m . Key . p3 ,
pre007 = m . Key . P4 ,
sum = sum
};