<%PageName="SongModify"%>
<!--#include file="function.asp"-->
<!--#include file="error.ini"-->
<!--#include file="../inc/admin_conn.asp"-->
<!--#include file="top.asp"-->
<!--#include file="Star.inc"-->
<%
id=request.QueryString("id")
AskClassid=request.QueryString("AskClassid")
AskSClassid=request.QueryString("AskSClassid")
AskNClassid=request.QueryString("AskNClassid")
page=request.QueryString("page")
set rs=server.createobject("adodb.recordset")
sql="select * from ylmv_MusicList where id="&id
rs.open sql,conn,1,1
if rs.eof then
	errmsg=errmsg+"<br>"+"<li>操作错误！请联系管理员"
	call error()
	Response.End 
else
	musictype=rs("musictype")
	Wma=rs("Wma")
	song_path=rs("song_path")
	MusicName=rs("MusicName")
	hits=rs("hits")
	Classid=rs("Classid")
	SClassid=rs("SClassid")
	Nclassid=rs("Nclassid")
	Specialid=rs("Specialid")
	singer=rs("singer")
end if
rs.close
%>
<link href="Images/Admin_Style.Css" rel="stylesheet" type="text/css">
<div align="center">
<center>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
        <form method="POST" action="Admin_Allmusic_Err.Asp?id=<%=id%>&AskClassid=<%=AskClassid%>&AskSClassid=<%=AskSClassid%>&AskNClassid=<%=AskNClassid%>&page=<%=page%>">
          <tr class="title">
           <td width="100%" height="20" colspan=2 align=center><b>修 改 歌 曲</b></td>
          </tr>
          <tr>
               <td class=tdbg align=right>分类：</td>
               <td class=tdbg><select class="smallSel" name="classid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid='+this.options[this.selectedIndex].value,'_self')">
<%
set rs=server.createobject("adodb.recordset")
sql="select * from ylmv_class"
rs.open sql,conn,1,1
do while not rs.eof
%>
                <option<%if (cstr(request("classid"))=cstr(rs("classid")) and request("classid")<>"") or (cstr(Classid)=cstr(rs("Classid")) and request("classid")="") then%> selected<%end if%> value="<%=CStr(rs("classID"))%>" name=classid><%=rs("class")%></option>
<%
rs.movenext
loop
rs.close
%>
              </select>&nbsp;&nbsp;     
<%if request("classid")<>"" or request("Sclassid")<>"" then
	if request("classid")<>"" then%>
              <select name="Sclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid='+this.options[this.selectedIndex].value,'_self')">     
<%	else%>
              </select>
              <select name="Sclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=Classid%>&SClassid='+this.options[this.selectedIndex].value,'_self')">    
<%	end if%>
                <option value="" <%if request("Nclassid")="" then%> selected<%end if%>>选择栏目</option>
<%
	if request("classid")<>"" then
		sql="select * from ylmv_Sclass where classid="&request("classid")
	else
		sql="select * from ylmv_Sclass where classid="&classid
	end if
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if (cstr(request("Sclassid"))=cstr(rs("Sclassid")) and request("Sclassid")<>"") then%> selected<%end if%> value="<%=CStr(rs("Sclassid"))%>" name=Sclassid><%=rs("Sclass")%></option>
<%
	rs.MoveNext
	Loop
	rs.close

else
%>
              </select>
              <select name="Sclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid='+this.options[this.selectedIndex].value,'_self')">    
                <option value="">选择栏目</option>
<%
	sql="select * from ylmv_Sclass where classid="&Classid
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if cstr(Sclassid)=cstr(rs("Sclassid")) then%> selected<%end if%> value="<%=CStr(rs("Sclassid"))%>" name=Sclassid><%=rs("Sclass")%></option>
<%
	rs.MoveNext
	Loop
	rs.close

end if
%>
              </select>&nbsp;&nbsp;       
<%if request("Sclassid")<>"" or request("Nclassid")<>"" then
	if request("Sclassid")<>"" then%>
              <select name="Nclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid=<%=request("SClassid")%>&NClassid='+this.options[this.selectedIndex].value,'_self')">     
<%	else%>
              </select>
              <select name="Nclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=Classid%>&SClassid=<%=SClassid%>&NClassid='+this.options[this.selectedIndex].value,'_self')">    
<%	end if%>     
                <option value="" <%if request("Nclassid")="" then%> selected<%end if%>>选择子栏目</option>
<%
	if request("Sclassid")<>"" then
		sql="select * from ylmv_Nclass where Sclassid="&request("Sclassid")
	else
		sql="select * from ylmv_Nclass where Sclassid="&Sclassid
	end if
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if (cstr(request("Nclassid"))=cstr(rs("Nclassid")) and request("Nclassid")<>"") then%> selected<%end if%> value="<%=CStr(rs("Nclassid"))%>" name=Nclassid><%=rs("Nclass")%>     
<%    
	rs.MoveNext
	Loop
	rs.close

else
%>
              </select>    
              <select name="Nclassid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid=<%=request("SClassid")%>&NClassid='+this.options[this.selectedIndex].value,'_self')">    
                <option value="">选择子栏目</option>
<%
	sql="select * from ylmv_Nclass where Sclassid="&SClassid
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if cstr(Nclassid)=cstr(rs("Nclassid")) then%> selected<%end if%> value="<%=CStr(rs("Nclassid"))%>" name=Nclassid><%=rs("Nclass")%>     
<%    
	rs.MoveNext
	Loop
	rs.close

end if
%>
              </select>     
            </td>
          </tr>
          <tr>
            <td class=tdbg align=right>专辑：</td>
            <td class=tdbg>
<%
if request("Classid")<>"" or request("Nclassid")<>"" or request("Specialid")<>"" then
	if request("Classid")<>"" then
%>
              <select name="Specialid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid=<%=request("SClassid")%>&NClassid=<%=request("NClassid")%>&Specialid='+this.options[this.selectedIndex].value,'_self')">
<%	elseif request("NClassid")<>"" then%>
</select>
              <select name="Specialid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=Classid%>&SClassid=<%=request("SClassid")%>&NClassid=<%=request("NClassid")%>&Specialid='+this.options[this.selectedIndex].value,'_self')">    
<%	else%>
</select>
              <select name="Specialid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=Classid%>&SClassid=<%=request("SClassid")%>&NClassid=<%=NClassid%>&Specialid='+this.options[this.selectedIndex].value,'_self')">    
<%	end if%>     
                <option value="" <%if request("Specialid")="" then%> selected<%end if%>>选择专辑</option>
<%
	if request("NClassid")<>"" then
		sql="select * from ylmv_special where Nclassid="&request("Nclassid")
	else
		sql="select * from ylmv_special where Nclassid="&Nclassid
	end if
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if cstr(request("Specialid"))=CStr(rs("Specialid")) then%> selected<%end if%> value="<%=CStr(rs("Specialid"))%>" name=Specialid><%=rs("name")%>     
<%    
	rs.MoveNext
	Loop
	rs.close
else
%>
 </select>    
              <select name="Specialid" size="1" onchange="window.open('Admin_Allmusic_Ok.Asp?id=<%=request("id")%>&AskClassid=<%=Askclassid%>&AskSClassid=<%=AskSclassid%>&AskNClassid=<%=AskNclassid%>&page=<%=page%>&Classid=<%=request("Classid")%>&SClassid=<%=request("SClassid")%>&NClassid=<%=request("NClassid")%>&Specialid='+this.options[this.selectedIndex].value,'_self')">    
                <option value="">选择专辑</option>
<%
	sql="select * from ylmv_special where Nclassid="&Nclassid
	rs.open sql,conn,1,1
	Do while not rs.eof
%>
                <option<%if cstr(Specialid)=cstr(rs("Specialid")) then%> selected<%end if%> value="<%=CStr(rs("Specialid"))%>" name=Specialid><%=rs("name")%>     
<%    
	rs.MoveNext
	Loop
	rs.close

end if%>
              </select>     
            </td>
          </tr>
          <tr>
            <td align="right" class=tdbg height=25 >播放格式：</td>
            <td class=tdbg height=25><select name="musictype" size="1">
                <option value="1"<%if musictype=1 Then response.write(" selected") End If%>>Mp3</option>
                <option value="2"<%if musictype=2 Then response.write(" selected") End If%> >Rm</option>
                <option value="3"<%if musictype=3 Then response.write(" selected") End If%> >WmaMtv</option>
                <option value="4"<%if musictype=4 Then response.write(" selected") End If%> >RmMtv</option>
              </select></td>
          </tr>
          <tr>
            <td class=tdbg align=right>歌曲名称：</td>
            <td class=tdbg width="85%"><input type="text" name="MusicName" size="15" class="smallinput" maxlength="100" value="<%=MusicName%>"></td>
          </tr>
          <tr>
            <td class=tdbg align="right">点击次数：</td>
            <td class=tdbg><input CLASS=input type="text" name="hits" size="15" class="smallinput" maxlength="100" value="<%=hits%>"></td>
          </tr>
        <tr>
            <td width="15%" class=tdbg align="right">歌曲地址：</td>
            <td class=tdbg width="85%">
              <select name="song_path" size="1">
                <option value="1"<%if song_path=1 Then response.write(" selected") End If%> >服务器(一)</option>
                <option value="2"<%if song_path=2 Then response.write(" selected") End If%> >服务器(二)</option>
                <option value="3"<%if song_path=3 Then response.write(" selected") End If%> >服务器(三)</option>
                <option value="4"<%if song_path=4 Then response.write(" selected") End If%> >服务器(四)</option>
                <option value="5"<%if song_path=5 Then response.write(" selected") End If%> >服务器(五)</option>
                <option value="6"<%if song_path=6 Then response.write(" selected") End If%> >服务器(六)</option>
                <option value="7"<%if song_path=7 Then response.write(" selected") End If%> >服务器(七)</option>
                <option value="8"<%if song_path=8 Then response.write(" selected") End If%> >服务器(八)</option>
                <option value="9"<%if song_path=9 Then response.write(" selected") End If%> >服务器(九)</option>
                <option value="10"<%if song_path=10 Then response.write(" selected") End If%> >服务器(十)</option>
              </select> <input type="text" name="Wma" value="<%=Wma%>" size="30"></td>    
        </tr>
        <tr>
            <td class=tdbg align=right>动态歌词：</td>
<%
	Dim MusicWord
	MusicWord=""
	sql="select MusicWord from [ylmv_MusicWord]  where MusicID="&id
	rs.open sql,conn,1,1
		If not(rs.bof or rs.eof) Then
			MusicWord=rs(0)
		End If
	rs.close
	
%>
            <td class=tdbg width="85%">
              <font color="#FFFFFF"><textarea rows="4" name="MusicWord" cols="44"><%=MusicWord%></textarea>
              </font>Lrc动态歌词</td> 
        </tr>
        <tr>
            <td class=tdbg align=right>静态歌词：</td>
<%
	Dim songwords
	songwords=""
	sql="select songwords from [ylmv_MusicList]  where ID="&id
	rs.open sql,conn,1,1
		If not(rs.bof or rs.eof) Then
			songwords=rs(0)
		End If
	rs.close
	
%>
            <td class=tdbg width="85%">
              <font color="#FFFFFF"><textarea rows="4" name="songwords" cols="44"><%=songwords%></textarea>
              </font>普通文本歌词</td> 
        </tr>
          <tr>
            <td class=tdbg colspan=2 align=center>
              <input type="hidden" value="edit" name="act">
<%
if request("Classid")<>"" then
	if request("SClassid")="" then
%>
              <input type="button" value=" 确 定 " name="cmdok" onclick="window.alert('请先选择二级栏目！')">&nbsp; 
              <%	elseif request("NClassid")="" then%> 
              <input type="button" value=" 确 定 " name="cmdok" onclick="window.alert('请先选择三级栏目！')">&nbsp;   
<%	elseif request("Specialid")="" then%>
              <input type="button" value=" 确 定 " name="cmdok" onclick="window.alert('请先选择专辑！')">&nbsp;   
<%
	else
%>
              <input type="submit" value=" 确 定 " name="cmdok">&nbsp;   
<%
	end if
else
%>
              <input type="submit" value=" 确 定 " name="cmdok">&nbsp;   
<%end if%>
              <input type="reset" value=" 清 除 "  name="cmdcancel">  
            </td>
          </tr>
        </form>
      </table>
    </td>
  </tr>
</table>
<%
set rs=nothing
conn.close
set conn=nothing%>