approve.asp

来自「网上车辆管理系统」· ASP 代码 · 共 43 行

ASP
43
字号
<!--#include file="..\pub\ChkAdmin.asp"-->
<!--#include file="..\CONN.INC"-->

<html>
<head>
<title>Information</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="..." type="text/css">
<link rel="stylesheet" href="..." type="text/css">
</head>
<body bgcolor="#FFFFFF" topmargin="8">
<%
WhereStr=" EventType=1"
SqlString="select u.* from UsageInfo u where "&WhereStr
set UsgRs=Conn.execute(Sqlstring)
if not UsgRS.eof then 
	set MobRs=Conn.Execute("select m.MobileModel from MobileInfo m where MobileID="&UsgRS("MobileID"))
	set DriRs=Conn.Execute("select d.DriverName from DriverInfo d where DriverID="&UsgRS("DriverID"))
	set UsrRs=Conn.Execute("select u.Realname from UserInfo u where UserID="&UsgRS("UserID"))
end if	
UsgStr="<table width=700 border=1>"
UsgStr=UsgStr&"<tr>"
UsgStr=UsgStr&"<td>车辆名称</td><td>相关司机</td><td>使用者</td><td>执行时间</td><td>结束时间</td><td>出发地</td><td>目的地</td><td>事件说明</td><td>批准人</td><td>功能</td></tr>"
while not UsgRs.eof
	UsgStr=UsgStr&"<tr><td>"&MobRs("MobileModel")&"</td>"
	UsgStr=UsgStr&"<td>"&DriRs("DriverName")&"</td>"
	UsgStr=UsgStr&"<td>"&UsrRs("RealName")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("EventBDate")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("EventEDate")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("FromWhere")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("ToWhere")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("ForWhat")&"</td>"
	UsgStr=UsgStr&"<td>"&UsgRs("ForWhat")&"</td>"
	UsgStr=UsgStr&"<td><a href=Approve_OK.asp?RPL=1&ID="&UsgRS("EventID")&">批准</a>"
	UsgStr=UsgStr&"&nbsp;<a href=Approve_OK.asp?RPL=2&ID="&UsgRS("EventID")&">驳回</a></td>"
	UsgRs.MoveNext
wend
UsgStr=UsgStr&"</table>"
Set UsgRs=nothing
response.write UsgStr
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?