📄 lhb_jkz.asp
字号:
<!--#include file="config.asp"-->
<%
id=trim(Request("id"))
sqlcmd = ("select a.*,b.L_MingCheng from LHB_Office_JKZ a inner join LHB_GongYong b ON a.L_type = b.L_MingChengBM where b.L_FenLeiBM = 6 and a.id="&id) '查询id(ID号)这条记录
Lours.Open sqlcmd,Louconn,1,1
L_photo = Lours("strFile1")
L_name = Lours("L_name")
L_sex = Lours("L_sex")
L_type = Lours("L_MingCheng")
L_year = Lours("L_year")
L_end = Lours("L_end")
L_HIV = Lours("L_HIV")
L_start_year = Lours("L_start_year")
L_start_month = Lours("L_start_month")
L_start_day = Lours("L_start_day")
Lours.Close
Louconn.Close
set Lours=nothing
set Louconn=nothing
%>
<%if L_photo=" " then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>照片未添加，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_end="0" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>体检结果未录入，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_end="2" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>体检结果不合格，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_HIV="2" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>HIV阳性，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_start_year="0" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>发证年份未录入，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_start_month="0" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>发证月份未录入，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%elseif L_start_day="0" then%>
<!--#include file="LHB_head.asp"-->
<!--#include file="LHB_DHT_01.asp"-->
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="table4">
<tr>
<td width="100" height="25" align="center"><!--#include file="LHB_DHT_02.asp"--></td>
</tr>
</table>
<br>
<center>发证日期未录入，不能打印健康证！
<form>
<INPUT TYPE='BUTTON' class="button1" value='关闭窗口' onClick='window.close()'>
</form>
</center>
<br>
<!--#include file="LHB_copy.asp"-->
<%else%>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="LHB_JKZ.files/filelist.xml">
<link rel=Edit-Time-Data href="LHB_JKZ.files/editdata.mso">
<link rel=OLE-Object-Data href="LHB_JKZ.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>楼宏标</o:LastAuthor>
<o:Created>2007-02-05T04:58:34Z</o:Created>
<o:LastSaved>2007-02-05T05:08:38Z</o:LastSaved>
<o:Version>11.6360</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;
mso-ruby-visibility:none;}
col
{mso-width-source:auto;
mso-ruby-visibility:none;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:middle;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:12.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:宋体;
mso-generic-font-family:auto;
mso-font-charset:134;
border:none;
mso-protection:locked visible;
mso-style-name:常规;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:12.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:宋体;
mso-generic-font-family:auto;
mso-font-charset:134;
mso-number-format:General;
text-align:general;
vertical-align:middle;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:bottom;}
.xl25
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
vertical-align:bottom;}
.xl26
{mso-style-parent:style0;
color:red;
font-size:10.0pt;}
.xl27
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
text-align:right;}
.xl28
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
text-align:center;}
.xl29
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
text-align:left;}
.xl30
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
text-align:right;
vertical-align:bottom;}
.xl31
{mso-style-parent:style0;
color:red;
font-size:10.0pt;
text-align:right;}
.xl32
{mso-style-parent:style0;
font-size:10.0pt;
vertical-align:bottom;
mso-protection:unlocked visible;}
.xl33
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
mso-protection:unlocked visible;}
.xl34
{mso-style-parent:style0;
color:black;
font-size:10.0pt;}
.xl35
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
mso-number-format:"Long Date";
text-align:left;}
.xl36
{mso-style-parent:style0;
color:black;
font-size:10.0pt;
text-align:left;
vertical-align:bottom;}
ruby
{ruby-align:left;}
rt
{color:windowtext;
font-size:9.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:宋体;
mso-generic-font-family:auto;
mso-font-charset:134;
mso-char-type:none;
display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>jkz</x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>285</x:DefaultRowHeight>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>768</x:PaperSizeIndex>
<x:VerticalResolution>0</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:DoNotDisplayGridlines/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>1</x:ActiveRow>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>6750</x:WindowHeight>
<x:WindowWidth>11700</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>75</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=336 style='border-collapse:
collapse;table-layout:fixed;width:253pt'>
<col width=45 style='mso-width-source:userset;mso-width-alt:1440;width:34pt'>
<col width=43 style='mso-width-source:userset;mso-width-alt:1376;width:32pt'>
<col width=41 style='mso-width-source:userset;mso-width-alt:1312;width:31pt'>
<col width=47 style='mso-width-source:userset;mso-width-alt:1504;width:35pt'>
<col width=34 style='mso-width-source:userset;mso-width-alt:1088;width:26pt'>
<col width=8 style='mso-width-source:userset;mso-width-alt:256;width:6pt'>
<col width=118 style='mso-width-source:userset;mso-width-alt:3776;width:89pt'>
<tr height=46 style='mso-height-source:userset;height:35.1pt'>
<td height=46 width=45 style='height:35.1pt;width:34pt'></td>
<td width=43 style='width:32pt'></td>
<td width=41 style='width:31pt'></td>
<td width=47 style='width:35pt'></td>
<td width=34 style='width:26pt'></td>
<td width=8 style='width:6pt'></td>
<td width=118 style='width:89pt'></td>
</tr>
<tr height=25 style='mso-height-source:userset;height:18.95pt'>
<td height=25 class=xl24 style='height:18.95pt'><!--下列信息由 Microsoft Office Excel 的“发布为网页”向导生成。--><!--如果同一条目从 Excel 中重新发布，则所有位于 DIV 标记之间的信息均将被替换。--><!-----------------------------><!--“从 EXCEL 发布网页”向导开始--><!-----------------------------></td>
<td colspan=2 class=xl25></td>
<td colspan=3 class=xl25 style='mso-ignore:colspan'></td>
<td rowspan=5 class=xl33><img src="UpLoadFile/<%=L_photo%>" width="80" height="100"></td>
</tr>
<tr height=25 style='mso-height-source:userset;height:18.95pt'>
<td height=25 class=xl26 style='height:18.95pt'></td>
<td colspan=2 class=xl34><%=L_name%></td>
<td class=xl27></td>
<td colspan=2 class=xl34><%if L_sex = 1 then%>男<%else%>女<%end if%></td>
</tr>
<tr height=25 style='mso-height-source:userset;height:18.95pt'>
<td height=25 class=xl26 style='height:18.95pt'></td>
<td colspan=2 class=xl34><%=L_type%></td>
<td class=xl28></td>
<td colspan=2 class=xl29><%=L_year%></td>
</tr>
<tr height=24 style='mso-height-source:userset;height:18.0pt'>
<td height=24 class=xl26 style='height:18.0pt'></td>
<td colspan=2 class=xl34><%if L_end = 1 then%>合格<%elseif L_end = 2 then%>不合格<%elseif L_end = "" then%><%end if%></td>
<td class=xl28>HIV:</td>
<td class=xl36><%if L_HIV = 1 then%>阴性<%else%>阳性<%end if%></td>
<td class=xl30></td>
</tr>
<tr height=24 style='mso-height-source:userset;height:18.0pt'>
<td height=24 class=xl31 style='height:18.0pt'></td>
<td class=xl29></td>
<td colspan=3 class=xl35 x:num="39118"><%=L_start_year%>年<%=L_start_month%>月<%=L_start_day%>日</td>
<td class=xl29></td>
</tr>
<tr height=24 style='mso-height-source:userset;height:18.0pt'>
<td height=24 colspan=2 class=xl26 style='height:18.0pt;mso-ignore:colspan'></td>
<td colspan=5 class=xl35> 苏溪中心卫生院</td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=7 class=xl24 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=7 class=xl32 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr class=xl32 height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=7 class=xl32 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr class=xl32 height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=7 class=xl32 style='height:12.0pt;mso-ignore:colspan'></td>
</tr>
<tr height=16 style='mso-height-source:userset;height:12.0pt'>
<td height=16 colspan=6 class=xl32 style='height:12.0pt;mso-ignore:colspan'></td>
<td class=xl32><!-----------------------------><!--“从 EXCEL 发布网页”向导结束--><!-----------------------------></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=45 style='width:34pt'></td>
<td width=43 style='width:32pt'></td>
<td width=41 style='width:31pt'></td>
<td width=47 style='width:35pt'></td>
<td width=34 style='width:26pt'></td>
<td width=8 style='width:6pt'></td>
<td width=118 style='width:89pt'></td>
</tr>
<![endif]>
</table>
<style media=print>
.Noprint{display:none;}
.PageNext{page-break-after: always;}
</style>
<center class="Noprint" >
<p>
<script type="text/javascript">
AC_AX_RunContent( 'id','WebBrowser','classid','CLSID:8856F961-340A-11D0-A96B-00C04FD705A2','height','0','width','0' ); //end AC code
</script><noscript><OBJECT id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 width=0>
</OBJECT></noscript>
<input type=button value=打印 onclick=document.all.WebBrowser.ExecWB(6,1)>
<input type=button value=直接打印 onclick=document.all.WebBrowser.ExecWB(6,6)>
<input type=button value=页面设置 onclick=document.all.WebBrowser.ExecWB(8,1)>
</p>
<p> <input type=button value=打印预览 onclick=document.all.WebBrowser.ExecWB(7,1)>
<br/>
</p>
</center>
</body>
</html>
<%end if%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -