📄 selectpoproduct.asp
字号:
<!--#include file="../config.ini"-->
<%
dim theName : theName = Request("theName")
dim theForm : theForm = Request("theForm")
dim theCode : theCode = Request("theCode")
dim thePrice : thePrice = Request("thePrice")
dim theSpecialPriceNo:theSpecialPriceNo=request("theSpecialPriceNo")
dim theAccount :theAccount=request("theAccount")
%>
<html>
<head>
<title>select</title>
<Script Language=JavaScript>
function pickup(what)
{
<%
response.write("window.opener."+theForm+"."+theName+".value=what;")
%>
window.close();
}
function pickup2(what,whatId,whatcode,whatPrice,whatSpecialPrice,theSpecialPriceNo){
window.opener.<%=theForm%>.<%=theCode%>.value=whatcode;
window.opener.<%=theForm%>.<%=theName%>.value=whatId;
//window.opener.<%=theForm%>.<%=theCode%>.value=whatcode;
window.opener.<%=theName%>name.innerHTML=what;
if(whatSpecialPrice==''){
window.opener.<%=theForm%>.<%=thePrice%>.value=whatPrice;
}
if(whatSpecialPrice!=''){
window.opener.<%=theForm%>.<%=thePrice%>.value=whatSpecialPrice;
window.opener.<%=theForm%>.<%=theSpecialPriceNo%>.value=theSpecialPriceNo;
}
window.close();
}
</Script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../global.css" rel=stylesheet type=text/css>
</head>
<body>
<form name="theForm" method="Post" action="">
<select name="Find" width="10">
<%
if instr(theName,"product")>0 then
%>
<option value=model <%if request("Find")="product" then Response.Write "selected"%>>型号</option>
<option value=productcode <%if request("Find")="productcode" then Response.Write "selected"%>>货号</option>
<option value=producttype <%if request("Find")="producttype" then Response.Write "selected"%>>产品类型</option>
<option value=shortkey <%if request("Find")="shortkey" then Response.Write "selected"%>>助记符</option>
<option value=price <%if request("Find")="price" then Response.Write "selected"%>>价格</option>
<option value=retail_price <%if request("Find")="retail_price" then Response.Write "selected"%>>市场价</option>
<%
end if
%>
</select>
<input type="Text" name="StartWith" size="16" value="<%=request("StartWith")%>">
<input type="Submit" name="Submit" value="搜索">
<input type="Hidden" name="theForm" value="<%=theForm%>"> <input type="Hidden" name="theName" value="<%=theName%>">
</form>
<div>
<table width="100%" bgcolor=cdcdcd cellspacing=1>
<tr bgcolor=f1f1f1>
<%
if instr(theName,"product")>0 then
%>
<td align=center height=20>货号</td>
<td align=center>型号</td>
<td align=center>产品类型</td>
<td align=center>在库数量</td>
<td align=center>保留数量</td>
<td align=center>成本</td>
<td align=center>政策价</td>
<td align=center>特价编号</td>
<%
end if
%>
</tr>
<%
submit = Request.Form("theName")
submit = trim(submit)
dim sql
Find = Request.Form("Find")
StartWith = Request.Form("StartWith")
if Find <>"" then
strwhere=" and " & Find & " like N'%" + trim(StartWith) + "%'"
end if
sql = "select top 100 * from v_popriiceselect where (disable=0) "&strwhere
set conn=server.CreateObject("adodb.connection")
conn.Open connstring
set rs=conn.Execute(sql)
if not rs.eof then
set model=rs("model")
set productid=rs("productid")
set productcode=rs("productcode")
set cost=rs("cost")
set cost=rs("specialprice")
set cost=rs("specialpriceno")
set qty_on_hand=rs("qty_on_hand")
set qty_rsvd=rs("qty_rsvd")
set producttype=rs("producttype")
do while not rs.EOF
%>
<tr bgcolor=white>
<td align="center" nowrap><a href="javascript:pickup2('<%=model%>','<%=productid%>','<%=productcode%>','<%=cost%>','<%=specialprice%>','<%=specialpriceno%>');"><%=productcode%></a></td>
<td align="center" nowrap><a href="javascript:pickup2('<%=model%>','<%=productid%>','<%=productcode%>','<%=cost%>','<%=specialprice%>','<%=specialpriceno%>');"><%=model%></a></td>
<td align="center" nowrap><%=producttype%></td>
<td align="center" nowrap><%=qty_on_hand%></td>
<td align="center" nowrap><%=qty_rsvd%></td>
<td align="center" nowrap><%=cost%></td>
<td align="center" nowrap><font color=red><%=specialprice%></font></td>
<td align="center" nowrap><%=specialpriceno%></td>
</tr>
<%
rs.MoveNext
loop
else
Response.Write "<tr bgcolor=white><td colspan=8>无记录</td></tr>"
end if
conn.Close
set conn = nothing
%>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -