admin_dj.asp

本程序采用花香内核

<%
rscat.close
set rscat=nothing%>    
      <%
i=i+1
rs.movenext
loop
else
if rs.eof and rs.bof then
%>
        <tr class=lanyuds> 
          <td colspan="9" 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 class=lanyuqs> <td class=lanyuqs colspan="9"><table width="100%" align="center">
            <td align="seft"> 
            <input type=hidden value=DEL name=operation>
	 <input type="checkbox" name="chkall" onclick="CheckAll(this.form)" value="ON">选中本页所有 <input type=submit value=批量删除 onclick="return Del()"> </td>
            <td align="right"><%=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">
            </table></td>
          </tr>
        </form>
      </table>

	  <%end if
if request.querystring("action")="newdj" then%>
     <table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            新增歌曲</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌曲名称：</td>
            <td width="83%"> 
              <input type="text" name="name" size="40"> 添加人：<input type="text" name="tjuser" size="10" value="虫虫">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌手姓名：</td>
            <td width="83%"> 
              <input type="text" name="user" size="20" value="虫虫提供">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌曲选项：</td>
            <td width="83%"> 
              <select name="djcatid">
                <%
sql="select * from djcat where sid=0"
set rs1=conn.execute(sql)
do while not rs1.eof
response.write "<optgroup label='"&rs1("djcat_name")&"'>"
sql="select * from djcat where sid="&rs1("djcat_id") 
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof
%>
              <option value="<%=rs2("djcat_id")%>">├ <%=rs2("djcat_name")%></option>
<%
rs2.movenext
loop
rs1.movenext
loop
rs1.close
set rs1=nothing%>
              </select>
<select name="pic">
<option value="rm">播放类型</option>
<option value="asf">ASF音乐</option>
<option value="asfmtv">ASF影视</option>
<option value="rm">RAM音乐</option>
<option value="rmmtv">RAM影视</option>
<option value="flash">FLASH动画</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 class=lanyuds> 
            <td width="17%">视听地址</td>
            <td width="83%"> 
              <input type="text" name="url" size="60">
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>       

          <tr class=lanyuds> 
            <td width="17%">添加歌词：</td>
            <td width="83%"> 
              <textarea rows="6" name="Word" cols="60">暂无歌词</textarea>
            </td>
          </tr>
          
          <tr class=lanyuqs align="center"> 
            <td colspan="2"> 
              <input type="checkbox" name="istop" value="1">
              置顶&nbsp;&nbsp;&nbsp;<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>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
      <%end if
	  if request.QueryString("action")="editdj" then
	  if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的歌曲ID参数！');history.back(1);</script>")
	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 align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            修改歌曲</td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌曲名称：</td>
            <td width="83%"> 
              <input name="name" type="text" class="textarea" id="name" size="40" value="<%=rs("dj_name")%>"> 添加人：<input type="text" name="tjuser" size="10" value="<%=rs("tjuser")%>"> 
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌手姓名：</td>
            <td width="83%"> 
              <input name="user" type="text" class="textarea" id="user" size="20" value="<%=rs("dj_user")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌曲分类：</td>
            <td width="83%"> 
            <select name="djcatid" id="djcatid">
                <%
sql="select * from djcat where sid=0"
set rs1=conn.execute(sql)
do while not rs1.eof
response.write "<optgroup label='"&rs1("djcat_name")&"'>"
sql="select * from djcat where sid="&rs1("djcat_id") 
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
rs1.movenext
loop
rs1.close
set rs1=nothing%>
              </select>
<select name="pic">
<option value="asf" <%if rs("dj_pic")="asf" then response.write "selected" end if%>>ASF音乐</option>
<option value="asfmtv" <%if rs("dj_pic")="asfmtv" then response.write "selected" end if%>>ASF影视</option>
<option value="rm" <%if rs("dj_pic")="rm" then response.write "selected" end if%>>RAM音乐</option>
<option value="rmmtv" <%if rs("dj_pic")="rmmtv" then response.write "selected" end if%>>RAM影视</option>
<option value="flash" <%if rs("dj_pic")="flash" then response.write "selected" end if%>>FLASH动画</option>
</select>
<select name="desc">
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★" selected>☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
          <tr class=lanyuds> 
            <td  width="17%">视听地址</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>
          <tr class=lanyuds> 
            <td width="17%">添加歌词：</td>
            <td width="83%"> 
              <textarea rows="6" name="Word" cols="60"><%=rs("dj_word")%></textarea>
            </td>
          </tr>
          <tr  class=lanyuqs align="center"> 
            <td colspan="2"> <input name="istop" type="checkbox"  id="istop" value="1" <%if rs("istop")=1 then response.write "checked" end if%>>
              置顶&nbsp;&nbsp;&nbsp;<input name="isbest" type="checkbox"  id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐&nbsp;&nbsp;&nbsp; 
              <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>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
	  <%end if
if request.QueryString("action")="editerror" then
	  if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的歌曲ID参数！');history.back(1);</script>")
	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 align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=lanyuss> 
            <td colspan="2">
            修改歌曲：</td>
          </tr>
          <tr class=lanyuds> 
            <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 class=lanyuds> 
            <td width="17%">歌手姓名：</td>
            <td width="83%"> 
              <input name="user" type="text" class="textarea" id="user" size="20" value="<%=rs("dj_user")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">歌曲分类：</td>
            <td width="83%"> 
              <select name="djcatid" id="djcatid">
                <%
sql="select * from djcat where sid=0"
set rs1=conn.execute(sql)
do while not rs1.eof
response.write "<optgroup label='"&rs1("djcat_name")&"'>"
sql="select * from djcat where sid="&rs1("djcat_id") 
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
rs1.movenext
loop
rs1.close
set rs1=nothing%>
</select>
<select name="pic">
<option value="asf" <%if rs("dj_pic")="asf" then response.write "selected" end if%>>ASF音乐</option>
<option value="asfmtv" <%if rs("dj_pic")="asfmtv" then response.write "selected" end if%>>ASF影视</option>
<option value="rm" <%if rs("dj_pic")="rm" then response.write "selected" end if%>>RAM音乐</option>
<option value="rmmtv" <%if rs("dj_pic")="rmmtv" then response.write "selected" end if%>>RAM影视</option>
<option value="flash" <%if rs("dj_pic")="flash" then response.write "selected" end if%>>FLASH动画</option>
</select>
<select name="desc">
<option value="☆☆☆☆★">☆☆☆☆★</option>
<option value="☆☆☆★★">☆☆☆★★</option>
<option value="☆☆★★★" selected>☆☆★★★</option>
<option value="☆★★★★">☆★★★★</option>
<option value="★★★★★">★★★★★</option>
              </select>
            </td>
          </tr>
<tr class=lanyuds> 
              <td> 上传文件： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=dj"></iframe></td>
            </tr>
          <tr class=lanyuds> 
            <td  width="17%">视听地址：</td>
            <td  width="83%"> 
              <input name="url" type="text" id="url" size="60" value="<%=rs("dj_url")%>">
            </td>
          </tr>
          <tr class=lanyuds> 
            <td width="17%">添加歌词：</td>
            <td width="83%"> 
              <textarea rows="6" name="Word" cols="60"><%=rs("dj_word")%></textarea>
            </td>
          </tr>
          <tr  class=lanyuqs align="center"> 
            <td colspan="2"> <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="editerror">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<br>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss> 
<td>类型说明</td>
</tr>
<tr  class=lanyuds>
<td>1."<FONT COLOR="#FF0000">.mp3.mid.wma.asf"纯音乐文件请选择<FONT COLOR="#0000FF">ASF音乐类型<br>2."<FONT COLOR="#FF0000">.wmv.asf.mpg.avi"影视文件选择<FONT COLOR="#0000FF">ASF影视类型.<br>3."<FONT COLOR="#FF0000">.ram.rm"纯音乐文件请选择<FONT COLOR="#0000FF">RAM音乐类型<br>4."<FONT COLOR="#FF0000">.ram.rm"影视文件请选择<FONT COLOR="#0000FF">RAM影视类型<br>5."<FONT COLOR="#FF0000">.swf"动画文件请选择<FONT COLOR="#0000FF">FLASH动画类型
</td></tr></table>
<%end if
end if
rs.close
set rs=nothing
%>