📄 wzgl_06.asp
字号:
<!--#include file="function/conn.asp"-->
<!--#include file="power.asp"-->
<%
set rs=server.createobject("adodb.recordset")
data_pro_bak=trim(request.form("data_pro"))
if data_pro_bak="ok" then
sql="INSERT INTO tmember(Mem_LoginName, Mem_LoginPasd, Mem_Name, Mem_Email, Mem_Sex, Mem_City,mem_province, Mem_Addr, Mem_Tel, Mem_Mobile, Mem_CardID, Mem_IDcard,Mem_Grade, Mem_RegistDate, Mem_Remark, mem_zip, mem_fax, mem_both,mem_cid, mem_company) SELECT Mem_LoginName, Mem_LoginPasd, Mem_Name,Mem_Email, Mem_Sex, Mem_City,mem_province, Mem_Addr, Mem_Tel, Mem_Mobile, Mem_CardID, Mem_IDcard, Mem_Grade, Mem_RegistDate, Mem_Remark, mem_zip, mem_fax, mem_both,mem_cid, mem_company FROM member WHERE (Mem_ID NOT IN (SELECT DISTINCT a.mem_id FROM member a RIGHT OUTER JOIN tmember b ON a.Mem_LoginName = b.Mem_LoginName))"
conn.execute(sql)
%>
<script language="javascript">
alert("数据导入操作成功！")
</script>
<%
data_pro_bak=""
end if%>
<!--#include file="../../config.asp"--><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>后台管理会员管理——集团会员</title>
<link href="RLimages/user.css" rel="stylesheet" type="text/css">
<script language="javascript">
function open_win(aa,id){
url="xiugai.asp?action="+aa+"&mem_id="+id;
var width = 500;
var height = 400;
var left = (screen.width-width)/2;
var top = (screen.height-height)/2;
window.open(url,'对币的操作','scrollbars=1,resizable=yes,left='+left+',top='+top+',width='+width+',height='+height);
}
function dele(){
if(!confirm('已经确认需要删除选中的会员吗？')) return false;
myform.submit();
}
function modify(aa){
modify_mem.mem_id.value=aa;
modify_mem.submit();
}
function sltall(){
var nn=self.document.all.item("deleteid");
for(j=0;j<nn.length;j++){
self.document.all.item("deleteid",j).checked=true;
}
}
function escall(){
var nn=self.document.all.item("deleteid");
for(j=0;j<nn.length;j++){
self.document.all.item("deleteid",j).checked=false;
}
}
</script>
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 { color: #003366;
font-weight: bold;
}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="RLimages/manager_top.jpg" width="775" height="108"></td>
</tr>
</table>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" background="RLimages/manager_top_01.jpg"><table width="775" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right"><span class="back-12">|</span> <a href="wzgl_01.asp" class="back-12">会员管理</a><span class="back-12">|</span>
<a href="gljp_01.asp" class="back-12">国内机票</a><span class="back-12">|</span>
<a href="gjjp_01.asp" class="back-12">国际机票</a><span class="back-12">|</span>
<a href="ny.asp" class="back-12">旅游 </a><span class="back-12">|</span>
<a href="jd.asp" class="back-12">酒店</a><span class="back-12"> |</span>
<a href="hkhy_01.asp" class="back-12">航空货运</a><span class="back-12">|</span>
<a href="hcp_01.asp" class="back-12">火车票</a><span class="back-12">|</span>
<a href="aboutus_01.asp" class="back-12" >关于我们</a><span class="back-12">|</span>
<a href="hyfw_01.asp" class="back-12">会员服务</a><span class="back-12">|</span>
<a href="zxfw_01.asp" class="back-12">在线服务</a><span class="back-12">|</span>
<a href="ad.asp" class="back-12">广告|</a><a href="logout.asp" class="back-12">
登录注销</a><span class="back-12">|</span></td>
</tr>
</table></td>
</tr>
</table>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="142" valign="top" bgcolor="#C3D9FF"> <table width="142" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="141" height="10"></td>
</tr>
<!-- <tr>
<td width="141" height="32" align="center" background="RLimages/manager_flie.gif"><a href="wzgl_06.asp" class="back-12">会员资料导入</a></td>
</tr> -->
<tr>
<td width="141" height="32" align="center"><table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td height="30" bgcolor="#C3D9FF"><div align="center" class="style2">会员管理</div></td>
</tr>
<tr>
<td height="32" align="center" class="b-14"><a href="wzgl_01.asp" class="back-12">网站管理员</a></td>
</tr>
<tr>
<td height="32" align="center" class="b-14"><a href="wzgl_02.asp" class="back-12">普通注册会员</a></td>
</tr>
<tr>
<td height="32" align="center"><a href="wzgl_03.asp" class="back-12">VIP会员</a></td>
</tr>
<tr>
<td height="32" align="center"><a href="wzgl_04.asp" class="back-12">VIP贵宾会员</a></td>
</tr>
<tr>
<td height="32" align="center"><a href="wzgl_05.asp" class="back-12">集团会员</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="141" height="32" align="center"> </td>
</tr>
<tr>
<td width="141" height="33" align="center"> </td>
</tr>
<tr>
<td width="141" height="32" align="center"> </td>
</tr>
<tr>
<td width="141" height="32" align="center"> </td>
</tr>
</table></td>
<td width="673" valign="top"><div align="center"><span class="style1">该功能已经完成!</span></div></td>
</tr>
</table>
<!--#include file="bottom.asp"-->
</body>
</html>
<form method="post" name="productsearch" action="wzgl_05.asp">
<input type="hidden" name="page" value="<%=ipage%>">
<input type="hidden" name="search_type" value="<%=search_type%>">
<input type="hidden" name="search_word" value="<%=search_word%>">
</form>
<form method="post" name="modify_mem" action="modify.asp">
<input type="hidden" name="filename" value="wzgl_05.asp">
<input type="hidden" name="mem_id" value="">
<input type="hidden" name="page" value="<%=ipage%>">
<input type="hidden" name="search_type" value="<%=search_type%>">
<input type="hidden" name="search_word" value="<%=search_word%>">
</form>
<%
rs.close
set rs=nothing
call conn_close()
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -