list.asp

这个系统是企业管理系统

sql=sql & " and jiaoshizhenghao like '%" & jiaoshizhenghao & "%'"
sc=sc&"教师证号:"&jiaoshizhenghao&"｜"
search_condition=search_condition&"&jiaoshizhenghao="&jiaoshizhenghao
end if

if luruname<>"" then
sql=sql & " and luruname like '%" & luruname & "%'"
sc=sc&"录入人:"&luruname&"｜"
search_condition=search_condition&"&luruname="&luruname
end if

if isdate(chushengsj1) and isdate(chushengsj2) then
if chushengsj1>chushengsj2 then
response.write "<script language=JavaScript>{window.alert('报错：“出生日期”范围(“"&chushengsj1&"”到“"&chushengsj2&"”) 前者不能大于后者，只能小于或等于后者。如前者等于后者则查询该月范围里的。请按“确定”返回!');window.history.go(-1);}</script>"
	response.end
else
	sql=sql & " and chushengsj <> null and  (cdate(chushengsj) between #" & chushengsj1 & "# and #" & chushengsj2 & "#)"
sc=sc&"出生时间段:"&chushengsj1&"到"&chushengsj2&"｜"
	end if
	search_condition=search_condition&"&chushengsj1="&chushengsj1&"&chushengsj2="&chushengsj2

end if

if isnumeric(nianling1) and isnumeric(nianling2) then
if cint(nianling1)<=cint(nianling2) then
sql=sql & " and chushengsj<>null and (DateDiff(""yyyy"",chushengsj,date()) between "&nianling1&" and "&nianling2&")"
sc=sc&"年龄段为:"&nianling1&"到"&nianling2&"｜"
end if
	search_condition=search_condition&"&nianling1="&nianling1&"&nianling2="&nianling2

end if

if isdate(lurudate1) and isdate(lurudate2) then
if lurudate1>lurudate2 then
response.write "<script language=JavaScript>{window.alert('报错：“录入时间”范围(“"&lurudate1&"”到“"&lurudate2&"”) 前者不能大于后者，只能小于或等于后者。如前者等于后者则查询该月范围里的。请按“确定”返回!');window.history.go(-1);}</script>"
	response.end
else
	sql=sql & " and lurudate <> null and  (cdate(lurudate) between #" & lurudate1 & "# and #" & lurudate2 & "#)"
sc=sc&"录入时间:"&lurudate1&"到"&lurudate2&"｜"
	end if
				search_condition=search_condition&"&lurudate1="&lurudate1&"&lurudate2="&lurudate2

end if


if isdate(canjiagongzuosj1) and isdate(canjiagongzuosj2) then
if canjiagongzuosj1>canjiagongzuosj2 then
response.write "<script language=JavaScript>{window.alert('报错：“参加工作时间”范围(“"&canjiagongzuosj1&"”到“"&canjiagongzuosj2&"”) 前者不能大于后者，只能小于或等于后者。如前者等于后者则查询该月范围里的。请按“确定”返回!');window.history.go(-1);}</script>"

	response.end
else
	sql=sql & " and canjiagongzuosj <> null and  (cdate(canjiagongzuosj) between #" & canjiagongzuosj1 & "# and #" & canjiagongzuosj2 & "#)"
sc=sc&"参加工作时间:"&canjiagongzuosj1&"到"&canjiagongzuosj2&"｜"
	end if
	search_condition=search_condition&"&canjiagongzuosj1="&canjiagongzuosj1&"&canjiagongzuosj2="&canjiagongzuosj2

end if

if isdate(jinxiaosj1) and isdate(jinxiaosj2) then
if jinxiaosj1>jinxiaosj2 then
response.write "<script language=JavaScript>{window.alert('报错：“进校时间”范围(“"&jinxiaosj1&"”到“"&jinxiaosj2&"”) 前者不能大于后者，只能小于或等于后者。如前者等于后者则查询该月范围里的。请按“确定”返回!');window.history.go(-1);}</script>"
	response.end
else
	sql=sql & " and jinxiaosj <> null and  (cdate(jinxiaosj) between #" & jinxiaosj1 & "# and #" & jinxiaosj2 & "#)"
