📄 addtodb.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
dim sclass_folder,sclass,temprs,tempsql
sclass=Request.Form ("sclass")
'--------------------------------------------------------
set temprs=server.createobject("adodb.recordset")
tempsql="select * from sclass where sclass_id = "&sclass&" "
temprs.open tempsql,conn,1,3
'--------------------------------------------------------
sclass_folder=temprs("sclass_folder")
temprs.Close
%>
<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
'--------------------------------------------------------
com_name=Request.Form ("com_name")
com_shen=Request.Form ("com_shen")
com_city=Request.Form ("com_city")
com_diqu=Request.Form ("com_diqu")
com_phone=Request.Form ("com_phone")
com_fax=Request.Form ("com_fax")
com_email=Request.Form ("com_email")
com_address=Request.Form ("com_address")
com_zip=Request.Form ("com_zip")
com_fuzeren=Request.Form ("com_fuzeren")
com_zczj=Request.Form ("com_zczj")
com_setup=Request.Form ("com_setup")
com_touzi=Request.Form ("com_touzi")
com_hangye=Request.Form ("com_hangye")
com_porduct=Request.Form ("com_porduct")
com_chanzhi=Request.Form ("com_chanzhi")
com_rzzk=Request.Form ("com_rzzk")
com_web=Request.Form ("com_web")
zy=Request.Form ("zy")
content=Request.Form ("content")
time=Request.Form ("time")
mclass=Request.Form ("mclass")
sclass=Request.Form ("sclass")
com_kongzhi=session("name")
'--------------------------------------------------------
if com_shen="" then com_shen="未填" end if
if com_city="" then com_city="未填" end if
if com_diqu="" then com_diqu="未填" end if
if com_phone="" then com_phone="未知或无" end if
if com_fax="" then com_fax="未知或无" end if
if com_email="" then com_email="未知或无" end if
if com_address="" then com_address="未填" end if
if com_zip="" then com_zip="未填" end if
if com_fuzeren="" then com_fuzeren="未填" end if
if com_zczj="" then com_zczj="未填" end if
if com_setup="" then com_setup="未填" end if
if com_touzi="" then com_touzi="未填" end if
if com_hangye="" then com_hangye="未填" end if
if com_porduct="" then com_porduct="未填" end if
if com_chanzhi="" then com_chanzhi="未填" end if
if com_rzzk="" then com_rzzk="未填" end if
if com_web="" or com_web="http://" then com_web="未填" end if
if content="" then content="无注释" 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%"> <%=com_name%></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%"> <%=com_shen%></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%"> <%=com_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%"> <%=com_diqu%></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%"> <%=com_phone%></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%"> <%=com_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%"> <%=com_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%">单位地址 </td>
<td width="408" bgcolor="#FFFFFF" height="25" style="font-family: 宋体,'Arial Narrow','Times New Roman'; font-size: 9pt; line-height: 150%"> <%=com_address%></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%"> <%=com_zip%></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%"> <%=com_fuzeren%></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%"> <%=com_zczj%></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%"> <%=com_setup%></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%"> <%=com_touzi%></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%"> <%=com_hangye%></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%"> <%=com_porduct%></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%"> <%=com_chanzhi%></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%"> <%=com_rzzk%></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%"> <%=com_web%></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 "重要"
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%"> <%=sclass_folder%></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%"> <%=com_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 customer where id is null "
rs.open sql,conn,1,3
rs.AddNew
'--------------------------------------------------------
rs("com_name")=com_name
rs("com_shen")=com_shen
rs("com_city")=com_city
rs("com_diqu")=com_diqu
rs("com_phone")=com_phone
rs("com_fax")=com_fax
rs("com_email")=com_email
rs("com_address")=com_address
rs("com_zip")=com_zip
rs("com_fuzeren")=com_fuzeren
rs("com_zczj")=com_zczj
rs("com_setup")=com_setup
rs("com_touzi")=com_touzi
rs("com_hangye")=com_hangye
rs("com_porduct")=com_porduct
rs("com_chanzhi")=com_chanzhi
rs("com_rzzk")=com_rzzk
rs("com_web")=com_web
rs("zy")=zy
rs("com_kongzhi") = com_kongzhi
rs("content")=content
rs("time")=time
rs("vest_s")=sclass
rs("vest_m")=mclass
'--------------------------------------------------------
rs.Update
rs.Close
set rs=nothing
%>
<center> <p><a href="step2.asp?mclass=<%=session("dd")%>"><font size="2" color="#FF0000">
<span style="text-decoration: none">继续添加客户</span></font></a><font size="2" color="#FF0000">
</font><a href="admin.asp"><font size="2" color="#FF0000">
<span style="text-decoration: none">返回主页</span></font></a></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -