📄 g_cpinfo1.asp
字号:
<!--#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>
<body bgcolor="#FFFFFF">
<%
'**************************
'
'Author:Ruphi Writing Time:2001-08-27
'功能说明：客房丢失报告中的产品选择，并传过来二个参数
'
'**************************
%>
<%
'带过来二个参数值
hth=request("hth")
year1=request("year1")
month1=request("month1")
date1=request("date1")
khxh=request("khxh")
lxr=request("lxr")
qyxz=request("qyxz")
if khxh="" then%>
<center>
<font size="2">请先选择客户！
<a href="javascript:window.close()">关闭</a>
</font>
</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
%>
<script language="vbscript">
sub GoPage()
spxh=document.form1.spxh.value
spmc=document.form1.spbm.value
hth=document.myform.hth.value
year1=document.myform.year1.value
month1=document.myform.month1.value
date1=document.myform.date1.value
khxh=document.myform.khxh.value
lxr=document.myform.lxr.value
qyxz=document.myform.qyxz.value
page1=document.myform.page1.value
a="G_CpInfo1.asp?page="+page1+"&spxh="+spxh+"&spmc="+spmc+"&hth="+hth+"&year1="+year1+"&month1="+month1+"&date1="+date1+"&khxh="+khxh+"&lxr="+lxr+"&qyxz="+qyxz
window.location=a
end sub
sub winsub()
window.myform.submit
window.close
end sub
</script>
<form method="post" action="G_CpInfo1.asp" name="form1">
<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>
</center>
</div>
<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%>">
<input type="hidden" name="khxh" value="<%=khxh%>">
<input type="hidden" name="lxr" value="<%=lxr%>">
<input type="hidden" name="qyxz" value="<%=qyxz%>">
<table border="0" cellspacing="0" width="630" align="center" width="630" width="636">
<tr>
<td width="12%" align="center" width="151" width="150" bgcolor="#F1E8DA">
<p align="right">
<font size="2">产品序号
</font>
</p>
</td>
<td width="19%" align="center" width="104" width="104" bgcolor="#F1E8DA">
<p align="left">
<input type="text" name="spxh" size="15">
</p>
</td>
<td width="11%" align="center" width="96" width="123" bgcolor="#F1E8DA">
<p align="right">
<font size="2">产品名称
</font>
</p>
</td>
<td width="29%" align="center" width="263" width="243" bgcolor="#F1E8DA">
<p align="left">
<input type="text" name="spmc" size="17">
<inpty type="hidden" name="bz" value="1">
<input type="submit" value="查询" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">
</p>
</td>
</tr>
</table>
</form>
<%
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -