Foxtable(狐表)用户栏目专家坐堂 → 保存数据问题


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

主题:保存数据问题

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


加好友 发短信
等级:八尾狐 帖子:1989 积分:12631 威望:0 精华:0 注册:2017/4/3 15:01:00
保存数据问题  发帖心情 Post By:2020/3/5 11:30:00 [只看该作者]

前一段时间保存还正常呢?为什么今天保存不了了?出现一下错误


图片点击可在新窗口打开查看此主题相关图片如下:截图18.jpg
图片点击可在新窗口打开查看

Dim dt As DataTable = DataTables("收入分类")
Dim dic As New Dictionary(of Integer, Integer)
Dim prevLevel As Integer = 0
Dim idxs As String = "-1,"
For Each nd As WinForm.TreeNode In e.Form.Controls("srflTreeView").AllNodes
    If nd.Level = 0 AndAlso dic.count > 0 Then
        Dim temp = dic(0)
        dic.Clear
        dic.Add(0, temp)
    End If
    
    If dic.ContainsKey(nd.Level) = False Then
        dic.Add(nd.Level, 1)
    Else
        dic(nd.Level) = dic(nd.Level) + 1
    End If
    For i As Integer = nd.level + 1 To prevLevel
        dic(i) = 0
    Next
    
    prevLevel = nd.Level
    Dim ndr As DataRow
    If nd.DataRow IsNot Nothing Then
        ndr = dt.Find("SRID = " & nd.DataRow("SRID"))
    Else
        ndr = dt.AddNew
    End If
    idxs &= ndr("SRID") & ","
    Dim str As String = ""
    For i As Integer = 0 To nd.Level
        str &= format(dic(i), "000") & "."
    Next
    ndr("收入分类代码") = str.TrimEnd(".")
    ndr("收入目录") = nd.Text
Next
dt.DeleteFor("SRID not in (" & idxs & ")")
 dt.Save

 回到顶部