<%
function TopAffiche()
dim rs,sql,i
set rs = server.createobject("adodb.recordset")
sql="select ID,NewsName"&LangData&",SortID from NwebCn_News where ViewFlag"&LangData&" and NoticeFlag order by id desc"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "暂无相关信息"
end if
for i=1 to 4
if rs.eof then exit for
response.write "·"&rs("NewsName"&LangData)&" "
rs.movenext
next
rs.close
set rs=nothing
end function
function TopNews()
dim rs,sql,i,NewsName,NewFlag
set rs = server.createobject("adodb.recordset")
sql="select ID,NewsName"&LangData&",SortID,AddTime from NwebCn_News where ViewFlag"&LangData&" order by id desc"
rs.open sql,conn,1,1
response.write""
response.write " | "
if rs.bof and rs.eof then
response.write "| 暂无相关信息 | "
else
for i=1 to 6
if rs.eof then exit for
if StrLen(rs("NewsName"&LangData))<=48 then
NewsName=rs("NewsName"&LangData)
else
NewsName=StrLeft(rs("NewsName"&LangData),46)
end if
if now()-rs("AddTime")<=2 then
NewFlag=" "
else
NewFlag=""
end if
response.write"| 4 "&NewsName&""&NewFlag&" | "
rs.movenext
next
end if
response.write " | "
response.write" "
rs.close
set rs=nothing
end function
function TopMessage()
dim rs,sql,i,MesName,NewFlag
set rs = server.createobject("adodb.recordset")
sql="select ID,MesName,AddTime from NwebCn_Message where ViewFlag order by id desc"
rs.open sql,conn,1,1
response.write""
response.write " | "
if rs.bof and rs.eof then
response.write "| 暂无相关信息 | "
else
for i=1 to 6
if rs.eof then exit for
if StrLen(rs("MesName"))<=46 then
MesName=rs("MesName")
else
MesName=StrLeft(rs("MesName"),44)
end if
if now()-rs("AddTime")<=2 then
NewFlag=" "
else
NewFlag=""
end if
response.write"| 4 "&MesName&""&NewFlag&" | "
rs.movenext
next
end if
response.write " | "
response.write" "
rs.close
set rs=nothing
end function
function TopProducts()
dim rs,sql,i,ProductName,SmallPicPath
set rs = server.createobject("adodb.recordset")
sql="select ID,ProductName"&LangData&",SortID,SmallPic,GroupID,Exclusive from NwebCn_Products where ViewFlag"&LangData&" and NewFlag order by id desc"
rs.open sql,conn,1,1
response.write""
response.write " | "
if rs.bof and rs.eof then
response.write "| 暂无相关信息 | "
else
response.write""
for i=1 to 4
if rs.eof then exit for
response.write"| "
if StrLen(rs("ProductName"&LangData))<=20 then
ProductName=rs("ProductName"&LangData)
else
ProductName=StrLeft(rs("ProductName"&LangData),18)
end if
SmallPicPath=HtmlSmallPic(rs("GroupID"),rs("SmallPic"),rs("Exclusive"))
response.write ""
response.write" | "
rs.movenext
next
response.write" "
end if
response.write " "
rs.close
set rs=nothing
end function
%> |