%
Response.Cookies("alibabaName") = "alibabas"
Response.Cookies("alibabaName").Expires=date()+365
if Chkrequest(request("typeid")) then
typeid=request("typeid")
else
Response.Redirect ("../login/chklogin.asp?login=4")
end if
show=replace_text(request("show"))
country=Replace_Text(request("country1"))
sf=Replace_Text(request("province"))
city=Replace_Text(request("city"))
datetime=replace_text(request("datetime"))
%> <%
sql="select productshow.*,corporation.id as corid,corporation.flag as corflag,corporation.qymc,corporation.country,corporation.sf,corporation.city,corporation.web,corporation.url,corporation.trust_score from productshow,corporation where productshow.typeid="&typeid&" and corporation.id=productshow.gsid and productshow.flag=1"
if country>"" then sql=sql&" and corporation.country='"&country&"'"
if sf>"" then sql=sql&" and corporation.sf='"&sf&"'"
if city>"" then sql=sql&" and corporation.city='"&city&"'"
if datetime="1" then sql=sql&" and productshow.idate>=date()-1"
if show="trust_score" then
sql=sql&" order by corporation.trust_score desc"
else
sql=sql&" order by productshow.id desc"
end if
Set rslist= Server.CreateObject("ADODB.Recordset")
rslist.open sql,conn,1,1
msg_per_page=20 '定义每页显示记录条数
%>
导航:供求商机 >>
我要采购 >> 查看供应信息 >>
<%
sorttype="select class_2.typeid,class_2.typename,class_1.* from class_2,class_1 where class_2.typeid="&typeid&" and class_1.sortid=class_2.sortid"
set rssorttype=conn.execute(sorttype)
if not rssorttype.eof then
response.write""&rssorttype("sort")&""
response.write" > "
response.write""&rssorttype("typename")&""
else
response.write "产品展示栏目"
end if
%>
您当前的位置: 首页
> 我要采购
> 查看供应信息
> <%
sorttype="select class_2.typeid,class_2.typename,class_1.* from class_2,class_1 where class_2.typeid="&typeid&" and class_1.sortid=class_2.sortid"
set rssorttype=conn.execute(sorttype)
if not rssorttype.eof then
sortname = rssorttype("sort")
sorttypename = rssorttype("typename")
response.write""&rssorttype("sort")&""
response.write" > "
response.write""&rssorttype("typename")&""
else
response.write "产品展示栏目"
end if
%>