<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../Include/Connect.asp"-->
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../CSS/Hompy/hompy.css" type=text/css rel=stylesheet>
<title></title>
<script language="JavaScript" type="text/JavaScript">
<!--
function winOpen(Url,width,height,scrollbar,resize)
{

ow = width;
oh = height;
os = scrollbar;
or = resize;
var xposition=0; 
var yposition=0;
if ((parseInt(navigator.appVersion) >= 4 ))
  {
    xposition = (screen.width - width) / 2;
    yposition = (screen.height - height-25) / 2;
  }
  window.open (Url,"","width ="+ow+",height="+oh+",scrollbars = "+os+",resizable="+or+",left="+xposition+",top="+yposition );
}

function ask(msg) {
	
	if( msg=='' ) {
		msg='真的要这样做吗？';
	}

	if (confirm(msg)) {
		return true;
	} else {
		return false;
	}
}
//-->
</script>
</head>
<body>
<TABLE height=300 cellSpacing=0 cellPadding=0 width=490 bgColor=#dbdbdb border=0>
                                  <TBODY>
                                    <TR> 
                                      <TD height="300" bgColor=#ffffff align="center"> 
                                        <DIV style="BORDER-RIGHT: 0px solid; BORDER-TOP: 0px solid; BORDER-LEFT: 0px solid; WIDTH: 488px; BORDER-BOTTOM: 0px solid; HEIGHT: 253px"> 
                                        <DIV style="WIDTH: 488px; HEIGHT: 300px" UNSELECTABLE="on">
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                              <TR> 
                                                
                <TD width="380" height=25 class=orange2_b> 背景音乐管理 </TD>
                                                
                <TD width="108" align="right"><a href="javascript:;" onClick="javascript:winOpen('uploadmusic.asp?username=<%=session("Username")%>', 380, 226, 'no','no')"><img src="../../Images/Hompy/btn_musicup.gif" width="82" height="19" border="0" align="absmiddle"></a></TD>
            </TR>
          </table><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                    <TBODY>
                    <TR>
                       <TD height=5></TD>
                      </TR></TBODY></TABLE>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <TR> 
      <td align="center" style="HEIGHT: 24px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
            <td width="54" align="center">编号</td>
                      <td width="223" align="center">歌曲名</td>
                      <td width="149" align="center">演唱者</td>
                      <td width="62" align="center">操作</td>
          </tr>
        </table></td>
    </TR>
</table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <%
set rs = server.CreateObject("adodb.recordset")
sql="select * from Show5_ALLMusic where Username='"&session("Username")&"'"
rs.CursorLocation=3
rs.open sql,cn,1,1
i=rs.recordcount
if rs.eof or rs.bof then
%>
              <tr> 
                <td colspan="4" height=83 align=center>暂无音乐！</td>
              </tr>
              <tr> 
                <td colspan="4" align="center" style="HEIGHT: 1px; BORDER-BOTTOM: #cecfce 1px dotted"><img name="" src="" width="1" height="1" alt=""></td>
              </tr>
<%
else
do while not rs.eof
%>
			<tr> 
                <td width="54" height=25 align=center><SPAN style="FONT-SIZE: 11px; COLOR: #666666"><%=i%></span></td>  
                <td width="223" style="PADDING-BOTTOM: 5px; PADDING-TOP: 5px" height=25><%=rs("Musicname")%></td>
                <td width="149" align="center"><%=rs("Singer")%></td>
                <td width="62" align=center><a class="orange" href="javascript:if(ask('真的要删除吗？')) location.href='deletemusic.asp?musicid=<%=rs("MusicID")%>';">删除</a></td>
            </tr>
            <tr> 
              <td colspan="4" align="center" style="HEIGHT: 1px; BORDER-BOTTOM: #cecfce 1px dotted"><img name="" src="" width="1" height="1" alt=""></td>
            </tr>
<%
rs.movenext
i=i-1
loop
rs.close
set rs=nothing
end if
%>
              <TR> 
                <td colspan="4" align="center" style="HEIGHT: 4px; BORDER-BOTTOM: #cecfce 1px solid; BACKGROUND-COLOR: #f7f7f7"><img src="" width="4" height="4" alt=""></td>
              </TR>
            </table>
          </DIV>
        </DIV></TD></TR></TBODY></TABLE>
</body>
</html>
