<!--#include file="include/nowshop.asp" -->
<HTML>
<HEAD>
<TITLE>新闻公告</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="description" content="<%=sitedescription%>">
<meta name="keywords" content="<%=sitekeywords%>">
<LINK href="images/news/style.css" type=text/css rel=stylesheet>
</HEAD>
<center>
<!--#include file="top.asp"-->
  <table width="768" border="0" cellpadding="0" cellspacing="0">
    <tr> 
      <td width="180" align="left" valign="top" background=images/left_bg.gif><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
          <TBODY>
            <TR> 
              <TD><IMG height=22 src="list/zbhz_shopping_car.gif" 
            width=180></TD>
            </TR>
            <TR> 
              <TD bgColor=#fcd8e7><IFRAME border=0 name=new_date11 marginWidth=0 
            marginHeight=0 src="gouwuche.asp" frameBorder=0 
            noResize width=178 scrolling=no height=83 spacing="0" 
            vspale="0"></IFRAME></TD>
            </tr>
            <TR> 
              <TD height=5 bgcolor="#FFFFFF"></TD>
            </tr>
            <TR> 
              <TD background="images/left_bg.gif"><IMG height=20 src="list/pic_fl.gif" 
              width=180></TD>
            </tr>
            <tr> 
              <td> <TABLE align=center cellSpacing=0 cellPadding=0 width=175 border=0>
                  <tr> 
                    <td width=175 colspan=3 height=10 ></td>
                  </tr>
                  <%
color1="77CC00"     '分类列表中大类的颜色
color2="0066ff"     '分类列表中中类的颜色
viewmidclass=1      '是否显示中类，1表示显示，0表示不显示
dim larcode(100)    '最多支持100个大类
dim midcode(20)     '最多支持20个中类

	'以下是分类列表，首先读取全部大类，然后根据每个大类读取各自的中类
	response.write "<table width='175' border='0' align='center' cellpadding=1 cellspacing=1>"
	Dim a,b,c
	sqllar="select Distinct LarCode,LarSeq from bclass order by LarSeq"
	Set rsprodtree=Server.CreateObject("ADODB.RecordSet") 
	rsprodtree.Open sqllar,conn,1,1 

	if rsprodtree.bof and rsprodtree.eof then
		response.write "<tr><td width=175 colspan=3 height=100 align=center>对不起，本商城暂未开业</td></tr>"
	else
		
		i=0
		Do While Not rsprodtree.eof	
		i=i+1
		larcode(i)=rsprodtree("LarCode")
		rsprodtree.movenext	
		if rsprodtree.eof then exit do
		Loop
	end if
	set rsprodtree=nothing
	set sqllar=nothing


	
	FOR t=1 to i
	response.write "<tr><td width='175'  class='dfont' height=25 colspan=3 valign=middle><B>&nbsp;&nbsp;&nbsp;&nbsp;<img src=images/dot.gif  border=0>&nbsp;&nbsp;<a href='class.asp?LarCode="&LarCode(t)&"'>"&LarCode(t)&"</B></a></td></tr>"
	response.write "<tr>"

if viewmidclass<>0 then           '是否显示中类
	'以下是根据前面读取的大类名称，读取各个大类下的中类
	sqllar="select MIDCode,MIDSeq from bclass where larcode='"&larcode(t)&"' order by MIDSeq"
	Set rsprodtree=Server.CreateObject("ADODB.RecordSet") 
	rsprodtree.Open sqllar,conn,1,1 
		m=0
		Do While Not rsprodtree.eof	
		m=m+1
		midcode(m)=rsprodtree("midCode")
		rsprodtree.movenext	
		if rsprodtree.eof then exit do
		Loop

	set rsprodtree=nothing
	set sqllar=nothing

		for n=1 to m
		if n mod 2<>0 then
		response.write "<td width=85 align=right  class='dfont'><a href='class.asp?LarCode="&LarCode(t)&"&MidCode="&MidCode(n)&"'>"&MidCode(n)&"</a></TD>"
		else
		response.write "<td align=center width=5>|</td><td  width=85 class='dfont'><a href='class.asp?LarCode="&LarCode(t)&"&MidCode="&MidCode(n)&"'>"&MidCode(n)&"</a></TD></tr><tr>"
	    end if
		next
			response.write "<tr><td width=175 colspan=3 height=10 ></td></tr>"

end if

	next

%>
                </table></td>
            </tr>
            <TR> 
              <TD bgcolor="#FFFFFF" height=30 valign="middle"><IMG height=25 src="list/pic_tj.gif" 
              width=180></TD>
            </TR>
            <tr> 
              <td> 
                <%
