a_del_agents0819.asp

1。超强文件读写锁定

<%'创建时间:2004/07/02
'
'功能:用于管理员删除会员
%>
<!--#include file="Include/conn.asp"-->
<!--#include file="Include/Islogin.asp"-->
<%'id=checkstr(request.QueryString("id"))
name1=checkstr(request.QueryString("name"))
'删除指定的代理以及此代理下的所有分销商
 M_sql="delete from Agent where Agent_name='"&name1 &"' or agent_second='"&name1&"'"
  conn.execute M_sql	
  '删除此代理下的所有会员
  Me_sql="delete from  member  where member_second='"&name1&"' or member_frist='"&name1&"'"
  conn.execute Me_sql
  
  '删除此代理下所有会员的投注
  invest_sql="delete from  invest where invest_second='"&name1&"' or invest_frist='"&name1&"'"
  conn.execute invest_sql
response.Redirect("List_agent.asp")
%>