1 #region table去重复求和
2 var query = dt.Rows.Cast<DataRow>
()
3 .OrderByDescending(n => n[
"OPERATION_TIME"])
4 .GroupBy(
5 s =>
new
6 {
7 MATERIAL_CODE = Convert.ToString(s[
"MATERIAL_CODE"]),
8 MATERIAL_NAME = Convert.ToString(s[
"MATERIAL_NAME"]),
9 STORAGE_STYLE = Convert.ToString(s[
"STORAGE_STYLE"]),
10 STORAGE_SIGN = Convert.ToString(s[
"STORAGE_SIGN"])
11 })
12 .Select(group =>
new
13 {
14 group.Key.MATERIAL_CODE,
15 group.Key.MATERIAL_NAME,
16 group.Key.STORAGE_STYLE,
17 group.Key.STORAGE_SIGN,
18 REMARK = group.First().Field<
string>(
"REMARK"),
19 OPERATION_TIME = group.First().Field<
string>(
"OPERATION_TIME"),
20 STORAGE_NUM = group.Sum(x => Convert.ToInt32(x[
"STORAGE_NUM"]))
21 });
22
23 if (query.ToList().Count >
0)
24 {
25 dtNew =
dt.Clone();
26 query.ToList().ForEach(q =>
27 {
28 DataRow drNew =
dtNew.NewRow();
29 drNew[
"MATERIAL_CODE"] =
q.MATERIAL_CODE;
30 drNew[
"MATERIAL_NAME"] =
q.MATERIAL_NAME;
31 drNew[
"REMARK"] =
q.REMARK;
32 drNew[
"STORAGE_NUM"] =
q.STORAGE_NUM;
33 drNew[
"STORAGE_STYLE"] =
q.STORAGE_STYLE;
34 drNew[
"OPERATION_TIME"] =
q.OPERATION_TIME;
35 drNew[
"STORAGE_SIGN"] =
q.STORAGE_SIGN;
36 dtNew.Rows.Add(drNew);
37 });
38 }
39 #endregion
转载于:https://www.cnblogs.com/wqtmelo/p/7305244.html
相关资源：数据结构—成绩单生成器
