以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 如何解析数据? (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=189301) |
-- 作者:lxhmax -- 发布时间:2023/11/23 10:51:00 -- 如何解析数据? 请问下接收到下面的数据要怎么转换成json进行解析? bgrq:2023-11-24 ypxx[ypzp][0][uid]:1700705259488 ypxx[ypzp][0][status]:success ypxx[ypzp][1][uid]:1700705262707 ypxx[ypzp][1][status]:success ypxx[yplb][0][ypbh]:00001 ypxx[yplb][0][ypmc]:白菜 ypxx[yplb][0][yplx]:蔬菜类 ypxx[yplb][0][ROW_NUMBER]:1 ypxx[yplb][1][ypbh]:010083 ypxx[yplb][1][ypmc]:土豆丝 ypxx[yplb][1][yplx]:蔬菜类 ypxx[yplb][1][ROW_NUMBER]:2 ypxx[yplb][2][ypbh]:010084 ypxx[yplb][2][ypmc]:萝卜丝 ypxx[yplb][2][yplx]:蔬菜类 ypxx[yplb][2][ROW_NUMBER]:3 ypxx[yplb][3][ypbh]:010085 ypxx[yplb][3][ypmc]:胡萝卜丝 ypxx[yplb][3][yplx]:蔬菜类 ypxx[yplb][3][ROW_NUMBER]:4 ypxx[yplb][4][ypbh]:10011 ypxx[yplb][4][ypmc]:西洋菜 ypxx[yplb][4][yplx]:蔬菜类 ypxx[yplb][4][ROW_NUMBER]:5 jcxx[0][jczp][0][uid]:1700705270361 jcxx[0][xmbh]:kjxm00001 jcxx[0][jgzp][0][uid]:1700705273644 jcxx[0][csr]:张三 jcxx[0][shr]:李四 jcxx[0][pzr]:王五
|
-- 作者:有点蓝 -- 发布时间:2023/11/23 10:56:00 -- 数据有没有什么规律?需要的json格式是怎么样的? |
-- 作者:lxhmax -- 发布时间:2023/11/23 10:58:00 -- 我是用下面的格式解析数据的,这个是我给对方的样式,结果对方回传过来的是那个,我就不知道怎么办了 "bgrq": "2023/11/1", "ypxx": { "yplb": [ { "ypbh": "1001", "ypmc": "生菜", "yplx": "蔬菜" }, { "ypbh": "1002", "ypmc": "早白", "yplx": "蔬菜" }, { "ypbh": "1003", "ypmc": "猪肉", "yplx": "肉类" } ], "ypzp": [ { "url": "https://www.cnanbao.cn/uploadfile/2021/0411/20210411032847709.jpg" }, { "url": "https://www.cnanbao.cn/uploadfile/2021/0411/20210411032847709.jpg" } ] },
|
-- 作者:有点蓝 -- 发布时间:2023/11/23 10:59:00 -- 问对方发过来的数据有没有固定的格式和规律? |
-- 作者:lxhmax -- 发布时间:2023/11/23 11:34:00 -- 现在对方传递过来的数据是这个?这个又要怎么解析为json? data:{"tsdh":"R2023112311064072","qymc":"\\u6d4b\\u8bd5\\u4f01\\u4e1a","qydz":"\\u6d4b\\u8bd5\\u5730\\u5740","lxr":"\\u5f20\\u4e09","lxfs":"13213213213","bgrq":"2023-11-24","ypxx":{"ypzp":[{"url":"http:\\/\\/leake.r5r6.com.cn\\/upload\\/LKTEST\\/6BBF67F67C064F748DBBEE0FD2AC0D01.jpg","uid":1700708703203,"status":"success"}],"yplb":[{"ypbh":"00001","ypmc":"\\u767d\\u83dc","yplx":"\\u852c\\u83dc\\u7c7b","ROW_NUMBER":"1"},{"ypbh":"010083","ypmc":"\\u571f\\u8c46\\u4e1d","yplx":"\\u852c\\u83dc\\u7c7b","ROW_NUMBER":"2"},{"ypbh":"010084","ypmc":"\\u841d\\u535c\\u4e1d","yplx":"\\u852c\\u83dc\\u7c7b","ROW_NUMBER":"3"},{"ypbh":"010085","ypmc":"\\u80e1\\u841d\\u535c\\u4e1d","yplx":"\\u852c\\u83dc |
-- 作者:有点蓝 -- 发布时间:2023/11/23 11:45:00 -- 这个发过来的已经是json字符串,直接用就行了:http://www.foxtable.com/mobilehelp/topics/0140.htm Dim json As String = ".....接收的json字符串......."
Dim jo As JObject = JObject.Parse(json) |