📄 khinfo.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../Connections/sell.asp" -->
<%
if Request.Form("khname")<>"" then
'判断用户输入的客户信息是否存在
set rs=server.CreateObject("ADODB.RecordSet")
sql="SELECT khname FROM dbo.tab_customer WHERE khname='"&Request.Form("khname")&"'"
set rs=conn.execute(sql)
khname=request.Form("khname")
khjc=request.Form("khjc")
address=request.Form("address")
postcode=request.Form("postcode")
tel=request.Form("tel")
fax=request.Form("fax")
lxr=request.Form("lxr")
lxrtel=request.Form("lxrtel")
email=request.Form("email")
khyh=request.Form("khyh")
yhzh=request.Form("yhzh")
if rs.eof then '保存客户信息
sql_Ins="Insert into dbo.tab_customer (khname,khjc,address,postcode,tel,fax,lxr,"&_
"lxrtel,email,khyh,yhzh) values('"&khname&"','"&khjc&"','"&address&"','"&postcode&_
"','"&tel&"','"&fax&"','"&lxr&"','"&lxrtel&"','"&email&"','"&khyh&"','"&yhzh&"')"
conn.execute(sql_Ins)
response.Write("<script language='javascript'>")
response.Write("alert("""&"数据保存成功！"&""");")
response.Write("</script>")%>
<%else%>
<script language="javascript">
alert("该客户信息已经存在！");
history.back();
</script>
<% end if
end if%>
<html>
<head>
<title>明日企业网上销售管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style.css" rel="stylesheet">
<script language="javascript">
function check()
{
if (form1.khname.value=="")
{ alert("您没有输入客户全称！");form1.khname.focus();
return;}
if (form1.address.value=="")
{alert("请输入地址！");form1.address.focus();return;}
if(form1.Email.value!="")
{if(form1.Email.value.indexOf('@',0)==-1||
form1.Email.value.indexOf('.',0)==-1)
{alert("您输入的E-mail地址无效！");form1.Email.focus();return;}
}
if (form1.tel.value=="")
{alert("请输入电话！");form1.tel.focus();return;}
if (form1.lxr.value=="")
{alert("请输入联系人姓名！");form1.lxr.focus();return;}
form1.submit();}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" background="../../images/bg.gif">
<table width="590" border="0" cellspacing="-2" cellpadding="-2" height="311">
<tr>
<td height="40">
<h2 style="filter:glow(color=#ccccff,strength=5);height:1pt"
align="center"><font size="2" color=#000099>
客户信息登记</font></h2>
</td>
</tr>
<tr>
<td valign="top">
<table width="590" border="0" cellspacing="-2" cellpadding="-2" height="191">
<tr>
<td width="117"> </td>
<td width="473"><font color="#00CCFF">注：带*号项必须填写。</font></td>
</tr>
<tr>
<td colspan="2">
<form method="POST" action="khinfo.asp" name="form1">
<table align="center" width="358">
<tr valign="baseline">
<td nowrap align="right">
<div align="left">客户全称：</div>
</td>
<td>
<input type="text" name="khname" value="" size="32">
<font color="#00CCFF"> *</font> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">客户简称：</div>
</td>
<td>
<input type="text" name="khjc" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">地 址：</div>
</td>
<td>
<input type="text" name="address" value="" size="32">
<font color="#00CCFF">*</font> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">邮政编码：</div>
</td>
<td>
<input type="text" name="postcode" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">电 话：</div>
</td>
<td>
<input type="text" name="tel" value="" size="32">
<font color="#00CCFF">*</font> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">传 真：</div>
</td>
<td>
<input type="text" name="fax" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">联 系 人：</div>
</td>
<td>
<input type="text" name="lxr" value="" size="32">
<font color="#00CCFF">*</font> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">联系人电话：</div>
</td>
<td>
<input type="text" name="lxrtel" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">E-Mail：</div>
</td>
<td>
<input type="text" name="Email" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">开户银行：</div>
</td>
<td>
<input type="text" name="khyh" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">
<div align="left">银行帐号：</div>
</td>
<td>
<input type="text" name="yhzh" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right" colspan="2">
<div align="center">
<input type="button" value="保存信息" name="Button" onclick="check()">
<input type="reset" name="Reset" value="清除重置">
</div>
</td>
</tr>
</table>
</form>
<p> </p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -