<!--#include file="../conn.asp"-->
<!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" />
<style type="text/css">
.tablelist_12 td{border:solid 1px #E0E0E0; border-right:none;}
</style>
</head>

<body>
<div class="bodyDiv">
<!--#include file="rent_top.asp"-->
<!--#include file="model_daohang.asp"-->
<table width="100%" height="111" border="0" cellpadding="0" cellspacing="0">
    <tr>
     <td valign="top">
       <table width="100%" height="160" border="0" cellpadding="0" cellspacing="0" background="img/2008-1-27-4.jpg">
         <tr>
           <td>
           <table width="800" height="240" border="0" align="center" cellpadding="0" cellspacing="0">
         <tr>
           <td height="60"><img src="img/2008-1-27-5.jpg" width="396" height="23" /></td>
         </tr>
         <tr>
           <td height="180" valign="top"><table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#CAD7E0">
             <tr style="font-weight:bold; text-align:center;">
               <td height="21" bgcolor="#E7ECF0">城市</td>
               <td bgcolor="#E7ECF0">门店名称</td>
               <td bgcolor="#E7ECF0">门店图片</td>
               <td bgcolor="#E7ECF0">办公地址</td>
               <td bgcolor="#E7ECF0">停车场地址</td>
               <td bgcolor="#E7ECF0">电话</td>
               <td bgcolor="#E7ECF0">乘车路线</td>
               <td bgcolor="#E7ECF0">备注</td>
             </tr>
             <%
			 id = 0
			 if request.form("select") <> "" then id = request.form("select")
			 
              set rs_uuu = server.CreateObject("adodb.recordset")
			  rs_uuu.open "select * from rent_qucheShop where parentId = "& request.form("select") &" order by id desc",conn,1,1
			  i = 1
			  do while not rs_uuu.eof
             %>
             <tr <%if i mod 2 = 0 then response.write "bgcolor='#FDFDF3'" else response.write "bgcolor='#FFFFFF'"%>>
               <td><%=getCity(id)%></td>
               <td><%=rs_uuu("shopName")%></td>
               <td><%if rs_uuu("shopImg") <> "" then%><img src="<%=rs_uuu("shopImg")%>" width="100" alt="" /><%end if%></td>
               <td><%=rs_uuu("shopAddr")%></td>
               <td><%=rs_uuu("shopCarAddr")%></td>
               <td><%=rs_uuu("shopTel")%></td>
               <td><%=rs_uuu("shopBus")%></td>
               <td><%=rs_uuu("beizhu")%></td>
             </tr>
             <%
			 i = i + 1
			 rs_uuu.movenext
			  loop
			  
			  rs_uuu.close
			  set rs_uuu = nothing
			 %>
           </table></td>
           </tr>
       </table>
           </td>
         </tr>
       </table>

       </td>
    </tr>
</table>
<!--#include file="../model_bottom.asp"-->
</div>
</body>
</html>
<%
'获得城市名称
function getCity(idd)
	dim rs_uuur, tm
	set rs_uuur = server.CreateObject("adodb.recordset")
	rs_uuur.open "select * from rent_qucheCity where id ="& idd &"",conn,1,1
	if not rs_uuur.eof then
		tm = rs_uuur("name1")
	else
		tm = "未知城市"
	end if
	rs_uuur.close
	set rs_uuur = nothing
	getCity = tm
end function
%>