<!--#include virtual="/inc/conn.asp"-->

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<%
id=SafeRequest("id")
ku=SafeRequest("ku")
gid=SafeRequest("gid")
%>




  <style type="text/css">
<!--
body,td,th {
	font-size: 13px;
}
body { 
	background-color: #EBEBEB;
}
-->
</style><table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="table_style_a1">
<form action="?act=alldel&page=<%=page%>" method="post" name="myform" id="myform"> 
       <tr>
        <th align="center" class="border_right border_bottom">卡号
        <th align="center" class="border_right border_bottom">
        密码        
        <th align="center" class="border_right border_bottom">商品
        <th align="center" class="border_right border_bottom">已用        </tr>
<%
if gid<>"" then
sql="select top 62 * from "&ku&" where aykasuoyou="&id&" and aykagoodid="&gid&" and aykayesno=0 order by aykaid desc" 
else
sql="select top 62 * from "&ku&" where aykasuoyou="&id&" and aykayesno=0 order by aykaid desc" 
end if
rs.open sql,conn,1,1
if not(rs.bof and rs.eof) then
do while not rs.eof%>

	  <tr onmouseover=this.bgColor='#D2FFFF' onmouseout=this.bgColor='#ffffff'>
        <td align="center" class="border_right border_bottom">
		<%=trim(rs("ayka"))%>		</td>
        <td align="center" class="border_right border_bottom">
		<%
		
		if trim(rs("aykapass"))<>"0" then
		response.Write trim(rs("aykapass"))
		else
		response.Write "-"
		end if
		%>		
		
		
		</td>
        <td align="center" class="border_right border_bottom"><%=rs("aykagoodid")%></td>
        <td align="center" class="border_right border_bottom">
		<%
		if cint(rs("aykayesno"))=0 then response.Write "否"
		if cint(rs("aykayesno"))=1 then response.Write "已用"
		%>		</td>
       </tr>
<%

rs.movenext 
loop
end if
rs.close%>
      </form>
    </table>



