📄 e_cx2.asp
字号:
<!--#include file="../include/Pubconn.asp"-->
<%
'**************************
'
'Author:Ruphi Writing Time:2001-09-02
'功能说明：计划活动明细查询客户的选择，并传过来二个参数，
'实现当前页面翻页或直接提交后能将选中的客户自动填写到指定的页面并不丢失带过来的参数
'
'**************************
%>
<%
'区域下拉单
set rssj=Server.CreateObject("ADODB.RecordSet")
sql="select NumValue from A_ConfigInfo Where Subject='salearea'"
rssj.open sql,Pubconn,1,1
if not rssj.eof then
if not isnull(rssj("NumValue")) then
CloseTime=Split(trim(rssj("NumValue")),",")
end if
end if
set rssj=nothing
%>
<%
'带过来三个参数值
djbh=request("djbh")
'本表单的值
khmc=request("khmc") '当前页面提交后的值
khlx=request("khlx")
khjb=request("khjb")
%>
<%
set RSkh=server.createobject("adodb.recordset")
str="select * from D_ClientInfo where ( tag='khindex'or ((type='潜在客户'or isnull(type)) and tag='kh') or (type='预期客户' and tag='kh')or (type='首次购买客户' and tag='kh') or (type='忠诚客户'and tag='kh') or (type='重复购买客户' and tag='kh') or tag='hbdealer' ) and (delflag<>'1') "
if khmc<>"" then
str=str&" and (ClientName like '%"&khmc&"%') "
end if
if khlx<>"" then
if khlx="hbdealer" or khlx="khindex" then
str=str&" and (tag='"&khlx&"')"
else
str=str&" and (type='"&khlx&"' and tag='kh') "
end if
end if
if khjb<>"" then
str=str&" and (Area='"&khjb&"') "
end if
RSkh.open str&"order by ID desc" ,pubconn,1
'response.write str
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>单据查询</title><link href="cread.css" rel="stylesheet" type="text/css">
</head>
<script language="vbscript">
sub GoPage()
page1=document.myform.page1.value
khmc=document.form1.khmc.value
khlx=document.form1.khlx.value
khjb=document.form1.khjb.value
djbh=document.myform.djbh.value
a="E_cx2.asp?page="+page1+"&khlx="+khlx+"&khmc="+khmc+"&khjb="+khjb+"&djbh="+djbh
window.location=a
end sub
sub winsub()
window.myform.submit
window.close
end sub
</script>
<body bgcolor="#FFFFFF" >
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%"><b><font size="3"><img border="0" src="../pic/it_22.gif">
</font>
<font size="2">客户信息查询
</font>
</b><hr width="40%" size="1" align="left">
</td>
</tr>
</table>
<form method="post" action="E_cx2.asp" name="form1" >
<input type="hidden" name="djbh" value="<%=djbh%>">
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="80" align="center" width="151" width="150" bgcolor="#F1E8DA">
<p align="right">
<font size="2">客户名称
</font>
</p>
</td>
<td width="80" align="center" width="104" width="104" bgcolor="#F1E8DA">
<p align="left">
<input type="text" name="khmc" size="12">
</p>
</td>
<td width="109" align="center" width="96" width="123" bgcolor="#F1E8DA">
<font size="2">客户类型
</td>
<td width="120" align="center" width="263" width="243" bgcolor="#F1E8DA">
<p align="left">
<select size="1" name="khlx" style="width:120;">
<option value="">全部</option>
<% if khlx="潜在客户" then%>
<option value="潜在客户" selected>潜在客户</option>
<%else%>
<option value="潜在客户">潜在客户</option>
<%end if%>
<% if khlx="预期客户" then%>
<option value="预期客户" selected>预期客户</option>
<%else%>
<option value="预期客户">预期客户</option>
<%end if %>
<% if khlx="首次购买客户" then%>
<option value="首次购买客户" selected>首次购买客户</option>
<%else%>
<option value="首次购买客户">首次购买客户</option>
<%end if %>
<% if khlx="重复购买客户" then%>
<option value="重复购买客户" selected>重复购买客户</option>
<%else%>
<option value="重复购买客户">重复购买客户</option>
<%end if %>
<% if khlx="忠诚客户" then%>
<option value="忠诚客户" selected>忠诚客户</option>
<%else%>
<option value="忠诚客户">忠诚客户</option>
<%end if %>
<% if khlx="hbdealer" then%>
<option value="hbdealer" selected>经销商</option>
<%else%>
<option value="hbdealer">经销商</option>
<%end if %>
</select>
<td width="73" bgcolor="#F1E8DA">
<p align="right">
区域</td>
<td width="214" bgcolor="#F1E8DA">
<select size="1" name="khjb" style="width:100;">
<option value="">全部</option>
<% for i=0 to Ubound(closetime)%>
<option value="<%=closetime(i)%>" <% if khjb=closetime(i) then %> selected <% end if %>><%=closetime(i)%></option>
<%next%>
</select>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -