admindj_body.asp

音乐类型的好网站

      <%
i=i+1
rs.movenext
loop
else
if rs.eof and rs.bof then
%>
        <tr> 
          <td bgcolor="#990000" colspan="4" height="22" align="center">当前没有歌曲！</td>
        </tr>
      <%end if
end if%>
        <form name="form1" method="post" action="admin_index.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_index.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_index.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 align="center"> 
            <td colspan="2">
            ：：：新增歌曲：：：</td>
          </tr>
          <tr bgcolor="#990000"> 
            <td width="17%">歌曲名称</td>
            <td width="83%"> 
              <input name="name" type="text" size="40">
            </td>
          </tr>
          <tr bgcolor="#990000"> 
            <td width="17%">歌曲选项</td>
            <td 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>
注意：MP3,WMA歌曲请选择为asf格式</td>
          </tr>
          <tr bgcolor="#990000"> 
            <td width="17%">视听地址</td>
            <td width="83%"> 
              <input type="text" name="url" size="60">
            </td>
          </tr>
          
          <tr  align="center"> 
            <td height="30" colspan="2"> 
              <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_index.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 align="center"> 
            <td colspan="2">
            <font>：：：修改歌曲：：：</font></td>
          </tr>
          <tr bgcolor="#990000"> 
            <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="#990000"> 
            <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="#990000"> 
            <td  width="17%">视听地址</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
          <tr  align="center"> 
            <td colspan="2" height="30" > <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_index.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">
            删除歌曲</td>
          </tr>
          <tr bgcolor="#990000"> 
            <td width="17%">歌曲名称</td>
            <td width="83%"> <%=rs("dj_name")%> 　</td>
          </tr>
          <tr bgcolor="#990000"> 
            <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="#990000"> 
            <td width="17%">视听地址</td>
            <td width="83%"><%=rs("dj_url")%> 　</td>
          </tr>
          <tr  align="center"> 
            <td colspan="2" height="30" > 
              <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_index.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%>