老师:
我在明细账表里录入数据,同步更新到实物账表的相关列,以下是我的代码,但我现在有一个要求,就是当明细账表的摘要列如果显示"上年结转",那就不同 步账更新,实物表不作任何变动.请问老师要怎么写?
Select Case e.DataCol.name
Case "明细账_领入起号","明细账_领入止号","明细账_领入张数","姓名","姓名","实物账_发出起号","实物账_发出止号","实物账_发出张数","明细账_今日领入张数","明细账_退piao张数","实物账_退piao张数","年","月","日","凭证_实物号","年","月","日","凭证_号","明细账_上年结转张数","实物账_上年结转张数","实物账部分_号","实物账部分_上年结转张数"
Dim dr As DataRow = DataTables("实物账").Find("id2 = '" & e.DataRow("_Identify") & "'")
If dr Is Nothing Then
dr = DataTables("实物账").AddNew()
dr("id2") = e.DataRow("_Identify")
End If
dr("实物账_发出起号") = e.DataRow("明细账_领入起号")
dr("姓名") = e.DataRow("姓名")
dr("年") = e.DataRow("年")
dr("月") = e.DataRow("月")
dr("日") = e.DataRow("日")
dr("实物账_今日发出张数") = e.DataRow("明细账_今日领入张数")
dr("实物账_退piao张数") = e.DataRow("明细账_退piao张数")
dr("凭证_号") = e.DataRow("实物账部分_号")
dr("引用部分") = e.DataRow("摘要_内容")
End Select
此主题相关图片如下:}vkoi~5~rtk9olh3`ywij`m.png