类文件:
Public function check as boolean
dim sqlcon as new sqlconnection("server=localhost;uid=sa;pwd=;database=book")
sqlcon.open
dim sqld as new SqlDataAdapter("select * from clerk where clerkid='" &_clerkid & "' and clerkpwd= _
&'" & _clerkpwd & "' and office='" &_office"'", sqlcon)
dim ds as new dataset
sqld.fill(ds,"clerk1")
if ds.tabels("clerk1").rows.count=0 then
_info="登录失败"
return False
else
_info="登录成功"
return True
end if
End function
调用类文件:
Sub igbAdgoin_Click( s As object, e As ImageClickEventArgs)
dim clerkin as new clsclerk
dim strad as string
strad = ddlAdminis.selecteditem.text
clerkin.clerkid=trim(adminiscard.text)
clerkin.clerkpwd=trim(adminispwd.text)
if clerkin.check then
select case strad
case "注册管理员"
response.redirect("zcadminis.aspx")
case "图书管理员"
response.redirect("bookadminis.aspx")
case "借还书管理员"
response.redirect("adminis.aspx")
end select
end if
End Sub