求方法获取这个json 里面的值 最好写代码[{"order_info":{"order_id":"771","order_sn":"1314426223","type":"","extension":"normal","seller_id":"8026","seller_name":"","buyer_id":"8032","buyer_name":"1231","buyer_email":"[email protected]","status":"20","add_time":"1369447178","payment_id":"1","payment_name":"","payment_code":"","out_trade_sn":"","pay_time":"1369447181","pay_message":"","ship_time":null,"invoice_no":null,"finished_time":"0","goods_amount":"2324.00","discount":"100.00","order_amount":"2224.00","evaluation_status":"0","evaluation_time":"0","anonymous":"0","postscript":"","pay_method":"0","is_print":"0","sms_code":"","conpon":"100","buyer_info":{"user_id":"8032","user_name":"1231","email":"[email protected]","password":"4297f44b13955235245b2497399d7a93","real_name":"test","gender":"0","birthday":"0000-00-00","phone_tel":"12312311111","phone_mob":"13031231231","im_qq":"123321","im_msn":"","im_skype":null,"im_yahoo":null,"im_aliww":"","reg_time":"1364814862","last_login":"1370545456","last_ip":"192.168.0.119","logins":"59","ugrade":"0","portrait":null,"outer_id":"0","activation":null,"code":"","audit":"1","alipay_account":"","taobao_shop_url":"","taobao_shop_name":"","is_anonymous":"0","cardID_p1":"\/data\/files\/user_8032\/attest_img\/201304011229381322.jpg","cardID_p2":"","shop_photo":"\/data\/files\/user_8032\/attest_img\/201304011229389124.gif","shop_name":"","cardID_num":"123123123123121233","is_authentication":"1","user_type":"0","operator":"","openid":"","reg_from":"","region_name":"","address":"badsf"},"permissions":[{"code":"ship","title":" \u53d1 \u8d27 ","btn":"<a href=\"\/JXC\/index.php?s=\/order\/shipping\/order_id\/771\/ret_url\/35D6B7113866865E60F78C4E775890A9\/?height=360;width=390;title=\u53d1\u8d27\" class=\"thickbox\">\u53d1\u8d27<\/a>"},{"code":"cancel","title":"\u53d6\u6d88\u8ba2\u5355"},{"code":"view","title":"\u67e5\u770b\u8ba2\u5355"}]},"store_infos":null,"order_extm_info":{"order_id":"771","consignee":"test","region_id":"2197","region_name":"","address":"badsf","zipcode":"","phone_tel":"123123","phone_mob":"13031231231","shipping_id":"store_promotion_17","shipping_name":"","shipping_fee":"0.00","self_pay_freight":"0","goods_weight":"0.00"},"order_update_logs":null,"order_goods_info":[{"rec_id":"5120","order_id":"771","goods_id":"35532","goods_name":"2013","store_id":"8026","spec_id":"92003","specification":"","price":"166.00","quantity":"14","goods_image":"data\/files\/store_8026\/goods\/111\/small_201304030705118774.jpg","evaluation":"0","comment":"","credit_value":"0","is_valid":"1","art_no":"","status":"20"}],"store_amount":"2324.00"}]
//将信息转换为 object(创建与json数组格式对应的实体bean,如下面的JsonBaseBean)
JsonBaseBean JsonBaseBean recBasebean = JsonConvert.DeserializeObject<JsonBaseBean>(recData);
//TODO：业务处理
引用 Newtonsoft.Json.dll
StringBuilder sb = new StringBuilder();
string str = "[{ID:'1',Name:'John',Other:[{Age:'21',Sex:'0'}]},{ID:'2',Name:'Good',Other:[{Age:'36',Sex:'1'}]}]";
JArray javascript = (JArray)JsonConvert.DeserializeObject(str);
for (int i = 0; i < javascript.Count; i++ )
{
JObject obj = (JObject)javascript[i];
sb.Append("ID：" + obj["ID"].ToString());
sb.Append("Name：" + obj["Name"].ToString());
JArray json = (JArray)obj["Other"];
for (int j = 0; j < json.Count; j++){
JObject jsonobj = (JObject)json[j];
sb.Append("Age：" + jsonobj["Age"].ToString());
sb.Append("Sex：" + jsonobj["Sex"].ToString());
}
}
string s = sb.ToString();
//ID：1Name：JohnAge：21Sex：0ID：2Name：GoodAge：36Sex：1
找不到JsonConvert.cs怎么解决？
Private Sub CommandButton2_Click() '比较复杂的json
On Error Resume Next bt = Split("order_id,order_sn,type,extension,seller_id,seller_name,buyer_id,buyer_name,buyer_email,status,add_time,payment_id,payment_name,payment_code,out_trade_sn,pay_time,pay_message,ship_time,invoice_no,finished_time,goods_amount,discount,order_amount,evaluation_status,evaluation_time,anonymous,postscript,pay_method,is_print,sms_code,conpon", ",")
ct = Split("user_id,user_name,email,password,real_name,gender,birthday,phone_tel,phone_mob,im_qq,im_msn,im_skype,im_yahoo,im_aliww,reg_time,last_login,last_ip,logins,ugrade,portrait,outer_id,activation,code,audit,alipay_account,taobao_shop_url,taobao_shop_name,is_anonymous,cardID_p1,cardID_p2,shop_photo,shop_name,cardID_num,is_authentication,user_type,operator,openid,reg_from,region_name,address", ",")
dt = Split("order_id,consignee,region_id,region_name,address,zipcode,phone_tel,phone_mob,shipping_id,shipping_name,shipping_fee,self_pay_freight,goods_weight", ",")
et = Split("rec_id,order_id,goods_id,goods_name,store_id,spec_id,specification,price,quantity,goods_image,evaluation,comment,credit_value,is_valid,art_no,status", ",") With CreateObject("WinHttp.WinHttpRequest.5.1")
.Open "GET", "http://bbs.csdn.net/topics/390485808", False
.send
tt = Split(Split(Split(.responsetext, "最好写代码<br />")(1), "<br />")(1), "<div class=")(0)
End With tt = "brr = " & tt With CreateObject("MSScriptControl.ScriptControl")
.Language = "JScript"
.AddCode tt For i = 0 To UBound(bt)
Cells(i + 3, 1) = .Eval("brr[0].order_info." & bt(i))
Next i
For i = 0 To UBound(ct)
Cells(i + 3 + UBound(bt), 1) = .Eval("brr[0].order_info.buyer_info." & ct(i))
Next i For i = 0 To 3
Cells(i * 3 + 4 + UBound(bt) + UBound(ct), 1) = .Eval("brr[0].order_info.permissions[" & i & "].code")
Cells(i * 3 + 5 + UBound(bt) + UBound(ct), 1) = .Eval("brr[0].order_info.permissions[" & i & "].title")
Cells(i * 3 + 6 + UBound(bt) + UBound(ct), 1) = .Eval("brr[0].order_info.permissions[" & i & "].btn")
Next i For i = 0 To UBound(dt)
Cells(i + 9 + UBound(bt) + UBound(ct), 1) = .Eval("brr[0].order_extm_info." & dt(i))
Next i For i = 0 To UBound(et)
Cells(i + 9 + UBound(bt) + UBound(ct) + UBound(dt), 1) = .Eval("brr[0].order_goods_info[0]." & et(i))
Next i End With
End Sub