-- 作者:twef
-- 发布时间:2020/10/12 11:46:00
--
With Forms("工程资金审批单").Controls("TextBox3")
Dim a As Double = DataTables("到账资金表").Compute("Sum(到账金额)","项目编号
= \'" & forms("工程资金审批单").controls("Label2").text & "\'")
Dim b As Double = DataTables("资金拨付表").Compute("Sum(实际拨付金额)","项目编号
= \'" & forms("工程资金审批单").controls("Label2").text & "\'")
\'Dim f As
Double = DataTables("到账资金表").Compute("Count(到账金额)","项目编号
= \'" & forms("工程资金审批单").controls("Label2").text
& "\'")
Dim k As Double = DataTables("扣款登记表").Compute("Sum(扣款金额)","项目编号
= \'" & forms("工程资金审批单").controls("Label2").text & "\'And 扣款类型 = \'预留风险金\'
" )
Dim dr3 As DataRow
dr3 = DataTables("工程资金审批单_Table1").Find("扣款内容 = \'预留风险金\'"
) \'总包合同主表中找到下拉框中内容相应的行
If forms("工程资金审批单").controls("项目名称").text = ""
Then
|