C#中LINQ的简单用法示例

 

业务场景：

对集合分组，求和

using System;
using System.Collections.Generic;
using System.Linq;

namespace Test
{
    class Program
    {
        static void Main(string[] args)
        {
            JhInfo jh01 = new JhInfo() { xmbh = "xm01", htbh = "ht01", name = "甲", amount = 11 };
            JhInfo jh02 = new JhInfo() { xmbh = "xm01", htbh = "ht01", name = "乙", amount = 6 };
            JhInfo jh03 = new JhInfo() { xmbh = "xm01", htbh = "ht02", name = "丙", amount = 9 };

            List<JhInfo> list = new List<JhInfo>();
            list.Add(jh01);
            list.Add(jh02);
            list.Add(jh03);

            // 对集合 按 xmbh 和 htbh 分组，对name多值拼接，对amount求和
            List<JhInfo> aa = list.GroupBy(x => new { x.xmbh, x.htbh }).Select(y => new JhInfo{ 
                xmbh = y.Key.xmbh,
                htbh = y.Key.htbh,
                name = string.Join(",", y.Select(x => x.name).ToArray()),
                amount = y.Sum(x => x.amount)
            }).ToList();

            foreach (JhInfo a in aa)
            {
                Console.WriteLine("name：【" + a.name + "】Count: 【" + a.amount + "】");
            }
            

            // 从集合查找
            JhInfo findOne = list.Find(x => x.name.Equals("甲"));
            List<JhInfo> findAll = list.FindAll(x => x.xmbh.Equals("xm01"));
        }
    }


    class JhInfo
    {
        public string xmbh { get; set; }
        public string htbh { get; set; }
        public string name { get; set; }
        public int amount { get; set; }
    }
}