votemanage.asp

BOB人才招聘系统

<%@language=vbscript codepage=936 %>
<!--#include file="Admin.asp"-->
<!--#include file="Conndb.asp"-->
<%
dim sql,rs,Action,ID
Action=Trim(Request("Action"))
ID=Trim(Request("VoteID"))
if Action="Set" and ID<>"" then
	conn.execute "Update Vote set IsSelected=False where IsSelected=True"
	conn.execute "Update Vote set IsSelected=True Where ID=" & ID
	response.Write "<script language='JavaScript' type='text/JavaScript'>alert('设置成功！');</script>"
end if
sql="select * from Vote order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<!-- #include file="Head.asp" -->
<table width="100%" height="93%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="180" align="center" valign="top"><!-- #include file="left.asp" --></td>
    <td align="center" valign="top">
	<br>
<form method="POST" action="VoteManage.asp">
      <table height="126" border="0" cellpadding="0" cellspacing="0"  class=tableBorder>
        <tr>
          <td colspan="4" background=images/top_bg.gif height="25">
		  <div align="center" style="color: #ffffFF; font-weight: bold;">添加新调查</div></td>
</tr>
<tr><td colspan="4">       
      <table width="100%" height="99" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#f1f3f5">
          <tr> 
            <td width="37" height="25" align="center">选择</td>
            <td width="37" align="center">ID</td>
            <td width="328" align="center">主题</td>
            <td width="88" align="center">操作</td>
    </tr>
<%
if not (rs.bof and rs.eof) then
	do while not rs.eof
%>
          <tr> 
            <td width="37" height="22" align="center"> 
              <input type="radio" value=<%=rs("ID")%><%if rs("IsSelected")=true then%> checked<%end if%> name="VoteID"></td>
            <td width="37" height="22" align="center"><%=rs("ID")%></td>
            <td height="22">&nbsp;<%=rs("Title")%></td>
            <td width="88" height="22" align="center"><a href="VoteModify.asp?ID=<%=rs("ID")%>">修改</a> 
              <a href="VoteDel.asp?ID=<%=rs("ID")%>">删除</a></td>
    </tr>
    <%
rs.movenext
loop
%>
    <tr> 
      <td height="30" colspan=4 align=center><input name="Action" type="hidden" id="Action" value="Set"> 
        <input type="submit" value="将选定的调查设为最新调查" name="submit">      </td>
    </tr>
<% end if%></table>
</td></tr>  </table>
</form>        </strong></p>
    </td>
  </tr>
</table>
<!-- #include file="Foot.asp" -->
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>