📄 search1.asp
字号:
<%
' used f:\gtly\data.mdb database
On Error Resume Next
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../../data.mdb")
MyYear = Request("Year")
MinMonth = Request("minyue")
MaxMonth = Request("maxyue")
RecCount=conn.execute("select Count(id) FROM tuyun where Year = "& MyYear & " and Month >= "& MinMonth &" and Month <= "& MaxMonth &" ",0,1)(0) '统计条数。。
set rs=server.createobject("adodb.recordset")
Sql = "select * FROM tuyun where Year = "& MyYear & " and Month >= "& MinMonth &" and Month <= "& MaxMonth &" "
Set Rs = Conn.Execute(Sql)
if Rs.eof then
response.write"<script language=javascript>alert('对不起！没有检索到相关货物信息，请重试!');"
response.write"javascript:history.go(-1)</script>"
end if
%>
<html>
<head>
<link href="../appmain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td bgcolor="#66CCFF"> <div align="center">公铁联运有限公司托运单信息</div></td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" class="FORMTABLE">
<tr>
<td background="../image/titlebg.gif"> <div align="center">ID号码</div></td>
<td background="../image/titlebg.gif"> <div align="center">时间</div></td>
<td background="../image/titlebg.gif">起始站点</td>
<td background="../image/titlebg.gif"><div align="center">到站</div></td>
<td background="../image/titlebg.gif"> <div align="center">收货单位</div></td>
<td background="../image/titlebg.gif"> <div align="center">详细地址或收货人</div></td>
<td background="../image/titlebg.gif"> <div align="center">货物名称</div></td>
</tr>
<% do while not rs.eof%>
<tr>
<td><div align="center"><a href=javascript:winopen('../huoyun/tuyun1.asp?id=<%=rs("id")%>')><%=rs("ID") %></a></div></td>
<td><div align="center"><%=rs("year") %>年<%=rs("month") %>月<%=rs("date1") %>
日</div></td>
<td><div align="center"><%=rs("send_first")%></div></td>
<td><div align="center"><%=rs("send_last")%></div></td>
<td><div align="center"><%=rs("accept_people") %></div></td>
<td><div align="center"><%=rs("accept_address")%></div></td>
<td><div align="center"><%=rs("goods")%></div></td>
</tr>
<%
rs.movenext
loop
%>
</table>
</body>
</html>
<script language="javascript">
function winopen(url)
{
window.open(url,"search","toolbar=0，location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=1,width=795,height=550,top=0,left=0");
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -