堆栈(Stack)就是栈
select OrderSn from ORDER_Tracking group by OrderSn having count(1)>=2
HttpClient httpclient = new HttpClient();
var ret = httpclient.GetAsync("https://www.baidu.com/");
var Content = ret.Result.Content.ReadAsStringAsync().Result;
UTF-8编码的文字可以在各国各种支持UTF-8字符集的浏览器上显示
假如我们得到了一个json的数据:json===》 {"Head":{"TransCode":"X1009","TransId":"20190514145005iQXk"},"Body":{"OrderSN":"95131406006","WHSE":"aaaaa","
SNs
":[{"SN":"HCMPFD000621"},{"SN":"1212122"}]}}
类似这样。我们要取出来里面特定的值,而且,SNs还是一个集合。
方法如下:
string OrderSn = json["Body"]["OrderSN"].ToString();
string WHSE = json["Body"]["WHSE"].ToString();
string SNs = json["Body"]["SNs"].ToString();
SNs是一个集合,怎么取出来呢:
将json字符串解析为JToken,JObject是JToken的父类,直接使用JToken比较好用
dynamic Sns =JToken.Parse(SNs) as dynamic
for (int i = 0; i < Sns.Count; i++)//获取备注里的SN
if (Sns[i].SN.ToString() != "")
str += Sns[i].SN.ToString() + ",";
这样子就可以循环出来里面的值了。
1 HttpWebResponse httpWebResponse = (HttpWebResponse)httpWebRequest.GetResponse();
2 string response = string.Empty;
3 using (StreamReader reader = new StreamReader(httpWebResponse.GetResponseStream()))
4 response = reader.ReadToEnd();
6 var j = JObject.Parse(response);
7 string shop_name = j["Success"]["items"]["item"][0]["shop_name"].ToString();//独一味日化旗舰店、、、一层层的层级关系
"Success": {
"total_results": "1",
"items": {
"item": [{
"shop_name": "独一味日化旗舰店",
"serial_num": "",
"order_channel": "直营网店",
"updatetime": "",
"总数量": "3739",
"maxrowver": "",
"tid_item": [{
"storage_id": "1",
"tid": "S17fdgfgfg0349",
"pro_detail_code": "191",
"book_inventory": "-5.000",
"store_location": "",
"pro_type": "原始产品"
"storage_id": "1",
"tid": "S1712220000349",
"pro_detail_code": "152",
"book_inventory": "-4.000",
"store_location": "",
"pro_type": "原始产品"
上面这个是其他的厂商返回的一个Json格式的数据,现在可以是Json嵌套的还挺多,其中的一个项次还有数组,现在就是把这些数据捞出来存下来。
var j = JObject.Parse(response);
//这个就是主干的值
string shop_name = j["Success"]["items"]["item"][0]["shop_name"].ToString();//独一味日化旗舰店
string tid_item = j["Success"]["items"]["item"][0]["tid_item"].ToString();
//下面是获取数组的名细可以取出来值
JArray jArray = JArray.Parse(tid_item);
for (int i = 0; i < jArray.Count; i++)
JObject jdata = (JObject)jArray[i];
string pro_detail_code = jdata["pro_detail_code"].ToString();
//将数据动态插入到数组中去
JArray jArray = JArray.Parse(tid_item);
JArray arr = new JArray();
for (int i = 0; i < jArray.Count; i++)
JObject obj = new JObject();
JObject jdata = (JObject)jArray[i];
obj["linenum"] = jdata["cost_price"].ToString();
obj["sku"] = jdata["sell_price"].ToString();
obj["qty"] = jdata["original_price"].ToString();
obj["inventoryname"] = jdata["sys_price"].ToString();
obj["price"] = jdata["product_name"].ToString();
arr.Add(obj);
var rss = new JObject
{"Head",new JObject
{"TransCode","X1009" },
{"TransId",1212}
{ "Body", new JObject
{"orderno", "orderno" },
{"billto","billto"},
{"shipto", "shipto"},
{"workid", "workid"},
{"tocity", "tocity"},
{"Address", "Address"},
{"Contact", "Contact"},
{"Tel", "Tel"},
{"detail", arr }
JToken response = JObject.Parse(json).SelectToken("sn_responseContent", false);
JToken error = response.SelectToken("sn_error", false);
var code = error.Value<string>("error_code");
{"Result":"0","Message":"分类编码不正确109050909。","ErrList":[{"XTLSH":"1672630450631","ErrMsg":"分类编码不正确109050909。 "}],"SucessList":[]}
protected ResultDataMsg<JToken> ParseResponse(string data, ApiActionEnum action)
var response = Newtonsoft.Json.JsonConvert.DeserializeObject<JToken>(data);
//解析返回的Result
string result = response["Result"].ToString();
if (result != "1")
if (response.SelectToken("ErrList", false) != null)
string ErrMsg = response["Message"].ToString() + "," + response["ErrList"][0]["ErrMsg"].ToString();
return ResultDataMsg<JToken>.CreateErrorResult(this.ApiSite, result, ErrMsg, action);
return ResultDataMsg<JToken>.CreateErrorResult(this.ApiSite, result, response["Message"].ToString(), action);
return ResultDataMsg<JToken>.CreateSuccessResult(response);