📄 f_clientinfo1.asp

📁 一个很好的在线购物系统
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页


<!--#include file="../include/Pubconn.asp"-->
<%
'**************************
'
'Author:Ruphi Writing Time:2001-09-20
'功能说明：商务合同录入页面客房选择
'实现当前页面翻页或直接提交后能将选中的客户自动填写到指定的页面并不丢失带过来的参数
'
'**************************
%>

<%
'在选择客户之前时带过来四个参数值
hth=request("hth")
year1=request("year1")
month1=request("month1")
date1=request("date1")

%>
<%
'区域下拉单提取，可变化的
 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
%>

<%

'本表单提交后的值
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='潜在客户'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 StuffNum='"&Session("UserID")&"'and (delflag<>'1') "
if khmc<>"" then
      str=str&" and (ClientName like '%"&khmc&"%')  "
end  if

if khlx<>"" then
      if khlx="hbdealer"    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
        hth=document.myform.hth.value
        year1=document.myform.year1.value
        month1=document.myform.month1.value
        date1=document.myform.date1.value
        khmc=document.form1.khmc.value
        khlx=document.form1.khlx.value
        khjb=document.form1.khjb.value
        a="F_clientInfo1.asp?page="+page1+"&khlx="+khlx+"&khmc="+khmc+"&khjb="+khjb+"&hth="+hth+"&year1="+year1+"&month1="+month1+"&date1="+date1
        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="F_clientInfo1.asp" name="form1" >                                                   
                                                    
 <input type="hidden" name="hth" value="<%=hth%>">   
  <input type="hidden" name="year1" value="<%=year1%>">  
  <input type="hidden" name="month1" value="<%=month1%>">    
  <input type="hidden" name="date1" value="<%=date1%>">                                                     
<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="忠诚客户" selectd>忠诚客户</option>    
      <%else%>      
         <option value="忠诚客户">忠诚客户</option>    
      <%end if %>  
      <% if khlx="hbdealer"  then%>       
         <option value="hbdealer" selectd>经销商</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;">
12 下一页
⌨️ 快捷键说明

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