📄 xy_hz_xy_zhuangyitaizhang.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<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;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.STYLE6 {color: #009900}
.STYLE1 {color: #FF0000}
-->
</style>
<title>转移培训-转移台账统计</title>
</head>
<body>
<p align="center"><br>
<span class="STYLE6">转移台账统计</span> <br />
<form id="form1" name="form1" method="post" action="">
<div align="center">
<table width="770" border="0" cellpadding="3" cellspacing="1" bgcolor="#62D8FF">
<tr>
<td bgcolor="#FFFFFF"><div align="justify">年度:
<input name="nianc" type="checkbox" id="nianc" value="on" />
<select name="nian" size="1" class="put" id="nian">
<option value=" " selected="selected"> </option>
<%for i=year(date) to 2004 step -1%>
<option value="<%=i%>"><%=i%>年</option>
<%next%>
</select>
</div></td>
<td bgcolor="#FFFFFF">
<div align="left"> 第几期:
<input name="qic" type="checkbox" id="qic" value="on" />
<select name="qi" size="1" class="put" id="select5">
<option value=" " selected="selected"> </option>
<%for i=1 to 50%>
<option value="<%=i%>">第<%=i%>期</option>
<%next%>
</select>
</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="justify">专业:
<input name="peixunzhuanyec" type="checkbox" id="peixunzhuanyec" value="on" />
<input name="peixunzhuanye" type="text" id="peixunzhuanye" size="10" />
</div></td>
<td bgcolor="#FFFFFF"><div align="justify">培训时间段：
<input name="peixunshijianc" type="checkbox" id="peixunshijianc" value="on" />
<span class="time style5">
<select name="peixunyear" size="1" class="put" id="peixunyear">
<option selected="selected"> </option>
<%for i=year(date) to 1990 step -1%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="peixunmonth" size="1" class="put" id="select2">
<option selected="selected"> </option>
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="peixunday" size="1" class="put" id="select16">
<option value="1"selected>1</option>
<%for i=1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日</span>到
<select name="peixunyear2" size="1" class="put" id="peixunyear2">
<option selected="selected"> </option>
<%for i=year(date) to 1990 step -1%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="peixunmonth2" size="1" class="put" id="peixunmonth2">
<option selected="selected"> </option>
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="peixunday2" size="1" class="put" id="peixunday2">
<option value="1"selected>1</option>
<%for i=1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日
<label></label>
</div></td>
</tr>
</table>
<br />
<input type="button" value="查询到页面" name="B12" class="put1" onClick="subie()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" />
<input type="button" value="输出到word" name="B1" class="put1" onClick="subword()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" />
<input type="button" value="输出到excel" name="B12" class="put1" onClick="subexcel()" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" />
<input type="hidden" name="docorxls" />
<input name="issubmit" type="hidden" id="issubmit" value="yes">
（
注：年度、期、专业和时间段均为可选项！）<span class="STYLE1"><br />
<br />
</span></div>
<script language="javascript">
function subword()
{
form1.action="xy_hz_xy_zhuangyitaizhang_we.asp";
form1.docorxls.value="doc";
form1.submit();
}
//
function subexcel()
{
form1.action="xy_hz_xy_zhuangyitaizhang_we.asp";
form1.docorxls.value="xls";
form1.submit();
}
function subie()
{
form1.action="xy_hz_xy_zhuangyitaizhang.asp";
form1.submit();
}
</script>
</form>
<%
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
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 align="center" cellPadding=0 cellSpacing=0
borderColorLight=#6699ff borderColorDark=#ffffff bgcolor="#FFFFFF" style="border-collapse:collapse">
<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="80" nowrap="nowrap" bgcolor="#FFCC66"><p align="center">联系电话</p></td>
<td width="60" 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="20" align="left" valign="middle" nowrap="nowrap"><%=count+1%></td>
<td height="20" 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("zhengshubianhao")%></td>
<td align="left" valign="middle"><%=rs("peixunzhuanye")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("jiuyequxiang")%></td>
<td align="left" valign="middle" nowrap="nowrap"><%=rs("lianxidianhua")%></td>
<td align="left" valign="middle"><%=rs("beizhu")%></td>
</tr>
<%rs.movenext
count=count+1
loop
%>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -