atjxmjs.asp
来自「医院医技科室系统,可以进行医技报告的生成打印,完全的BS结构」· ASP 代码 · 共 95 行
ASP
95 行
<%
set conn=server.CreateObject ("adodb.connection")
conn.Open application("sconn")
set rs=server.CreateObject ("adodb.recordset")
dim imax,ssql
ssql= "select count(mz_ttjd.tjdid) from mz_ttjd,mz_ttjdnr where mz_ttjd.tjdid=mz_ttjdnr.tjdid and mz_ttjdnr.tjdzt=1 and mz_ttjdnr.tjks="&session("ks")&" "
rs.Open ssql,conn
imax=rs(0)
rs.Close
ssql= "select distinct mz_ttjd.tjdid,mz_ttjd.tjr,mz_ttjd.tjh from mz_ttjd,mz_ttjdnr where mz_ttjd.tjdid=mz_ttjdnr.tjdid and mz_ttjdnr.tjdzt=1 and mz_ttjdnr.tjks="&session("ks")&" "
%>
<script language="javascript">
<!--
function clime(tjdid,tjr,tjh){
frmRQDJ.iLSH.value=tjdid;
frmRQDJ.iXM.value=tjr;
frmRQDJ.iMZH.value=tjh;
frmRQDJ.submit();
}
-->
</script>
<html>
<head>
<meta http-equiv="refresh" content="120">
<meta name="VI60_defaultClientScript" content="VBScript">
<link href="../../hcss.htm" rel="stylesheet" type="text/css">
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</head>
<body><center>
<form action =acTJXMJS.asp method="post" id="frmRQDJ" name="frmRQDJ">
<input type=hidden id=iLSH name=iLSH><input type=hidden id=iXM name=iXM>
<input type=hidden id=iMZH name=iMZH>
<table border="1" name="tbcxjg" bgcolor="#cce8d6" bordercolorlight="#000000" bordercolordark="#ffffff" cellpadding="4" cellspacing="0" >
<tr><td colspan="10" bgcolor="#3399ff"><font color="white">待体检病人一览
</font></td></tr>
<%
dim cs
if imax>30 then
cs=int(imax/6+0.9)
else
cs=5
end if
set rsyf=server.CreateObject ("adodb.recordset")
rs.Open ssql,conn
for i=1 to cs
Response.Write "<tr>"
for j=1 to 6
if not rs.EOF then
do while not rs.EOF
'判断在本药房是否有药
rsyf.Open "select count(*) from mz_Ttjd,mz_ttjdnr where mz_ttjd.tjdid=mz_ttjdnr.tjdid and mz_ttjdnr.tjdzt=1 and mz_ttjdnr.tjks="&session("ks")&"",conn
if rsyf(0)<>0 then
Response.Write "<td style='cursor:hand;height:85;width:80' background='../../images/wait.gif'align=center"
Response.Write " onclick=javascript:clime(" & rs("tjdid") & ",'" & rs("tjr") & "','" & rs("tjh") & "')>"
Response.Write "<font color=blue>" & rs("tjh") & "<br>" & rs("tjr") & "</font></td>"
rsyf.close
ssql= "select count(distinct tjdid) from mz_ttjd,mz_ttjdnr where mz_ttjd.tjdid=mz_ttjdnr.tjdid and mz_ttjdnr.tjdzt=1 and mz_ttjdnr.tjks="&session("ks")&""
exit do
else
rs.MoveNext
end if
rsyf.close
loop
if not rs.EOF then
rs.MoveNext
else
Response.Write "<td style='height:85;width:80'> </td>"
end if
else
Response.Write "<td style='height:85;width:80'> </td>"
end if
next
Response.Write "</tr>"
next
%>
</table>
</form></P>
</body>
</html>
<% set rs=nothing
conn.Close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?