⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 pcch.asp

📁 客户管理系统-支持 Ms Sql-Server
💻 ASP
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>排除重复</title>
<LINK href="mainimages/style.css" type="text/css" rel="stylesheet">
<style type="text/css">
<!--
.STYLE2 {font-size: 16}
-->
</style>
<body >
</head>
   <!--#include file="piaoy.inc"-->
   <!--#include file="hyyxlAdmin.asp"-->
   <%
kfglfzbm=session("kfglfzbm")

kfglid=request("kfglid")%>
   
    <%

  sqlfzb = "select * from "&kfglfzbm&"  where kfglid=" &request("kfglid")&" order by fzbid desc"
  Set rsfzb = Server.CreateObject("ADODB.RecordSet")
  rsfzb.Open sqlfzb,conn,1,2
  

%>
<%
  kfgldl=session("kfgldl")
  sql = "select * from kfgl where kfgldl='"&kfgldl&"'"
  Set hymain = Server.CreateObject("ADODB.RecordSet")
  hymain.Open sql,conn,1,2
%>
 <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
   <tr align="center" valign="middle">
     <td height="30"><form id="form1" name="form1" method="post" action="pcchpost.asp?kfglid=<%=kfglid%>&kfglfzbm=<%=kfglfzbm%>"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="30" align="left" class="black12px"><strong>&nbsp;&nbsp;<font color="#003399">您现在的位置:</font></strong><font color="#003399">客户管理系统 <span class="nav">-&gt;</span> 用户中心 <span class="nav">-&gt;</span> 排除重复手机号</font> </td>
    </tr>
  </table>
  <TABLE id=data_table cellSpacing=0 cellPadding=3 width="100%" 
      bgColor=#dbeaf5 border=0>
    <TBODY>
      <TR>
        <TD height="20" align="left" valign="middle"><SPAN 
            class=blue12px><STRONG>&nbsp;&nbsp;&nbsp;</font></STRONG></SPAN></TD>
      </TR>
      <TR bgColor=#c1cdd8>
        <TD align=middle height=1></TD>
      </TR>
      <TR bgColor=#c1cdd8>
        <TD align=middle 
height=1></TD>
      </TR>
    </TBODY>
  </TABLE>
       <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#fff7e5">
  <tr>
  
   <td height="30" align="left"><strong>&nbsp;排除重复手机号</strong></td>
   </tr>
   <tr>
     <td height="30" align="left"><span class="STYLE2">&nbsp;此功能用于排除手机号码的重复!<br />
       &nbsp;请您先选择排除重复的范围,然后单击“排除重复手机号并删除”按钮,将会在您选定的范围内搜索重复的手机号码,然后删除重复的手机号码!<br />
       &nbsp;注意:此功能搜索到重复的手机号码以后只保留一条数据,其他重复的手机号码将被删除!手机号码为空的记录不在排除范围内!<br />
     &nbsp;推荐您使用“排除重复手机号至垃圾箱”,以免丢失一些重要客户名单。</span></td>
  </tr>
  <tr>
    <td height="50" align="center" valign="middle"><select id="ydzb"  name="ydzb">
	     
	    <option value="qb" selected="selected">全部</option>
       <option value="0" >不归组</option>
         <% do while not rsfzb.eof %>
         <option value="<%=rsfzb("fzbid")%>" <% if int(fzbidsave)=rsfzb("fzbid") then response.write " selected" %>><%=rsfzb("fzbm")%></option>
         <%  rsfzb.movenext
		  loop
          		rsfzb.close
		  		set rsfzb=nothing
		  		
				%>
       </select>
       <input name="cdsc" type="submit"  class=button id="cdsc" style="COLOR: #ffcc33" onClick="Javascript:return confirm('一但排除重复手机号并删除,这些客户将无法恢复,你确定这样做吗?');" value="排除重复手机号并删除" />
       &nbsp;&nbsp;<input name="ljx" type="submit"  class=button id="ljx" style="COLOR: #ffcc33" value="排除重复手机号至垃圾箱" /></td>
  </tr>
</table>

     <TABLE id=data_table cellSpacing=0 cellPadding=3 width="100%" 
      bgColor=#dbeaf5 border=0>
  <TBODY>
    <TR>
      <TD height="20" align="left" valign="middle"></TD>
    </TR>
    <TR bgColor=#c1cdd8>
      <TD align=middle height=1></TD>
    </TR>
    <TR bgColor=#c1cdd8>
      <TD align=middle 
height=1></TD>
    </TR>
  </TBODY>
</TABLE></form></td>
   </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -