?? yinyun1.asp
字號:
<% @language="vbscript" %>
<%
if session("pwd")<>"pass" then
response.Redirect "../hcy/login.asp"
response.end
end if
%>
<%
response.buffer=true
Response.Expires=0
id=request.querystring("id")
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("../data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From yinyun where id="&id, conn,3,3
'nCounter=rs("counter")
'rs.close
'rs.Open "Select * From yinyun where id="&id, conn,3,3
'rs("counter")=rs("counter")+1
'rs.update
'nCounter=rs("counter")
%>
<html>
<head>
<link href="../appmain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>經營者詳細情況說明</title>
</head>
<body bgcolor="#e1f4ee">
<table width="500" align="center" class="TOOLBARTABLE">
<tr>
<td><div align="center"><font color="#000000" size="5" face="隸書">經營者詳細情況說明</font></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr>
<td width="39" height="20" ><div align="center"><font color="#000000">編 號</font></div></td>
<td width="74"><div align="center"><font color="#3300FF"><%=rs("編號") %></font></div></td>
<td width="52" ><div align="center"><font color="#000000">車牌號</font></div></td>
<td width="74"><div align="center"><font color="#3300FF"><%=rs("車牌號") %></font></div></td>
<td width="42" ><div align="center"><font color="#000000">噸位</font></div></td>
<td width="55"><div align="center"><font color="#3300FF"><%= rs("噸位") %></font></div></td>
<td width="64" ><div align="center"><font color="#000000">車輛類型</font></div></td>
<td width="105"><div align="center"><font color="#3300FF"><%=rs("車輛類型") %></font></div></td>
<td width="75" ><div align="center"><font color="#000000">燃油種類</font></div></td>
<td width="98"><div align="center"><font color="#3300FF"><%= rs("燃油種類") %></font></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr class="tabback">
<td> <div align="center"><font color="#000000">經營者</font></div></td>
<td> <div align="center"><font color="#000000">性別</font></div></td>
<td> <div align="center"><font color="#000000">身份證號碼</font></div></td>
<td> <div align="center"><font color="#000000">家庭地址</font></div></td>
<td> <div align="center"><font color="#000000">現住地址</font></div></td>
<td> <div align="center"><font color="#000000">聯系號碼</font></div></td>
<td> <div align="center"><font color="#000000">合同期限</font></div></td>
</tr>
<tr>
<td> <div align="center"><font color="#3300FF"><%= rs("經營者") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("性別") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("身份證號碼") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("家庭地址") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("現住地址") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("聯系號碼") %></font></div></td>
<td> <div align="center"><font color="#3300FF"><%= rs("合同期限") %>--</font><font color="#6600FF"><%=rs("合同期限1") %></font></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr>
<td width="36"> <p align="center" ><font color="#000000">車型</font></p></td>
<td width="103"> <div align="center"><font color="#3300FF"><%= rs("車型") %></font></div></td>
<td width="61"> <p align="center" c><font color="#000000">投產時間</font></p></td>
<td width="147"> <div align="center"><font color="#3300FF"><%= rs("投產時間年") %>年 <%= rs("投產時間月") %>月<%= rs("投產時間日") %> 日</font></div></td>
<td width="50"> <p align="center" ><font color="#000000">顏 色</font></p></td>
<td width="52"> <div align="center"><font color="#3300FF"><%= rs("顏色") %></font></div>
<div align="center"></div></td>
<td width="60"> <p align="center" ><font color="#000000">制造廠家</font></p></td>
<td width="173"><div align="center"><font color="#3300FF"><%= rs("制造廠家") %></font></div></td>
</tr>
<tr>
<td height="2" colspan="8"> <div align="center"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center"></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr>
<td width="80" ><div align="center"><font color="#000000">發動機號碼</font></div></td>
<td width="93"><div align="center"><font color="#3300FF"><%= rs("發動機號碼") %></font></div></td>
<td width="40" ><div align="center"><font color="#000000">車架號</font></div></td>
<td width="100"><div align="center"><font color="#3300FF"><%=rs("車架號") %></font></div></td>
<td width="42" ><div align="center"><font color="#000000">軸數</font></div></td>
<td width="65"><div align="center"><font color="#3300FF"><%=rs("軸數") %></font></div></td>
<td width="29" ><div align="center"><font color="#000000">軸距</font></div></td>
<td width="66"><div align="center"><font color="#3300FF"><%= rs("軸距") %></font></div></td>
<td width="89" ><div align="center"><font color="#000000">駕駛室載客</font></div></td>
<td width="74"><div align="center"><font color="#3300FF"><%= rs("駕駛室載客") %></font></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr>
<td width="80" ><div align="center"><font color="#000000">保險期限</font></div></td>
<td width="269"><div align="center"><font color="#3300FF"><%= rs("保險期限年") %>年<%=rs("保險期限月") %>月<%= rs("保險期限日") %> 日 至 <%= rs("保險期限年1") %>年<%= rs("保險期限月1") %> 月 <%= rs("保險期限日1") %>日</font></div></td>
<td width="54" ><div align="center"><font color="#000000">承保單位</font></div></td>
<td width="147"><div align="center"><font color="#3300FF"><%=rs("承保單位") %> </font></div></td>
<td width="67" ><div align="center"><font color="#000000">保單號</font></div></td>
<td width="69"><div align="center"><font color="#3300FF"><%= rs("保單號") %></font></div></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE" bordercolordrak="#ffffff">
<tr>
<td width="48"> <p align="center" class="tabback"><font color="#000000">險種</font></p></td>
<td width="72"> <p align="center" class="tabback"><font color="#000000">車損險</font></p></td>
<td width="76"> <p align="center" class="tabback"><font color="#000000">第三責任險</font></p></td>
<td width="102"> <p align="center" class="tabback"><font color="#000000">司乘人員險</font></p></td>
<td width="109"> <p align="center" class="tabback"><font color="#000000">貨物承責</font></p></td>
<td width="97"> <p align="center" class="tabback"><font color="#000000">貨物公定險</font></p></td>
<td width="90"> <p align="center" class="tabback"><font color="#000000">不計免賠</font></p></td>
<td width="90"><div align="center" class="tabback"><%= rs("other") %></div></td>
</tr>
<tr>
<td> <p align="center" class="tabback"><font color="#000000">保額</font></p></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額車損險") %>萬元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額第三責任險") %>萬元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額司乘人員險") %>萬元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額貨物承責險") %>萬元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額貨物公定險") %>萬元 </font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保額不計免賠") %>萬元</font></div></td>
<td><div align="center"><%= rs("other1") %><font color="#3300FF">萬元</font></div></td>
</tr>
<tr>
<td> <p align="center" class="tabback"><font color="#000000">保費</font></p></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費車損險") %>元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費第三責任險") %>元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費司乘人員險") %>元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費貨物承責險") %>元</font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費貨物公定險") %>元 </font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs("保費不計免賠") %>元</font></div></td>
<td><div align="center"><%= rs("other2") %><font color="#3300FF">元`</font></div></td>
</tr>
</table>
<%
set rs1=server.createobject("adodb.recordset")
sql="select * from driver1 where 編號='"&rs("編號")&"'"
' sql="select * from driver1 where 經營者='李清勇'"
rs1.open sql,conn,1,3
%>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE"bordercolordrak="#ffffff">
<tr>
<td width="63" height="16"> <div align="center">
<p class="tabback">聘用駕駛員</p>
</div></td>
<td width="35"> <div align="center">
<p class="tabback">性別</p>
</div></td>
<td width="81"> <div align="center">
<p class="tabback">出生年月</p>
</div></td>
<td width="188" class="tabback"><div align="center">家庭地址</div></td>
<td width="94"> <div align="center">
<p class="tabback">上崗證號碼</p>
</div></td>
<td colspan="2"> <div align="center"></div>
<div align="center">
<p class="tabback">駕駛證號碼</p>
</div></td>
<td width="53"> <div align="center">
<p class="tabback">駕駛車類</p>
</div></td>
<td width="83"> <div align="center">
<p class="tabback">聯系號碼</p>
</div></td>
</tr>
<% do while not rs1.eof %>
<tr>
<td height="22"><div align="center"><font color="#3300FF"><%= rs1("聘用駕駛員") %></font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs1("性別") %></font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs1("出生年月") %></font></div></td>
<td><font color="#3300FF"><%= rs1("家庭地址") %></font></td>
<td><div align="center"><font color="#3300FF"><%= rs1("現住地址") %></font></div></td>
<td colspan="2"><div align="center"><font color="#3300FF"><%= rs1("駕駛證號碼") %></font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs1("駕駛車類") %></font></div></td>
<td><div align="center"><font color="#3300FF"><%= rs1("聯系號碼") %></font></div></td>
</tr>
<% rs1.movenext
loop
%>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE"bordercolordrak="#ffffff">
<tr>
<td width="52" height="66" > <font color="#000000">安全記錄</font></td>
<td width="642"><font color="#3300FF"><a href=javascript:winopen('../yinyun/accsident.asp?id=<%=rs("id")%>')><%=rs("安全記錄")%></a></font></td>
</tr>
</table>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#000000" class="TOOLBARTABLE"bordercolordrak="#ffffff">
<tr>
<td width="52" height="66">
<div align="center">
<p ><font color="#000000">備注</font></p>
</div></td>
<td width="642"><font color="#3300FF"><%= rs("備注") %></font></td>
</tr>
</table>
<table width="381" align="center">
<tr>
<td height="38"> <div align="center"><font color="#FF0000"> </font></div>
<div align="center"><font color="#3300FF"><a href="vbscript:window.close()"><font color="#FF0000">［關閉窗口</font></a><font color="#FF0000">］</font></font></div></td>
</tr>
</table>
</body>
</html>
<script language="javascript">
function winopen(url)
{
window.open(url,"search","toolbar=0，location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=1,width=490,height=430,top=0,left=0");
}
</script>
<% rs.close
set rs=nothing
conn.close
set conn=nothing
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -