savepass.asp

来自「网络考试系统最终备份」· ASP 代码 · 共 124 行

ASP
124
字号
<!--#include file="conn.inc"-->
<html>
<head>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body>
<%
if request("objname")="考试计划" then
v_PaperID=request("testid")

sql="select * from paper_info where PaperID = "&v_PaperID
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
'if rs("Pass_User_ID")<>0 then
'else
 'rs("Pass_User_ID")=request.cookies("userid")
 'rs("PassTime")=now()
 'rs("Paper_Type")=1
 
 
 
 
 sql1="select * from waitforpass where objid="&v_PaperID
  set rs1=server.createobject("adodb.recordset")
  rs1.open sql1,conn,3,2
  if request("yesorno")="同意" then
    rs("Pass_User_ID")=request.cookies("userid")
    rs("PassTime")=now()
    rs("Paper_Type")=1
    rs1("havepass")=1
  else
    rs("Pass_User_ID")=request.cookies("userid")
    rs("PassTime")=now()
    rs("Paper_Type")=0
    rs1("havepass")=6
  end if
 rs1("passuserid")=request.cookies("userid")
 rs1("passtime")=now()
 rs1("passadvice")=request("passadvice")
 rs1.update
 rs.update
 'rs1.close
 'rs.close
'end if
%>
<p><br>
<br>
</p>
<div align="center">
  <center>
  <table cellspacing="0" style="border-collapse: collapse" bordercolor="#336699" width="480" id="AutoNumber2" cellpadding="0" border="1">
    <tr>
      <td width="100%" height="25" bgcolor="#6699CC"><b>&nbsp;<font color="#FFFFFF">操作成功</font></b></td>
    </tr>
    <tr>
      <td width="100%" height="160" bgcolor="#EFEFEF">
      <p align="center"><font size="2">祝贺您,已经成功审批考试计划!</font></td>
    </tr>
    <tr>
      <td width="100%" height="25" bgcolor="#6699CC">
      <p align="center">
      <input type="button" value=" 返 回 " name="B3" class="s02" onClick="window.location='news.asp'"></td>
    </tr>
  </table>
  </center>
</div>
<%
end if


if request("objname")="新闻" then
newsid=request("newsid")

sql="select * from exam_news where newsid="&newsid
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
'if rs("passuserid")<>"" then
'else
  rs("passuserid")=request.cookies("userid")
  rs("passtime")=now()
  rs.update
  rs.close
  sql="select * from waitforpass where objid="&newsid
  set rs=server.createobject("adodb.recordset")
  rs.open sql,conn,3,2
  if request("yesorno")="同意" then
  rs("havepass")=1
  else
  rs("havepass")=0
  end if
  rs("passuserid")=request.cookies("userid")
  rs("passtime")=now()
  rs("passadvice")=request("passadvice")
  rs.update
  rs.close
 ' end if
%>
<p><br>
<br>
</p>
<div align="center">
  <center>
  <table cellspacing="0" style="border-collapse: collapse" bordercolor="#336699" width="480" id="AutoNumber2" cellpadding="0" border="1">
    <tr>
      <td width="100%" height="25" bgcolor="#6699CC"><b>&nbsp;<font color="#FFFFFF">操作成功</font></b></td>
    </tr>
    <tr>
      <td width="100%" height="160" bgcolor="#EFEFEF">
      <p align="center"><font size="2">祝贺您,已经成功审批新闻!</font></td>
    </tr>
    <tr>
      <td width="100%" height="25" bgcolor="#6699CC">
      <p align="center">
      <input type="button" value=" 返 回 " name="B3" class="s02" onClick="window.location='news.asp'"></td>
    </tr>
  </table>
  </center>
</div>
<%
end if
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?