📄 accinfo.asp
字号:
<!--#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">
<%
if Request("MobileID")<>"" then
if WhereStr="" then WhereStr="MobileID="&Request("MobileID") else WhereStr=WhereStr&" and MobileID="&Request("MobileID")
if QueryString="" then QueryString="MobileID="&Request("MobileID") else QueryString=QueryString&" &MobileID="&Request("MobileID")
end if
if Request("DriverID")<>"" then
if WhereStr="" then WhereStr="DriverID="&Request("DriverID") else WhereStr=WhereStr&" and DriverID="&Request("DriverID")
if QueryString="" then QueryString="DriverID="&Request("DriverID") else QueryString=QueryString&"&DriverID="&Request("DriverID")
end if
SqlString="select u.* from AccInfo u where "&WhereStr
set AccRs=Conn.execute(Sqlstring)
if not AccRS.eof then
set MobRs=Conn.Execute("select m.MobileModel from MobileInfo m where MobileID="&AccRS("MobileID"))
set DriRs=Conn.Execute("select d.DriverName from DriverInfo d where DriverID="&AccRS("DriverID"))
set UsrRs=Conn.Execute("select u.Realname from UserInfo u where UserID="&AccRS("UserID"))
end if
AccStr="<table width=700 border=1>"
AccStr=AccStr&"<tr>"
AccStr=AccStr&"<td>车辆名称</td><td>相关司机</td><td>使用者</td><td>事故发生时间</td><td>赔付金额</td><td>事故描述</td><td>功能</td></tr>"
while not AccRs.eof
AccStr=AccStr&"<tr><td>"&MobRs("MobileModel")&"</td>"
AccStr=AccStr&"<td>"&DriRs("DriverName")&"</td>"
AccStr=AccStr&"<td>"&UsrRs("RealName")&"</td>"
AccStr=AccStr&"<td>"&AccRs("EventDate")&"</td>"
AccStr=AccStr&"<td>"&AccRs("Compensate")&"</td>"
AccStr=AccStr&"<td>"&AccRs("ResultDescription")&"</td>"
AccStr=AccStr&"<td><a href=AccDel.asp?ID="&AccRS("AccID")&">删除</a></td>"
AccRs.MoveNext
wend
AccStr=AccStr&"</table>"
Set AccRs=nothing
response.write AccStr
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -