?? 指定生成的客戶資料.asp
字號:
<!--#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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -