📄 g_statecp.asp
字号:
<!--#include file="../include/Pubconn.asp"-->
<%
Response.ExpiresAbsolute=#May 31,1995 13:30:15#
Response.CacheControl="private"
%>
<%
khxh=request("khxh")
khmc=request("khmc")
khjb=request("khjb")
'response.write khxh&"<br>"
'response.write khmc&"<br>"
spxh=request("spxh")
spmc=request("spmc")
'bz=request("bz")
%>
<%
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
%>
<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">
<script language="vbscript">
sub GoPage()
a="G_StateCp.asp?page="+document.myform.page1.value+"&spxh="+document.myform.spxh.value+"&spmc="+document.myform.spmc.value
'msgbox a
window.location=a
end sub
sub winsub()
'msgbox"ok"
window.myform.submit()
window.close
end sub
</script>
<form method="post" action="G_StateCp.asp" name="form1">
<p>
<div align="center">
<center>
<table border="0" width="100%" width="490" width="285">
<tr>
<td width="100%" width="482" width="277">
<p align="center">
<b><font size="3">产品信息查询
</font>
</b>
</td>
</tr>
</table>
</center>
</div>
<input type="hidden" name="khxh" value="<%=khxh%>">
<input type="hidden" name="khmc" value="<%=khmc%>">
<input type="hidden" name="khjb" value="<%=khjb%>">
<table border="0" cellspacing="0" width="630" align="center" width="630" width="636">
<tr>
<td width="150" align="center" width="151" width="150" bgcolor="#F1E8DA" >
<p align="right">
<font size="2">产品序号
</font>
</p>
</td>
<td width="104" align="center" width="104" width="104" bgcolor="#F1E8DA" >
<p align="left">
<input type="text" name="spxh" size="15">
</p>
</td>
<td width="123" align="center" width="96" width="123" bgcolor="#F1E8DA">
<p align="right">
<font size="2">产品名称
</font>
</p>
</td>
<td width="243" 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="查询" >
</p>
</td>
</tr>
</table>
</form>
<%
if RScp.eof then%>
<center><p>
<font size="2">没有符合条件的记录！
<a href=G_mainlost.asp>
返回
</a></center>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -