📄 list_jg_setup.asp

📁 用C++编写的人事管理系统
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@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=trim(request("by"))
key=trim(request("key"))
set rs=server.createobject("adodb.recordset")
if key="" then 
sql="select * from jg where  ischeck like 0 and isdeletetozhan = '否'"
if by="" then
sql=sql & " Order by  name desc"
end if
if by<>"" then
Select case by
case ""
             sql=sql & " Order by  name asc"
       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"
		 case "birthdayasc"
             sql=sql & " Order by  birthday asc"
       case "birthdaydesc"
             sql=sql & " Order by birthday desc"
       End Select
end if
rs.open sql,conn,1,1
else
sql="select * from jg where  ischeck like 0 and isdeletetozhan = '否' and "&ziduan&" like '%"&key&"%' "
if by="" then
sql=sql & " Order by  name desc"
end if
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"
	   case "birthdayasc"
             sql=sql & " Order by  birthday asc"
       case "birthdaydesc"
             sql=sql & " Order by birthday desc"
       End Select
end if
rs.open sql,conn,1,1
end if
if rs.eof then
response.write"没有相关记录！"
response.end
end if
size=request.QueryString ("size")
if size="" then
rs.PageSize=20
end if
if size="all" then
rs.PageSize=rs.recordcount
end if
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-color: #537CA6;
}
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: 14px ; COLOR: #000000; TEXT-DECORATION: none
}
A:link {FONT-SIZE: 9pt; TEXT-DECORATION: none; color: #000000}
A:visited {FONT-SIZE: 9pt; TEXT-DECORATION: none; color: #FF0000 } 
A:active {FONT-SIZE: 9pt; color: #000000} 
A:hover {COLOR: #0000FF; 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
}
.style1 {color: #0000FF}
.style3 {color: #FF0000}
</STYLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<table width="99%"  border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#C5E0FA">
  <tr>
    <td><form name="form1" action="searchreseasy.asp">
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#33CCFF">
    <tr align="left" valign="middle" bordercolor="#FFFFFF" bgcolor="#C9E3FA" class="cssresult">
      <td height="41" colspan="8"><div align="center" class="style3">关键字：<b>                <input name="key" type="text" value="<%=key%>" size="20">
                </b>按<b> <font class="search">
  <select name="ziduan">
      <option value="name">姓名(更多选项）</option>
      <option value="login">登录名</option>
      <option value="sex">性别</option>
      <option value="shenfenzheng">身份证号</option>
      <option value="jiguan">籍贯</option>
      <option value="mianmao">政治面貌</option>
      <option value="xueke">任教学科</option>
      <option value="zhuanye">所学专业</option>
      <option value="renjiaobumen">任教初高中</option>
      <option value="firstxueli">第一学历</option>
      <option value="lastxlgradufrom">第一学历毕业学校</option>
      <option value="lastxueli">最高学历</option>
      <option value="zhicheng">职称</option>
      <option value="zhiwu">职务</option>
      <option value="bianzhi">编制情况</option>
      <option value="bianzhileibie">工人或干部编</option>
  </select>
                              </font></b>
              <input type="submit" name="Submit22" value="搜索" style="width:40;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
              <a href="searchprn.asp"> *高级搜索* </a>
              <input type="submit" name="Submit222" value="更新显示项目" style="width:85;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00">
      </div></td>
      </tr>
    <tr align="left" valign="middle" bordercolor="#FFFFFF" bgcolor="#C9E3FA" class="cssresult">
      <td><span class="style6" style="font-size: 12px">
        <input name="pname" type="checkbox" id="pname" value="on" checked>
      姓名</span></td>
      <td><div align="left" style="font-size: 12px"> <span class="style6">
          <input name="psex" type="checkbox" id="prn_sex2" value="on" checked>
      性别 </span></div></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pbirthday" type="checkbox" id="f_birthday83" value="on" checked>
      出生日期</span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pmianmao" type="checkbox" id="pmianmao2" value="on" checked>
      政治面貌</span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pzhuanye" type="checkbox" id="pzhuanye3" value="on">
      专业 </span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pzhicheng" type="checkbox" id="pzhicheng4" value="on" checked>
      职称 </span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pxueke" type="checkbox" id="pxueke" value="on" checked>
      任教学科</span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="prenjiaobumen" type="checkbox" id="f_birthday633" value="on">
      任教部门</span></td>
    </tr>
    <tr align="left" valign="middle" bordercolor="#FFFFFF" bgcolor="#C9E3FA" class="cssresult">
      <td><span class="style6" style="font-size: 12px">
        <input name="pmingzu" type="checkbox" id="pmingzu" value="on">
      民族</span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pjiguan" type="checkbox" id="pjiguan2" value="on" checked>
      </span><span style="font-size: 12px">籍贯</span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="phunyin" type="checkbox" id="phunyin2" value="on">
      婚否 </span></td>
      <td><span class="style6" style="font-size: 12px">
        <input name="pfirstxueli" type="checkbox" id="f_birthday623" value="on">
12 下一页
💿 文件大小 1315 K
👤 上传用户 zzxt
📂 所属分类企业管理
🏷️ 相关标签

#编写 #管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -