<!--#include file="../conn.asp"-->
<!--#include file="left_login.asp"-->
<%set rsst = server.CreateObject("adodb.recordset")%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>团购信息</title>
<link href="/css/comm.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/comm.js"></script>
<script language="javascript">
var img1 = new Image();
img1.src = "/images/xinwenhuod2.gif";	//黑的最新活动
var img2 = new Image();
img2.src = "/images/xinredian2.gif";		//红的热点新闻

/*最新动态鼠标上移事件*/
function zuixinover()
{
	showOb("zuixin");
	hiddenOb("redian");
	zuixindt.src = "/images/xinwenhuod.gif";		//红的最新活动
	xinwenrd.src = "/images/xinredian.gif";		//黑的热点新闻
}

/*热点新闻鼠标上移事件*/
function redianover()
{
	showOb("redian");
	hiddenOb("zuixin");
	zuixindt.src = img1.src;					//黑的最新活动
	xinwenrd.src = img2.src;					//红的热点新闻
}
</script>
<style type="text/css">
.jieduan{ overflow:hidden; text-overflow:ellipsis; width:70px; white-space:nowrap;}
.car_biaoti {font-size:14px; color:#3b393a; text-decoration:none;}
.car_biaoti a:link{font-size:14px; color:#3b393a; text-decoration:none;}
.car_biaoti a:visited{font-size:14px; color:#3b393a; text-decoration:none;}
.car_biaoti a:hover{font-size:14px; color:#3b393a; text-decoration:underline;}
.car_biaoti a:active{font-size:14px; color:#3b393a; text-decoration:none;}
</style>
</head>

<body>
<div class="bodyDiv">
	<!--#include file="tuangou_top.asp"-->
	<!--#include file="daohang.asp"-->
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="267" valign="top" style="background-image:url(/images/leftbg.gif);">
		<%if session("userId23") = "" then call loginCon() else call logined()%>
		<!--#include file="model_paihang.asp"-->
        <br />
        <!--#include file="model_bidu.asp"--><br />
        <!--#include file="model_liucheng.asp"--><br />
        <!--#include file="model_shili.asp"--></td>
        <td valign="top" width="22">　</td>
        <td valign="top">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="37%" align="center">
			<div style="margin-top:5px; margin-left:auto;margin-right:auto;">
			<iframe name="imgFrame" id="imgFrame" src="/defaultImgNews/index.asp" width="216" height="161" marginheight="0" marginwidth="0" frameborder="0"></iframe>
			</div>
			</td>
            <td width="63%" rowspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="19%"><img name="zuixindt" src="/images/xinwenhuod.gif" width="75" height="34" onMouseOver="zuixinover()"  style="cursor:pointer;" /></td>
                <td width="19%"><img name="xinwenrd" src="/images/xinredian.gif" width="75" height="34" onMouseOver="redianover()"  style="cursor:pointer;" /></td>
                <td width="62%" align="right" valign="bottom" background="/images/xinwenbg.gif" class="moren"><a href="news_tuangou.asp?smallClass=&amp;bigClass=12">更多信息&gt;&gt;</a></td>
              </tr>
            </table>
            <div id="zuixin">
              <table width="100%" border="0" cellspacing="0" cellpadding="5" class="tabledot">
              <%
			  rs.open "select top 6 * from article where Nclassid = 14 order by articleid desc",conn,1,1
			  do while not rs.eof
			  %>
                <tr>
                  <td width="4%" style="padding:0"><img src="/images/xinwenjt.gif" width="15" height="11" /></td>
                  <td width="69%" style="padding-left:0;" class="moren"><div style="width:264px; overflow:hidden; text-overflow:ellipsis; white-space:nowrap;"><%="<a href='/viewNews.asp?id="& rs("articleid") &"' target='_blank'>"& rs("title")&"</a>"%></div></td>
                  <td width="27%"><%=rs("dateandtime")%></td>
                </tr>
                <%
				rs.movenext
				loop
				rs.close
				%>
              </table>
             </div>
              <div id="redian" style="display:none;">
              <table width="100%" border="0" cellspacing="0" cellpadding="5" class="tabledot">
            <%
			  rs.open "select top 6 * from article where Nclassid = 15 order by articleid desc",conn,1,1
			  do while not rs.eof
			  %>
                <tr>
                  <td width="4%" style="padding:0"><img src="/images/xinwenjt.gif" width="15" height="11" /></td>
                  <td width="69%" style="padding-left:0;" class="moren"><div style="width:264px; overflow:hidden; text-overflow:ellipsis; white-space:nowrap;"><%="<a href='/viewNews.asp?id="& rs("articleid") &"' target='_blank'>"&rs("title")&"</a>"%></div></td>
                  <td width="27%"><%=rs("dateandtime")%></td>
                </tr>
                <%
				rs.movenext
				loop
				rs.close
				%>
              </table>
             </div>
            </td>
          </tr>
          <tr>
            <td height="51" align="center"><a href="../user_main.asp" onFocus="this.blur()"><img src="/img/yaotuangou.jpg" width="102" height="31" border="0" /></a>&nbsp;<a href="../user_main.asp" onFocus="this.blur()"><img src="/img/faqituangou.jpg" width="102" height="31" border="0" /></a></td>
          </tr>
        </table>
        
        <table width="100%" height="116" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="27" colspan="2"><div style="width:603px; height:20px; line-height:20px; background-image:url(img/Snap20.jpg);"><span style="margin-left:20px; color:#FFFFFF;">上牌地点|</span><span style="margin-left:100px; color:#FFFFFF;">上牌号码</span></div></td>
          </tr>
          <tr>
            <td width="47%" valign="top">
            <div style="width:304px; border:solid 1px #FFCC33; margin-left:10px;">
            <table width="100%" border="0" cellspacing="0" cellpadding="3">
              <%
			  set rs_jjj = server.CreateObject("adodb.recordset")
			  rs_jjj.open "select * from tuangou_paizhao order by id asc",conn,1,1
			  do while not rs_jjj.eof
			  %>
              <tr>
                <td width="51" style="border-right:solid 1px #FFCC33;"><div style="width:50px;"><div style="border-bottom:solid 1px #FFCC33; text-align:center; padding:5px 0;"><%=rs_jjj("didian")%></div></div></td>
                <td width="75"><div style="width:75px;"><div style="border-bottom:solid 1px #FFCC33; text-align:center; padding:5px 0;"><%=rs_jjj("haoma1")%></div></div></td>
                <td width="75"><div style="width:75px;">
                  <div style="border-bottom:solid 1px #FFCC33; text-align:center; padding:5px 0;"><%=rs_jjj("haoma2")%></div>
                </div></td>
                <td width="79"><div style="width:75px;">
                  <div style="border-bottom:solid 1px #FFCC33; text-align:center; padding:5px 0;"><%=rs_jjj("haoma3")%></div>
                </div></td>
              </tr>
              <%
			  rs_jjj.movenext
			  loop
			  rs_jjj.close
			  set rs_jjj = nothing
			  %>
            </table>
            </div>
            </td>
            <td width="53%" valign="top">
            <div style="margin-left:10px;">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td style="line-height:150%; color:#626262;">&nbsp;&nbsp;&nbsp;&nbsp;为响应网友的需求，莆田二手车网2010年各大品牌4S店签订全年团购协议，将不定期的举行各大汽车品牌团购，团购车型将从报名人数最多的几款品牌中选取，我们的服务承诺是：比您的价格更低，服务更好。</td>
              </tr>
              <tr>
                <td><img src="img/Snap21.jpg" width="293" height="30" /></td>
              </tr>
              <tr>
                <td><img src="img/Snap22.jpg" width="294" height="47" /></td>
              </tr>
            </table>
            </div>
            </td>
          </tr>
        </table>
        <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#dad8db" style="border:solid 1px #cfb6a2; margin-top:20px;">
          <tr>
            <td height="36" bgcolor="#FFFFFF" style="color:#6e5c50; padding-left:10px; font-size:14px; font-weight:bold;">团购品牌</td>
          </tr>
         
          <tr>
            <td bgcolor="#f6f5f1">
             <%
		  set rs_tt = server.CreateObject("adodb.recordset")
		  rs_tt.open "select top 12 pinpaiImg,sort1,sort2,id from tuangouCar where ifshenhe='yes'",conn,1,1
		  i = 1
		  do while not rs_tt.eof
		  %>
            <div style="float:left; width:205px; border-right:solid 1px #d9d9db;">
              <table width="100%" border="0" cellpadding="5" cellspacing="0">
                <tr>
                  <td colspan="2" style="border-bottom:solid 1px #dad8db; background-color:#ecf4f6; font-size:14px;" class="car_biaoti"><%="<a href='viewCar.asp?id="& rs_tt("id") &"&sort2="& rs_tt("sort2") &"&sort1="& rs_tt("sort1") &"'>"& getSortNameById(rs_tt("sort2")) &"</a>"%></td>
                </tr>
                <tr>
                  <td width="63"><a href="viewCar.asp?id=<%=rs_tt("id")%>&sort2=<%=rs_tt("sort2")%>&sort1=<%=rs_tt("sort1")%>"><img src="<%if rs_tt("pinpaiImg")<>"" then response.write "/"& rs_tt("pinpaiImg") &"" else response.write "/smallimg/pinpaiImg/noimg.jpg"%>" width="63" border=0  /></a></td>
                  <td width="122" valign="top" class="moren">
				<%
				set rs_last = server.CreateObject("adodb.recordset")
				  rs_last.open "SELECT sum(carNum) AS carNum1, sort3 FROM tuangou_tongji WHERE sort2="& rs_tt("sort2") &" GROUP BY sort3",conn,1,1
				  
				  do while not rs_last.eof
					response.write "<div><a href='viewCar.asp?id="& rs_tt("id") &"&sort2="& rs_tt("sort2") &"&sort1="& rs_tt("sort1") &"&sort3="&  rs_last("sort3") &"'>"&getSortNameById(rs_last("sort3"))&"</a>("&rs_last("carNum1")&")人&nbsp;<a href='viewCar.asp?id="& rs_tt("id") &"&sort2="& rs_tt("sort2") &"&sort1="& rs_tt("sort1") &"&sort3="&  rs_last("sort3") &"'>报名</a></div>"
				  rs_last.movenext
				  loop
				  
				  rs_last.close
				  set rs_last = nothing%></td>
                </tr>
              </table>
            </div>
            
            <%
			if i mod 3 = 0 then response.write "<div style='clear:both;'></div>"
		  i = i + 1
		  rs_tt.movenext
		  loop
		  rs_tt.close
		  set rs_tt = nothing
		  %>
              </td>
          </tr>
          
        </table></td>
      </tr>
  </table>
<!--#include file="../model_bottom.asp"-->
</div>
</body>
</html>
<%
'=============================
'功能：根据ID号获得sortName
function getSortNameById(iddd)
	if iddd = "" then
		getSortNameById = "未定义"
	else
		set rs_1232456 = conn.execute("select sortName from carSort where id="& iddd &"")
		if rs_1232456.eof then 
			getSortNameById = "未定义"
		else
			getSortNameById = rs_1232456("sortName")
		end if
		set rs_1232456 = nothing
	end if
end function
%>