📄 g_cpinfo.asp

📁 一个很好的在线购物系统
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<!--#include file="../include/Pubconn.asp"-->
<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>

<%
'**************************
'
'Author:Ruphi   Writing Time:2001-08-27
'功能说明：客房丢失报告中的产品选择，并传过来二个参数
'
'**************************
%>

<%
'带过来二个参数值
khxh=request("khxh")
khmc=request("khmc")
if khxh="" then
   response.write "<center>请先选择客户！"&"<br>"
   response.write"<a href=javascript:close()>关闭</a></center>"
   response.end
end  if 
'当前页面提交后的值
spxh=request("spxh")  
spmc=request("spmc")

%>
<%
set RScp=server.createobject("adodb.recordset")
str="select * from A_ProductInfo  where delflag<>'1'"

   if spxh<>"" then
     str=str&" and  ProdCode like  '"&spxh&"%' "
   end if 
   if spmc<>"" then
     str=str&" and   ProdName like '%"&spmc&"%' "
   end if 
   'if spmc<>"" and spxh<>"" then
   '    str=str&"where ProdCode like  '"&spxh&"%' and ProdName like '%"&spmc&"%' "
   'end if

RScp.open str ,pubconn,1
'response.write str
%>                                     
<body bgcolor="#FFFFFF">
<script language="vbscript">
   sub GoPage()
       page1=document.myform.page1.value
       khxh=document.myform.khxh.value
       khmc=document.myform.khmc.value
       spxh=document.form1.spxh.value
       spmc=document.form1.spmc.value
       a="G_CpInfo.asp?page="+page1+"&spxh="+spxh+"&spmc="+spmc+"&khxh="+khxh+"&khmc="+khmc
       window.location=a
   end sub
   sub winsub()
      window.myform.submit
      window.close
  end sub
</script>  
 
<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="G_CpInfo.asp" name="form1">                                             
                                              
<table border="0" cellspacing="0" width="560" align="center" width="630" width="636" bgcolor="#F1E8DA" height="51">                                                   
   <input type="hidden" name="khxh" value="<%=khxh%>">   
   <input type="hidden" name="khmc" value="<%=khmc%>">     
 <tr>                                                    
    <td width="103" align="center" width="151" width="150"  bgcolor="#F1E8DA" height="49">   
   
     <p align="right">
     <font size="2">产品序号
     </font>
  
     </p>  
  
    </td>                                                     
    <td width="126" align="center" width="104" width="104"  bgcolor="#F1E8DA" height="49">                                                   
  
    <p align="left">  
    <input type="text" name="spxh" size="15">

    </p>   
   
    </td>                                                             
    <td width="102" align="center" width="96" width="123" bgcolor="#F1E8DA" height="49">   
   
     <p align="right">   
     <font size="2">产品名称
     </font>
  
     </p>  
  
    </td>                                                  
                                                       
    <td width="162" align="center" width="263" width="243" bgcolor="#F1E8DA" height="49">                                                        
  
      <p align="left">  
      <input type="text" name="spmc" size="17"> <input type="submit" value="查询" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1"  >           
           
             
           
      </p>           
           
    </td>                                                                                  
 </tr>                                                                                 
</table>       
</form>                                                                      
                                                                              
 <%               
 if RScp.eof then%>               
<center><p>        
<font size="2">没有符合条件的记录！<b>         
</b>         
</font>         
</center>                
                
 <%else                                                                                  
   if request.querystring("page")<>"" then                                                                                 
   page=cint(request.querystring("page"))                                                                                
else
12 下一页
⌨️ 快捷键说明

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