 鲁 食 资 讯 |
|
| 颜氏新闻>> |
活动喜报>> |
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='颜氏新闻' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='活动喜报' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
|
|
|
| 美食快报>> |
行业新闻>> |
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='美食快报' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='行业新闻' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
|
|
|
|
|
| 鲁
食 名 家 |
|
|
| 大师专题>> |
厨艺交流 赛事传真>> |
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='大师专题' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='厨艺交流' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
|
|
|
| 名
菜 名 店 |
|
|
| 名菜推荐>> |
名店推荐>> |
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='名菜推荐' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where BigClassName='名店推荐' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
|
<%i=0
do while not rs_news.eof%>
|
|
|
<%rs_news.movenext
i=i+1
if i=5 then exit do
loop
rs_news.close %>
|
|
|
|
|
|
|
|
| 菜
品 列 表 |
<%i=1
set rs_Product=server.createobject("adodb.recordset")
sqltext="select top 15 * from Product where Passed=True And Elite=True And BigClassName = '鲁菜' order by UpdateTime desc"
rs_Product.open sqltext,conn,1,1
%>
|
|
菜品名称 |
规格 |
单位 |
备注 |
<%
do while not rs_Product.eof
%>
<% if i mod 2 =0 then%>
<% else %>
<% end if %>
| " target="_blank"><%=cutstr(rs_Product("Title"),15)%> |
<%=cutstr(rs_Product("Spec"),6)%> |
<%=rs_Product("Unit")%> |
<%=cutstr(rs_Product("Memo"),16)%> |
<%
i=i+1
rs_Product.movenext
loop
rs_Product.close
%>
|
|
|
| |
|
|
