admindj_body.asp

不错的asp论坛,大家可以看看啊和呵呵.

<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>     
      <%
i=i+1
rs.movenext
loop
else
if rs.eof and rs.bof then
%>
        <tr> 
          <td bgcolor="#FFFFFF" colspan="4" height="22" align="center">当前没有舞曲！</td>
        </tr>
      <%end if
end if%>
        <form name="form1" method="post" action="admin_dj.asp?action=dj&djcat_id=<%=request.querystring("djcat_id")%>">
          <tr> 
            <td align="right" colspan="4"> <%=currentpage%> /<%=totalpages%>页,<%=totaldj%>条记录/<%=djperpage%>篇每页. 
              <%
i=1
showye=totalpages
if showye>10 then
showye=10
end if
for i=1 to showye
if i=currentpage then
%>
              <%=i%> 
              <%else%>
              <a href="admin_dj.asp?action=dj&page=<%=i%>&djcat_id=<%=request.querystring("djcat_id")%>"><%=i%></a> 
              <%end if
next
if totalpages>currentpage then
if request("page")="" then
page=1
else
page=request("page")+1
end if%>
              <a href="admin_dj.asp?action=dj&page=<%=page%>&djcat_id=<%=request.querystring("djcat_id")%>" title="下一页">>></a> 
              <%end if%>
              &nbsp;&nbsp;&nbsp;&nbsp; 
              <input type="text" name="page" class="textarea" size="4">
              <input type="submit" name="Submit" value="Go" class="button">
            </td>
          </tr>
        </form>
      </table>
      <br>
	  <%end if
if request.querystring("action")="newdj" then%>
      <table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr> 
            <td colspan="2">
            <font color="#333333">新增舞曲</font></td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> 
              <input type="text" name="name" size="40">
            </td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td class="chinese" width="17%">舞曲选项</td>
            <td class="chinese" width="83%"> 
              <select name="djcatid">
<%
sql="select * from djcat"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof%><option value="<%=rs("djcat_id")%>"><%=rs("djcat_name")%></option>
<%rs.movenext
loop
if rs.eof and rs.bof then%><option value="0">当前没有舞曲分类</option>
<%end if%>
</select>
<select name="pic">
<option value="rm">播放类型</option>
<option value="rm">rm</option>
<option value="asf">asf</option>
<option value="flash">flash</option>
<option value="rmmtv">rmmtv</option>
<option value="asfmtv">aspmtv</option>
              </select>
<select name="desc">
<option value="☆☆★★★">推荐等级</option>
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★">☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">视听地址</td>
            <td width="83%"> 
              <input type="text" name="url" size="60">
            </td>
          </tr>
          
          <tr bgcolor="#E8E8E8" align="center"> 
            <td colspan="2" height="30" bgcolor="#F5F5F5"> 
              <input type="checkbox" name="isbest" value="1">
              推荐&nbsp;&nbsp;&nbsp; 
              <input type="submit" name="Submit" value="确定新增" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button">
              [<a href="admin_dj.asp?action=dj">返回</a>] </td>
          </tr>
		  <input type="hidden" name="action" value="newdj">
		<input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
      <%end if
	  if request.QueryString("action")="editdj" 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 dj where dj_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="form2" method="post" action="">
          <tr> 
            <td colspan="2">
            <font color="#333333">修改舞曲</font></td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> 
              <input name="name" type="text" class="textarea" id="name" size="40" value="<%=rs("dj_name")%>">
            </td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">舞曲分类</td>
            <td width="83%"> 
              <select name="djcatid" id="djcatid">
                <%
sql="select * from djcat"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof%>
                <option value="<%=rs2("djcat_id")%>" <%if rs2("djcat_id")=rs("djcat_id") then response.write "selected" end if%>><%=rs2("djcat_name")%></option>
                <%rs2.movenext
loop
if rs2.eof and rs2.bof then%>
                <option value="0">当前没有舞曲分类</option>
                <%end if%>
              </select><input name="pic" type="text" id="pic" size="20" value="<%=rs("dj_pic")%>">
<input name="desc" type="text" id="desc" size="20" value="<%=rs("dj_desc")%>">
            </td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td  width="17%">视听地址</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
          <tr bgcolor="#E8E8E8" align="center"> 
            <td colspan="2" height="30" bgcolor="#F5F5F5"> <input name="isbest" type="checkbox"  id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐
              <input name="Submit" type="submit" id="Submit" value="确定修改"> 
              <input type="reset" name="Reset" value="清空重填" >
              [<a href="admin_dj.asp?action=dj">返回</a>] </td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("dj_id")%>">
          <input type="hidden" name="action" value="editdj">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if
	  if request.QueryString("action")="deldj" 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 dj where dj_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="form2" method="post" action="">
          <tr> 
            <td colspan="2">
            <font color="#333333">删除舞曲</font></td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">舞曲名称</td>
            <td width="83%"> <%=rs("dj_name")%> 　</td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">舞曲分类</td>
            <td width="83%"> 
                <%
sql="select * from djcat where djcat_id="&rs("djcat_id")
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
%><%=rs2("djcat_name")%> 　</td>
          </tr>
          <tr bgcolor="#FFFFFF"> 
            <td width="17%">视听地址</td>
            <td width="83%"><%=rs("dj_url")%> 　</td>
          </tr>
          <tr bgcolor="#E8E8E8" align="center"> 
            <td colspan="2" height="30" bgcolor="#F5F5F5"> 
              <input name="isbest" type="checkbox" id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐 
              <input name="Submit" type="submit" id="Submit" value="确定删除">
              [<a href="admin_dj.asp?action=dj">返回</a>] </td>
          </tr>
          <input type="hidden" name="id" value="<%=rs("dj_id")%>">
          <input type="hidden" name="action" value="deldj">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if%>
      <br>
    </td>
  </tr>
</table>
<%
end sub%>