| |
|
上海异型钢管有限公司 |
|
上海浦东民夏路100号邮编:201209
TEL: 58633138(总机) FAX: 58634328
................................................................................................................................
SHANHAI SHAPED STEEL TUBE CO., LTD,
100 MINXIA ROAD , PUDONG, SHANGHAI
TEL: 58633138 FAX: 58634328
|
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
| |
| 上海异型钢管有限公司销售部 |
|
上海中山南二路777号1号楼5F邮编:200032
TEL: 54253808,64867788 FAX: 54253443 ................................................................................................................................
SHANHAI SHAPED STEEL TUBE CO., LTD,SALES DEPARTMENT
BUILDING 1, 777, ZHONGSHAN ROAD (S,2), SHANGHAI
TEL: 54253808,64867788 FAX: 54253443
E-MAIL: SSST@YSST.COM |
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
| |
|
上海异型钢管有限公司莘庄分公司 |
|
上海黎安路858号
TEL: 64880143
................................................................................................................................
SHANHAI SHAPED STEEL TUBE CO., LTD,XINZHUANG BRANCH
858 LI AN ROAD, SHANGHAI
TEL: 64880143 |
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
|
| |
| 上海异型钢管有限公司焊接分公司 |
|
上海浦东民夏路100号邮编:201209
TEL: 58633138(总机) FAX: 58634328
................................................................................................................................
SHANHAI SHAPED STEEL TUBE CO., LTD,
100 MINXIA ROAD , PUDONG, SHANGHAI
TEL: 58633138 FAX: 58634328 |
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
| >返回首页< |
|
|
|