28,408
社区成员




<%
sql="select * from V_TJCX where guid='"&UserRs("guid")&"' order by KSMC Asc"
Set KsRs=ConnM.Execute(sql)
%>
<table width="95%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td colspan="4"> <strong>项目结果 </strong> </td>
</tr>
<tr>
<td> <div align="center">科室 </div> </td>
<td> <div align="center">项目 </div> </td>
<td> <div align="center">结果 </div> </td>
<td> <div align="center">标准 </div> </td>
</tr>
<%
k=0
Session("ksmc")=""
do while not KsRs.Eof
%>
<tr>
<%if Session("ksmc")<>KsRs("ksmc") then%>
<td width="25%" rowspan="<%=k%>">
<div align="center"> <%=KsRs("ksmc")%>
<% if KsRs("KSSM") <>"" then %>
<br>
<span class="style1">( <%=KsRs("KSSM")%>) </span>
<%
end if
Session("ksmc")=KsRs("ksmc")
%>
</div>
</td>
<%
else
k=k+1
end if
%>
<td> <div align="center"> <%=KsRs("XXMC")%> </div> </td>
<td> <div align="center"> <%=KsRs("XMvalue")%> </div> </td>
<td> <div align="center">
<% if KsRs("CKSX") <>"" then %>
<%= KsRs("CKXX") %>- <%= KsRs("CKSX") %> <%= KsRs("DW") %>
<% else %>
<%end if%>
</div> </td>
</tr>
<% KsRs.MoveNext %>
<% Loop %>
</table>
<% KsRs.Close %>
<%
sql="select * from V_TJCX where guid='"&UserRs("guid")&"' order by KSMC Asc"
Set KsRs=ConnM.Execute(sql)
%>
<table width="95%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td colspan="4"> <strong>项目结果 </strong> </td>
</tr>
<tr>
<td> <div align="center">科室 </div> </td>
<td> <div align="center">项目 </div> </td>
<td> <div align="center">结果 </div> </td>
<td> <div align="center">标准 </div> </td>
</tr>
<%
k=0
Session("ksmc")=""
do while not KsRs.Eof
%>
<tr>
<%if Session("ksmc")<>KsRs("ksmc") then%>
<td width="25%" rowspan="<%=k%>">
<div align="center"> <%=KsRs("ksmc")%>
<% if KsRs("KSSM") <>"" then %>
<br>
<span class="style1">( <%=KsRs("KSSM")%>) </span>
<%
end if
Session("ksmc")=KsRs("ksmc")
%>
</div>
</td>
<%
else
nd if k=k+1
e
%>
<td> <div align="center"> <%=KsRs("XXMC")%> </div> </td>
<td> <div align="center"> <%=KsRs("XMvalue")%> </div> </td>
<td> <div align="center">
<% if KsRs("CKSX") <>"" then %>
<%= KsRs("CKXX") %>- <%= KsRs("CKSX") %> <%= KsRs("DW") %>
<% else %>
<%end if%>
</div> </td>
</tr>
<% KsRs.MoveNext %>
<% Loop %>
</table>
<% KsRs.Close %>
...........
<%
sql="SELECT *,(SELECT COUNT([KSMC]) FROM V_TJCX GROUP BY [KSMC]) AS rowspan FROM V_TJCX WHERE guid='"&UserRs("guid")&"' order by KSMC Asc"
Set KsRs=ConnM.Execute(sql)
%>
<table width="95%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td colspan="4"> <strong>项目结果 </strong> </td>
</tr>
<tr>
<td> <div align="center">科室 </div> </td>
<td> <div align="center">项目 </div> </td>
<td> <div align="center">结果 </div> </td>
<td> <div align="center">标准 </div> </td>
</tr>
<%
prename=""
do while not KsRs.Eof
rowspan=rs("rowspan")
if prename<>rs("ksmc")'如果换了科室
%>
<tr>
<td width="25%" rowspan="<%=rowspan%>"> <div align="center"> <%=KsRs("ksmc")%>
<% if KsRs("KSSM") <>"" then %>
<br>
<span class="style1">( <%=KsRs("KSSM")%>) </span>
<%end if %>
</div> </td>
<td> <div align="center"> <%=KsRs("XXMC")%> </div> </td>
<td> <div align="center"> <%=KsRs("XMvalue")%> </div> </td>
<td> <div align="center">
<% if KsRs("CKSX") <>"" then %>
<%= KsRs("CKXX") %>- <%= KsRs("CKSX") %> <%= KsRs("DW") %>
<% else %>
<%end if%>
</div> </td>
</tr>
<%
else
%>
<tr>
<td> <div align="center"> <%=KsRs("XXMC")%> </div> </td>
<td> <div align="center"> <%=KsRs("XMvalue")%> </div> </td>
<td> <div align="center">
<% if KsRs("CKSX") <>"" then %>
<%= KsRs("CKXX") %>- <%= KsRs("CKSX") %> <%= KsRs("DW") %>
<% else %>
<%end if%>
</div> </td>
</tr>
<%
end if
prename=rs("KSMC")&""
KsRs.MoveNext %>
<% Loop %>
</table>
<% KsRs.Close %>
...........
ks = ""
response.write "<table>"
while not rs.eof
if ks = rs("科室") then
l_ks = ""
else
l_ks = rs("科室")
ks = l_ks
end if
response.write "<tr>"
response.write "<td>" & l_ks & "</td>"
response.write "<td>" & rs("项目") & "</td>"
response.write "<td>" & rs("结果") & "</td>"
response.write "<td>" & rs("标准") & "</td>"
response.write "</tr>"
rs.movenext
wend
response.write "</table>"
ks = ""
response.write "<table>"
while not rs.eof
if ks = rs("科室") then
l_ks = ""
else
l_ks = rs("科室")
end if
response.write "<tr>"
response.write "<td>" & l_ks & "</td>"
response.write "<td>" & rs("项目") & "</td>"
response.write "<td>" & rs("结果") & "</td>"
response.write "<td>" & rs("标准") & "</td>"
response.write "</tr>"
rs.movenext
wend
response.write "</table>"
<%
str="1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50"
a=split(str,",")
b=Ubound(a)
%>
<table width="100%" border="1" cellpadding="3" cellspacing="1" bgcolor="#999999">
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF">123</td>
</tr>
<tr>
<td rowspan="<%=b+2%>" bgcolor="#FFFFFF">4</td>
<td bgcolor="#FFFFFF">0</td>
<td bgcolor="#FFFFFF">1</td>
</tr>
<%
For i= 0 to b
%>
<tr>
<td bgcolor="#FFFFFF">2</td>
<td bgcolor="#FFFFFF">3</td>
</tr>
<%
Next
%>
</table>