list.asp

这个系统是企业管理系统

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% Server.ScriptTimeout = 99999 %>

<% Response.Buffer =True  
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0  
Response.CacheControl = "no-cache"  
Response.AddHeader "Pragma", "No-Cache" %>
<!--#include file="Check_Sql123.asp" -->
<!--#include file="inc/Config_zd.asp"-->
<!--#include file="admin_qx.asp" -->
<%call islogin()
'call isqx_view_jb()

'************************************权限二次处理**********************************
if session("admv_jb")<>"" then 
btm_view_disp_all = "T" '查看按钮是否显示
end if
if session("admu_jb")<>"" then 
btm_upd_disp_all = "T"
end if
'**********************************************************************
%>

<!--#include file="conn_db123.asp" -->
<!--#include file="inc/Config_zd.asp"-->

<%
by=trim(request("by"))

s_listfield=trim(request("s_listfield"))

fieldclose=trim(request("fieldclose")) '显示项目开关
xlsclose=trim(request("xlsclose")) '显示项目开关
tiaojianclose=trim(request("tiaojianclose")) '显示项目开关

if fieldclose<>""then
session("fieldclose")=fieldclose
else
if session("fieldclose")=""then
session("fieldclose")="openlist"'默认打开
end if
end if

if xlsclose<>""then
session("xlsclose")=xlsclose
else
if session("xlsclose")=""then
session("xlsclose")="openlist"
end if
end if


if tiaojianclose<>""then
session("tiaojianclose")=tiaojianclose
else
if session("tiaojianclose")=""then
session("tiaojianclose")="openlist"
end if
end if

if listfield<>""then
session("listfield")=listfield
else
if session("listfield")="" or  s_listfield="none"then
session("listfield")="姓名|xingming,所在部门|bumen,学科|xueke,性别|xingbie,出生日期|chushengsj,在职状态|zaizhizhuangtai,第一学历|xueli1,最高学历|xueli2"

end if
end if

issearch=request("issearch")

if issearch="search" then

xingming=trim(request("xingming"))
xingbie=trim(request("xingbie"))
hunyinzhuangkuang=trim(request("hunyinzhuangkuang"))
zhengzhimianmao=trim(request("zhengzhimianmao"))
xueli1=trim(request("xueli1"))
xueli2=trim(request("xueli2"))
bumen=trim(request("bumen"))
xueke=trim(request("xueke"))
zaizhizhuangtai=trim(request("zaizhizhuangtai"))
bianzhi=trim(request("bianzhi"))
shenfenzhenghao=trim(request("shenfenzhenghao"))
xingzhengzhiwu=trim(request("xingzhengzhiwu"))

zhicheng=trim(request("zhicheng"))
zhicheng_xianpin=trim(request("zhicheng_xianpin"))
bianzhileibie=trim(request("bianzhileibie"))
renshidaili=trim(request("renshidaili"))
jiaoshizhenghao=trim(request("jiaoshizhenghao"))

chushengsj1=trim(request("chushengsj1"))
chushengsj2=trim(request("chushengsj2"))
nianling1=trim(request("nianling1"))
nianling2=trim(request("nianling2"))
canjiagongzuosj1=trim(request("canjiagongzuosj1"))
canjiagongzuosj2=trim(request("canjiagongzuosj2"))
jinxiaosj1=trim(request("jinxiaosj1"))
jinxiaosj2=trim(request("jinxiaosj2"))
lurudate1=trim(request("lurudate1"))
lurudate2=trim(request("lurudate2"))
luruname=trim(request("luruname"))
'sql="select * from mainjg  where  ispasscheck_add='T' and  ispasscheck_upd='T' and  isinrecycle='F' and id like '%'"

 
   'sql="select * from mainjg  where bumen_big='"&session("admin_bumen_big")&"' and  bumen_small like '"&session("admin_bumen_small_this")&"' and id like '%'"

sql="select * from mainjg  where  ischeck='passcheck' and id like '%'"

search_condition=""


