?? edi.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="session.asp"-->
<HTML><HEAD><title>客戶資料編輯息---SMS-GIS管理系統</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK href="img/css.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #EEEEEE;
}
-->
</style>
<center>
<%if request.Form("sub")="sub" then
person_sn=request.Form("person_sn")
full_name=request.Form("full_name")
birthday=request.Form("birthday")
mobile_tel=request.Form("mobile_tel")
business_tel=request.Form("business_tel")
business_fax=request.Form("business_fax")
company=request.Form("company")
corp_web=request.Form("corp_web")
set rs=server.CreateObject("adodb.recordset")
sql="select * from address_book where person_sn="&person_sn
rs.open sql,conn,3,3
rs("person_sn")=person_sn
rs("full_name")=full_name
rs("birthday")=birthday
rs("mobile_tel")=mobile_tel
rs("business_tel")=business_tel
rs("business_fax")=business_fax
rs("company")=company
rs("corp_web")=corp_web
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "<SCRIPT language=JavaScript>alert('編輯成功！');"
response.write "this.location.href='kehu.asp';</SCRIPT>"
response.End()
end if
%>
<%person_sn=cint(request.QueryString("person_sn"))
if person_sn<>"" then
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from address_book where person_sn="&person_sn
rs2.open sql2,conn,1,1%>
<!--#include file="top.asp"-->
<table width="720" height="243" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top" bgcolor="#F9F9F9"><form name="form1" method="post" action="edi.asp">
<table width="449" height="219" border="0" cellpadding="0" cellspacing="1" bgcolor="#666666">
<tr align="center">
<td colspan="2" height="45" style="background-color: #D4D0C8">
<font color="#0066CC" style="font-size: 9pt"><b>編 輯 客 戶 資 料</b></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="117" align="center" height="30"><span style="font-size: 9pt">序 號:</span></td>
<td width="329">
<span style="font-size: 9pt">
<input name="person_sn" type="text" id="rdata0" size="20" value="<%=rs2("person_sn")%>"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="117" align="center" bgcolor="#CCCCCC" height="30">
<span style="font-size: 9pt">客 戶 姓 名:</span></td>
<td width="329" bgcolor="#CCCCCC">
<span style="font-size: 9pt">
<input name="full_name" type="text" id="rdata" size="20" value="<%=rs2("full_name")%>"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="117" align="center" height="30"><span style="font-size: 9pt">客 戶 生 日:</span></td>
<td width="329">
<span style="font-size: 9pt">
<input name="birthday" type="text" id="name" size="25" value="<%=rs2("birthday")%>"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="117" align="center" bgcolor="#CCCCCC" height="30">
<span style="font-size: 9pt">移 動 電 話:</span></td>
<td width="329" bgcolor="#CCCCCC">
<span style="font-size: 9pt">
<input name="mobile_tel" type="text" id="tel" size="25" value="<%=rs2("mobile_tel")%>"></span></td>
</tr>
<tr>
<td align="center" height="30"><span style="font-size: 9pt">公 司 電 話:</span></td>
<td>
<span style="font-size: 9pt">
<input name="business_tel" type="text" id="sdizhi" value="<%=rs2("business_tel")%>" size="25"></span></td>
</tr>
<tr bgcolor="#CCCCCC" >
<td align="center" bgcolor="#CCCCCC" height="30">
<span style="font-size: 9pt">公 司 傳 真:</span></td>
<td bgcolor="#CCCCCC">
<span style="font-size: 9pt">
<input name="business_fax" type="text" id="edizhi" value="<%=rs2("business_fax")%>" size="25"></span></td>
</tr>
<tr>
<td align="center" height="30"><span style="font-size: 9pt">公 司 名 稱:</span></td>
<td>
<span style="font-size: 9pt">
<input name="company" type="text" id="gongsi" value="<%=rs2("company")%>" size="25"></span></td>
</tr>
<tr>
<td align="center" height="30" style="background-color: #D7D7D7">
<span style="font-size: 9pt">公 司 網
頁:</span></td>
<td style="background-color: #D7D7D7">
<span style="font-size: 9pt">
<input name="corp_web" type="text" id="beizhu" size="39" value="<%=rs2("corp_web")%>"></span></td>
</tr>
<tr align="center">
<td colspan="2" bgcolor="#F7F7F7" height="40">
<span style="font-size: 9pt">
<input type="submit" name="Submit" value="確定修改">
<input type="reset" name="Submit" value="返回原始值">
<input type="hidden" name="sub" value="sub">
</span>
</td>
</tr>
</table>
<table border="0" width="780" id="table1" cellspacing="0" cellpadding="0">
<tr>
<td height="50" style="background-color: #F7F7F7">
<p align="center"><span style="font-size: 10pt">‖ <a href='javascript:history.back()'><font color="#FF3300">返回</font></a> ‖<font color="#0000FF">
<b> </b></font><b><a href="session_out.asp"><font color="#FF3300">退出系統</font></a>
</b><font color="#0000FF"> </font>‖</span></td>
</tr>
</table>
</form><%end if%></td>
</tr>
</table>
</center>
</body>
</html> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -