8,497
社区成员
发帖
与我相关
我的任务
分享
var distinctfirst = (from DataRow dr in dt.Rows
select new Temp{
id = dr[btsqlist.Fields["身份证号"].InternalName],
shebaohao =dr[btsqlist.Fields["社保号"].InternalName],
money =dr[btsqlist.Fields["金额"].InternalName]
}).Distinct(new TempDataRowComparer())
.Sum(t=>t.money);
public class TempDataRowComparer : IEqualityComparer<Temp>
{
public bool Equals(Temp t1, Temp t2)
{
return (t1.id == t2.id && t1.shebaohao == t2.shebaohao);
}
public int GetHashCode(Temp t)
{
return t.ToString().GetHashCode();
}
}
public Class Temp
{
public int id{get;set;}
public string shebaohao {get;set;}
public double money{get;set}
}
//提供思路参考