📄 mobileinfo.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">
<%
Sqlstring="select u.realname,u.Username,m.* from UserInfo u,MobileInfo m where u.UserID=m.DriverUID"
set rs=Conn.execute(Sqlstring)
Response.write "<table border=1 width=750>"
response.write "<tr>"
response.write "<td>车辆型号</td>"
response.write "<td>驾驶员</td>"
response.write "<td>车辆类型</td>"
response.write "<td>车牌号</td>"
response.write "<td>所属单位</td>"
response.write "<td>功能</td>"
response.write "</tr>"
while (not rs.eof)
response.write "<tr>"
response.write "<td>"&rs("MobileModel")&"</td>"
response.write "<td>"&rs("RealName")&"("&rs("UserName")&")</td>"
response.write "<td>"&rs("MobileType")&"</td>"
response.write "<td>"&rs("SerialNO")&"</td>"
response.write "<td>"&rs("Affiliation")&"</td>"
response.write "<td><a href=FeeInfo.asp?MobileID="&rs("MobileID")&">费用信息</a>"
response.write "<a href=UsageInfo.asp?MobileID="&rs("MobileID")&"> 使用信息</a>"
response.write "<a href=AccInfo.asp?MobileID="&rs("MobileID")&"> 事故信息</a></td>"
response.write "</tr>"
rs.movenext
wend
Sqlstring="select m.* from MobileInfo m where m.DriverUID is null"
set rs=Conn.execute(Sqlstring)
while (not rs.eof)
response.write "<tr>"
response.write "<td>"&rs("MobileModel")&"</td>"
response.write "<td>未配备</td>"
response.write "<td>"&rs("MobileType")&"</td>"
response.write "<td>"&rs("PurchaseDate")&"</td>"
response.write "<td>"&rs("SerialNO")&"</td>"
response.write "<td>"&rs("Affiliation")&"</td>"
response.write "<td><a href=FeeInfo.asp?MobileID="&rs("MobileID")&">费用信息</a>"
response.write "<a href=UsageInfo.asp?MobileID="&rs("MobileID")&"> 使用信息</a>"
response.write "<a href=AccInfo.asp?MobileID="&rs("MobileID")&"> 事故信息</a></td>"
response.write "</tr>"
rs.movenext
wend
response.write "</table>"
response.write "<br>"
response.write "<table width=700>"
response.write "<tr><td><center><a href=MobileNew.asp>添加新的车辆</a></center></td></tr>"
response.write "</table>"
conn.close
set rs=nothing
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -