ElseIf e.Form.Controls("ComboBox1").Value = e.Form.Controls("ComboBox1").Items(2)
If e.Form.Controls("DateTimePicker1").Value = "" OrElse e.Form.Controls("DateTimePicker2").Value = "" Then '当日期为空取消保存操作
messagebox.show("请选择起止时间")
Return
Else
Dim Filter1 As String
Filter1 = "分类 = '" & e.Form.Controls("ComboBox1").Value & "'"
With e.Form.Controls("DateTimePicker1")
If .Value IsNot Nothing Then
If Filter1 > "" Then
Filter1 = Filter1 & " And "
End If
Filter1 = Filter1 & "缴费_临时停放_起计时间 >= #" & Format(.Value.adddays(-1),"G") & "#"
End If
End With
With e.Form.Controls("DateTimePicker2")
If .Value IsNot Nothing Then
If Filter1 > "" Then
Filter1 = Filter1 & " And "
End If
Filter1 = Filter1 & "缴费_临时停放_止计时间 <= #" & Format(.Value.adddays(1),"G") & "#"
End If
End With
With e.Form.Controls("DropBox1")
If .Value IsNot Nothing Then
If Filter1 > "" Then
Filter1 = Filter1 & " And "
End If
Filter1 = Filter1 & "车牌号码 = '" & .Value & "'"
End If
End With
If Filter1 > "" Then
With Tables("月租所属期缴费统计表_Table1")
For i As Integer = .Rows.count - 1 To 0 Step -1
.Rows(i).Delete
Next
LockBaseMainForm() '锁定主界面
.StopRedraw()
For i As Integer = DataTables("缴费情况").DataRows.count - 1 To 0 Step -1
Dim tr As DataRow = DataTables("缴费情况").DataRows(i)
If tr.Isnull("车牌号码") Then
tr.delete
End If
Next
.Fill("Select 分类,亲属临时停车,车牌号码,Count(车牌号码) As 查询_临时停放_出入次数 fro m {缴费情况} Where " & Filter1 & " group by 分类,亲属临时停车,车牌号码",True)
Dim t As DataTable = e.Form.Controls("Table1").Table.DataTable
If t.DataCols.Contains("查询_临时停放_起计时间") = False And t.DataCols.Contains("查询_临时停放_止计时间") = False And t.DataCols.Contains("查询_临时停放_停放累计时间") = False And t.DataCols.Contains("查询_临时停放_计费累计时间") = False And t.DataCols.Contains("查询_临时停放_缴费累计金额") = False Then
t.DataCols.add("查询_临时停放_起计时间", Gettype(Date))
t.DataCols.add("查询_临时停放_止计时间", Gettype(Date))
t.DataCols.add("查询_临时停放_停放累计时间", Gettype(Double))
t.DataCols.add("查询_临时停放_计费累计时间", Gettype(Double))
t.DataCols.add("查询_临时停放_缴费累计金额", Gettype(Double))
End If
.SetColVisibleWidth("分类|80|亲属临时停车|50|车牌号码|100|查询_临时停放_出入次数|80|查询_临时停放_起计时间|100|查询_临时停放_止计时间|100|查询_临时停放_停放累计时间|100|查询_临时停放_计费累计时间|100|查询_临时停放_缴费累计金额|120")
For Each dr As DataRow In DataTables("月租所属期缴费统计表_Table1").DataRows
dr("查询_临时停放_起计时间") = e.Form.Controls("DateTimePicker1").Value
dr("查询_临时停放_止计时间") = e.Form.Controls("DateTimePicker2").Value
dr("查询_临时停放_停放累计时间") = DataTables("缴费情况").Compute("Sum(缴费_临时停放_停车时间)","[车牌号码] ='" & dr("车牌号码") & "' And [缴费_临时停放_起计时间] >= #" & Format(e.Form.Controls("DateTimePicker1").Value.adddays(-1),"G") & "# And [缴费_临时停放_止计时间] <= #" & Format(e.Form.Controls("DateTimePicker2").Value.adddays(1),"G") & "#")
dr("查询_临时停放_计费累计时间") = DataTables("缴费情况").Compute("Sum(缴费_临时停放_计费时间)","[车牌号码] ='" & dr("车牌号码") & "' And [缴费_临时停放_起计时间] >= #" & Format(e.Form.Controls("DateTimePicker1").Value.adddays(-1),"G") & "# And [缴费_临时停放_止计时间] <= #" & Format(e.Form.Controls("DateTimePicker2").Value.adddays(1),"G") & "#")
dr("查询_临时停放_缴费累计金额") = DataTables("缴费情况").Compute("Sum(缴费_临时停放_缴费金额)","[车牌号码] ='" & dr("车牌号码") & "' And [缴费_临时停放_起计时间] >= #" & Format(e.Form.Controls("DateTimePicker1").Value.adddays(-1),"G") & "# And [缴费_临时停放_止计时间] <= #" & Format(e.Form.Controls("DateTimePicker2").Value.adddays(1),"G") & "#")
Next
If .Rows.Count < 15 Then
.AddNew(15 - .Rows.Count)
End If
.ResumeRedraw()
UnLockBaseMainForm()
.Cols("查询_临时停放_停放累计时间").GrandTotal = True
.Cols("查询_临时停放_计费累计时间").GrandTotal = True
.Cols("查询_临时停放_缴费累计金额").GrandTotal = True
.GrandTotal = True
End With
DataTables("月租所属期缴费统计表_Table1").DataCols("查询_临时停放_缴费累计金额").SetFormat("#,###.##")
End If
End If
End If