📄 print.asp
字号:
<%response.expires=0%>
<%Response.Buffer=true%>
<!-- #include file="../conn_lr.asp"-->
<!-- #include file="../css.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='../../default.asp';")
response.write("</script>")
response.end
end if
%>
<html>
<head>
<title>打印</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<% '定义变量
dim Number,opFlag,rs,rs1
'获取输入参数:记录号和操作标志
Number=request("Number")
if Number="" then Number="0"
Number=Cint(Number)
opFlag=request("opFlag")
'创建记录访问对象
Set rs = Server.CreateObject("ADODB.Recordset")
'打开记录源,并定位到输入参数决定的记录号
rs.Open Session("SQL"),Session("conn"),1,3
rs.move Number
'根据当前的记录打开carfy表
SET rs1=Server.CreateObject("ADODB.RecordSet")
rs1.open "select * from carfy where Cnumber='"& rs("Cbianhao")&" '" ,Session("conn"),1,1
%>
<style>table{border:solid windowtext .5pt;border-right:none;border-bottom:none;}td{border:solid windowtext .5pt;border-left:none;border-top:none;mso-border-left-alt:solid windowtext .5pt;padding:0mm 5.4pt 0mm 5.4pt }</style>
</head>
<body id=all>
<p align="center"><b><font size="5"><%=rs("Cchepai")%>汽车详细资料</font></b></p>
<hr size=1>
<table class=vtext width="95%" align="center" border=1>
<tr>
<td width="98" align="right" nowrap height="25">汽车编号：</td>
<td height="25" align="left" valign="middle"><%=rs("Cbianhao")%></td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">车型：</td>
<td height="25" align="left" valign="middle"><%=rs("Cchexin")%></td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">车牌：</td>
<td height="25" align="left" valign="middle"><%=rs("Cchepai")%></td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">司机：</td>
<td height="25" align="left" valign="middle"><%=rs("Csiji")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">现状：</td>
<td height="25" align="left" valign="middle"><%=rs("Cxianzhuang")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">购车日期：</td>
<td height="25" align="left" valign="middle"><%=rs("Cgcriqi")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">购车者：</td>
<td height="25" align="left" valign="middle"><%=rs("Cgcren")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">购车费用(元)：</td>
<td height="25" align="left" valign="middle"><%=rs("Cgcfeiyong")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">备注：</td>
<td height="25" align="left" valign="middle"><%=rs("Cbeizhu")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">历史记录：</td>
<td height="25" align="left" valign="middle"><%=rs("Chistory")%> </td>
</tr>
<tr>
<td width="98" align="right" nowrap height="25">费用记录：</td>
<td width="854" >
<table class=vtext width="100%" align="center" style="mso-border-left-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right-style: none; border-right-width: medium; border-top: .5pt solid windowtext; border-bottom-style: none; border-bottom-width: medium; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0mm; padding-bottom: 0mm" >
<tr align="center" >
<td><p align="center" style="MARGIN-RIGHT: 0px">日期</p></td>
<td><p align="center" style="MARGIN-RIGHT: 0px">收支</p></td>
<td><p align="center" style="MARGIN-RIGHT: 0px">费用(元)</p></td>
<td><p align="center" style="MARGIN-RIGHT: 0px">经办人</p></td>
<td><p align="center" style="MARGIN-RIGHT: 0px">简述</p></td>
</tr>
<%
'显示相应字段的值
while not rs1.eof
response.write("<tr bgcolor='ffffff'><td>" & rs1("Criqi") & " </td>")
response.write("<td>" & rs1("Cshouzhi") & " </td>")
response.write("<td>" & rs1("Cfeiyong") & " </td>")
response.write("<td>" & rs1("Cpeople") & " </td>")
response.write("<td>" & rs1("Cjianshu") & " </td></tr>")
rs1.movenext
wend
%>
</table>
</td>
</tr>
</table>
<script language=javascript>
window.print();
</script>
<% '关闭记录源
rs.close
set rs=nothing
rs1.close
set rs1=nothing
%>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -