%
Function Get_SEO_chanpin_title()
'网站产品列表页SEO_chanpin_title调用
Dim chanpin_title
set rs_name = Server.CreateObject("ADODB.RecordSet")
sql_name="select * from CM_SEO_L"
rs_name.open sql_name, conn,1,1
if not rs_name.eof and not rs_name.bof then
chanpin_title=rs_name("SEO_chanpin_title")
else
chanpin_title=""
end if
rs_name.close
set rs_name=nothing
If chanpin_title = "" then
Get_SEO_chanpin_title = "产品超市|"& get_title
Else
Get_SEO_chanpin_title = chanpin_title
End if
End Function
Function Get_SEO_chanpin_description()
'网站产品列表页SEO_chanpin_description调用
Dim chanpin_description
set rs_name = Server.CreateObject("ADODB.RecordSet")
sql_name="select * from CM_SEO_L"
rs_name.open sql_name, conn,1,1
if not rs_name.eof and not rs_name.bof then
chanpin_description=rs_name("SEO_chanpin_description")
else
chanpin_description=""
end if
rs_name.close
set rs_name=nothing
If chanpin_description = "" then
Get_SEO_chanpin_description = "产品超市|"& get_description
Else
Get_SEO_chanpin_description = chanpin_description
End if
End Function
Function Get_SEO_chanpin_keywords()
'网站产品列表页SEO_chanpin_keywords调用
Dim chanpin_keywords_2
set rs_name = Server.CreateObject("ADODB.RecordSet")
sql_name="select * from CM_SEO_L"
rs_name.open sql_name, conn,1,1
if not rs_name.eof and not rs_name.bof then
chanpin_keywords_2 = rs_name("SEO_chanpin_keywords_2")
else
chanpin_keywords_2 = ""
end if
If chanpin_keywords_2 = "" then
Get_SEO_chanpin_keywords = "产品超市|"& get_keywords
Else
If rs_name("SEO_chanpin_keywords_1") = 1 then
chanpin_keywords_2 = get_keywords & "," & chanpin_keywords_2
End If
Get_SEO_chanpin_keywords = chanpin_keywords_2
End if
rs_name.close
set rs_name=nothing
End Function
%>
<%
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
Set Rs_chanpin = Server.CreateObject("ADODB.RecordSet")
if request("xx_chanpin_class_id")=1 then
Rs_chanpin.open " select * from xx_chanpin_content where xx_chanpin_content_class not in (2,17,18) and xx_chanpin_content_xianshi = 1 and xx_chanpin_content_shenhe = 1 order by xx_chanpin_content_paixu asc,xx_chanpin_content_date desc ",conn,1,1
else
Rs_chanpin.open " select * from xx_chanpin_content where (xx_chanpin_content_class = "& CheckStr(request("xx_chanpin_class_id")) &" or xx_chanpin_content_class in (select xx_chanpin_class_id from xx_chanpin_class where xx_chanpin_class_sj = "& CheckStr(request("xx_chanpin_class_id")) &")) and xx_chanpin_content_xianshi = 1 and xx_chanpin_content_shenhe = 1 order by xx_chanpin_content_paixu asc,xx_chanpin_content_date desc ",conn,1,1
end if
Rs_chanpin.Pagesize=15
Pagesize=Rs_chanpin.Pagesize
Allrecord=Rs_chanpin.Recordcount
Allpage=Rs_chanpin.Pagecount
if ThisPage<1 then
ThisPage=1
end if
On Error Resume Next
Rs_chanpin.move (ThisPage-1)*Pagesize
k=0
If Not Rs_chanpin.bof And Not Rs_chanpin.eof Then
Do while Not Rs_chanpin.eof
%>
<%
k=k+1
Rs_chanpin.Movenext
if k>=Pagesize then exit do
Loop
End If
%>
<%
if ThisPage<2 then
response.write "首页 "
response.write "上一页 "
else
response.write "首页 "
response.write "上一页 "
end if
if Allpage-ThisPage<1 then
response.write "下一页 "
response.write "尾页 "
else
response.write "下一页 "
response.write "尾页 "
end if
%>
<%
Rs_chanpin.close
Set Rs_chanpin = Nothing
%>