if xingming<>"" then
sql=sql & " and xingming like '%" & xingming & "%'"
sc=sc&"姓名:"&xingming&"｜"
search_condition=search_condition&"&xingming="&xingming
end if

if xingbie<>"" then
sql=sql & " and xingbie ='" & xingbie & "'"
sc=sc&"性别:"&xingbie&"｜"
search_condition=search_condition&"&xingbie="&xingbie
end if

if hunyinzhuangkuang<>"" then
sql=sql & " and hunyinzhuangkuang = '" & hunyinzhuangkuang & "'"
sc=sc&"婚姻状况:"&hunyinzhuangkuang&"｜"
search_condition=search_condition&"&hunyinzhuangkuang="&hunyinzhuangkuang
end if
if zhengzhimianmao<>"" then
sql=sql & " and zhengzhimianmao = '" & zhengzhimianmao & "'"
sc=sc&"政治面貌:"&zhengzhimianmao&"｜"
search_condition=search_condition&"&zhengzhimianmao="&zhengzhimianmao
end if

if xueli2<>"" then
sql=sql & " and xueli2 = '" & xueli2 & "'"
sc=sc&"最高学历:"&xueli2&"｜"
search_condition=search_condition&"&xueli2="&xueli2
end if

if xueli1<>"" then
sql=sql & " and xueli1 = '" & xueli1 & "'"
sc=sc&"第一学历:"&xueli1&"｜"
search_condition=search_condition&"&xueli1="&xueli1
end if

if bumen<>"" then
sql=sql & " and bumen ='" & bumen & "'"
sc=sc&"部门:"&bumen&"｜"
search_condition=search_condition&"&bumen="&bumen
end if

if xueke<>"" then
sql=sql & " and xueke = '" & xueke & "'"
sc=sc&"任教学科:"&xueke&"｜"
search_condition=search_condition&"&xueke="&xueke
end if

if zaizhizhuangtai<>"" then
sql=sql & " and zaizhizhuangtai = '" & zaizhizhuangtai & "'"
sc=sc&"在职状态:"&zaizhizhuangtai&"｜"
search_condition=search_condition&"&zaizhizhuangtai="&zaizhizhuangtai
end if

if bianzhi<>"" then
sql=sql & " and bianzhi = '" & bianzhi & "'"
sc=sc&"编制情况:"&bianzhi&"｜"
search_condition=search_condition&"&bianzhi="&bianzhi
end if

if shenfenzhenghao<>"" then
sql=sql & " and shenfenzhenghao like '%" & shenfenzhenghao & "%'"
sc=sc&"身份证号:"&shenfenzhenghao&"｜"
search_condition=search_condition&"&shenfenzhenghao="&shenfenzhenghao
end if


if xingzhengzhiwu<>"" then
sql=sql & " and xingzhengzhiwu = '" & xingzhengzhiwu & "'"
sc=sc&"行政职务:"&xingzhengzhiwu&"｜"
search_condition=search_condition&"&xingzhengzhiwu="&xingzhengzhiwu
end if

if zhicheng<>"" then
sql=sql & " and zhicheng = '" & zhicheng & "'"
sc=sc&"最高职称:"&zhicheng&"｜"
search_condition=search_condition&"&zhicheng="&zhicheng
end if

if zhicheng_xianpin<>"" then
sql=sql & " and zhicheng_xianpin = '" & zhicheng_xianpin & "'"
sc=sc&"现聘职称:"&zhicheng_xianpin&"｜"
search_condition=search_condition&"&zhicheng_xianpin="&zhicheng_xianpin
end if

if bianzhileibie<>"" then
sql=sql & " and bianzhileibie = '" & bianzhileibie & "'"
sc=sc&"编制类别:"&bianzhileibie&"｜"
search_condition=search_condition&"&bianzhileibie="&bianzhileibie
end if

if renshidaili<>"" then
sql=sql & " and renshidaili = '" & renshidaili & "'"
sc=sc&"是否人事代理:"&renshidaili&"｜"
search_condition=search_condition&"&renshidaili="&renshidaili
end if

if jiaoshizhenghao<>"" then