sc=sc&"进校时间:"&jinxiaosj1&"到"&jinxiaosj2&"｜"
	end if
	search_condition=search_condition&"&jinxiaosj1="&jinxiaosj1&"&jinxiaosj2="&jinxiaosj2

end if

'if isnumeric(baomingriqi1) and isnumeric(baomingriqi2) then
'if cint(baomingriqi1)<=cint(baomingriqi2) then
'sql=sql & " and baomingriqi between "&baomingriqi1&" and "&peixuncishu2&" "
'sc=sc&"培训次数段:"&baomingriqi1&"到"&peixuncishu2&"｜"
'end if
'end if

'----------------

else

sql="select * from mainjg  where   ischeck='passcheck'  "

'----------------

end if

set rs=server.CreateObject("adodb.recordset")

if by="" then
sql=sql & " Order by  id desc"
end if

if by<>"" then
		
Select case by
	'---------------------------------------------	
    	'case "xbjnian_du|asc"
           '  sql=sql & " Order by  xbjnian_du asc , xbjnianji asc, xbjbanji asc,xbjxuehao asc"
      ' case "xbjnian_du|desc"
            ' sql=sql & " Order by  xbjnian_du desc , xbjnianji asc, xbjbanji asc,xbjxuehao asc"
      ' case "xbjnianji|asc"
            ' sql=sql & " Order by   xbjnian_du desc , xbjnianji asc, xbjbanji asc,xbjxuehao asc"
     '  case "xbjnianji|desc"
            ' sql=sql & " Order by   xbjnian_du desc , xbjnianji desc, xbjbanji asc,xbjxuehao asc"
	  
       End Select
	   	'---------------------------------------------	
	'if by<>"xbjnian_du|asc" and  by<>"xbjnian_du|desc"  and  by<>"xbjnianji|asc" and  by<>"xbjnianji|desc" then
	
 by_dongtai=split(by,"|")
sql=sql & " Order by "&by_dongtai(0)&" "&by_dongtai(1)	
'end if
 '---------------------
end if

rs.open sql,conn,1,2

'-------

if not rs.eof then
'-------
selectidtoview=""
 do while not rs.eof
selectidtoview=selectidtoview&rs("id")&" "
rs.movenext
loop
session("selectid")=trim(selectidtoview)
rs.movefirst '因为上面do loop已经到最后一条记录了
'-------
PageSize=trim(request("pageSize"))
if PageSize<>""then
session("pageSize")=PageSize
pz=PageSize
end if
if PageSize=""then
 if session("pageSize")<>""then
 pz=session("pageSize")
 else
 pz=20
 end if
 end if
 
rs.PageSize=pz
pagecount=rs.PageCount 
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then page=1
rs.AbsolutePage=page
end if
'-------
%>



<html>
<head>
<script language="JavaScript" src="otherfile/dateinput.js"></script>
<script language="JavaScript" src="otherfile/shengshixian123.js"></script>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="Images/Style.css" rel="stylesheet" type="text/css">
<title>管理</title>
<style type="text/css">
<!--
.style3 {color: #FF0000}
.style1 {color: #0000FF}
body {
	BACKGROUND: #39867b;
	MARGIN: 0px;
	FONT: 9pt 宋体;
	TEXT-DECORATION: none;
	margin-left: 2px;
	margin-top: 2px;
	margin-right: 2px;
	margin-bottom: 4px;
	background-color: #F1F4FC;
	
	 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;
}
.STYLE4 {color: #FFFFFF}
.STYLE5 {color: #000000}
body,td,th {
	font-size: 12px;
	color: #000000;
}
.mycolor:link {
	text-decoration: none;
}
.mycolor:visited {
	text-decoration: none;
	color: #E85C00;
}
.mycolor:hover {
	text-decoration: underline;
	color: #339900;
}
.mycolor:active {
	text-decoration: none;
	color: #339900;
}
.STYLE13 {color: #0000FF; font-size: 14px; }
.STYLE4 {font-size: 12px; color: #000000; }
.STYLE19 {font-size: 12px; color: #FF0000; }
.STYLE20 {color: #FF3300}