📄 list_jg_setup_updquan.asp

📁 轻燕工作室中学人事管理系统最新的V5.0版本！
💻 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.asp" -->

<%
if session("admin_id")=""then
 	response.write "<script language=JavaScript>{window.alert('对不起，您尚未登录或登录超时!');window.location.href='index.asp';}</script>"
  response.end 
  end if
  %>
<% 
ziduan=request("ziduan")
by=request("by")
key=request("key")
set rs=server.createobject("adodb.recordset")
if key="" then 
sql="select * from jg where  ischeck = '0 'and isdeletetozhan = '否'and isupdate= '是'"
if by<>"" then
Select case by
       case "nameasc"
             sql=sql & " Order by  name asc"
       case "namedesc"
             sql=sql & " Order by name desc"
	   case "sexasc"
             sql=sql & " Order by  sex asc"
       case "sexdesc"
             sql=sql & " Order by sex desc"
       End Select
end if
rs.open sql,conn,1,2

else
sql="select * from jg where  name like '%"&key&"%' and ischeck ='0' and isdeletetozhan = '否' and isupdate= '是' and  name like '%"&key&"%' "
if by<>"" then
Select case by
       case "nameasc"
             sql=sql & " Order by  name asc"
       case "namedesc"
             sql=sql & " Order by name desc"
	   case "sexasc"
             sql=sql & " Order by  sex asc"
       case "sexdesc"
             sql=sql & " Order by sex desc"
       End Select
end if
rs.open sql,conn,1,2
end if
if rs.eof and rs.bof then
  response.write("没找到记录，或者记录被删除到回收站中，或者没有通过审核")
  response.end
  end if 
rs.PageSize=20
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>
<head>
<STYLE type=text/css>
BODY {
	SCROLLBAR-FACE-COLOR: #c6ebde;
	MARGIN: 0px;
	FONT: 9pt 宋体;
	SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
	SCROLLBAR-SHADOW-COLOR: #39867b;
	SCROLLBAR-3DLIGHT-COLOR: #39867b;
	SCROLLBAR-ARROW-COLOR: #330000;
	SCROLLBAR-TRACK-COLOR: #e2f3f1;
	SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
	TEXT-DECORATION: none;
	background-image: url(images/bg/bg2.gif);
}
TABLE {
	BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
TD {
	FONT: 13px 宋体
}
IMG {
	BORDER-RIGHT: 0px; BORDER-TOP: 0px; VERTICAL-ALIGN: bottom; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
A {
	FONT: 12px 宋体; COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
	COLOR: #cc0000; TEXT-DECORATION: underline
}
.sec_menu {
	BORDER-RIGHT: white 1px solid; BACKGROUND: #c6ebde; OVERFLOW: hidden; BORDER-LEFT: white 1px solid; BORDER-BOTTOM: white 1px solid
}
.menu_title {
	
}
.menu_title SPAN {
	FONT-WEIGHT: bold; LEFT: 8px; COLOR: #39867b; POSITION: relative; TOP: 2px
}
.menu_title2 {
	
}
.menu_title2 SPAN {
	FONT-WEIGHT: bold; LEFT: 8px; COLOR: #cc0000; POSITION: relative; TOP: 2px
}

INPUT{BORDER-TOP-WIDTH: 1px; PADDING-RIGHT: 1px; PADDING-LEFT: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 9pt; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM-WIDTH: 1px; BORDER-BOTTOM-COLOR: #cccccc; PADDING-BOTTOM: 1px; BORDER-TOP-COLOR: #cccccc; PADDING-TOP: 1px; HEIGHT: 18px; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #cccccc}
select {border-width: 1; border-color: #000000; background-color: #ffffff; font-family: 宋体; font-size: 9pt; font-style: bold;}
OPTION {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
.style1 {
	color: #000000;
	font-weight: bold;
}
</STYLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<form name="form1" action="#">
  <table width="700" height="30" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFCC99">
    <tr>
      <td height="30" class="cssresult">
        <div align="center"><b><font color="#0000FF">
          </font></b>
            
      </div>        
        <div align="center"><font color="#0000FF">关键字：<b>          <input name="key" type="text" value="<%=key%>" size="20">
        </b></font> 　
      <input type="submit" name="Submit22" value="按姓名搜索"style="width:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00"></div>        </td>
    </tr>
  </table>
</form>
<form name="form2" method="post" action="">

<table width="99%" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#FAFAFA">
  <tr align="center" bgcolor="FF9393" class="cssresult" background="images/bg/bg7.jpg">
    <td width="54"><div align="center">全<input name="checkbox" type=checkbox id="checkbox" onClick="this.value=check(this.form.seljgid)" value="全选">选</div></td>
   
    <td width="91"><div align="center"><span class="style6">姓名</span></div></td>
    <td width="38"><div align="center"><span class="style6">性别</span></div></td>
    <td width="89"><div align="center"><span class="style6">出生</span></div></td>
    <td width="78"><div align="center"><span class="style6">政治面貌</span></div></td>
    <td width="73"><div align="center"><span class="style6">最后学历</span></div></td>
    <td width="70"><div align="center"><span class="style6">第一学历</span></div></td>
    <td width="74"><div align="center"><span class="style6">学科</span></div></td>
    <td width="80"><div align="center"><span class="style6">职称</span></div></td>
	 <td width="60"><div align="center">允许修改</div></td>
    </tr>
 <%count=0
do while not rs.eof and count<rs.pagesize  %>
   <%if count Mod 2=0 then%>
  <tr bgcolor="#FFE8E8">
  <%else%>
   <tr bgcolor="#FFCCCC">
     <%end if%>

    <td height="27">
      <div align="center">
        <input name="seljgid" type="checkbox" id="seljgid" value="<%=rs("id")%>">
      </div></td>
   
    <td><div align="center"><a href="admin_jgdetial.asp?id=<%=rs("id")%>"><u><%=rs("name")%></u></a></div></td>
    <td><div align="center"><%=rs("sex")%></div></td>
    <td><div align="center"><%=rs("birthday")%></div></td>
    <td ><div align="center"><%=rs("mianmao")%></div></td>
    <td ><div align="center"><%=rs("lastxueli")%></div></td>
    <td><div align="center"><%=rs("firstxueli")%></div></td>
    <td ><div align="center"><%=rs("xueke")%></div></td>
    <td><div align="center"><%=rs("zhicheng")%></div></td>
	 <td><div align="center"><%=rs("isupdate")%></div></td>    
    </tr>
  <% count=count+1
  rs.movenext
loop %>
</table>
    <div align="center"><p><input name="deleteorupdate" type="hidden" id="deleteorupdate">
</p>
      <table width="775" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><div align="center" style="font-size: 12px">共<%=rs.recordcount%>条记录,每页显示<%=rs.pagesize%>条
            ，第<%=page%>/<%=rs.pagecount%>页&nbsp;
			<%if page>1 then%><a Href="list_jg_setup_updquan.asp?Page=<% = 1%>">首页</a> <a Href="list_jg_setup_updquan.asp?Page=<% =page -1 %>">上一页</a><%end if %><%if page<>rs.pagecount then %><a Href="list_jg_setup_updquan.asp?Page=<% =page + 1%>">下一页</a> <a Href="list_jg_setup_updquan.asp?Page=<% = rs.PageCount%>">尾页</a> <% end if %>
               <select name="page" id="page" onChange="javascript:window.location.href('list_jg_setup_updquan.asp?page='+this.options[this.selectedIndex].value+'')">
                 <% for i=1 to rs.pagecount%>
                 <option value="<%=i%>" <%if i=page then response.Write("selected") end if%> ><%=i%> </option>
                 <% next%>
               </select>
          </div></td>
        </tr>
      </table>
      <p><br>
    全选/不选
      <input name="checkbox" type=checkbox onClick="this.value=check(this.form.seljgid)" value="全选">
      <input type="button" name="Submit" 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:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">　
      <input type="button" name="Submit2" value="设定修改权" onClick="subupdate()"style="width:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">　
      <input type="button" name="Submit23" value="限制修改" onClick="subupdateno()"style="width:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
  </p>
  </div>
</form>
<p>&nbsp;</p>
</body>
</html>

  <script language="javascript">
//
function subdeletetozhan()
{
form2.action="jgsetup_delupd.asp"; 
form2.deleteorupdate.value="deletetozhan";
form2.submit();
}
//
function subdeleteforever()
{
    if (window.confirm('真的要永久删除所选教工吗？该操作不可恢复！继续吗？'))
     {
	  form2.action="jgsetup_delupd.asp";
	  form2.deleteorupdate.value="deletforever";
       form2.submit();//提交该表单; 
     }
    else
     {
       return;//取消提交表单操作
     }
}
//
function subupdate()
{
form2.action="jgsetup_delupd.asp"; 
form2.deleteorupdate.value="update";
form2.submit();
}
//
function subupdateno()
{
form2.action="jgsetup_delupd.asp"; 
form2.deleteorupdate.value="updateno";
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 + -