Linq - Sum()

最新推荐文章于 2021-09-29 00:06:22 发布

GuanXX

最新推荐文章于 2021-09-29 00:06:22 发布

阅读量3k

点赞数

分类专栏： C# 文章标签： linq filter list

本文链接：https://blog.csdn.net/guanxx/article/details/4551728

版权

C# 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

VS 2005:

Func<DataRow, decimal> filter = delegate(DataRow row)
                                                  {
                                                      if (row["dgvColumnItemId"].ToString() == itemId)
                                                          return (decimal)row["dgvColumnQty"];
                                                      return 0;
                                                  };

decimal totalQty = Enumerable.Sum<DataRow>(tripGlobal.curUserRows, filter);

decimal totalQty = Enumerable.Sum<DataRow>(tripGlobal.curUserRows, delegate(DataRow row)
                                                  {
                                                      if (row["dgvColumnItemId"].ToString() == itemId)
                                                          return (decimal)row["dgvColumnQty"];
                                                      return 0;
                                                  });

如果要查询DataTable.Rows的结果，视乎要把row放到一个list中.然后用list做TSource。

VS 2008:

decimal total = dataTable.AsEnumerable().Where(row => row["dgvColumnItemId"].ToString() == itemId).Sum(row => (decimal)row["dgvColumnQty"]);

decimal totalQty = (from DataRow row in dataTable.Rows
                               where row["dgvColumnItemId"].ToString() == itemId
                               select new
                               {
                                      qty = row["dgvColumnQty"]
                               }).Sum(a => Convert.ToDecimal(a.qty));