以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- [求助] 请教任务栏的代码问题。 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=30432) |
-- 作者:bahamute -- 发布时间:2013/3/27 18:39:00 -- [求助] 请教任务栏的代码问题。 今天试了一下做任务栏,代码来自帮助,略作修改,只要把代码嵌入Select Case 语句就没了反应,单独运行则一切正常。 代码如下,请高手指点:
Select Case e.Link.Name
|
-- 作者:狐狸爸爸 -- 发布时间:2013/3/27 19:53:00 -- MessageBox.show("名称是:" & e.Link.Name) Select Case e.Link.Name Case "今天生日员工" MessageBox.show("今日") Dim nms As String For Each dr As DataRow In DataTables("基本信息").DataRows Dim dt As Date = dr("出生日期") If dt.Month = Date.Today.Month AndAlso dt.Day = Date.Today.Day Then nms = nms & ",\'" & dr("姓名") & "\'" End If Next If nms > "" Then nms = nms.Trim(",") Tables("基本信息").filter = "[姓名] In (" & nms &")" End If Forms("正式工信息").Open MainTable = Tables("基本信息") Case "本周生日员工" MessageBox.show("本周") Dim ids As String Dim n As Integer = 6 For Each dr As DataRow In DataTables("基本信息").DataRows Dim dt As Date = dr("出生日期") Dim dt1 As New Date(Date.Today.Year,dt.Month,dt.Day) Dim dt2 As New Date(Date.Today.AddDays(n).Year,dt.Month,dt.Day) If (dt1 >= Date.Today AndAlso dt1 < Date.Today.AddDays(n)) OrElse (dt2 >= Date.Today AndAlso dt2 < Date.Today.AddDays(n)) Then ids = ids & ",\'" & dr("工号") & "\'" End If Next If ids > "" Then ids = ids.Trim(",") Tables("基本信息").filter = "[工号] In (" & ids &")" End If Forms("正式工信息").Open MainTable = Tables("基本信息") Case Else MessageBox.show("名称不符,罢工了") End Select |
-- 作者:bahamute -- 发布时间:2013/3/27 20:27:00 -- 眼都看花了,没想到居然是这个原因,还得细心呀... 谢谢狐爸指点。
|