|
|
<%set rs=server.createobject("adodb.recordset")
btype_id=trim(request("btype_id"))
if btype_id=empty then
response.redirect "index.asp"
end if
page=request.querystring("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
if stype_id<>0 then
sql="select * from shop_product where stype_id="+cstr(stype_id)+" and btype_id="+cstr(btype_id)+" and kucun>0 order by productid desc"
elseif btype_id<>0 then
sql="select * from shop_product where btype_id="+cstr(btype_id)+" and kucun>0 order by productid desc"
else
sql="select * from shop_product and kucun>0 order by productid desc"
end if
if order="time" then
sql="select * from shop_product where btype_id="+cstr(btype_id)+" and kucun>0 order by productid desc"
elseif order="price1" then
sql="select * from shop_product where btype_id="+cstr(btype_id)+" and kucun>0 order by huiyuanjia desc , productid desc"
elseif order="price2" then
sql="select * from shop_product where btype_id="+cstr(btype_id)+" and kucun>0 order by huiyuanjia asc , productid desc"
end if
rs.open sql,conn,3,3
if rs.eof then
response.write "| 产品数据正在收集当中...... | "
else
rs.pagesize=20
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
%>
|
|
手,脚拘束类(pvc)
|
|
|
|
| 编 号：sm419 |
|
优惠价：￥138  订 购 |
|
|
|
|
|
|
| 编 号：sm418 |
|
| 优惠价：￥128 订 购 |
|
|
|
|
|
|
| 编 号：sm390 |
|
| 优惠价：￥168 订 购 |
|
|
|
|
|
|
| 编 号：sm388 |
|
| 优惠价：￥148 订 购 |
|
|
|
|
|
|
| 编 号：sm380 |
|
| 优惠价：￥159 订 购 |
|
|
|
|
|
|
| 编 号：sm376 |
|
| 优惠价：￥90 订 购 |
|
|
|
|
|
|
| 编 号：sm375 |
|
| 优惠价：￥150 订 购 |
|
|
|
|
|
|
| 编 号：sm359 |
|
| 优惠价：￥100 订 购 |
|
|
|
|
|
|
| 编 号：sm356 |
|
| 优惠价：￥68 订 购 |
|
|
|
|
|
|
| 编 号：sm355 |
|
| 优惠价：￥120 订 购 |
|
|
|
|
|
|
| 编 号：sm354 |
|
| 优惠价：￥110 订 购 |
|
|
|
|
|
|
| 编 号：sm353 |
|
| 优惠价：￥118 订 购 |
|
|
|
|
|
|
| 编 号：sm352 |
|
| 优惠价：￥80 订 购 |
|
|
|
|
|
|
| 编 号：sm351 |
|
| 优惠价：￥78 订 购 |
|
|
|
|
|
|
| 编 号：sm350 |
|
| 优惠价：￥69 订 购 |
|
|
|
|
|
|
| 编 号：sm349 |
|
| 优惠价：￥139 订 购 |
|
|
|
|
|
|
| 编 号：sm348 |
|
| 优惠价：￥78 订 购 |
|
|
|
|
|
|
| 编 号：sm347 |
|
| 优惠价：￥69 订 购 |
|
|
|
|
|
705100462
