supplysave.asp

相对于流通企业

<% Option Explicit %>
<%Response.Charset="utf-8"%>
<!--#include file="../Include/Const.asp"-->
<!--#include file="../Include/ConnSiteData.asp"-->
<!--#include file="../Include/Function.asp"-->
<%
dim NeedID,SupplyName,Remark
dim MemID,Linkman,Sex,Company,Address,ZipCode,Telephone,Fax,Mobile,Email,VerifyCode
dim rs,sql
NeedID=request.QueryString("NeedID")
SupplyName=trim(request.form("SupplyName"))
Remark=request.form("Remark")
MemID=request.QueryString("MemberID")
Linkman=trim(request.form("Linkman"))
Sex=trim(request.form("Sex"))
Company=trim(request.form("Company"))
Address=trim(request.form("Address"))
ZipCode=trim(request.form("ZipCode"))
Telephone=trim(request.form("Telephone"))
Fax=trim(request.form("Fax"))
Mobile=trim(request.form("Mobile"))
Email=trim(request.form("Email"))
VerifyCode=trim(request.form("VerifyCode"))
dim ErrMessage,ErrMsg(8),FindErr(8),i
  ErrMsg(0)="·供应名称必填，长度不能超过100个字符"
  ErrMsg(1)="·姓名必填，长度不能超过50个字符"
  ErrMsg(2)="·单位名称、地址必填，长度为8-100个字符"
  ErrMsg(3)="·邮编必填长度为6-20个字符"
  ErrMsg(4)="·电话必填长度为11-50个字符"
  ErrMsg(5)="·传真、移动电话长度不能超过50个字符"
  ErrMsg(6)="·电子邮箱格式不正确"
  ErrMsg(7)="·验证码错误或已失效"
if len(SupplyName)>100 or len(SupplyName)=0 then
  FindErr(0)=true
end if  
if len(Linkman)>50 or len(Linkman)=0 then
  FindErr(1)=true
end if
if len(Company)>100 or len(Address)>100 or len(Company)<8 or len(Address)<8 then
  FindErr(2)=true
end if
if len(ZipCode)>20 or len(ZipCode)<6 then
  FindErr(3)=true
end if
if len(Telephone)>50 or len(Telephone)<11 then
  FindErr(4)=true
end if
if len(Fax)>50 or len(Mobile)>50 then
  FindErr(5)=true
end if
if not IsValidEmail(Email) then
  FindErr(6)=true
end if
if session("VerifyCode")<>VerifyCode then
  FindErr(7)=true
end if
for i = 0 to UBound(FindErr)
  if FindErr(i)=true then
    ErrMessage=ErrMessage+ErrMsg(i)+"<br>"
  end if
next
if not (ErrMessage="" or isnull(ErrMessage)) then
  WriteMsg(ErrMessage)
  response.end
end if
set rs = server.createobject("adodb.recordset")
sql="select * from suqun_Supply"
rs.open sql,conn,1,3
rs.addnew
rs("NeedID")=NeedID
rs("SupplyName")=StrReplace(SupplyName)
rs("Remark")=StrReplace(Remark)
rs("MemID")=MemID
rs("Linkman")=StrReplace(Linkman)
rs("Sex")=Sex
rs("Company")=StrReplace(Company)
rs("Address")=StrReplace(Address)
rs("ZipCode")=StrReplace(ZipCode)
rs("Telephone")=StrReplace(Telephone)
rs("Fax")=StrReplace(Fax)
rs("Mobile")=StrReplace(Mobile)
rs("Email")=Email
rs("AddTime")=now()
rs.update
rs.close
set rs=nothing
WriteMsg("·提交供应成功，点击查看<a href='MemberSupply.asp'><font color='red'>[我的供应]</font></a>。")
%>