📄 price.asp
字号:
else
Response.Write "<a href='price.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&type="&request.querystring("type")&"&CurPage=1'><img src='../images/button_start.gif' border=0></a> "
Response.Write "<a href='price.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&type="&request.querystring("type")&"&CurPage="&CurPage-1&"'><img src='../images/button_backward.gif' border=0></a> "
end if
if CurPage>=RS.PageCount then
Response.Write "<a href='price.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&type="&request.querystring("type")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
else
Response.Write "<a href='price.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&type="&request.querystring("type")&"&CurPage="&CurPage+1&"'><img src='../images/button_forward.gif' border=0></a> "
Response.Write "<a href='price.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&type="&request.querystring("type")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
end if
%>
</td><td width=30%><div id=dateformat <%if request("strfield")="createdate" then response.write "style=display:block" else response.write "style=display:none" end if%>>日期输入格式提示：YYYY-MM-DD</div></td>
</tr>
<tr>
<td height="25" colspan=5><strong><font class=title>
<%
if request.querystring("type")="productprice" then
response.write "按产品制定的销售价格列表"
elseif request.querystring("type")="productaccount" then
response.write "按产品与客户制定的销售价格列表"
elseif request.querystring("type")="productqty" then
response.write "按产品与数量制定的销售价格列表"
elseif request.querystring("type")="producttype" then
response.write "按产品类型制定的销售价格列表"
elseif request.querystring("type")="" then
response.write "所有销售价格列表"
end if
%>
</font></strong> <a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 100, top=100, menubar=no, location=no, toolbar=no ,width=600, height=400','newprice.asp?type=<%=Request("type")%>');"><img src="../images/button_new.gif" border=0></a></td>
</tr>
<tr >
<td height="16" colspan="5" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4 colspan="5"></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#DECFAD">
<tr bgcolor="efefef">
<td width="15%" height=15 align=center>相关</td>
<td width="15%" height=15 align=center><a href="price.asp?CurPage=<%=CurPage%>&type=<%=request.querystring("type")%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=productcode&orderby=<%=session("orderby")%>">货号</a></td>
<td width="30%" height="15" align=center><a href="price.asp?CurPage=<%=CurPage%>&type=<%=request.querystring("type")%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=model&orderby=<%=session("orderby")%>">型号</a></td>
<td width="10%" height="15" align=center><a href="price.asp?CurPage=<%=CurPage%>&type=<%=request.querystring("type")%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=discount&orderby=<%=session("orderby")%>">折扣</a></td>
<td width="10%" height="15" align=center><a href="price.asp?CurPage=<%=CurPage%>&type=<%=request.querystring("type")%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=price&orderby=<%=session("orderby")%>">价格</a></td>
<td width="10%" height="15" align=center><a href="price.asp?CurPage=<%=CurPage%>&type=<%=request.querystring("type")%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=createdate&orderby=<%=session("orderby")%>">更新日期</a></td>
<td width="10%" height="15" align=center>操作</td>
</tr>
<%
set productid=rs("productid")
set productcode=rs("productcode")
set model=rs("model")
set producttypename=rs("producttypename")
set createdate=rs("createdate")
set account=rs("account")
set accounttype=rs("accounttype")
set industry=rs("industry")
set address=rs("address")
set ownername=rs("ownername")
set price=rs("price")
set priceid=rs("priceid")
set discount=rs("discount")
set qty1=rs("qty1")
set discount1=rs("discount1")
set price1=rs("price1")
set qty2=rs("qty2")
set discount2=rs("discount2")
set price2=rs("price2")
set qty3=rs("qty3")
set discount3=rs("discount3")
set price3=rs("price3")
i=1:do while not rs.EOF and i<=session("pagesize")%>
<tr bgcolor="#FFFFFF">
<td align=center>
<%if qty1<>"" then%>
<!--不知何原因不行 <IMG border=0 id="IMGtr1<%=i%>" src="../images/button1.gif" onclick="showit('tr1<%=i%>',1)" style="cursor:hand"></td>
-->
<table width=100%>
<tr id="IMGtr1<%=i%>" style="display:block">
<td width=70% align=right>数量折扣查看</td>
<td width=30% align=right><a href="javascript:showit('tr1<%=i%>',1)"><img src="../images/button1.gif" border=0></a><td></tr>
<tr id="IMG1tr1<%=i%>" style="display:none">
<td width=70% align=right>数量折扣查看</td>
<td width=30% align=right><a href="javascript:showit('tr1<%=i%>',1)"><img src="../images/button2.gif" border=0></a></td></tr></table>
<%elseif account<>"" then%>
<table width=100%>
<tr id="IMGtr1<%=i%>" style="display:block">
<td width=70% align=right>客户查看</td>
<td width=30% align=right><a href="javascript:showit1('tr1<%=i%>',1)"><img src="../images/button1.gif" border=0></a><td></tr>
<tr id="IMG1tr1<%=i%>" style="display:none">
<td width=70% align=right>客户查看</td>
<td width=30% align=right><a href="javascript:showit1('tr1<%=i%>',1)"><img src="../images/button2.gif" border=0></a></td></tr></table>
<%
elseif producttypename<>"" then
response.write producttypename
else
response.write "--"
end if
%></td>
<td align=center height=18>
<%
if producttypename<>"" then
response.write "--"
else
%>
<a href="javascript:opensubwin3('../product/productdetail.asp?productid=<%=productid%>','product<%=productid%>','toolbar=no,scrollbars=yes,location=no,status=no,menubar=no,width=600,height=250,top=150,left=160');"><%=productcode%></a>
<%end if%></td>
<td align=center>
<%if producttypename<>"" then
response.write "--"
else
response.write model
end if
%></td>
<td align=center>
<%if qty1<>"" then
response.write "--"
else
response.write discount&"%"
end if
%>
</td>
<td align=center>
<%if producttypename<>"" or qty1<>"" then
response.write "--"
else
response.write price
end if
%>
</td>
<td align=center><%=Year(createdate)%>-<%=Month(createdate)%>-<%=Day(createdate)%></td>
<td align=center><a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 100, top=100, menubar=no, location=no, toolbar=no ,width=600, height=400','newprice.asp?id=<%=rs("priceid")%>&type=<%=rs("salespricetype")%>');">编辑</a> <a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=220','../delete.asp?priceid=<%=priceid%>');">删除</a></td>
</tr>
<%'相关数量折扣%>
<tr bgcolor="#FFFFFF" border=0 id='tr1<%=i%>' style=display:none><td colspan=8>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF">
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>数量1</em></font></td>
<td width="18%" bgcolor="efefef"><%=qty1%></td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣1</em></font></td>
<td width="18%" align="left" bgcolor="efefef"><%=discount1%>%</td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣价1</em></font></td>
<td bgcolor="efefef"><%=price1%></td>
</tr>
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>数量2</em></font></td>
<td width="18%" bgcolor="efefef"><%=qty2%></td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣2</em></font></td>
<td width="18%" align="left" bgcolor="efefef"><%=discount2%>%</td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣价2</em></font></td>
<td bgcolor="efefef"><%=price2%></td>
</tr>
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>数量3</em></font></td>
<td width="18%" bgcolor="efefef"><%=qty3%></td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣3</em></font></td>
<td width="18%" align="left" bgcolor="efefef"><%=discount3%>%</td>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>折扣价3</em></font></td>
<td bgcolor="efefef"><%=price3%></td>
</tr>
</table>
</td></tr>
<%'相关客户%>
<tr bgcolor="#FFFFFF" border=0 id='accounttr1<%=i%>' style=display:none><td colspan=8>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF">
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>客户</em></font></td>
<td width="35%" bgcolor="efefef"><%=account%></td>
<td width="15%" bgcolor="DEDFDE"><em><font color="#000099">行业</font></em></td>
<td bgcolor="efefef"><%=industry%></td>
</tr>
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>客户类型</em></font></td>
<td width="35%" bgcolor="efefef"><%=accounttype%><em></em></td>
<td width="15%" bgcolor="DEDFDE"><em><font color="#000099">所有者</font></em></td>
<td bgcolor="efefef"><%=ownername%></td>
</tr>
<tr>
<td width="15%" bgcolor="DEDFDE"><font color="#000099"><em>地址</em></font></td>
<td colspan="3" bgcolor="efefef"><%=address%></td>
</tr>
</table>
</td></tr>
<%'相关产品类型%>
<tr bgcolor="#FFFFFF" border=0 id='producttypetr1<%=i%>' style=display:none><td colspan=8>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF">
<tr>
<td width="15%" bgcolor="DEDFDE"><em><font color="#000099">产品类型</font></em></td>
<td width="85%" bgcolor="efefef"><%=producttypename%></td>
</tr></table>
</td></tr>
<%
i=i+1
rs.MoveNext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="50"><td>第<%=CurPage%>页 / 共<%=RS.PageCount%>页 / 记录数:<%=Rs.RecordCount%>条
</td></tr></table>
<%
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -