📄 admindj_body.asp
字号:
<%sub admindj_body()
%>
<HTML><HEAD><TITLE>管理中心</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="inc/style.css" type=text/css rel=stylesheet>
<script language="JavaScript" src="inc/open.js"></script>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
</HEAD>
<body onkeydown=return(!(event.keyCode==78&&event.ctrlKey))>
<%if request.querystring("action")="djerror" then%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bgcolor="#F5F5F5" style="border-collapse: collapse" bordercolor="#C0C0C0" align="center">
<tr>
<td colspan="3" background="images/pic000/c005.jpg"> <font color="#333333">错误连接管理
<font color="#FF0000"> 请修改成为正确路径，错误报告连接自动消除</font></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="60%">舞曲名称</td>
<td width="20%" align="center">报错人次</td>
<td width="20%" align="center">操作</td>
</tr>
<%
sql="select * from dj where error > 0 order by dj_id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof
%><tr bgcolor="#FFFFFF"><td><a href="javascript:openwin('../play.asp?dj_id=<%=rs("dj_id")%>')"><%=rs("dj_name")%></td>
<td align="center"><%=rs("error")%></td>
<td align="center"><a href="admin_dj.asp?id=<%=rs("dj_id")%>&action=editdj">edit</a> <a href="admin_dj.asp?id=<%=rs("dj_id")%>&action=deldj">del</a></td>
</tr>
<%rs.movenext
loop
if rs.eof and rs.bof then%>
当前还没有错误舞曲
<%end if%>
</table>
<%end if%>
<%if request.querystring("action")="djcat" then
sql="select * from djcat order by djcat_id DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<tr>
<td colspan="3">
<font color="#333333">舞曲分类管理</font></td>
</tr>
<tr bgcolor="#FFFFFF" align="center">
<td width="10%" class="chinese">编号</td>
<td width="70%" class="chinese">分类名称</td>
<td width="20%" class="chinese">操作</td>
</tr>
<%do while not rs.eof%>
<tr bgcolor="#FFFFFF">
<td align="center"><%=rs("djcat_id")%> </td>
<td class="chinese"><a href="../dj.asp?djcat_id=<%=rs("djcat_id")%>" target="_blank"><%=rs("djcat_name")%></a> </td>
<td align="center"><a href="admin_dj.asp?id=<%=rs("djcat_id")%>&action=editdjcat">edit</a>
<a href="admin_dj.asp?id=<%=rs("djcat_id")%>&action=deldjcat">del</a> <a href="../dj.asp?djcat_id=<%=rs("djcat_id")%>" target="_blank">view</a></td>
</tr>
<%rs.movenext
loop
if rs.bof and rs.eof then%>
<tr bgcolor="#FFFFFF" align="center">
<td colspan="3">当前没有舞曲分类！</td>
</tr>
<%rs.close
set rs=nothing
end if%>
</table>
<br>
<%end if
if request.querystring("action")="newdjcat" then%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td>
<font color="#333333">新增舞曲分类</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"">分类名称-
<input type="text" name="djcat_name" size="40" class="textarea">
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" height="30" align="center">
<input type="submit" name="Submit" value="确定新增" class="button">
<input type="reset" name="Reset" value="清空重填" class="button">
</td>
</tr>
<input type="hidden" name="action" value="newdjcat">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.QueryString("action")="editdjcat" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
call diserror()
response.end
else
if not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的舞曲分类ID参数！"
call diserror()
response.end
end if
end if
sql="select * from djcat where djcat_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td>
<font color="#333333">修改舞曲分类</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">分类名称-
<input name="djcat_name" type="text" class="textarea" id="djcat_name" size="40" value="<%=rs("djcat_name")%>">
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" height="30" align="center"> <input name="Submit" type="submit" class="button" id="Submit" value="确定修改">
<input name="Reset" type="reset" class="button" id="Reset" value="清空重填"> </td>
</tr>
<input type="hidden" name="id" value="<%=rs("djcat_id")%>">
<input type="hidden" name="action" value="editdjcat">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.QueryString("action")="deldjcat" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
call diserror()
response.end
else
if not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的舞曲分类ID参数！"
call diserror()
response.end
end if
end if
sql="select * from djcat where djcat_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td>
<font color="#333333">删除舞曲分类</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">分类名称- <%=rs("djcat_name")%>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" height="30" align="center">
<input name="Submit" type="submit" class="button" id="Submit" value="确定删除">
</td>
</tr>
<input type="hidden" name="id" value="<%=rs("djcat_id")%>">
<input type="hidden" name="action" value="deldjcat">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%end if
if request.querystring("action")="dj" then
sql="select * from dj order by dj_id desc"
if request.querystring("djcat_id")<>"" then
sql="select * from dj where djcat_id="&cint(request.querystring("djcat_id"))&" order by dj_id desc"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
totaldj=rs.recordcount
%>
<table width="98%" border="1" cellspacing="0" cellpadding="4" bgcolor="#F5F5F5" style="border-collapse: collapse" bordercolor="#C0C0C0" align="center">
<tr>
<td>
<font color="#333333">舞曲管理</font></td>
<form name="form3" method="post" action=""><td align="right" colspan="3">
<select name="go" onChange='window.location=form.go.options[form.go.selectedIndex].value'>
<option value="">选择显示方式</option>
<option value="admin_dj.asp?action=dj">显示所有舞曲</option>
<%sql="select * from djcat"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof%>
<option value="admin_dj.asp?action=dj&djcat_id=<%=rs2("djcat_id")%>"><%=rs2("djcat_name")%></option>
<%rs2.movenext
loop
if rs2.bof and rs2.eof then%><option value="">当前没有分类</option>
<%end if
rs2.close
set rs2=nothing%>
</select>
</td>
</form>
</tr>
<tr bgcolor="#FFFFFF">
<td width="45%">舞曲名称</td>
<td width="25%" align="center">加入时间</td>
<td width="10%" align="center">点击</td>
<td width="20%" align="center">操作</td>
</tr>
<%
if not rs.eof then
rs.movefirst
rs.pagesize=djperpage
if trim(request("page"))<>"" then
currentpage=clng(request("page"))
if currentpage>rs.pagecount then
currentpage=rs.pagecount
end if
else
currentpage=1
end if
totaldj=rs.recordcount
if currentpage<>1 then
if (currentpage-1)*djperpage<totaldj then
rs.move(currentpage-1)*djperpage
dim bookmark
bookmark=rs.bookmark
end if
end if
if (totaldj mod djperpage)=0 then
totalpages=totaldj\djperpage
else
totalpages=totaldj\djperpage+1
end if
i=0
do while not rs.eof and i<djperpage
%>
<tr bgcolor="#FFFFFF">
<td><a href="javascript:openwin('../play.asp?dj_id=<%=rs("dj_id")%>')"><%=rs("dj_name")%></td>
<td align="center"><%=rs("dj_date")%></td>
<td align="center"><%=rs("dj_count")%></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -