Dim e As Request EventArgs = args(0)
Dim wb As New WeUI '定义一个东基于WeUI 框架的网页生成器
Dim PrimaryKey As Integer = e.GetValues("key")
Dim cmd2 As New SQLCommand
cmd2.Conn ecti '记得设置数据源名称
cmd2.Comm andText = "Select * Fr om (Sel ect Row_Number() Over(Order by f_number) As [NO.],* Fr om {user_power} where f_id= '"& PrimaryKey &"' ) As a "
Dim dt2 As Data Table = cmd2.Execute Reader
'根据此页数据生成网页
With wb.AddTable("","Table2")
.Colwidth="12px"
.Highlight= 1
.Alternate = 2
Dim nms1() As String={"NO","项目","功能表(0无权1有权)","功能表(0无权1有权)","功能表(0无权1有权)","功能表(0无权1有权)","功能表(0无权1有权)","功能表(0无权1有权)"}
Dim nms2() As String={"NO","项目","新增","修改","删除","审核","上图","查询"}
.head.AddRow(nms1)
.head.AddRow(nms2)
For Each dr2 As DataRow In dt2.DataRows
With .body.addrow(dr2("NO."))
.addcell(dr2("f_name"),"class='alignC'")
.addcell(dr2("f_add"),"class='alignC'")
.addcell(dr2("f_edit"),"class='alignC'")
.addcell(dr2("f_del"),"class='alignC'")
.addcell(dr2("f_check"),"class='alignC'")
.addcell(dr2("f_img"),"class='alignC'")
.addcell(dr2("f_view"),"class='alignC'")
' .Prim aryKey=dr("_Identify") '每行都需要定义上主键
End With
Next
End With
e.Write String(wb.Build)