📄 adminvote_body.asp
字号:
<%sub adminvote_body()
%>
<HTML><HEAD><TITLE>管理中心</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="inc/adminstyle.css" type=text/css rel=StyleSheet>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
</HEAD>
<body onkeydown=return(!(event.keyCode==78&&event.ctrlKey))>
<%if request.querystring("action")="newvote" then%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form1" method="post" action="">
<tr class="a1">
<td colspan="2">新增投票主题</td>
</tr>
<tr class="a3">
<td width="16%">主题名称</td>
<td width="84%">
<input type="text" name="vt_name" size="50" maxlength="50">
</td>
</tr>
<tr class="a4">
<td width="16%">开始日期</td>
<td width="84%">
<input type="text" name="vt_startdate" size="30">
例子：2002-09-30 </td>
</tr>
<tr class="a3">
<td width="16%">过期日期</td>
<td width="84%">
<input type="text" name="vt_expiredate" size="30">
同上</td>
</tr>
<tr class="a4" align="center">
<td colspan="2" height="30" bgcolor="#F5F5F5">
<input type="submit" name="Submit" value="确定新增">
<input type="reset" name="Reset" value="清空重填">
</td>
</tr>
<input type="hidden" name="action" value="newvote">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.querystring("action")="vote" then
sql="select * from votetopic"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<tr>
<td colspan="3" class="a1">投票主题管理</td>
</tr>
<tr align="center" class="a4">
<td width="10%">编号</td>
<td width="60%">投票主题</td>
<td width="30%">操作</td>
</tr>
<%do while not rs.eof%>
<tr class="a3">
<td align="center"><%=rs("vt_id")%> </td>
<td><%=rs("vt_name")%> </td>
<td align="center"><a href="admin_vote.asp?action=vote&caction=edit&id=<%=rs("vt_id")%>">edit</a>
<a href="admin_vote.asp?action=vote&caction=del&id=<%=rs("vt_id")%>">del</a></td>
</tr>
<%rs.movenext
loop
if rs.bof and rs.eof then%>
<tr>
<td colspan="3" class="a3" align="center">当前没有投票主题！</td>
</tr>
<%end if%>
</table>
<br>
<%if request.querystring("action")="vote" and request.querystring("caction")="edit" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
call diserror()
response.end
end if
sql="select * from votetopic where vt_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form2" method="post" action="">
<tr class="a1">
<td colspan="3">修改投票主题</td>
</tr>
<tr class="a3">
<td width="18%">主题名称</td>
<td colspan="2">
<input type="text" name="vt_name" size="50" maxlength="50" value="<%=rs("vt_name")%>">
</td>
</tr>
<tr class="a4">
<td width="18%">开始日期</td>
<td colspan="2">
<input type="text" name="vt_startdate" size="30" value="<%=rs("vt_startdate")%>">
</td>
</tr>
<tr class="a3">
<td width="18%">过期日期</td>
<td colspan="2">
<input type="text" name="vt_expiredate" size="30" value="<%=rs("vt_expiredate")%>">
</td>
</tr>
<tr class="a4">
<td colspan="3"><a href="admin_vote.asp?action=newitem&id=<%=rs("vt_id")%>">新增投票选项</a></td>
</tr>
<%sql="select * from voteitem where vt_id="&cint(request.querystring("id"))
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof
%>
<tr class="a3">
<td width="18%">投票选项</td>
<td width="57%"><%=rs2("item_name")%> <span class="newshead"><%=rs2("item_count")%></span>票</td>
<td width="25%" align="center"><a href="admin_vote.asp?action=edititem&id=<%=rs2("item_id")%>&vt_id=<%=request.querystring("id")%>">edit</a>
<a href="admin_vote.asp?action=delitem&id=<%=rs2("item_id")%>&vt_id=<%=request.querystring("id")%>">del</a></td>
</tr>
<%rs2.movenext
loop
if rs2.eof and rs2.bof then%>
<tr class="a3">
<td colspan="3">当前没有投票选项！</td>
</tr>
<%end if
rs2.close
set rs2=nothing%>
<tr align="center" class="a4">
<td colspan="3" height="30">
<input type="submit" name="Submit" value="确定修改">
<input type="reset" name="Reset" value="清空重填">
</td>
</tr>
<input type="hidden" name="id" value="<%=rs("vt_id")%>">
<input type="hidden" name="action" value="editvote">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%
rs.close
set rs=nothing
end if
end if
if request.querystring("action")="newitem" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
call diserror()
response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("id"))
set rs=conn.execute(sql)%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form3" method="post" action="">
<tr class="a1">
<td colspan="2">新增投票选项</td>
</tr>
<tr class="a3">
<td width="13%">所属主题</td>
<td width="87%"><%=rs("vt_name")%> </td>
</tr>
<tr class="a4">
<td width="13%">选项名称</td>
<td width="87%">
<input type="text" name="item_name" size="40" maxlength="50">
</td>
</tr>
<tr align="center" class="a3">
<td colspan="2" height="30">
<input type="submit" name="Submit" value="确定新增">
<input type="reset" name="Reset" value="清空重填">
</td>
</tr>
<input type="hidden" name="id" value="<%=rs("vt_id")%>">
<input type="hidden" name="action" value="newitem">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%rs.close
set rs=nothing
end if
if request.querystring("action")="edititem" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
call diserror()
response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("vt_id"))
set rs=conn.execute(sql)
sql="select item_id,item_name from voteitem where item_id="&cint(request.querystring("id"))
set rs2=conn.execute(sql)%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form3" method="post" action="">
<tr class="a1">
<td colspan="2">修改投票选项</td>
</tr>
<tr class="a3">
<td width="13%">所属主题</td>
<td width="87%"><%=rs("vt_name")%> </td>
</tr>
<tr class="a4">
<td width="13%">选项名称</td>
<td width="87%">
<input type="text" name="item_name" size="40" maxlength="50" value="<%=rs2("item_name")%>">
</td>
</tr>
<tr align="center" class="a3">
<td colspan="2" height="30">
<input type="submit" name="Submit" value="确定修改">
<input type="reset" name="Reset" value="清空重填">
[<a href="admin_vote.asp?action=vote&caction=edit&id=<%=request.querystring("vt_id")%>">返回</a>]
</td>
</tr>
<input type="hidden" name="vtid" value="<%=rs("vt_id")%>">
<input type="hidden" name="id" value="<%=rs2("item_id")%>">
<input type="hidden" name="action" value="edititem">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
if request.querystring("action")="delitem" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
call diserror()
response.end
end if
sql="select vt_name,vt_id from votetopic where vt_id="&cint(request.querystring("vt_id"))
set rs=conn.execute(sql)
sql="select item_id,item_name from voteitem where item_id="&cint(request.querystring("id"))
set rs2=conn.execute(sql)%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form3" method="post" action="">
<tr class="a1">
<td colspan="2">删除投票选项</td>
</tr>
<tr class="a3">
<td width="13%">所属主题</td>
<td width="87%"><%=rs("vt_name")%> </td>
</tr>
<tr class="a4">
<td width="13%">选项名称</td>
<td width="87%"><%=rs2("item_name")%> </td>
</tr>
<tr class="a3" align="center">
<td colspan="2" height="30">
<input type="submit" name="Submit" value="确定删除">
[<a href="admin_vote.asp?action=vote&caction=edit&id=<%=request.querystring("vt_id")%>">返回</a>] </td>
</tr>
<input type="hidden" name="vtid" value="<%=rs("vt_id")%>">
<input type="hidden" name="id" value="<%=rs2("item_id")%>">
<input type="hidden" name="action" value="delitem">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
if request.querystring("action")="vote" and request.querystring("caction")="del" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>你必须指定操作的对象！"
call diserror()
response.end
end if
sql="select * from votetopic where vt_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table cellpadding="2" cellspacing="1" border="0" width="760" cellpadding="4" align=center class="a2">
<form name="form2" method="post" action="">
<tr class="a1">
<td colspan="2">删除投票主题</td>
</tr>
<tr class="a4">
<td width="18%">主题名称</td>
<td width="82%"> <%=rs("vt_name")%> </td>
</tr>
<tr class="a3">
<td width="18%">开始日期</td>
<td width="82%"> <%=rs("vt_startdate")%> </td>
</tr>
<tr class="a4">
<td width="18%">过期日期</td>
<td width="82%"> <%=rs("vt_expiredate")%> </td>
</tr>
<%sql="select * from voteitem where vt_id="&cint(request.querystring("id"))
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof
%>
<tr class="a3">
<td width="18%">投票选项</td>
<td width="82%"><%=rs2("item_name")%> <span class="newshead"><%=rs2("item_count")%></span>票</td>
</tr>
<%rs2.movenext
loop
if rs2.eof and rs2.bof then%>
<tr class="a3">
<td colspan="2">当前没有投票选项！</td>
</tr>
<%end if
rs2.close
set rs2=nothing%>
<tr align="center" class="a4">
<td colspan="2" height="30">
<input type="submit" name="Submit" value="确定删除">
[<a href="admin_vote.asp?action=vote">返回</a>] </td>
</tr>
<input type="hidden" name="id" value="<%=rs("vt_id")%>">
<input type="hidden" name="action" value="delvote">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%
rs.close
set rs=nothing
end if%>
<br>
</td>
</tr>
</table>
<%
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -