<!--#include file="pysjzx_conn.asp"-->
<!--#include file="session.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预约留言</title>
<LINK href="../css/style.css" rel=stylesheet type=text/css>
</head>
<%
id=request.QueryString("id")
 if request.QueryString("action")="modify" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [order] where  id="&id,conn,1,3
rs("estate")=int(request("estate"))
rs.update
response.write "<script language=javascript>alert('修改成功！');window.location.href='order.asp?id="&id&"';</script>"
response.End
end if
%>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [order] where id="&id,conn,1,1%>
	<div align="right">
	<table cellSpacing="1" cellPadding="3" width="99%" border="1" id="table9" style="border-collapse: collapse" bordercolor="#C0C0C0">
<form name="myform" method="post" action="order.asp?action=modify&id=<%=id%>">
  <tr height=25> 
	<td class="tableHeaderText" colspan=2 height=20 bgcolor="#E8F1FF">
<p align="center"><b>预约管理</b></td>	
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">车型：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" > <%set rs2=server.CreateObject("adodb.recordset")
		   rs2.open "select  *  from [price]  where id="&rs("priceid")&" order by adddate desc  ",conn,1,1
 response.write rs2("model")
 rs2.close
 set rs2=nothing
  %></td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">客户姓名：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("name")%>　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">性别：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("sex")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">电话：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("tel")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">地区：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%set rs2=server.createobject("adodb.recordset")
									rs2.open "select * from province where shengNo="&rs("province"),conn,1,1
									if rs2.recordcount>0 then
									response.write rs2("shengname")
									shengid=rs2("id")
									else
									response.write "不限"
									end if
									rs2.close
									%>
									<%set rs2=server.createobject("adodb.recordset")
									rs2.open "select * from city where shengid="&shengid&" and shiNo="&rs("city")&"",conn,1,1
									if rs2.recordcount>0 then
									response.write "-"&rs2("shiname")
									end if
									rs2.close
									%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">车辆颜色：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("color")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">Email：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("email")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">购买意向</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("buydate")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">即时通讯：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%if rs("contract2") <>"" then
						if rs("contract")="qq" then
						response.write "QQ:"
						else
						response.write"MNS:"
						end if
						response.write rs("contract2")
						end if%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" bgcolor="#F7F7F7" >
    <p align="right">其他：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("content")%>
	　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" valign="top" bgcolor="#F7F7F7" >
    <p align="right">发布日期：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" ><%=rs("adddate")%>　</td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="22%" valign="top" bgcolor="#F7F7F7" >
    <p align="right">是否阅读：</td>
   <td class="forumRowHighlight" width="75%" bgcolor="#F7F7F7" >
	<select class="wenbenkuang" name="estate">
	<option value="1" <%if rs("estate")=1 then%> selected <%end if%>>已阅</option>
	<option value="0" <%if rs("estate")=0 then%> selected <%end if%>>未阅</option>
	</select></td>
  </tr>
  <tr>
   <td class="forumRowHighlight" width="98%" colspan="2" bgcolor="#F7F7F7" >
    <p align="center">
    <input type=submit value="提交"> <input type=reset value="重设">　</td>
  </tr>
</table>
	</div>
</td>
</form>
</tr>
</table>