voteset.asp

社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功

<!--#include file="conn.asp"-->
<!--#include file="char.inc"-->

<%IF request.cookies("KEY")<>"super"THEN
response.redirect "index_face.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判断用户的合法性
  set rs=server.createobject("adodb.recordset")
  sql="select * from admin where username='"&usernamecookie&"'"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
             response.redirect "login.asp"
            response.end
         end if
  IF passwdcookie<>rs("passwd") THEN
          response.redirect "login.asp"
           response.end
      END IF
   '下面判断用户级别实际在有用户级别是都应该判断
   if KEYcookie<>rs("OSKEY") then
      response.redirect "index_face.asp"
      response.end
    end if
           rs.close
           set rs=nothing
END IF
END IF
if votemana="1" or request.cookies("purview")="99999" then
%>
<%
Checked=request.form("Checked")
if Checked="" then
response.write "<script>alert('对不起，请您选择投票项！');history.go(-1);</Script>"
	
	Response.End 
	
end if

set rs=server.createobject("adodb.recordset")
sql="Select isChecked from vote where IsChecked=1"
rs.open sql,conn,1,3
if not rs.eof then
	do while not rs.eof
		rs("IsChecked")=0
	rs.movenext
	loop
end if
rs.close

sql="Select IsChecked from vote where ID="&Checked
rs.open sql,conn,1,3
if not rs.EOF then
	do while not rs.EOF 
		rs("isChecked")=1
	rs.MoveNext 
	loop
end if
rs.close
set rs=nothing

else
response.redirect "index_face.asp"
response.end
end if

conn.close
set conn=nothing
response.redirect "voteManage.asp"
%>