List<Object> 使用Linq

 List<Asset> bdList = allAsset.Where(m => m.Owner.Depts == view.DeptName).ToList();
                    var query = from item in bdList
                                group item by new
                                {
                                    mainName = item.MainCategory.Name,
                                    subName = item.SubCategory.Name,
                                    assetName = item.Name,
                                    stateName = item.State.Name
                                }
                                    into gp
                                    select new
                                    {
                                        MainCategory = gp.First().MainCategory.Name,
                                        SubCategory = gp.First().SubCategory.Name,
                                        AssetName = gp.First().Name,
                                        StateName = gp.First().State.Name,
                                        CostTotal = gp.Sum(m => m.Cost)
                                    };

 

posted @ 2016-07-18 17:03  lishidefengchen  阅读(505)  评论(0编辑  收藏  举报