bmxqfx.asp

原代码学生信息管理系统（原代码）不够的的话我给原程序 QQ3810091

<%@ language=vbscript %>
<!--#include file="conn.asp"-->
<%  



  if Session.Contents("gws")=true or Session.Contents("gws1")=true then
  
jlh=request("jlh")
s= request("s")
mc=request("mc")

if s="" then	
		response.write"<script language='javascript'>" 
		 response.write"alert('你没有输入部门名称！');" 
		 response.write"history.go(-1);"
		 response.write"</script>" 
		 response.end
end if

  dim rs,rs1,rs2
 dim sql,sql1,sql2,mzxs
  set rs=server.createobject("adodb.recordset")
  set rs1=server.createobject("adodb.recordset")
  
  
  
 sql1="select * from zybjmc where s='" + s + "'"

 rs1.open sql1,conn,3,3

  
if jlh="" then jlh=0
if mc="" then mc=1

if mc="1" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs10+fs11+fs12+fs13+fs14+fs15+fs16+fs17+fs18+fs19+fs110+fs111+fs112+fs113+fs114+fs115+fs116+fs117+fs118+fs119 desc"
  rs.open sql,conn,3,3 
elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs10 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs10")
  mzxs1="fs10"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs11 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs11")
  mzxs1="fs11"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs12 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs12")
  mzxs1="fs12"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs13 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs13")
  mzxs1="fs13"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs14 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs14")
  mzxs1="fs14"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs15 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs15")
  mzxs1="fs15"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs16 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs16")
  mzxs1="fs16"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs17 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs17")
  mzxs1="fs17"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs18 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs18")
  mzxs1="fs18"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs19 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs19")
  mzxs1="fs19"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs110 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs110")
  mzxs1="fs110"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs111 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs111")
  mzxs1="fs111"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs112 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs112")
  mzxs1="fs112"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs113 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs113")
  mzxs1="fs113"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs114 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs114")
  mzxs1="fs114"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs115 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs115")
  mzxs1="fs115"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs116 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs116")
  mzxs1="fs116"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs117 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs117")
  mzxs1="fs117"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs118 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs118")
  mzxs1="fs118"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs119 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs119")
  mzxs1="fs119"


end if 
end if
if mc="2" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs20+fs21+fs22+fs23+fs24+fs25+fs26+fs27+fs28+fs29+fs120+fs121+fs122+fs123+fs124+fs125+fs126+fs127+fs128+fs129 desc"
  rs.open sql,conn,3,3  

elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs20 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs20")
   mzxs1="fs20"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs21 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs21")
   mzxs1="fs21"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs22 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs22")
   mzxs1="fs22"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs23 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs23")
   mzxs1="fs23"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs24 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs24")
   mzxs1="fs24"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs25 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs25")
   mzxs1="fs25"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs26 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs26")
   mzxs1="fs26"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs27 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs27")
   mzxs1="fs27"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs28 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs28")
   mzxs1="fs28"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs29 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs29")
   mzxs1="fs29"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs120 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs120")
   mzxs1="fs120"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs121 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs121")
   mzxs1="fs121"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs122 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs122")
   mzxs1="fs122"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs123 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs123")
   mzxs1="fs123"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs124 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs124")
   mzxs1="fs124"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs125 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs125")
   mzxs1="fs125"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs126 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs126")
   mzxs1="fs126"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs127 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs127")
   mzxs1="fs127"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs128 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs128")
   mzxs1="fs128"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs129 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs129")
   mzxs1="fs129"

end if 
end if
if mc="3" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs30+fs31+fs32+fs33+fs34+fs35+fs36+fs37+fs38+fs39+fs130+fs131+fs132+fs133+fs134+fs135+fs136+fs137+fs138+fs139 desc"
  rs.open sql,conn,3,3  

elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs30 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs30")
    mzxs1="fs30"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs31 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs31")
    mzxs1="fs31"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs32 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs32")
    mzxs1="fs32"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs33 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs33")
    mzxs1="fs33"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs34 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs34")
    mzxs1="fs34"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs35 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs35")
    mzxs1="fs35"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs36 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs36")
    mzxs1="fs36"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs37 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs37")
    mzxs1="fs37"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs38 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs38")
    mzxs1="fs38"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs39 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs39")
    mzxs1="fs39"


elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs130 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs130")
    mzxs1="fs130"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs131 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs131")
    mzxs1="fs131"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs132 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs132")
    mzxs1="fs132"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs133 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs133")
    mzxs1="fs133"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs134 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs134")
    mzxs1="fs134"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs135 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs135")
    mzxs1="fs135"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs136 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs136")
    mzxs1="fs136"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs137 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs137")
    mzxs1="fs137"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs138 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs138")
    mzxs1="fs138"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs139 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs139")
    mzxs1="fs139"


end if 

end if
if mc="4" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs40+fs41+fs42+fs43+fs44+fs45+fs46+fs47+fs48+fs49+fs140+fs141+fs142+fs143+fs144+fs145+fs146+fs147+fs148+fs149 desc"
  rs.open sql,conn,3,3  

elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs40 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs40")
     mzxs1="fs40"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs41 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs41")
     mzxs1="fs41"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs42 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs42")
     mzxs1="fs42"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs43 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs43")
     mzxs1="fs43"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs44 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs44")
     mzxs1="fs44"

elseif jlh=6 then
sql="select * from cxb where s like '%"&s&"%' Order by fs45 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs45")
     mzxs1="fs45"

elseif jlh=7 then
sql="select * from cxb where s like '%"&s&"%' Order by fs46 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs46")
     mzxs1="fs46"

elseif jlh=8 then
sql="select * from cxb where s like '%"&s&"%' Order by fs47 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs47")
     mzxs1="fs47"

elseif jlh=9 then
sql="select * from cxb where s like '%"&s&"%' Order by fs48 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs48")
     mzxs1="fs48"

elseif jlh=10 then
sql="select * from cxb where s like '%"&s&"%' Order by fs49 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs49")
     mzxs1="fs49"

elseif jlh=11 then
sql="select * from cxb where s like '%"&s&"%' Order by fs140 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs140")
     mzxs1="fs140"

elseif jlh=12 then
sql="select * from cxb where s like '%"&s&"%' Order by fs141 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs141")
     mzxs1="fs141"

elseif jlh=13 then
sql="select * from cxb where s like '%"&s&"%' Order by fs142 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs142")
     mzxs1="fs142"

elseif jlh=14 then
sql="select * from cxb where s like '%"&s&"%' Order by fs143 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs143")
     mzxs1="fs143"

elseif jlh=15 then
sql="select * from cxb where s like '%"&s&"%' Order by fs144 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs144")
     mzxs1="fs144"

elseif jlh=16 then
sql="select * from cxb where s like '%"&s&"%' Order by fs145 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs145")
     mzxs1="fs145"

elseif jlh=17 then
sql="select * from cxb where s like '%"&s&"%' Order by fs146 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs146")
     mzxs1="fs146"

elseif jlh=18 then
sql="select * from cxb where s like '%"&s&"%' Order by fs147 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs147")
     mzxs1="fs147"

elseif jlh=19 then
sql="select * from cxb where s like '%"&s&"%' Order by fs148 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs148")
     mzxs1="fs148"

elseif jlh=20 then
sql="select * from cxb where s like '%"&s&"%' Order by fs149 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs149")
     mzxs1="fs149"


end if 


end if
if mc="5" then
 if jlh=0 then
 sql="select * from cxb where s like '%"&s&"%' Order by fs50+fs51+fs52+fs53+fs54+fs55+fs56+fs57+fs58+fs59+fs150+fs151+fs152+fs153+fs154+fs155+fs156+fs157+fs158+fs159 desc"
  rs.open sql,conn,3,3 
 
elseif jlh=1 then
sql="select * from cxb where s like '%"&s&"%' Order by fs50 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs50")
    mzxs1="fs50"

elseif jlh=2 then
sql="select * from cxb where s like '%"&s&"%' Order by fs51 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs51")
  mzxs1="fs51"

elseif jlh=3 then
sql="select * from cxb where s like '%"&s&"%' Order by fs52 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs52")
  mzxs1="fs52"

elseif jlh=4 then
sql="select * from cxb where s like '%"&s&"%' Order by fs53 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs53")
  mzxs1="fs53"

elseif jlh=5 then
sql="select * from cxb where s like '%"&s&"%' Order by fs54 desc"
 rs.open sql,conn,3,3
 mzxs=rs1("fs54")
  mzxs1="fs54"

elseif jlh=6 then