<!--#include virtual="/show/adminhead.asp"-->
<!--#include file="adminleft.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />



<title><%=webname%>-最高权限-SQL查询</title>
<%
call logquanxian("a9",1)
%>

<DIV>

<SCRIPT LANGUAGE="JavaScript">
var checkflag1 = "false";
function check1(field) {
if (checkflag1 == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;}
checkflag1 = "true";
return "false"; }
else {
for (i = 0; i < field.length; i++) {
field[i].checked = false; }
checkflag1 = "false";
return "true"; }
}

function unselectall1()
{
    if(document.myform.chkAll1.checked){
	document.myform.chkAll1.checked = document.myform.chkAll1.checked&0;
	checkflag1 = "false";
    } 	
}
</script>
<%
link="adminsqldd.asp?ct="
%>
<DIV id=main1200> 
<%call webleft()%>

<DIV id=main_right>
<DIV id=main_right_content>
<STYLE>.apply_style {
	POSITION: absolute
}
.right_title A {
	LINE-HEIGHT: 27px; WIDTH: 126px; DISPLAY: inline-block; BACKGROUND: url(<%=ossurl%>images/bg22.gif) no-repeat; HEIGHT: 27px
}
.right_title A.current {
	BACKGROUND: url(<%=ossurl%>images/main_right_title_bg.gif) no-repeat; COLOR: #fff; FONT-WEIGHT: bold
}
.table_style_1 TD {
	HEIGHT: 38px
}
.table_style_home_info TD {
	PADDING-BOTTOM: 0px; PADDING-LEFT: 10px; PADDING-RIGHT: 0px; HEIGHT: 30px; PADDING-TOP: 0px
}
</STYLE>
<DIV class=right_titleadmin>&nbsp;&nbsp;SQL卡密查询</DIV>
<DIV class=main><br>

<table width="99%" border="0" cellpadding="0" cellspacing="0" class="table_style_a1">
     <form action="" method="post" name="zengsongque" id="zengsongque"> 
       <tr>
        <th colspan="10" align="center" style="font-weight: bold; color: #FF6633">
		卡库<select name="kamishuju" id="kamishuju">
        <option value="ayka">ayka</option>
		<option value="ayka01">ayka01</option>
		<option value="ayka02">ayka02</option>
		<option value="ayka03">ayka03</option>
		<option value="ayka04">ayka04</option>
		<option value="ayka05">ayka05</option>
		<option value="ayka06">ayka06</option>
		<option value="ayka07">ayka07</option>
		<option value="ayka08">ayka08</option>
		<option value="ayka09">ayka09</option>
        <option value="ayka10">ayka10</option>
        <option value="ayka11">ayka11</option>
        <option value="ayka12">ayka12</option>
        <option value="ayka13">ayka13</option>
        <option value="ayka14">ayka14</option>
        <option value="ayka15">ayka15</option>
        <option value="ayka16">ayka16</option>
        <option value="ayka17">ayka17</option>
        <option value="ayka18">ayka18</option>
        <option value="ayka19">ayka19</option>
        <option value="ayka20">ayka20</option>
      </select>
	  输入卡密       
          <input name="kami" type="text" id="kami" size="60">
          <input type="submit" name="Submit" value=" 查 询 ">
          <input name="act" type="hidden" id="act" value="cha">        </tr>
       </form>
    </table>
<br>

<%
if SafeRequestform("act")="cha" then
kami=trim(SafeRequestform("kami"))
kamishuju=trim(SafeRequestform("kamishuju"))
if kami="" then call PopErr("请填写完整")




sql="select * from "&kamishuju&" where ayka like '%"&kami&"%'" 
rs.open sql,conn,1,1
if not(rs.bof and rs.eof) then
%>
<table width="99%" border="0" cellpadding="0" cellspacing="0" class="table_style_a1">
<%do while not rs.eof%>
       <tr>
	   <td>
	   [卡密信息]<br>
	   aykaid <%=rs("aykaid")%> [卡密ID]<br>
	   aykayesno <%=rs("aykayesno")%> <span style="color: #FF6600">[0未用 1已用]</span> <br>
	   ayka <%=rs("ayka")%> <span style="color: #FF6600">[卡号]</span> <br>
	   aykapass <%=rs("aykapass")%> <span style="color: #FF6600">[密码]</span> <br>
	   aykasuoyoudd <%=rs("aykasuoyoudd")%> <span style="color: #FF6600">[订单号]</span> <br>
	   aykasuoyou <%=rs("aykasuoyou")%> [所有者ID] <br>
	   aydailiid <%=rs("aydailiid")%> [代理ID] <br>
	   aykagoodid <%=rs("aykagoodid")%> [商品ID] <br>
	   aykadata <%=rs("aykadata")%> [建卡时间] <br>
	   aykakai <%=rs("aykakai")%> [购卡时间] <br>

	   aykatel <%=rs("aykatel")%> [买家联系方式] <br>
	   
	   <br>[订单信息]<br>
	   <%
	   set rs2=server.CreateObject("adodb.recordset")
	   if trim(rs("aykasuoyoudd"))<>"" then

	   ddku=getddku(rs("aykasuoyoudd"))
	   
	   rs2.open "select * from "&ddku&" where aydingdansum='"&trim(rs("aykasuoyoudd"))&"'" ,conn,1,1
	   		if not(rs2.bof and rs2.eof) then
			do while not rs2.eof
			ayddzffangshi=rs2("ayddzffangshi")%>
			   ayddsuo <%=rs2("ayddsuo")%> <span style="color: #FF6600">[锁定 1锁定]</span> <br>
			   aydingdanid <%=rs2("aydingdanid")%> [自动编号] <br>
			   aydingdansum <%=rs2("aydingdansum")%> [订单号] <br>
			   aydingdanzt <%=rs2("aydingdanzt")%> <span style="color: #FF6600">[订单状态 0待付款 1已付款 2支付失败  默认0]</span> <br>
			   aydingdanuser <%=rs2("aydingdanuser")%> [订单会员id] <br>
			   aydingdanjjhao <%=rs2("aydingdanjjhao")%> [付款交易号] <br>
			   aydigndanyf <%=rs2("aydigndanyf")%> <span style=" color:#FF0000; font-weight: bold">[应付总价]</span> <br>
			   aydingdanin <%=rs2("aydingdanin")%> <span style="color: #FF6600">[商户入帐总价]</span> <br>
			   aydingdanyj <%=rs2("aydingdanyj")%> <span style="color: #FF6600">[订单原价]</span> <br>
			   aydingdanjin <%=rs2("aydingdanjin")%> <span style="color: #FF6600">[订单单价]</span> <br>
			   aydingdanzj <%=rs2("aydingdanzj")%> <span style="color: #FF6600">[订单总价]</span> <br>
			   aydingdancb <%=rs2("aydingdancb")%> [成本单价  默认0] <br>
			   ayddquantity <%=rs2("ayddquantity")%> [购买数量] <br>
			   ayddfeileiid <%=rs2("ayddfeileiid")%> [分类ID] <br>
			   ayddshangid <%=rs2("ayddshangid")%> [商品ID] <br>
			   ayddyouhuiquanzhi <%=rs2("ayddyouhuiquanzhi")%> [优惠券值] <br>
			   ayddyouhuiquan <%=rs2("ayddyouhuiquan")%> [优惠券信息] <br>
			   ayddcontact <%=rs2("ayddcontact")%> [联系方式] <br>
			   ayddemail <%=rs2("ayddemail")%> [邮箱] <br>
			   ayddzffangshi <%=rs2("ayddzffangshi")%> <span style="color: #FF6600">[支付方式 0网银 1充值卡 2支付宝 3财付通 4快捷 99账户余额支付]</span> <br>
			   ayddpid <%=rs2("ayddpid")%> <span style="color: #FF6600">[支付通道代码]</span> <br>
			   aydingdansj <%=rs2("aydingdansj")%> [订单时间] <br>
			   aydingdanka <%'=rs2("aydingdanka")%> [包含卡号ID] <br>
			   aydingdanpass <%=rs2("aydingdanpass")%> [提卡密码] <br>


			   ayddmaijiajin <%=rs2("ayddmaijiajin")%> [买家点卡退还金额] <br>
			   ayddmaijiaispay <%=rs2("ayddmaijiaispay")%> [是否退还 0否 1是   默认0]  <br>

			   aybuyipxx <%=rs2("aybuyipxx")%> [购买详细信息]<br>
			   ayddbody <%=rs2("ayddbody")%> [错误描述] <br>
			   aygooddlid <%=rs2("aygooddlid")%> [上级代理ID 默认0] <br>
			   aysgoodid <%=rs2("aysgoodid")%> [上级代理商品ID 默认0] <br>
			   aysjjiage            <%=rs2("aysjjiage")%>        [商品代理价格]     <br>       
			   aysinddzj             <%=rs2("aysinddzj")%>        [上级代理应入总价 默认0]<br>
			   ayuinddzj             <%=rs2("ayuinddzj")%>        [代理商应入总价 默认0]<br>
			   isalipayfz <%=rs2("isalipayfz")%> [支付宝分账 0否 1是 默认0]<br>
			   alipayfzfei <%=rs2("alipayfzfei")%> [分账手续费]<br>
			   apicheng <%=rs2("apicheng")%>  [接口成本]<br>
				
			<%
			n=n+1
			rs2.movenext 
			loop
			end if
			rs2.close
	   
	   end if
	   %>





			

	   <br><br>--------------------------------------------------<br></td></tr>
<%
n=n+1
rs.movenext 
loop
%>
</table>

<%
end if
rs.close
end if
%>




<br>
</DIV>
</DIV></DIV>
<DIV class=clear></DIV></DIV>
</DIV>
<SCRIPT>
$(function(){
$('.left_title').each(function(){
   $(this).click(function(){
	   var index=$('.left_title').index(this);
	   if($(this).next().hasClass('hide_m')){
		   $(this).next().removeClass('hide_m');
           $(this).next().show();		 
		   $(this).find('img').attr('src','<%=ossurl%>images/expansion.gif');
		   $.cookie('m_index_'+index,'',{expires:0});
	   } else {
	       $(this).next().hide();
		   $(this).next().addClass('hide_m');
		   $(this).find('img').attr('src','<%=ossurl%>images/shrank.gif');		   
		   $.cookie('m_index_'+index,'none',{expires:365});
	   }
   })
})

$('.left_title').each(function(){
	var index=$('.left_title').index(this);
    $(this).next().css('display',$.cookie('m_index_'+index) ? $.cookie('m_index_'+index) : '');
	if($.cookie('m_index_'+index)){
	    $(this).next().addClass('hide_m');
	}
	$(this).find('img').attr('src',$.cookie('m_index_'+index) ? '<%=ossurl%>images/shrank.gif' : '<%=ossurl%>images/expansion.gif');
})
})

</SCRIPT>


<!--#include virtual="/show/footadmin.asp"-->

