Foxtable(狐表)用户栏目专家坐堂 → 表同步问题


  共有2486人关注过本帖树形打印复制链接

主题:表同步问题

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2017/7/2 21:02:00 [显示全部帖子]

if e.datarow.IsNull("??") = false andalso e.datarow.IsNull("??") = false then
    Select Case e.DataCol.name
        Case "??"
            dim dr as datarow
            if e.OldValue = nothing then
                dr = DataTables("服饰账单").Find("?? = '" & e.NewValue & "' and ?? = '" & e.datarow("??") & "'")
            else
                dr = DataTables("服饰账单").Find("?? = '" & e.OldValue & "' and ?? = '" & e.datarow("??") & "'")
            end if
            If dr Is Nothing Then
                dr = DataTables("服饰账单").AddNew()
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("kg") = e.DataRow("kg")
            Else
                dr("??") = e.DataRow("??")
            End If
        Case "??"
            dim dr as datarow
            if e.OldValue = nothing then
                dr = DataTables("服饰账单").Find("?? = '" & e.datarow("??") & "' and ?? = '" & e.NewValue & "'")
            else
                dr = DataTables("服饰账单").Find("?? = '" & e.datarow("??") & "' and ?? = '" & e.OldValue & "'")
            end if
            If dr Is Nothing Then
                dr = DataTables("服饰账单").AddNew()
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("??") = e.DataRow("??")
                dr("kg") = e.DataRow("kg")
            Else
                dr("??") = e.DataRow("??")
            End If
           
        Case "??","??","??","kg"
            Dim dr As DataRow = DataTables("服饰账单").Find("?? = '" & e.DataRow("??") & "'")
            If dr IsNot Nothing Then
                dr(e.DataCol.Name) = e.DataRow(e.DataCol.Name)
            End If
    End Select
end if

 回到顶部