admin_xy_caozuo.asp

培训学员管理系统

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% issjcz %>
<%  
selxyid=trim(Request.Form("seltyid")) 
caozuo=Request.Form("caozuo")
deleteorcheck=Request.Form("caozuo") 
if caozuo="check" then
  if selxyid<>"" then
       selxyid=split(selxyid,",")
	set rs=server.createobject("adodb.recordset")
       for i=0 to ubound(selxyid)
		        sql="select * from jlzd321 where id=" & selxyid(i)
				 rs.open sql,conn,1,2
				 if rs.eof then
 	response.write "<script language=JavaScript>{window.alert('??????????,??“??”???“??”??!');window.history.go(-1);}</script>"
  response.end
   end if
				 rs("ischeck")="1"
				 rs.update
				 rs.close
				next
				response.write "<script language=JavaScript>{window.alert('ÉóºË³É¹¦¡¡!');window.location.href='admin_xy_ischeck.asp';}</script>"
  end if 
 end if
 
 if caozuo="outzhan" then
  if selxyid<>"" then
       selxyid=split(selxyid,",")
	set rs=server.createobject("adodb.recordset")
       for i=0 to ubound(selxyid)
		        sql="select * from jlzd321 where id=" & selxyid(i)
				 rs.open sql,conn,1,2
				 if rs.eof then
 	response.write "<script language=JavaScript>{window.alert('ËùÑ¡¼Ç¼ÖÐÓв»´æÔÚ»òÒѱ»É¾³ýµÄ¼Ç¼£¬Çë°´¡°È·¶¨¡±·µ»Øºó¡°Ë¢Ð¡±Ò³Ãæ!');window.history.go(-1);}</script>"
  response.end
   end if
				 rs("isrecycle")="0"
				 rs.update
				 rs.close
				next
				response.write "<script language=JavaScript>{window.alert('³É¹¦½«ËüÃÇ´Ó»ØÊÕÕ¾Öлָ´µ½ÕýʽѧԱ¡¡!');window.location.href='admin_xy_isrecycle.asp';}</script>"
  end if 
 end if
 
 if caozuo="intozhan" then
  if selxyid<>"" then
       selxyid=split(selxyid,",")
	set rs=server.createobject("adodb.recordset")
       for i=0 to ubound(selxyid)
		        sql="select * from jlzd321 where id=" & selxyid(i)
				 rs.open sql,conn,1,2
				 if rs.eof then
 	response.write "<script language=JavaScript>{window.alert('ËùÑ¡¼Ç¼ÖÐÓв»´æÔÚ»òÒѱ»É¾³ýµÄ¼Ç¼£¬Çë°´¡°È·¶¨¡±·µ»Øºó¡°Ë¢Ð¡±Ò³Ãæ!');window.history.go(-1);}</script>"
  response.end
   end if
				 rs("isrecycle")="1"
				 rs.update
				 rs.close
				next
				response.write "<script language=JavaScript>{window.alert('³É¹¦½«ËüÃÇɾ³ýµ½»ØÊÕÕ¾£¬ÈçÓÐÐèÒª£¬Äú¿ÉÒÔͨ¹ý¡°»ØÊÕÕ¾¹ÜÀí¡±²Ëµ¥À´»Ö¸´ËûÃÇÕýʽѧԱµÄÉí·Ý¡¡!');window.history.go(-1);}</script>"
  end if 
 end if
 
 
 if deleteorcheck="delforever" then
    if seljgid<>"" then
        seljgid=split(seljgid,",")
		 for i=0 to ubound(seljgid) 
	   set rsimg=server.createobject("adodb.recordset")
	    sqldelimg="select * from jg where id=" & seljgid(i)
		rsimg.open sqldelimg,conn,1,3
		 if rsimg.eof then
 	response.write "<script language=JavaScript>{window.alert('ËùÑ¡¼Ç¼ÖÐÓв»´æÔÚ»òÒѱ»É¾³ýµÄ¼Ç¼£¬Çë°´¡°È·¶¨¡±·µ»Øºó¡°Ë¢Ð¡±Ò³Ãæ!');window.history.go(-1);}</script>"
  response.end
   end if
		img=rsimg("img")
		if img<>"" then
		set DelObj=Server.CreateObject("Scripting.FileSystemObject")
 filepath="upload/"&img
  Delpath=server.mappath(filepath)
 if DelObj.FileExists(Delpath) then
 set DelFi=DelObj.getfile(Delpath)
 DelFi.Delete
 set Delobj=nothing
 end if
 end if
 set rsde=server.createobject("adodb.recordset")
    s="select * from jg where id=" & seljgid(i)
				rsde.open s,conn,1,2
				session("jg_name")=rsde("name")
				session("jg_login")=rsde("login")
				rsde.delete
				 '-----------------------***************
	  ip111 = Request.ServerVariables("HTTP_X_FORWARDED_FOR")  
ip222 =Request.ServerVariables("REMOTE_ADDR") 
if ip111 = "" then
ipupdate = ip222
else
ipupdate = ip111
end if
jgpcname=Request.ServerVariables("HTTP_USER_AGENT")
sql_jgupddiary="select * from deljgdiary"
set rs_jgupddiary=server.CreateObject("adodb.recordset")
rs_jgupddiary.open sql_jgupddiary,conn,1,2
rs_jgupddiary.addnew     
      rs_jgupddiary("jg_login")=session("jg_login")
	  rs_jgupddiary("jg_name")=session("jg_name")  
      rs_jgupddiary("lastupduser")=session("adminlogin")
      rs_jgupddiary("lastupdname")=session("adminname")
      rs_jgupddiary("lastupddate")=now
      rs_jgupddiary("lastupdip")=ipupdate
	  rs_jgupddiary("os")=jgpcname
      rs_jgupddiary.update
	  rs_jgupddiary.close
	  set rs_jgupddiary=nothing
	  '------------------------------********************
						next	
			response.Write "<script language=javascript>{window.alert('¹§Ï²Äú£¬¸Ã½Ì¹¤µÄ×ÊÁϺÍÏàƬȫ²¿³É¹¦É¾³ý');window.history.go(-1);}</script>"
  end if   
  end if
 
  %>