📄 gysinfo.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../Connections/sell.asp" -->
<%
if request.Form("gysname")<>"" then
'判断用户输入的供应商信息是否存在
set rs_gys =server.CreateObject("ADODB.RecordSet")
sql_gys="SELECT gysname FROM dbo.tab_supplier WHERE gysname='" &_
request.Form("gysname") & "'"
set rs_gys=conn.execute(sql_gys)
if rs_gys.eof then '保存供应商信息
gysname=Request.Form("gysname")
jc=Request.Form("jc")
address=Request.Form("address")
postcode=Request.Form("postcode")
tel=Request.Form("tel")
fax=Request.Form("fax")
lxr=Request.Form("lxr")
lxrtel=Request.Form("lxrtel")
khyh=Request.Form("khyh")
email=Request.Form("email")
sql_Ins="Insert into dbo.tab_supplier (gysname,jc,address,postcode,tel,fax,lxr,"&_
"lxrtel,khyh,email) values('"&gysname&"','"&jc&"','"&address&"','"&postcode&"','"&_
tel&"','"&fax&"','"&lxr&"','"&lxrtel&"','"&khyh&"','"&email&"')"
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>
<link href="../style.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="../../images/bg.gif">
<script language="javascript">
function check()
{
if (form1.gysname.value=="")
{ alert("请输入供应商全称！");form1.gysname.focus();return;}
if (form1.jc.value=="")
{ alert("请输入简称！");form1.jc.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>
<table width="590" border="0" cellspacing="-2" cellpadding="-2" height="341">
<tr>
<td valign="top">
<table width="590" border="0" cellspacing="-2" cellpadding="-2" height="50">
<tr>
<td>
<h2 style="filter:glow(color=#ccccff,strength=5);height:1pt"align="center">
<font size="2" color=#000099>
供应商信息登记</font></h2>
</td>
</tr>
</table>
<table width="590" border="0" cellspacing="-2" cellpadding="-2" height="234">
<tr>
<td width="104">
<div align="center"></div>
</td>
<td width="486"><font color="#00CCFF">带*号项为必填项。</font></td>
</tr>
<tr>
<td colspan="2">
<form method="POST" action="gysinfo.asp" name="form1">
<table align="center" width="384">
<tr valign="baseline">
<td nowrap align="right">
<div align="left">供应商全称：</div>
</td>
<td>
<input type="text" name="gysname" 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="jc" 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="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">开户银行：</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="email" 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 + -