<!--#include file="conn.asp"-->
<!--#include file="session.asp"-->
<%Response.Buffer = True 
response.ContentType ="Application/msword" %>
<table width="100%" height="0" border="0" cellpadding="0" cellspacing="0" align=center>
  <tr>
    <td align="center" valign="top">
    <table width="100%" height="37" border="0" cellpadding="0" bgcolor="#666666" style="border-collapse: collapse">
      <tr align="center">
        <td width="970" height="30" colspan="8" bgcolor="#FFFFFF">
			<p align="center">
			<font color="#3131CE">
			<span style="font-size: 11pt; font-weight: 700; letter-spacing: 6pt">
			SMS-GIS客戶信息列表</span></font></td>
      </tr>
      <tr align="center">
        <td width="56" height="30"><font color="#FFFFFF">
		<span style="font-size: 10pt">序號</span></font></td>
        <td width="102"><font color="#FFFFFF"><span style="font-size: 10pt">姓 名</span></font></td>
        <td width="132"><font color="#FFFFFF"><span style="font-size: 10pt">生 日</span></font></td>
        <td width="158"><font color="#FFFFFF"><span style="font-size: 10pt">移動電話</span></font></td>
        <td width="106"><font color="#FFFFFF"><span style="font-size: 10pt">公司電話</span></font></td>
        <td width="100"><font color="#FFFFFF"><span style="font-size: 10pt">傳 真</span></font></td>
        <td width="180"><font color="#FFFFFF"><span style="font-size: 10pt">公司名稱</span></font></td>
        <td width="136"><font color="#FFFFFF"><span style="font-size: 10pt">公司網頁</span></font></td>
      </tr>
<%
set rs=server.createobject("adodb.recordset")
keyword=request.form("keyword")
leibie=request.form("leibie")
if keyword="" then
keyword=request("keyword")
end if

if leibie="0"then
sql="SELECT * from address_book where full_name like '%"&keyword&"%' or mobile_tel like '%"&keyword&"%'" 
end if
if leibie="1" then
sql="SELECT * from address_book where full_name like '%"&keyword&"%'" 
end if
if leibie="2" then
sql="SELECT * from address_book where mobile_tel like '%"&keyword&"%'" 
end if

rs.Open sql,conn,1,1
do while not rs.EOF
%>      
      <tr align="center">
        <td width="56" bgcolor="#FFFFFF" height="35"><span style="font-size: 9pt"><%=rs("person_sn")%></span></td>
        <td width="102" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("full_name")%></span></td>
        <td width="132" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("birthday")%></span></td>
        <td width="158" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("mobile_tel")%></span></td>
        <td width="106" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("business_tel")%></span></td>
        <td width="100" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("business_fax")%></span></td>
        <td width="180" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("company")%></span></td>
        <td width="136" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("corp_web")%></span></td>
      </tr>
<%rs.movenext
			 loop
			 rs.close
			 set rs = nothing
			 %>
    </table>
</td>
  </tr>
</table>
</body>
</html>