set cqrsprod=conn.execute("select  * from bproduc where online=true order by ClickTimes desc,AddDate desc")
Do While Not cqrsprod.eof
prodname=lleft(cqrsprod("ProdName"),22)
response.write "<tr><td class=td1 height=22>&nbsp;&nbsp;&nbsp;&nbsp;·<a href='list.asp?ProdId="&cqrsprod("ProdId")&"'><font alt='热门商品TOP"&K+1&"'>"&prodname&"</font></a></td></tr>"
k=k+1
if k>renmen_num-1 then exit do
if cqrsprod.eof then exit do
cqrsprod.movenext
loop
set cqrsprod=nothing
%>
              </td>
            </tr>
          </TBODY>
        </TABLE></td>
      <td width="9"></td>
      <td width="579" align="center" valign="top" ><TABLE width=552 
                  border=0 cellPadding=0 cellSpacing=0 bgColor=#f1f1f1>
          <TBODY>
            <TR> 
              <TD bgcolor="#FFFFFF">&nbsp;</TD>
              <TD height=30 bgcolor="#FFFFFF">目前位置：<a href=main.asp>首页</a> > 新闻公告</TD>
              <TD bgcolor="#FFFFFF">&nbsp;</TD>
            </TR>
            <TR> 
              <TD width=10><IMG height=12 
                        src="images/news/com_article_01.gif" width=10></TD>
              <TD width=532 height=12></TD>
              <TD width=10><IMG height=12 
                        src="images/news/com_article_02.gif" width=10></TD>
            </TR>
            <TR> 
              <TD></TD>
              <TD align=middle>
			  <table cellspacing=0 cellpadding=0 width=504 bgcolor=#FFFFFF border=0 class=com_table_zb align="center">
                  <%
dim newstitle(5)
Set rs = conn.Execute("select * from bconfig") 
newstitle(1)=rs("newstitle1")
newstitle(2)=rs("newstitle2")
newstitle(3)=rs("newstitle3")
newstitle(4)=rs("newstitle4")
newstitle(5)=rs("newstitle5")
set rs=nothing
%>
                  <tbody>
                    <%
set rs=conn.execute ("select * from News where online=true and now()<OffDate and now()>=PubDate")
if rs.eof and rs.bof then
response.write "<tr><td height=50 align=center>暂时没有新闻文章</td></tr>"
else

for i=1 to 5
set rs=conn.execute ("select top 10 * from News where online=true and now()<OffDate and now()>=PubDate and NewsClass='"&i&"'  order by uup desc,Pubdate desc")

if newstitle(i)<>"" then
if not (rs.eof and rs.bof) then
%>
                    <tr> 
                      <td width=98%  valign=top> <table border=0  width=165>
                          <tr> 
                            <td width=165 height=28 align=left>&nbsp;&nbsp;&nbsp;&nbsp;<a href='allnews.asp?class=<%=i%>' alt="浏览更多<%=newstitle(i)%>"><B><FONT color=#ff6600><%=newstitle(i)%></font></b></a></td>
                          </tr>
                        </table>
                        <table cellpadding=2 cellspacing=0 border=0  width=95% align=center  class=com_table_zb>
                          <%
	Do while Not rs.eof
	%>
                          <tr> 
                            <td width=55%>&nbsp;&nbsp;&nbsp;&nbsp;<a href="news.asp?NewsId=<%=Cstr(rs("NewsId"))%>"  ><%=lleft(rs("NewsTitle"),40)%></a></td>
                            <td  width=25%><%=rs("PubDate")%></td>
                            <td  width=20%>人气值：<%=rs("cktimes")%></td>
                          </tr>
                          <%
	rs.movenext
	loop
set rs=nothing
%>
                        </table></td>
                    </tr>
                    <tr> 
                      <td height="30" align=right><a href='allnews.asp?class=<%=i%>' alt="浏览更多<%=newstitle(i)%>"><font color="#FF0000">更多内容…</font></a>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    </tr>
                    <%
end if
end if
next
end if
%>
                  </tbody>
                </table> </TD>
              <TD></TD>
            </TR>
            <TR> 
              <TD><IMG height=12 
                        src="images/news/com_article_03.gif" width=10></TD>
              <TD height=12></TD>
              <TD><IMG height=12 
                        src="images/news/com_article_04.gif" 
                    width=10></TD>
            </TR>
          </TBODY>
        </TABLE>
        <table width="552" height="20" border="0" cellpadding="0" cellspacing="0">
          <tr> 
            <td>&nbsp; </td>
          </tr>
        </table></td>
    </tr>
  </table>
      </td>
    </tr>

  </table>
<!--#include file="down.asp"-->
</BODY></CENTER>

</HTML>
<%
conn.close
set conn=nothing
%>
