c# group by list

標籤：color   val   ring   rto   sel   erb   value   span   list   

 ViewBag.PnlTotal = pnlTotal;            // 直條圖            string data = "";            string cat = "";            string buyOrderTotalOrderAmount = "";            var r = listReports.OrderBy(p => p.DateRange).ThenBy(p => p.VendorID).GroupBy(g => g.DateRange).Select(g =>              new PnlDiagram              {                  Key = g.Key,                  Value = string.Join(",", g.Select(c => c.VendorTotalPnL)),                  BuyOrderTotalOrderAmount=string.Join(",",g.Select(p=>p.BuyOrderTotalOrderAmount)),                  Partner = string.Join(",", g.Select(c => c.VendorID))              });                       foreach (var item in r)            {                cat = item.Partner;                data += "name:" + item.Key + "#data:[" + item.Value + "];";                buyOrderTotalOrderAmount += "name:" + item.Key + "#data:[" + item.BuyOrderTotalOrderAmount + "];";            }            ViewBag.CatNew = cat;            ViewBag.DataNew = data;            ViewBag.BuyOrderTotalOrderAmount = buyOrderTotalOrderAmount;            return PartialView("PNLReport_Partial", listReports);

結果

 

@{
ViewBag.Title = "PNLReport_Diagram";
Layout = null;
var CatNew = Html.Raw(ViewBag.CatNew);
var DataNew= Html.Raw(ViewBag.DataNew);
}

c# group by list