Dim cmd As new SQLCommand
cmd.C
Dim uname As String = e.cookies("username")
msgbox(uname) ‘这里弹出什么名称’
If uname = "张三" Then
cmd.CommandText= "select 物料名称,实收数量,规格型号,单价,[入库日期] From 入库表"
ElseIf uname = "李四" Then
cmd.CommandText= "select 物料名称,实收数量,规格型号,单价,[入库日期] From 入库表"
Else
cmd.CommandText= "select 物料名称,实收数量,规格型号,[入库日期] From 入库表"
End If
If flt > "" Then
cmd.CommandText = cmd.CommandText & " where " & flt
End If
msgbox(cmd.CommandText) ‘这里弹出的sql是什么’