var query = from t in dtFin.AsEnumerable()
group t by new { t1 = t.Field<string>("保单号"), t2 = t.Field<string>("批单号"), t3 =t.Field<object>("保费金额") } into m
select new
{
amout = m.First().Field<object>("保费金额"),
pob = m.Key.t1,
pop = m.Key.t2,
rowcount = m.Count()
};
foreach (var q in query)
{
if (q.rowcount > 1)
group t by new { t1 = t.Field<string>("保单号"), t2 = t.Field<string>("批单号"), t3 =t.Field<object>("保费金额") } into m
select new
{
amout = m.First().Field<object>("保费金额"),
pob = m.Key.t1,
pop = m.Key.t2,
rowcount = m.Count()
};
foreach (var q in query)
{
if (q.rowcount > 1)
{
Response.Write(q.amout+"出现多次!");//出现多次。
}
}