linq实现聚合分组

List<ChemicalInventory> listInventory = new List<ChemicalInventory>();

                    foreach (var item in response.EX_TAB)

                    {

                        ChemicalInventory Inventory = new ChemicalInventory();

                        Inventory.infocode = item.MATNR.ToString();//物料编号

                        Inventory.regioncode = item.LGORT.ToString();//对应工智道设施分区编码

                        Inventory.number = Convert.ToDouble(item.CLABS.ToString());//对应工智道设施分区编码

                        string matnr = item.MATNR.ToString();//物料编号

                        string lgort = item.LGORT.ToString();//对应工智道设施分区编码

                        string clabs = item.CLABS.ToString();//对应工智道数量

                        listInventory.Add(Inventory);

                    }

                    //手动添加一个相同编号相同区域的数据测试一下

                    //ChemicalInventory Inventory2 = new ChemicalInventory();

                    //Inventory2.infocode = "000000008000000001";

                    //Inventory2.regioncode = "1102";//对应工智道设施分区编码

                    //Inventory2.number = 100;//对应工智道设施分区编码

                    //listInventory.Add(Inventory2);

                    var groupList = listInventory.GroupBy(m => new { m.infocode, m.regioncode }).

                           Select(a => new

                           {

                               infocode = a.Key.infocode,

                               regioncode = a.Key.regioncode,

                               number = a.Sum(c => c.number)

                           }).ToList();

                    JsonSerializer serializer = new JsonSerializer();

                    StringWriter sw = new StringWriter();

                    serializer.Serialize(new JsonTextWriter(sw), groupList);

                    json = sw.GetStringBuilder().ToString();