集合中取出列名相同的，并把其他列的值合并成数组

需求：有这样一个集合
List<User> lst = new List<User>{
new User{ name="zhangsan",YFYE=2.1D,XFSJ=4.2D },
new User{ name="zhangsan",YFYE=2.2D,XFSJ=4.3D },
new User{ name="zhangsan",YFYE=2.3D,XFSJ=4.4D },
new User{ name="lisi",YFYE=2.2D,XFSJ=4.3D },
new User{ name="lisi",YFYE=2.3D,XFSJ=4.4D },
new User{ name="lisi",YFYE=2.4D,XFSJ=4.5D },
new User{ name="lisi",YFYE=2.5D,XFSJ=4.6D }
};
把name相同的数据的YFYE的字段拼成一个数组。然后转成Json
例如：{“name”:”zhangsan”,”datas”:[2.1,2.2,2.3]}
代码如下：

        public static void Test()        {            List<User> lst = new List<User>{                            new User{ name="zhangsan",YFYE=2.1D,XFSJ=4.2D },                            new User{ name="zhangsan",YFYE=2.2D,XFSJ=4.3D },                            new User{ name="zhangsan",YFYE=2.3D,XFSJ=4.4D },                            new User{ name="lisi",YFYE=2.2D,XFSJ=4.3D },                            new User{ name="lisi",YFYE=2.3D,XFSJ=4.4D },                            new User{ name="lisi",YFYE=2.4D,XFSJ=4.5D },                            new User{ name="lisi",YFYE=2.5D,XFSJ=4.6D }                           };            List<NewModel> lstNewModel = new List<NewModel>();            //这里可能有简单的方法，我没研究过            List<User> lstFirst = null;            //取出name种类            var query = from newlist in lst group newlist by newlist.name into g select g;            //分组的数量            var iCount = query.Count();            foreach (var item in query)            {                lstFirst = new List<User>();                //每个集合的长度                for (int i = 0; i < lst.Count; i++)                    if (lst[i].name == item.Key)                        lstFirst.Add(lst[i]);                NewModel model = new NewModel();                model.name = item.Key;                //把得到的全部放到数组中                var data=new double[lstFirst.Count];                for (int i = 0; i < lstFirst.Count; i++)                {                    data[i] = lstFirst[i].YFYE;                }                model.datas = data;                //当前数据已获取                lstNewModel.Add(model);            }            JavaScriptSerializer serializer = new JavaScriptSerializer();            Console.WriteLine(serializer.Serialize(lstNewModel));        }

测试结果如下：

欢迎加入技术交流群（169767436）这里有各种大神共同帮你解决问题。