📄 admin_xy_ischeck.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% Response.Buffer =True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "No-Cache" %>
<!--#include file="conn_fj16.asp" -->
<!--#include file="admin_qx.asp" -->
<% issjcz %>
<%
ziduan=trim(request("ziduan"))
key=trim(request("key"))
if key<>"" and ziduan<>""then
sql="select * from jlzd321 where ischeck='0' and "&ziduan&" like '%"&key&"%' order by nian desc , qi asc,xuehao asc"
end if
if key=""then
sql="select * from jlzd321 where ischeck='0' order by nian desc , qi asc,xuehao asc"
end if
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,2
if rs.eof then
response.write"没有记录"
response.end
end if
rs.PageSize=15
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then page=1
rs.AbsolutePage=page
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
<!--
table {
word-break:break-all;
}
.style1 {color: #0000FF}
.STYLE2 {color: #FF0000}
.STYLE3 {font-size: 12px}
.STYLE4 {font-size: 12px; color: #FF0000; }
body {
margin-left: 0px;
margin-right: 0px;
margin-bottom: 3px;
margin-top: 0px;
SCROLLBAR-FACE-COLOR: #c6ebde;
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
SCROLLBAR-SHADOW-COLOR: #39867b;
SCROLLBAR-3DLIGHT-COLOR: #39867b;
SCROLLBAR-ARROW-COLOR: #330000;
SCROLLBAR-TRACK-COLOR: #e2f3f1;
SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
}
.STYLE13 {color: #0000FF; font-size: 14px; }
.STYLE16 {font-size: 13px}
body,td,th {
font-size: 13px;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>学员浏览与简单查询</title>
</head>
<body class="STYLE3">
<%
if rs.eof then
response.write"没有记录"
end if
%>
<table width="99%" height="99%" border="0" align="center" cellpadding="0" cellspacing="0" background="images/admin_bg_1.gif">
<tr>
<td align="center" valign="middle"><table width="99%" height="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="114" valign="top" bgcolor="#FFFFFF" >
<%if not rs.eof then%>
<form action="admin_xy_ischeck.asp" method="post" name="form1" target="_self" id="form1">
<table width="599" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#EDFEF3">
<tr>
<td align="center" class="STYLE2"><div align="center">
<label>
<select name="ziduan" id="ziduan">
<option value="xingming">选择查找项目(默认为按姓名查找)</option>
<option value="xuehao">学号</option>
<option value="xingbie">性别</option>
<option value="wenhuachengdu">文化程度</option>
<option value="peixunzhuanye">培训专业</option>
<option value="jiguan">籍贯</option>
<option value="shenfenzhenghao">身份证号</option>
<option value="jiuyequxiang">就业单位</option>
</select>
</label>
<span class="STYLE3">关键字:</span>
<input name="key" type="text" id="key" value="<%=key%>" size="15" />
<label>
<span class="STYLE3">
<input type="submit" name="Submit" value="查找">
</span> </label></td>
</tr>
</table>
</form>
<form name="form2" method="post" action="">
<div align="center">
<%if not rs.eof then%>
<span class="style4">共<%=rs.recordcount%>条记录,每页显示<%=rs.pagesize%>条 ，第<%=page%>/<%=rs.pagecount%>页
<%if page>1 then%>
<a href="admin_xy_ischeck.asp?Page=<% = 1%>&key=<%=key%>&ziduan=<%=ziduan%>">首页</a> <a href="admin_xy_ischeck.asp?Page=<% =page -1 %>&key=<%=key%>&ziduan=<%=ziduan%>">上一页</a>
<%end if %>
<%if page<>rs.pagecount then %>
<a href="admin_xy_ischeck.asp?Page=<% =page + 1%>&key=<%=key%>&ziduan=<%=ziduan%>">下一页</a> <a href="admin_xy_ischeck.asp?Page=<% = rs.PageCount%>&key=<%=key%>&ziduan=<%=ziduan%>">尾页</a></span>
<% end if %>
<select name="select" id="select2" onChange="javascript:window.location.href('admin_xy_ischeck.asp?page='+this.options[this.selectedIndex].value+'&key=<%=key%>&ziduan=<%=ziduan%>')">
<% for i=1 to rs.pagecount%>
<option value="<%=i%>" <%if i=page then response.Write("selected") end if%> ><%=i%> </option>
<% next%>
</select>
<a href="admin_xy_ischeck.asp" target="_self">浏览所有学员</a><br>
</div>
<TABLE width=99% border=1 align="center" cellPadding=0 cellSpacing=0
borderColorLight=#6699ff borderColorDark=#ffffff bgcolor="#FFFFFF" style="border-collapse:collapse">
<col width="166" />
<tr height="21">
<td width="6%" bgcolor="#FFCC99"><div align="center">
<input name="checkbox" type=checkbox id="checkbox" onClick="this.value=check(this.form.seltyid)" value="全选">
</div></td>
<td width="10%" bgcolor="#FFCC99"><div align="center"><span class="STYLE4">姓 名</span></div></td>
<td width="12%" bgcolor="#FFCC99"><div align="center"><span class="STYLE4">学号</span></div></td>
<td width="5%" bgcolor="#FFCC99"><div align="center"><span class="STYLE4">性别</span></div></td>
<td width="12%" bgcolor="#FFCC99"><div align="center"><span class="STYLE4">出生年月</span></div></td>
<td width="12%" bgcolor="#FFCC99"><div align="center"><span class="STYLE4">文化程度</span></div></td>
<td width="13%" bgcolor="#FFCC99"><div align="center" class="STYLE4">审核状态</div></td>
<td colspan="2" bgcolor="#FFCC99"><div align="center" class="STYLE4">
<div align="center">操作</div>
</div></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="22"><div align="center">
<input name="seltyid" type="checkbox" id="seltyid" value="<%=rs("id")%>">
</div></td>
<td><span class="STYLE3"><a href="xy_view_all.asp?ID=<%=rs("ID")%>" target="_self"><%=rs("xingming")%></a></span></td>
<td height="22"><div align="center"><%=rs("xuehao")%></div></td>
<td height="22"><%=rs("xingbie")%></td>
<td height="22"><div align="center"><span class="STYLE3"><%=rs("chushengnianyue")%></span></div></td>
<td><div align="center"><span class="STYLE3"><%=rs("wenhuachengdu")%></span></div></td>
<td><div align="center">
<%if rs("ischeck")="0" then
response.write"待审"
end if
if rs("ischeck")="1" then
response.write"审核通过"
end if
%></div></td>
<td width="6%" ><div align="center" class="STYLE3"><a href="xy_update.asp?ID=<%=rs("ID")%>" target="_self"><img src="images/edit.gif" alt="修改该学员的资料" width="16" height="16" border="0"></a> <a href="delete.asp?ID=<%=rs("ID")%>" target="_self"></a></div></td>
<td width="6%" ><a href="xy_delete_view_all.asp?ID=<%=rs("ID")%>" target="_self" onClick="return confirm('确认删除该学员吗？')"><img src="images/delete.gif" alt="删除该学员" width="18" height="18" border="0"></a></td>
</tr>
<%rs.movenext
count=count+1
loop
%>
<%end if%>
</table>
<div align="center">
<p>
<%end if%>
<span class="style4">共<%=rs.recordcount%>条记录,每页显示<%=rs.pagesize%>条 ，第<%=page%>/<%=rs.pagecount%>页
<%if page>1 then%>
<a href="admin_xy_ischeck.asp?Page=<% = 1%>"&key=<%=key%>&ziduan=<%=ziduan%>>首页</a> <a href="admin_xy_ischeck.asp?Page=<% =page -1 %>&key=<%=key%>&ziduan=<%=ziduan%>">上一页</a>
<%end if %>
<%if page<>rs.pagecount then %>
<a href="admin_xy_ischeck.asp?Page=<% =page + 1%>&key=<%=key%>&ziduan=<%=ziduan%>">下一页</a> <a href="admin_xy_ischeck.asp?Page=<% = rs.PageCount%>&key=<%=key%>&ziduan=<%=ziduan%>">尾页</a></span>
<% end if %>
<select name="select2" id="select" onChange="javascript:window.location.href('admin_xy_ischeck.asp?page='+this.options[this.selectedIndex].value+'&key=<%=key%>&ziduan=<%=ziduan%>')">
<% for i=1 to rs.pagecount%>
<option value="<%=i%>" <%if i=page then response.Write("selected") end if%> ><%=i%> </option>
<% next%>
</select>
<a href="admin_xy_ischeck.asp" target="_self">浏览所有学员</a></p>
<p align="center"><span class="STYLE13">全选/不选</span>
<input name="checkbox2" type=checkbox onClick="this.value=check(this.form.seltyid)" value="全选">
<input type="button" name="Submit2" value="所选学员通过审核" onClick="subjgregcheck()" style="width:115;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
<input type="button" name="Submit4" value="删除到回收站" onClick="subdeletetozhan()" style="width:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
<input type="button" name="Submit3" value="永久批量删除所选学员" onClick="subdeleteforever()" style="width:135;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
<input name="deleteorupdate" type="hidden" id="deleteorupdate">
<input name="deleteall" type="hidden" id="deleteall">
<input name="caozuo" type="hidden" id="caozuo">
</p>
</form>
<p style="color: #999999"> </p></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<script language="javascript">
//
function subdeleteforever()
{
if (window.confirm('真的要永久删除所选学员吗？该操作不可恢复！继续吗？'))
{
form2.action="xy_delete_all.asp";
form2.deleteall.value="deletforever";
form2.submit();//提交该表单;
}
}
function subjgregcheck()
{
form2.action="admin_xy_caozuo.asp";
form2.caozuo.value="check";
form2.submit();
}
function subdeletetozhan()
{
form2.action="admin_xy_caozuo.asp";
form2.caozuo.value="intozhan";
form2.submit();
}
</script>
<SCRIPT LANGUAGE="JavaScript">
<!--
var checkflag = "false";
function check(field) {
if (checkflag == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;}
checkflag = "true";
return "false"; }
else {
for (i = 0; i < field.length; i++) {
field[i].checked = false; }
checkflag = "false";
return "true"; }
}
-->
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -