110,545
社区成员
发帖
与我相关
我的任务
分享
dt.Rows.Cast<DataRow>()
.GroupBy((t) => new { ID = (int)t["ID"], Name = (string)t["Name"], Alarm = (bool)t["Alarm"] == true })
.Select((g) => new { g.Key.ID, g.Key.Name, ACount = g.Sum((t) => (decimal)t["ACount"]), BCount = g.Sum((t) => (decimal)t["BCount"]), CCount = g.Sum((t) => (decimal)t["CCount"]), Date = g.Min((t) => (DateTime)t["Date"]) });
dt.Rows.Cast<DataRow>()
.GroupBy((t) => new { ID = (int)t["ID"], Name = (string)t["Name"], Alarm = (bool)t["Alarm"] == true })
.Select((g) => new { g.Key.ID, g.Key.Name, ACount = g.Sum((t) => (decimal)t["ACount"]), BCount = g.Sum((t) => (decimal)t["BCount"]), CCount = g.Sum((t) => (decimal)t["CCount"]), Date = g.Min((t) => (decimal)t["Date"]) });
dt.Rows.Cast<DataRow>()
.GroupBy((t) => new { ID = (int)t["ID"], Name = (string)t["Name"], Alarm = (bool)t["Alarm"] == true })
.Select((g) =>
{
DataRow dr = permissionTable.NewRow();
dr["ID"] = g.Key.ID;
dr["Name"] = g.Key.Name;
dr["ACount"] = g.Sum((t) => (decimal)t["ACount"]);
dr["BCount"] = g.Sum((t) => (decimal)t["BCount"]);
dr["CCount"] = g.Sum((t) => (decimal)t["CCount"]);
dr["Date"] = g.Min((t) => (DateTime)t["Date"]);
dr["Alarm"] = g.Key.Alarm;
return dr;
});