我做的方法是平时把单位的发文做好登记,收文做好登记,是两张表.到归档时间通过按钮把两张表复制到归档表中,用的是如下代码
For Each adr As DataRow In DataTables("发文登记簿").Select("是否归档= true")
Dim dr As DataRow = DataTables("预归档表").AddNew
Dim cs1() As String = {"流水号", "文件编号", "文件题名","责任者","文件时间","保管期限","页数"} '表B列
Dim cs2() As String = {"流水号", "文件编号", "文件题名","责任者","文件时间","归档保管期限","页数"} '表A列
For i As Integer = 0 To cs1.length-1
dr(cs1(i)) = adr(cs2(i))
Next
DataTables("发文登记簿").deletefor("是否归档 = true")
Next
'-------------------------------
For Each adr As DataRow In DataTables("收文登记簿").Select("是否归档= true")
Dim dr As DataRow = DataTables("预归档表").AddNew
Dim cs1() As String = {"流水号", "文件编号", "文件题名","责任者","文件时间","保管期限","页数"} '表B列
Dim cs2() As String = {"流水号", "文件编号", "文件题名","责任者","文件时间","归档保管期限","页数"} '表A列
For i As Integer = 0 To cs1.length-1
dr(cs1(i)) = adr(cs2(i))
Next
DataTables("收文登记簿").deletefor("是否归档 = true")
Next