'按姓名查询时用,判断是否是管理员============================
Dim zw() As String = {"010101","010102","010103","010104","010108"} '管理员职位编号
Dim lzw As New List(of String)
lzw.AddRange(zw) '将数组中的元素全部加入到集合中
'===========================================================
'按姓名查询时的下拉列表项===================================
cmd.C ommandText = "S elect 姓名,[当前_岗位] from [RL_员工档案] where 当前_岗位 in ('010105','010106','010107') and 当前状态 = '1'"
Dim mddt As DataTable = cmd.Exe cuteReader
Dim md As List(of String) = mddt.GetValues("姓名","","[当前_岗位] Desc")
'===========================================================
wb.InsertHTML("<p style='font-size:12px;color:red'>★注意:①当月数据无需设置时间段或月份.<br>    ②如按时间段选择,则不用填写下面的月份,反之如按月筛选,则不用填写时间段.</p>")
wb.InsertHTML("<hr/>")
wb.AddForm("","form1","ludanlist.htm")
'按职位编号加载表单项
If lzw.Contains(e.Cookies("userzw")) Then
With wb.AddInputGroup("form1","fornm","按名查询,对管理人员开放!")
.AddSelect("username","姓名","|向**|" & String.Join("|",md.ToArray))
End With
Else
With wb.AddRadioGroup("form1","selettype","筛选条件")
.Add("onlyme","仅我的",True)
.Add("aboutme","与我相关的")
End With
End If
With wb.AddRadioGroup("form1","formonth","按月份查询")
.Add("thismth","本月").Attribute = "onchange=""cdat();"""
.Add("prevmth","上月").Attribute = "onchange=""cdat();"""
End With
With wb.AddInputGroup("form1","fordate","按时段查询")
'AddSelect("username","姓名","|向**|" & String.Join("|",md.ToArray))
.AddInput("startdate","从","date").Attribute = "onchange=""cmth();"""
.AddInput("enddate","到","date").Attribute = "onchange=""cmth();"""
End With
With wb.AddButtonGroup("form1","btg1", False)
.Add("btn1", "筛选", "submit")
.Add("btn2","退出","index.htm")
End With
wb.AppendHTML("<script src='./lib/ludantable.js'></script>") '引入脚本文件
e.WriteString(wb.Build)