Linq语句分组后再根据不同条件查询出对应的数据

一个简单例子：Linq语句分组后再根据不同条件查询出对应的数据

  var PickSumList = KTPR.KD_T_PickSummaryList.GroupBy(p => new { p.CSOCode, p.OCInvCode, p.OCInvName, p.TCQuantity, p.JHInvCode, p.JHInvName, p.JHcWhCode,p.CDefine1 })
                            .Select(g => new
                    {
                        CSOCode = g.Key.CSOCode,
                        OCInvCode = g.Key.OCInvCode,
                        OCInvName = g.Key.OCInvName,
                        TCQuantity = g.Key.TCQuantity,
                        JHInvCode = g.Key.JHInvCode,
                        JHInvName = g.Key.JHInvName,
                        JHcWhCode = g.Key.JHcWhCode,
                        JHQuantity = g.Sum(t => t.JHQuantity),
                        JHBatch= g.Where(p=>p.CDefine1=="1").Select(p=>p.JHBatch).FirstOrDefault()           
                    }).ToList();