子表代码
Select Case e.DataCol.Name
Case "付款日期","付款金额"
Dim pr As DataRow
pr = DataTables("出库").Find("送货单号= '" & e.DataRow("送货单号") & "'")
If pr IsNot Nothing Then
DataTables("出库").DataCols("送货单号").RaiseDataColChanged(pr)
End If
End Select
父表代码
If e.DataCol.Name = "送货单号" Then
Dim dr As DataRow
Dim Filter As String = "[送货单号] = '" & e.NewValue & "'"
If dr IsNot Nothing '如果找到, 则设置各列内容
e.DataRow("已付") = DataTables("销售明细").Compute("Sum(付款金额)", Filter)
e.DataRow("应收") = DataTables("销售明细").Compute("Sum(金额)", Filter)
e.DataRow("未付") = DataTables("销售明细").Compute("Sum(应收)", Filter)
End If
End If
当子表中付款日期、付款金额变动时,引发父表算同一送货单号的:已付、应收、未付三列,上面代码没有实现,请问要如何修改?