以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  用代码实现显示修改行  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=157424)

--  作者:朱女士
--  发布时间:2020/10/15 15:39:00
--  用代码实现显示修改行

老师您好!

    我想用ddqdb中的数据回填到ddpsb中,我的回填程序是运行成功的。我想编写代码显示哪些数据是回填上去的。怎么写代码?谢谢!我的源代码是这样的:

Dim zh1 As String   \'ddqdb的zzh
Dim zh2 As String   \'ddpsb的zzh

Dim zl As Double
Dim je As Double
Dim bje As Double
Dim ts As Integer
Dim zyy As String
Dim zyy1 As String
Dim zyy2 As String
Dim lg As Integer
Dim dzl As Double
Dim dje As Double
Dim dbje As Double
Dim count As Integer
Dim wr As DataRow
Dim wzl As Double

For Each dr As DataRow In DataTables("ddqdb").DataRows
    zh1=dr("zzh")
    zl = Tables("ddqdb").Compute("Sum(重量)","[zzh]=\'" & zh1 & "\'" )
    dr = DataTables("ddqdb").Find("[zzh]=\'" & zh1 & "\'" )

    If dr("客户")="魏德曼"
        wzl = Tables("ddqdb").Compute("Sum(理论重量)","[zzh]=\'" & zh1 & "\'" )
        wzl=Round2(wzl,2)
        dje=dr("含税价")*wzl
       je=dje
    Else
             
        je = Tables("ddqdb").Compute("Sum(含税金额)","[zzh]=\'" & zh1 & "\'" )
        bje = Tables("ddqdb").Compute("Sum(不开票金额)","[zzh]=\'" & zh1 & "\'" )
    End If
      If dr IsNot Nothing Then
        ts=dr("台数")
        dzl=zl/ts
        If dr("客户")<>"魏德曼"
            dje=je/ts
        End If
        dbje=bje/ts
        If dr.isnull("zzh_yy") = False
            zyy=dr("zzh_yy")
            If zyy.length >= 2
                zyy1=zyy.SubString(0,2)
            End If
            If zyy.length >= 5
                zyy2=zyy.SubString(3,2)
            End If
           
            Dim k1 As Integer
            Dim k2 As Integer
            k1=cint(zyy1)
            k2=cint(zyy2)
           
            Dim i As Integer
            Dim zys(10) As String
            For i=k1 To k2
                If ts<=9
                    zys(i)="0"+cstr(i)
                Else
                    zys(i)=cstr(i)
                End If
               
                wr=DataTables("ddpsb").find("[zzh]=\'" & zh1 & "\'and [zzh_xx]=\'" & zys(i) & "\' and 净重 is null")
                If wr IsNot Nothing Then
                     If dzl<>0
                    wr("净重")=dzl
                    wr("含税金额")=dje
                    wr("不开票金额")=dbje
                   End If
                End If
            Next
        Else
            wr=DataTables("ddpsb").find("[zzh]=\'" & zh1 &  "\'and 净重 is null")
            If wr IsNot Nothing Then
               If zl <>0
                wr("净重")=zl
                wr("含税金额")=je
                wr("不开票金额")=bje
             End If
            End If
           
        End If
    End If
Next
messagebox.show("回填完毕")


--  作者:朱女士
--  发布时间:2020/10/15 15:50:00
--  
就是显示哪些数据是现在回填的
--  作者:有点蓝
--  发布时间:2020/10/15 15:52:00
--  
哪些数据才算是回填上去的?要怎么显示?
--  作者:朱女士
--  发布时间:2020/10/15 16:12:00
--  
最好在窗口中显示刚刚回填的数据。也可以在ddpsb中直接筛选出来。ddpsb 中的净重,含税金额,不开票金额等在没回填前是空值。
--  作者:有点蓝
--  发布时间:2020/10/15 16:24:00
--  
这个?http://www.foxtable.com/webhelp/topics/1630.htm