📄 xy_hz_xy_anqi.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<html>
<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;
font-weight: bold;
}
.STYLE1 {color: #FF0000}
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"><span class="STYLE7 STYLE1">学员登记表</span> <br />
<form id="form1" name="form1" method="post" action="xy_hz_xy_anqi.asp">
<div align="center">
<p>年度:
<select name="nian" size="1" class="put" id="select14">
<option value=" " selected="selected"> </option>
<%for i=year(date) to 2004 step -1%>
<option value="<%=i%>"><%=i%>年</option>
<%next%>
</select>
期:
<select name="qi" size="1" class="put" id="qi">
<option value=" " selected="selected"> </option>
<%for i=1 to 50 %>
<option value="<%=i%>">第<%=i%>期</option>
<%next%>
</select>
<input type="button" value="查询到页面" name="B122" onclick="subie()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00"/>
<input type="button" value="输出到word" name="B1" onclick="subword()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00"/>
<input name="docorxls" type="hidden" id="docorxls">
<input type="button" value="输出到excel" name="B12" onClick="subexcel()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00"/>
<input name="issubmit" type="hidden" id="issubmit" value="yes">
<br>
<br>
注：只填年度不填期则统计该年所有期的学员<br>
<span class="STYLE1"> </span></p>
</div>
<script language="javascript">
function subword()
{
form1.action="xy_hz_xy_anqi_we.asp";
form1.docorxls.value="doc";
form1.submit();
}
function subexcel()
{
form1.action="xy_hz_xy_anqi_we.asp";
form1.docorxls.value="xls";
form1.submit();
}
function subie()
{
form1.action="xy_hz_xy_anqi.asp";
form1.submit();
}
</script>
</form>
<%
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
%>
<p align="center">（<%=nian%>年第 <%=qi%> 期）<span class="style4">共<%=rs.recordcount%>条记录</span> 培训单位(盖章)： 填表人： 填报日期：<%=DATE%> </p>
<TABLE width=99% border=1 align="center" cellPadding=0 cellSpacing=0
borderColorLight=#6699ff borderColorDark=#ffffff bgcolor="#FFFFFF" style="border-collapse:collapse">
<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="96" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">就业去向 </p></td>
</tr>
<%count=0
do while not rs.eof and count<rs.pagesize %>
<%if count Mod 2=0 then%><TR bgcolor="#F5FAFE" onMouseOver="this.style.backgroundColor='#FFDA6A'" onMouseOut="this.style.backgroundColor='#F5FAFE'">
<%else%><TR bgcolor="#E2EEFC" onMouseOver="this.style.backgroundColor='#FFDA6A'" onMouseOut="this.style.backgroundColor='#E2EEFC'">
<%end if%>
<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"))
nianling=year(date)-byear
end if
%><%=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>
</tr>
<%rs.movenext
count=count+1
loop
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -