ad_sub.asp

凡人网络购物系统 v8.0 中文版

<!--#include file="conn.asp"-->
<!--#include file="ad_chk.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=inc/css.css rel=STYLESHEET type=text/css>

<table border="0" cellpadding="2" cellspacing="0" id="table1"><form method="POST" action="ad_sub.asp">
<tr><td rowspan="2"><font color="#FF0000"><b>查询统计：</b></font></td>
		<td> 订单号：</td>
		<td>用户名：</td>
		<td> 开始日期：</td>
		<td> 结束日期：</td>
		<td>订单状态：</td><td rowspan="2">
	<input type="submit" value="确定" name="B1" style="height: 34; width: 48"></td></tr>
<tr><td> <input type="text" name="sub_number" size="12" class=input value="<%=request("sub_number")%>">　</td>
		<td><input type="text" name="user_name" size="12" class=input value="<%=request("user_name")%>"></td>
		<td> <input type="text" name="dataa" size="12" class=input value="<%if request("dataa")<>"" then%><%=request("dataa")%><%else%><%=year(now())%>-<%=month(now())-1%>-<%=day(now())%><%end if%>"></td>
		<td> <input type="text" name="datab" size="12" class=input value="<%if request("datab")<>"" then%><%=request("datab")%><%else%><%=year(now())%>-<%=month(now())%>-<%=day(now())+1%><%end if%>"></td>
		<td><select size="1" name="zt">
<option value="">全部订单</option>
<option value="1">未处理订单</option>
<option value="-1">等待客户付款</option>
<option value="2">已付款订单</option>
<option value="3">已收款订单</option>
<option value="4">已发货订单</option>
<option value="5">已收货订单</option>
<option value="0">无效订单</option>
</select></td></tr></form></table><pre></pre>
<%
zt=request("zt")
sub_number=request("sub_number")
user_name=request("user_name")
dataa=request("dataa")
datab=request("datab")
if dataa="" then dataa="2000-1-1"
if datab="" then datab="2050-12-12"
if zt<>"" then sera=" and sub_zt=" & zt & ""
if user_name<>"" then serb=" and sub_name like '%" & user_name & "%'"
if sub_number<>"" then serc=" and sub_number like '%" & sub_number & "%'"
if dataa<>"" then serd=" and sub_date>=#" & dataa & "#"
if datab<>"" then sere=" and sub_date<=#" & datab & "#"
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_sub where 1=1 " &sera&serb&serc&serd&sere&" order by sub_id DESC"
rs.open sql,conn,1,1
if rs.eof then
response.write "暂且没有任何订单"
rs.close
else%>
<table border="0" width="100%" cellspacing="1" style="border-collapse: collapse" cellpadding="3" bgcolor="#C8C8C8">
<tr><td bgcolor="#F0F0F0">订单号</td><td bgcolor="#F0F0F0">订单状态</td><td bgcolor="#F0F0F0">订货人</td><td bgcolor="#F0F0F0">地址</td><td bgcolor="#F0F0F0">日期</td></tr>
<%do while not rs.eof
if subn="" then
subn=subn&rs("sub_number")
else
subn=subn&","&rs("sub_number")
end if%>
<tr><td bgcolor="#FFFFFF"><a href=ad_submore.asp?sub_id=<%=rs("sub_id")%>><%=rs("sub_number")%></a></td><td bgcolor="#FFFFFF">
<%if rs("sub_zt")=0 then response.write "无效订单"%>
<%if rs("sub_zt")=1 then response.write "未处理"%>
<%if rs("sub_zt")=-1 then response.write "已处理等待客户付款"%>
<%if rs("sub_zt")=2 then response.write "已付款等待发货"%>
<%if rs("sub_zt")=3 then response.write "已收款发货中"%>
<%if rs("sub_zt")=4 then response.write "已发货注意收货"%>
<%if rs("sub_zt")=5 then response.write "已收货（归档）"%></td>
<td bgcolor="#FFFFFF"><a href="<%=filename%>?user_name=<%=rs("sub_name")%>"><%=rs("sub_name")%></a>&nbsp;<img border="0" src="Img/ad_help.gif" class="helpimg" alt="点击用户名可以查看该用户所有订单"></td><td bgcolor="#FFFFFF"><%=rs("sub_adds")%></td>
<td bgcolor="#FFFFFF"><%=rs("sub_date")%></td></tr>
<%rs.movenext
loop
rs.close
set rs=nothing%></table>
<table border="0" cellpadding="2" cellspacing="0" width="100%"><tr><td height="5"></td></tr></table>

<table cellSpacing="1" cellPadding="0" width="100%" bgColor="#c8c8c8" border="0" id="table3">
	<tr>
		<td bgColor="#f0f0f0" height="20">&nbsp;销售统计:<b><a href="ad_ven.asp"><font color="#FF0000">（免费版不提供销售统计功能，您看到的只是效果演示）</font></a></b></td>
	</tr>
	<tr>
		<td bgColor="#ffffff" height="20">
		<table id="table4" cellSpacing="1" cellPadding="5" width="100%" bgColor="#f5f5f5" border="0">
			<tr>
				<td width="30%" bgColor="#ffffff">产品名称</td>
				<td width="20%" bgColor="#ffffff">商品单价</td>
				<td width="20%" bgColor="#ffffff">销售数量</td>
				<td width="20%" bgColor="#ffffff">价格合计</td>
			</tr>
			<tr>
				<td width="30%" bgColor="#ffffff">
				<a target="_blank" href="http://localhost/8/views.asp?hw_id=2">
				凡人网络购物系统V8.0 Sql版</a></td>
				<td width="20%" bgColor="#ffffff">800</td>
				<td width="20%" bgColor="#ffffff">1</td>
				<td width="20%" bgColor="#ffffff">800</td>
			</tr>
			<tr>
				<td width="30%" bgColor="#ffffff">
				<a target="_blank" href="http://localhost/8/views.asp?hw_id=21">
				香奈儿No19女士香水套装</a></td>
				<td width="20%" bgColor="#ffffff">247</td>
				<td width="20%" bgColor="#ffffff">1</td>
				<td width="20%" bgColor="#ffffff">247</td>
			</tr>
			<tr>
				<td width="30%" bgColor="#ffffff">
				<a target="_blank" href="http://localhost/8/views.asp?hw_id=1">
				凡人网络购物系统V8.0 Access版</a></td>
				<td width="20%" bgColor="#ffffff">688</td>
				<td width="20%" bgColor="#ffffff">7</td>
				<td width="20%" bgColor="#ffffff">4816</td>
			</tr>
		</table>
		</td>
	</tr>
</table>


<%end if%><table cellSpacing="0" cellPadding="3" border="0" width="500"><tr><td height="20"></td></tr>
<tr><td bgcolor="#F2F2F2"><p style="LINE-HEIGHT: 150%"><font color="#FF0000">凡人网络购物系统V8.0 版权所有:</font><a target="_blank" href="http://www.venshop.com"><font color="#FF0000">凡人网络VenShop.Com</font></a><font color="#FF0000"><br>客服电话:[phone]&nbsp; QQ:57152557/5404818 Email/Msn:</font><a href="mailto:[e-mail]"><font color="#FF0000">[e-mail]</font></a></td>
</tr></table>