Dim e As RequestEventArgs = args(0)
Dim wb As New weui
Dim flt As String
Dim bzlb As String '表彰类别
If e.GetValues.ContainsKey("unfilter") Then '如果是取消筛选
wb.ClearCookie() '清除Cookie
Else
dim ar() as string = Functions.Execute("getbiaozhang",e, wb) '根据输入内容合成条件,注意WeUI也需要传递过去
bzlb = ar(0)
flt =ar(1)
End If
msgbox(bzlb)
if bzlb="个人表彰" then
Dim Book As New XLS.Book(ProjectPath & "Attachments\【模板】表彰(个人)统计表.xlsx")
book.AddDataTable("表彰","黔南宣传","Sel ect * from {表彰} where" & flt)
e.WriteBook(book,"shaixuandaochu.xls",False)
else
if bzlb="集体表彰" then
Dim Book1 As New XLS.Book(ProjectPath & "Attachments\【模板】表彰(集体)统计表.xlsx")
book1.AddDataTable("表彰","黔南宣传","Sele ct * from {表彰} where" & flt)
e.WriteBook(book1,"shaixuandaochu.xls",False)
end if
end if