111,097
社区成员




var result = from r in dt.AsEnumerable()
group r by r.Field<string>("规格型号").Replace(" ", "") into g
where g.Count() > 1
select g;
//遍历分组结果集
foreach (var item in result)
{
DataRow[] dr_finds = dt.Select("规格型号='" + item.Key + "' ");
foreach (DataRow dr in dr_finds)
{
DataRow drNew = dtSorted.NewRow();
drNew["代码"] = dr["代码"];
//drNew["名称"] = dr["名称"];
//drNew["全名"] = dr["全名"];
//drNew["规格型号"] = dr["规格型号"];
dtSorted.Rows.Add(drNew);
}
}
var result = (from r in dt.AsEnumerable()
group r by new
{
code = r.Field<string>("代码"),
name = r.Field<string>("名称"),
exname = r.Field<string>("全名"),
gtype = r.Field<string>("规格型号")
} into g
select new
{
code = g.Key.code,
name = g.Key.name,
exname = g.Key.exname,
gtype = g.Key.gtype
} into c
where c.gtype.Count() > 1
select c).ToList();
foreach (var q in result)
{
DataRow[] dr_finds = dt.Select("代码='" + q.code + "' and 名称='" + q.name + "' and 全名='" + q.exname + "' and 规格型号 ='" + q.gtype + "' ");
foreach (DataRow dr in dr_finds)
{
DataRow drNew = dtSorted.NewRow();
drNew["代码"] = dr["代码"];
drNew["名称"] = dr["名称"];
drNew["全名"] = dr["全名"];
drNew["规格型号"] = dr["规格型号"];
dtSorted.Rows.Add(drNew);
}
}
group r by new {
r.Field<string>("规格型号").Replace(" ", ""),
r.Field<string>("其它").Replace(" ", "")
}