📄 xy_hz_xy_anqi_we.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<%
nian=trim(request("nian"))
qi=trim(request("qi"))
issubmit=trim(request("issubmit"))
if issubmit="yes" and nian="" then
response.Write "<script language=javascript>{window.alert('请至少选择“年度”，如只选择“年度”而不选择“期”，则统计该年所有期的学员。请按确定返回！');window.history.go(-1);}</script>"
response.end
end if
if nian<>"" and qi <>"" then
sql="select * from jlzd321 where ischeck='1' and isrecycle='0' and nian='"&nian&"' and qi='"&qi&"' order by nian desc , qi asc , xuehao asc , xingming asc"
end if
if nian<>"" and qi ="" then
sql="select * from jlzd321 where ischeck='1' and isrecycle='0' and nian='"&nian&"' order by nian desc , qi asc , xuehao asc , xingming asc"
end if
if nian="" and qi="" then
response.end
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,2
if rs.eof then
response.write "<script language=JavaScript>{window.alert('没有相关记录，请按“确定”返回后“刷新”页面!');window.history.go(-1);}</script>"
response.end
end if
%>
<%
s=Second(time)
docorxls=request("docorxls")
if docorxls="doc" then
Response.ContentType = "application/msword"
response.AddHeader "content-disposition", "inline; filename=学员按期统计表_"&nian&"年第"&qi&"期"&date&"_"&s&".doc"
else if docorxls="xls" then
Response.ContentType = "application/msexcel"
response.AddHeader "content-disposition", "inline; filename=学员按期统计表_"&nian&"年第"&qi&"期"&date&"_"&s&".xls"
end if
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
<!--
.style5 {color: #000000}
body,td,th {
font-size: 13px;
}
table {
word-break:break-all;
}
.STYLE7 {font-size: 16px}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style>
<title>学员按期统计表</title>
</head>
<body>
<p align="center" class="STYLE7">学员按期统计表
<p align="center">（<%=nian%>年第 <%=qi%> 期）<span class="style4">共<%=rs.recordcount%>条记录</span> 培训单位(盖章)： 填表人： 填报日期：<%=DATE%> </p>
<table width="99%" border="1" cellspacing="1" cellpadding="3" style="border-collapse: collapse" bordercolor="#CCCCCC">
<tr>
<td width="26" nowrap="nowrap" bgcolor="#FFCC66"><div align="center">序号</div></td>
<td width="63" nowrap="nowrap" bgcolor="#FFCC66">学号</td>
<td width="61" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">姓名 </p></td>
<td width="33" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">性别 </p></td>
<td width="34" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">年龄 </p></td>
<td width="103" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">身份证号</p></td>
<td width="90" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">家庭住址</p></td>
<td width="105" valign="middle" bgcolor="#FFCC66"><p align="center">培训专业</p></td>
<td width="73" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">培训时间 </p></td>
<td width="38" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">收费<br />
标准 </p> </td>
<td width="40" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">补助<br />
金额 </p> </td>
<td width="43" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">考核 </p></td>
<td width="83" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">就业去向 </p></td>
<td width="127" bgcolor="#FFCC66"><p align="center">联系电话 </p></td>
</tr>
<%
do while not rs.eof %>
<TR>
<td height="27" align="left" valign="middle" nowrap="nowrap"><%=count+1%></td>
<td align="left" valign="middle" nowrap="nowrap"><a href="xy_view_all.asp?ID=<%=rs("ID")%>" target="_bank"><%=rs("xuehao")%></a></td>
<td align="left" valign="middle" nowrap="nowrap"><a href="xy_view_all.asp?ID=<%=rs("ID")%>" target="_bank"><%=rs("xingming")%></a></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("xingbie")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%
if isdate(rs("chushengnianyue"))then
byear=year(rs("chushengnianyue"))
bmonth=month(rs("chushengnianyue"))
'bday=day(rs("chushengnianyue"))
end if
%><%=rs("nianling")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("shenfenzhenghao")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("zhuzhi")%></td>
<td align="left" valign="middle"><%=rs("peixunzhuanye")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("peixunshijian")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("shoufeibiaozhun")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("buzhujine")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("kaohe")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("jiuyequxiang")%></td>
<td align="left" valign="middle"><%=rs("lianxidianhua")%></td>
</tr>
<%rs.movenext
loop
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -