📄 car_search.asp

📁 办公自动化系统适用于办公室的各种几本功能的操作功能比较简单

💻 ASP

字号:

<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/connection.asp"-->
<!--#include file="../inc/dbtools.asp"-->
<HTML>
<HEAD>
<TITLE>  </TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../CSS/main.css">
</HEAD>

<BODY BGCOLOR="#FFFFFF">
<div align=center>
<table border=1 cellpadding=3 cellspacing=0 width="90%" bgcolor=#EEEEEE bordercolordark="#FFFFFF" bordercolorlight="#999999"><tr><td>
<INPUT TYPE="button" name="cmdreturn" value="返  回" class="font9boldwhite" onclick="javascript:window.location.href='car_index.asp'">
</td></tr></table>
</div>

<%
LoginID=trim(session("LoginID"))
if LoginID="" then response.end
selectdate=trim(request("SelectDate"))
if selectdate="" then selectdate=date()

set rs=server.createobject("adodb.recordset")
sql="select * from tblCar where ID>0"
rs.open sql,Conn
while not rs.eof
	carID=trim(rs("ID"))
	name=trim(rs("Name"))
	model=trim(rs("model"))
	owner=trim(rs("owner"))
	contain=trim(rs("contain"))
	body=trim(rs("body"))
	buytime=trim(rs("buytime"))
	repairtime=trim(rs("repairtime"))
%>

<div align=center>

<table border=1 cellpadding=3 cellspacing=0 width="90%" bgcolor=#EEEEEE bordercolordark="#FFFFFF" bordercolorlight="#999999">
<tr>
	<td bgcolor=#CCCCCC width=100>车辆</td>
	<td><a href="car_Searchdetail.asp?carID=<%=CarID%>">
	<%
	if isbusy(carID) then
		response.write "<font color=red>"&Name&"(使用中)</font>"
	else
		response.write Name&"(空闲)"
	end if
	%></a>
	——<a href="car_order.asp?carid=<%=carid%>">>>我要预约</a>
	</td>
	<td bgcolor=#CCCCCC width=100>型号</td>
	<td><%=model%></td>
</tr>
<tr>
	<td bgcolor=#CCCCCC>责任负责人</td>
	<td><%=owner%></td>
	<td bgcolor=#CCCCCC>可使用人数</td>
	<td><%=contain%></td>
</tr>
<tr>
	<td bgcolor=#CCCCCC>购买时间</td>
	<td><%=buytime%></td>
	<td bgcolor=#CCCCCC>保修时间</td>
	<td><%=repairtime%></td>
</tr>
<tr>
	<td bgcolor=#CCCCCC>介绍</td>
	<td colspan=3>
	<%=replace(replace(server.htmlencode(body&""),chr(13),"<br>")," ","&nbsp;")%>&nbsp;
	</td>
</tr>
</table>
</div><BR>
<%
rs.movenext
wend
rs.close
set rs=nothing
%>
</div><BR><BR>
</BODY>
</HTML>
<!--#include file="../inc/connclose.asp"-->
<%
private function isbusy(byval carid)
	set rstmp=server.createobject("Adodb.recordset")
	sql="select * from tblCarOrder where startTime<='"& now() &"' and EndTime>='"& now() &"' and CarID="& carid
	rstmp.open sql,Conn
	if not rstmp.eof then
		isbusy=true
	else
		isbusy=false
	end if
	rstmp.close
end function
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -