📄 xy_hz_xy_peixuntaizhang_we.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<%
nian=trim(request("nian"))
nianc=trim(request("nianc"))
qi=trim(request("qi"))
qic=trim(request("qic"))
peixunzhuanye=trim(request("peixunzhuanye"))
peixunzhuanyec=trim(request("peixunzhuanyec"))
peixunshijianc=trim(request("peixunshijianc"))
peixunyear=request("peixunyear")
peixunmonth=request("peixunmonth")
peixunday=request("peixunday")
peixunyear2=request("peixunyear2")
peixunmonth2=request("peixunmonth2")
peixunday2=request("peixunday2")
issubmit=trim(request("issubmit"))
if issubmit="yes" then
if nian="" and qi="" and peixunzhuanye="" and peixunyear=""then
response.Write "<script language=javascript>{window.alert('请至少选择一种查询条件！这四种条件均为可选，且可以任意组合。请按确定返回！');window.history.go(-1);}</script>"
response.end
end if
end if
set rs=server.createobject("adodb.recordset")
sql="select * from jlzd321 where ischeck='1' and isrecycle='0'"
if nianc="on" then
sql=sql & " and nian = '" & nian & "'"
sc="年度:"&nian&"｜"
end if
if qic="on" then
sql=sql&"and qi like'%"&qi&"%'"
sc=sc&"期:第"&qi&"期｜"
end if
if peixunzhuanyec="on" then
sql=sql & " and peixunzhuanye like '%" & peixunzhuanye & "%'"
sc=sc&"培训专业:"&peixunzhuanye&"｜"
end if
if peixunshijianc="on" then
sql=sql & " and peixunshijian between #"&peixunyear&"-"&peixunmonth&"-"&peixunday&"# and #"&peixunyear2&"-"&peixunmonth2&"-"&peixunday2&"#"
sc=sc&"培训时间段:"&peixunyear&"."&peixunmonth&"."&peixunday&"到"&peixunyear2&"."&peixunmonth2&"."&peixunday2
end if
if nianc="" and qic="" and peixunzhuanyec="" and peixunshijianc="" then
response.end
end if
sql=sql&" order by nian desc , qi asc , xuehao asc , xingming asc"
rs.open sql,conn,1,2
if rs.eof and rs.bof then
response.write "<script language=JavaScript>{window.alert('您的查询条件为："&sc&"，没有符合条件的记录!请按“确定”返回后重新搜索');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}
.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">培训台账统计 <br />
<br />
<% allrecord=rs.recordcount
if sc="" then
response.write "您没有选择任何查询条件，此处显示所有记录,共"&allrecord&"条"
end if
if sc<>"" then
response.write "查询条件为："&sc&",符合条件的记录有"&allrecord&"条"
end if%>,培训单位(盖章)： 填表人： 日期:<%=DATE%>
<table width="99%" border="1" cellspacing="1" cellpadding="3" style="border-collapse: collapse" bordercolor="#CCCCCC">
<tr>
<td width="30" height="18" nowrap="nowrap" bgcolor="#FFCC66"><div align="center">序号</div></td>
<td width="45" nowrap="nowrap" bgcolor="#FFCC66">学号</td>
<td width="52" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">姓名 </p></td>
<td width="57" nowrap="nowrap" bgcolor="#FFCC66">出生年月</td>
<td width="33" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">性别 </p></td>
<td width="76" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">身份证号</p></td>
<td width="59" nowrap="nowrap" bgcolor="#FFCC66">文化程度 </td>
<td width="84" valign="middle" bgcolor="#FFCC66"><p align="center">培训专业 <br />
(工种)</p></td>
<td width="89" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">培训时间 </p></td>
<td width="52" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">家庭住址</p></td>
<td width="80" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">联系电话</p></td>
<td width="60" 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 height="27" 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("chushengnianyue")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("xingbie")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("shenfenzhenghao")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("wenhuachengdu")%></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("zhuzhi")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("lianxidianhua")%></td>
<td align="left" valign="middle"><%=rs("beizhu")%></td>
</tr>
<%rs.movenext
loop
%>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -