Foxtable(狐表)用户栏目专家坐堂 → 懵了!没有方向


  共有2068人关注过本帖平板打印复制链接

主题:懵了!没有方向

帅哥哟,离线,有人找我吗?
石四
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:四尾狐 帖子:972 积分:7048 威望:0 精华:0 注册:2013/3/31 10:33:00
懵了!没有方向  发帖心情 Post By:2020/9/10 15:06:00 [只看该作者]

现在单子上的二维码扫出来的字符是标准的JSON,很好调用。
{"D":"DL0859020090409","S":"S-00008590","W":"1400DPDP","I":[{"I":"23928550","N":"480.0","P":"20200904"},{"I":"23928552","N":"480.0","P":"20200904"},{"I":"24510382","N":"96.0","P":"20200904"},{"I":"24513058","N":"96.0","P":"20200904"}]}

Dim jsonStr=e.Form.Controls("TextBox1").value
Dim jo As JObject = JObject.Parse(jsonStr)
e.Form.Controls("Label1").text=jo("W").Tostring

Dim ja As JArray = jo("I")
Dim msg0 As String=""
Dim msg1 As String=""
For i As Integer = 0 To ja.Count - 1
    Dim jo2 As JObject =ja(i)
    msg0  = jo2("I").Tostring
    msg1  = jo2("N").Tostring
    Tables("test_Table1").AddNew()
    Dim r As Row = Tables("test_Table1").Current
    r("第一列") = msg0
    r("第二列") = msg1
Next

 回到顶部