📄 add_cust_todb.asp
字号:
<!--#include file="conn.asp" -->
<%
if session("name")="" or session("dd")="" then
response.write "SORRY <br>"
response.write "数据在携带中出现意外！<br>"
response.write "<a href=login.asp target=_top>回去重来</a>"
response.end
end if
if session("quanxian")="1" then
response.write "SORRY <br>"
response.write "您的权限不够！请勿尝试非法访问！<br>"
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>客户管理系统</title>
<%
dim time,city
'--------------------------------------------------------
name=Request.Form ("name")
sex=Request.Form ("sex")
zhiwu=Request.Form ("zhiwu")
company=Request.Form ("company")
mobile=Request.Form ("mobile")
homephone=Request.Form ("homephone")
email=Request.Form ("email")
oicq=Request.Form ("oicq")
city=Request.Form ("city")
msn=Request.Form ("msn")
zy=Request.Form ("zy")
content=Request.Form ("content")
time=Request.Form ("time")
mclass=session("dd")
fax=Request.Form ("fax")
cust_s=Request.Form ("cust_s")
kongzhi=session("name")
'--------------------------------------------------------
dim temprs,tempsql
set temprs=server.createobject("adodb.recordset")
tempsql="select com_phone from customer where id="&cust_s&" and vest_m="&session("dd")
temprs.open tempsql,conn,1,3
com_phone=temprs("com_phone")
set temprs=nothing
'--------------------------------------------------------
if fax ="" then fax ="未填" end if
if mobile ="" then mobile ="未填" end if
if zhiwu ="" then zhiwu ="不详" end if
if homephone="" then homephone=com_phone end if
if city ="" then city ="不详" end if
if email="" then email="未填" end if
if oicq="" then oicq="未填" end if
if msn="" then msn="未填" end if
if content="" then content="无注释" end if
if cust_s="" then
response.write="错误"
response.end
end if
%>
<div align="center">
<div align="center">
<table border="0" width="554" id="table2" cellspacing="0" cellpadding="0">
<tr>
<td style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> </td>
</tr>
<tr>
<td style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
<font color="#FF0000">增加联系人成功!</font></td>
</tr>
<tr>
<td style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> </td>
</tr>
</table>
</div>
<table border="0" width="554" cellspacing="1" cellpadding="0" height="211" bgcolor="#DADADA" id="table1">
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
联系人名 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=name%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
性 别 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%
if sex="0" then
response.write "男"
else
response.write "女"
end if
%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">职
务 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=zhiwu%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
部
门 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=city%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">联系手机 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=mobile%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
固定电话 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=homephone%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
家庭传真 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=fax%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">电子邮件 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=email%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">Oicq </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=oicq%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">MSN </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=msn%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">重要度 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <font color="#FF0000"><%
if zy="0" then
response.write "初步"
end if
if zy="1" then
response.write "一般"
end if
if zy="2" then
response.write "<font color=#FF0000>重要</font>"
end if
%></font></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
所属单位 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=company%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">备注 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=content%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
录入人 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=kongzhi%></td>
</tr>
<tr>
<td width="143" bgcolor="#EBEBEB" height="25" align="right" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%">
录入时间 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=time%></td>
</tr>
</table>
</div>
<%
'--------------------------------------------------------
set rs=server.createobject("adodb.recordset")
sql="select * from cust_user where id is null "
rs.open sql,conn,1,3
rs.AddNew
'--------------------------------------------------------
rs("name")=name
rs("sex")=sex
rs("zhiwu")=zhiwu
rs("city")=city
rs("mobile")=mobile
rs("homephone")=homephone
rs("email")=email
rs("msn")=msn
rs("zy")=zy
rs("fax")=fax
rs("content")=content
rs("time")=time
rs("oicq")=oicq
rs("cust_s")=cust_s
rs("vest_m")=mclass
rs("kongzhi")= kongzhi
'--------------------------------------------------------
rs.Update
rs.Close
set rs=nothing
%>
<center> <p><a href="add_cust.asp?company=<%=company%>&id=<%=cust_s%>&mclass=<%=session("dd")%>&sclass=<%=request("sclass")%>"><font size="2" color="#FF0000">
<span style="text-decoration: none">继续添加联系人</span></font></a><font size="2" color="#FF0000">
</font><a href="c_userlist.asp?mclass=<%=session("dd")%>&cust_s=<%=cust_s%>&sclass=<%=request("sclass")%>"><font size="2" color="#FF0000">
<span style="text-decoration: none">返回客户信息</span></font></a></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -