📄 mobilefeeinfo.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
if Request("FeeType")<>"" then
if WhereStr="" then WhereStr="EventType="&Request("FeeType") else WhereStr=WhereStr&" and EventType="&Request("FeeType")
end if
SqlString="select f.* from FeeInfo f where "&WhereStr
set FeeRs=Conn.execute(Sqlstring)
if not FeeRS.eof then set UsrRs=Conn.Execute("select m.MobileModel,d.DriverName from MobileInfo m , DriverInfo d where MobileID="&FeeRS("MobileID")&" or DriverID="&FeeRs("DriverID"))
FeeStr="<table width=700 border=0><tr>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?"&QueryString&">全部费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=1&"&QueryString&">修车费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=2&"&QueryString&">加油费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=3&"&QueryString&">清洗费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=4&"&QueryString&">停车费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=5&"&QueryString&">年检费用信息</a></td>"
FeeStr=FeeStr&"<td><a href=MobileFeeInfo.asp?FeeType=6&"&QueryString&">其它费用信息</a></td>"
FeeStr=FeeStr&"</tr>"
FeeStr=FeeStr&"<table width=700 border=1>"
FeeStr=FeeStr&"<tr>"
FeeStr=FeeStr&"<td>车辆名称</td><td>相关司机</td><td>费用类型</td><td>费用使用时间</td><td>支付费用</td><td>事件信息</td><td>功能</td></tr>"
while not FeeRs.eof
FeeStr=FeeStr&"<tr><td>"&UsrRs("MobileModel")&"</td>"
FeeStr=FeeStr&"<td>"&UsrRs("DriverName")&"</td>"
FeeStr=FeeStr&"<td>"&FeeRs("EventType")&"</td>"
FeeStr=FeeStr&"<td>"&FeeRs("EventDate")&"</td>"
FeeStr=FeeStr&"<td>"&FeeRs("Price")&"</td>"
FeeStr=FeeStr&"<td>"&FeeRs("EventInfo")&"</td>"
FeeStr=FeeStr&"<td><a href=..\Fee\FeeDel.asp>删除</a></td>"
FeeRs.MoveNext
wend
FeeStr=FeeStr&"</table>"
Set FeeRs=nothing
response.write FeeStr
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -