📄 xx_search.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=cookies.asp--><!--#include file=function.asp-->
<html><head><link href="css.css" rel="stylesheet" type="text/css">
<title>祥星送货单打印系统-显示搜索记录</title>
</head>
<body>
<form name=soform action="xx_search.asp" method="post">
<table width="100%" border="0"><tr><td align=center>输入进库日期：<input name=key type="text" class="inputa"> <input name="ok" type="submit" value="点击查询" class=inputb></td></tr></table></form>便捷查询：<form name=soform action="xx_search2.asp" method="post">
<table width="100%" border="0"><tr><td align=center>
<select name="keys">
<option value="2" selected>查询今天</option>
<option value="1" >查询本月</option>
</select> <input name="ok" type="submit" value="点击查询" class=inputb></td></tr></table></form>
<%rs2=conn.execute("select * from xx_config where start=0 and ones=1")
listnums=rs2("Deliverynum")+rs2("usernums")
lennums=rs2("Deliverylen")
%>
<table width="100%" class="inputb"><tr><td align="center">商品销售记录</td></tr></table>
<br>
<%
key=request.form("key")
if not IsDate(key) then
response.write"日期格式错误！"
response.end
end if
Set Rs=Server.Createobject("adodb.recordset")
sql="select * from XX_GoodsUnit where addtime=#"&key&"#"
rs.open Sql,conn,1,1
Response.write"<form name=lpform action=check_lipei.asp method=post>"
Response.Write"<table border=1 width=100% cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>"
response.write"<tr bgcolor=#efefef><td align=center>ID编号</td><td align=center>货单编号</td><td align=center>送货对象</td><td align=center>送货数量</td><td align=center>应收总额</td><td align=center>操作员工</td><td align=center>操作时间</td><td align=center>修改操作</td></tr>"
if rs.bof and rs.eof then
response.write"对不起暂无销售记录！"
else
while not rs.eof
response.write"<tr bgcolor=#efefef><td align=center>"&rs("ID")&"</td>"
response.write"<td align=center><a href=xx_LookGoodsUnit.asp?listnum="&rs("listnum")&">"&gen(rs("listnum"),lennums)&"</a></td>"
response.write"<td align=center>"&rs("listuser")&"</td>"
response.write"<td align=center>"&rs("shopnum")&"件</td>"
response.write"<td align=center>"&rs("summoney")&"</td>"
response.write"<td align=center>"&rs("username")&"</td>"
response.write"<td align=center>"&rs("addtime")&"</td>"
response.write"<td align=center><a href=XX_AddIndenture.asp?listnum="&rs("listnum")&">填单</a> <a href=XX_AddGoodsUnit.asp?id="&rs("id")&">修改</a> <a href=XX_save.asp?action=DelGoods&id="&rs("id")&">删除</a></td>"
response.write"</tr>"
rs.movenext
wend
End if
rs.close
response.write"</table>"
response.write"</form>"
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -