Jobject 与 JArray 的使用

 

将服务端返回的JSON 明细数据，进行分组和明细共同显示

JArray ja = JArray.Parse(result);

//分组

var r = ja.Children().GroupBy(v => v["stime"]).Select(g => new { date = (string)g.Key, money = g.Sum(item => (decimal)item["collectionPrice"]) });

JArray newResult = new JArray();
foreach (var item in r)
{
JObject jo = new JObject() {
new JProperty("date",item.date),
new JProperty("money",item.money),
new JProperty("child",new JArray(ja.Children().Where(a=>(string)a["stime"]==item.date)))
};
newResult.Add(jo);
}

//排序

var AAA = new JArray(ja.Children().OrderByDescending(W => W["date"]));
return AAA.ToString();

 

new JProperty("data", data)

/// data:string int...基本类型 jobject jarray ....
/// 不可以接收实体/集合 可以通过 JObject.FromObject 或JArray.FromObject 转成jobject jarray 传入