<%
UName=FilterSQL(request.form("UName"))
Pwd=FilterSQL(request.form("Pwd"))
set rs=Server.createobject("ADODB.Recordset")
SQL="Select * from dbo_OEM_User where OEM_Name='" & UName & "'" & " and OEM_Attrib=0"
rs.open SQL,ConnectJS,AdOpenStatic,AdLockReadOnly
if rs.EOF then
Found=0
else
Found=1
if rs.eof then
oemp=rs("oem_name=js_oem_name")
response.write "<p align=center>对不起,您是江苏分站用户,请到中学生在线江苏分站进行注册。"
else
OEMP=rs("OEM_Pwd")
end if
end if
rs.close
if Found=0 then
response.write "<p align=center>卡号错误,请返回重新输入!</p>"
else
if UCase(trim(OEMP))<>UCase(Pwd) then
response.write "<p align=Center>口令错误,请返回重新输入!</P>"
else
rs.open "Select * from dbo_Grade_Ref where GR_Grade_ID>0",ConnectJS,AdOpenStatic,AdLockReadOnly
dim GDES()
redim GDES(rs.recordcount,2)
GNum=rs.recordcount
while Not rs.Eof
GDES(cint(rs("GR_Grade_ID")),1)=trim(rs("GR_Grade_Name"))
GDES(cint(rs("GR_Grade_ID")),2)=trim(rs("GR_Available_Subject"))
rs.movenext
wend
response.write "<input Name=""GradeNum"" value=""" & rs.recordcount & """ type=Hidden>"
rs.close
rs.open "Select * from dbo_Subject_Ref where SR_Subject_ID>0",ConnectJS,adopenStatic,AdLockReadonly
Dim SDes()
SNum=rs.recordcount
redim SDes(rs.recordcount)
while not rs.EOF
SDes(cint(rs("SR_Subject_ID")))=trim(rs("SR_Subject_Name"))
rs.movenext
wend
rs.close
%>