📄 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 + -