?? searchreseasy.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")
key=trim(request("key"))
by=trim(request("by"))
set rs=server.createobject("adodb.recordset")
if key="" then
session("key")=key
sql="select * from jg where ischeck like 0 and isdeletetozhan = '否' "
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
else
session("key")=key
sql="select * from jg where ischeck like 0 and isdeletetozhan = '否' and "&ziduan&" 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
end if
rs.open sql,conn,1,2
%>
<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
}
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}
.style2 {color: #FF0000}
</STYLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
</head>
<body>
<form name="form1" action="searchreseasy.asp">
<table width="719" height="30" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D0FDF9">
<tr>
<td height="30" class="cssresult">
<div align="center" class="style1"> 關鍵字：
<input name="key" type="text" value="<%=session("key")%>" size="16">
按<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">所學專業(yè)</option>
<option value="renjiaobumen">任教初高中</option>
<option value="firstxueli">第一學歷</option>
<option value="lastxlgradufrom">第一學歷畢業(yè)學校</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="搜索">
<a href="searchprn.asp" class="style2">*高級搜索* </a>
<input type="submit" name="Submit222" value="更新顯示項目"></div> </td>
</tr>
</table>
<br>
<table width="98%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFE6E6" bgcolor="#FFCCCC">
<tr align="left" valign="middle" 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">
專業(yè) </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" 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">
第一學歷</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="plastxueli" type="checkbox" id="f_birthday43" value="on">
最后學歷 </span></td>
<td> <span class="style6" style="font-size: 12px">
<input name="pzhiwu" type="checkbox" id="f_birthday618" value="on">
職務 </span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pbianzhi" type="checkbox" id="pbianzhi" value="on">
編制 </span></td>
<td> <span class="style6" style="font-size: 12px">
<input name="pleibie" type="checkbox" id="pleibie" value="on">
編制類別</span></td>
</tr>
<tr align="left" valign="middle" class="cssresult">
<td><span class="style6" style="font-size: 12px">
<input name="prenshidaili" type="checkbox" id="prenshidaili3" value="on">
人事代理</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pshenfenzheng" type="checkbox" id="pshenfenzheng3" value="on" checked>
身份證號</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pemail" type="checkbox" id="pemail2" value="on">
電子信箱</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pphone" type="checkbox" id="pphone2" value="on" checked>
</span><span style="font-size: 12px">電話號碼</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pzhuzhi" type="checkbox" id="pzhuzhi2" value="on">
</span><span style="font-size: 12px">家庭住址 </span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pniankao" type="checkbox" id="pniankao3" value="on">
年度考核</span></td>
<td><span class="style6" style="font-size: 12px">
<input name="pgongzu" type="checkbox" id="pgongzu2" value="on">
</span><span style="font-size: 12px">工資情況</span></td>
<td> <span class="style6" style="font-size: 12px">
<input name="plunwen" type="checkbox" id="plunwen2" value="on">
發(fā)表論文 </span></td>
</tr>
</table>
</form><% if rs.eof and rs.bof then
response.write("沒有記錄")
response.end
end if %><table width="650" border="0" align="center">
<tr>
<td><form action="#" name="form5">
<div align="center">
<table width="775" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" style="font-size: 12px">
<table width="775" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" style="font-size: 12px">共<%=rs.recordcount%>條記錄</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
</form></td>
</tr>
</table>
<form name="form2" method="post" action="">
<table border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF">
<%
'第一行 'pname psex pbirthday pmianmao pzhuanye pzhicheng pxueke prenjiaobumen
psex=request("psex")
pbirthday=request("pbirthday")
pmianmao=request("pmianmao")
pzhuanye=request("pzhuanye")
pzhicheng=request("pzhicheng")
pxueke=request("pxueke")
prenjiaobumen=request("prenjiaobumen")
'第二行 pmingzu pjiguan phunyin pfirstxueli plastxueli pzhiwu pbainzhi pleibie
pmingzu=request("pmingzu")
pjiguan=request("pjiguan")
phunyin=request("phunyin")
pfirstxueli=request("pfirstxueli")
plastxueli=request("plastxueli")
pzhiwu=request("pzhiwu")
pbianzhi=request("pbianzhi")
pleibie=request("pleibie")
'第三行 ' prenshidaili pshenfenzheng pemail pphone pzhuzhi pniankao pgongzu plunwen
prenshidaili=request("prenshidaili")
pshenfenzheng=request("pshenfenzheng")
pemail=request("pemail")
pphone=request("pphone")
pzhuzhi=request("pzhuzhi")
pniankao=request("pniankao")
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -