Dim Filter As String
Dim StartDate As Date = Date.Today().AddDays(-2)
Filter = "[申报时间] > '" & StartDate & "' And 监督所名称 = '" & User.Group & "'"
DataTables("产地检疫申报").LoadFilter = Filter
DataTables("产地检疫申报").Load()
If Tables("产地检疫申报").Current Is Nothing Then
MessageBox.Show("对不起,没有产地检疫申报的数据,不能进行动物产地检疫工作记录!", "提示")
Dim dt As DataTable = Tables("动物产地检疫工作记录").DataTable
For Each dr As DataRow In dt.DataRows
If dr.RowState = DataRowState.Added Then
dr.Delete
End If
Next
Else
Tables("动物产地检疫工作记录").AddNew()
Tables("动物产地检疫工作记录").Current("监督所名称") = User.Group
Tables("动物产地检疫工作记录").Current("基本情况_检疫时间") = Date.Today
Forms("产地检疫工作记录录入").Open
End If