老师好，我想在入库明细表退勾后同时删除数据汇总表的数据。谢谢老师
If e.DataCol.Name = "审核"
If e.DataRow("审核") = True Then
Dim nma() As String = {"编号","抄表日期","项目","项目ID","年","月"} 'A表数据来源列
Dim nmb() As String = {"编号","日期","项目","项目ID","年","月"} 'B表数据接收列
e.DataRow.save
Dim dr2 As DataRow = DataTables("数据汇总").Find("编号 = '" & e.DataRow("编号") & "'") '找到指定返回的行
If dr2 Is Nothing Then
Dim dr3 As DataRow = DataTables("数据汇总").AddNew
For i As Integer = 0 To nma.Length - 1
dr3(nmb(i)) = e.DataRow(nma(i))
Next
' dr("来源") = "销售" '入库表就改为"采购",其他表改为"其它"
End If
Else
DataTables("数据汇总").deletefor("_Identify = '" & e.DataRow("_Identify") & "'")
End If
End If
加好友 
发短信
Post By：2024/12/28 12:47:00 [只看该作者]
