📄 modify_save.asp
字号:
<% data_path="../../" 'ACC连接数据库路径,对SQL无效 %>
<!--#include file="../../conn/conn.asp"-->
<!--#include file="../../inc/safe.asp"-->
<!--#include file="../checkrole.asp"-->
<%
Response.Buffer = true
Response.ExpiresAbsolute=now()-1
Response.Expires=0
Response.CacheControl="no-cache"
call checkuser("xz")
if Not ChkPost then
response.write "<script language='javascript'>"
response.write"parent.location.href='"&HOPE_InstallDir&"login/login1.asp';</SCRIPT>"
response.end
end if
id=session("id")
name1=Replace_Text(request.form("name"))
ch=Replace_Text(request.form("ch"))
email=Replace_Text(request.form("email"))
phonecountry=Replace_Text(request.form("phonecountry"))
phonearea=Replace_Text(request.form("phonearea"))
phonenumber=Replace_Text(request.form("phonenumber"))
phone=phonecountry&" "&phonearea&" "&phonenumber
faxcountry=Replace_Text(request.form("faxcountry"))
faxarea=Replace_Text(request.form("faxarea"))
faxnumber=Replace_Text(request.form("faxnumber"))
fax=faxcountry&" "&faxarea&" "&faxnumber
mobile=Replace_Text(request.form("mobile"))
post=Replace_Text(request.form("post"))
country=Replace_Text(request.form("country1"))
sf=Replace_Text(request.form("province"))
city=Replace_Text(request.form("city"))
address=Replace_Text(request.form("address"))
qymc=Replace_Text(request.form("qymc"))
zw=Replace_Text(request.form("zw"))
tm=Replace_Text(request.form("tm"))
p_z_Z_productionService=Replace_Text(request.form("p_z_Z_productionService"))
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
'处理种类的id号
sortid=Replace_Text(request.form("p_z_Z_RootCategory")) '第一类
CategoryId=split(Replace_Text(request.form("p_z_Z_CategoryId1")),",")
typeid=CategoryId(0) '第二类
if ubound(CategoryId)>=1 then
typeid_2=CategoryId(1) '第三类
else
typeid_2=0
end if
if typeid="" then
typeid=0
end if
if typeid_2="" then
typeid_2=0
end if
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
web=Replace_Text(request.form("web"))
isournotify=Replace_Text(request.form("isournotify"))
msn=Replace_Text(request.form("msn"))
qylb=Replace_Text(request.form("qylb"))
if isournotify="" then
isournotify=0
else
isournotify=1
end if
isothernotify=Replace_Text(request.form("isothernotify"))
if isothernotify="" then
isothernotify=0
else
isothernotify=1
end if
%>
<%
sql="select * from wygkcn_corporation where id<>"&id&" and (qymc='"&qymc&"' or email='"&email&"')"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if not (rs.eof and rs.bof) then
response.write"<SCRIPT language=JavaScript>alert('您填写的公司名称或E-mail已存在,请返回重新填写!!');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
end if
set rs=server.CreateObject ("adodb.recordset")
sql="select * from wygkcn_corporation where id="&id&""
rs.open sql,conn,1,3
rs("name")=name1
rs("ch")=ch
rs("email")=email
rs("phone")=phone
rs("fax")=fax
rs("mobile")=mobile
rs("post")=post
rs("country")=country
rs("sf")=sf
rs("city")=city
rs("address")=address
rs("qymc")=qymc
rs("zw")=zw
rs("zycp")=p_z_Z_productionService
rs("sortid")=sortid
rs("typeid")=typeid
rs("typeid_2")=typeid_2
rs("web")=web
rs("isournotify")=isournotify
rs("isothernotify")=isothernotify
rs("tm")=tm
rs("msn")=msn
rs("qylb")=qylb
rs.update
id1=id
id2=id
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>操作成功</title>
<link href="../../images/css.css" rel="stylesheet" type="text/css">
<meta HTTP-EQUIV=refresh Content='1;url=modify_info.asp'>
</head>
<%
if session("id")<>"" and session("flag")<>1 then
if id1<>"" and id2<>"" then
%>
<iframe src="../../manage/Autohtml/corporation/makedetail.asp?all=update&id1=<%=id1%>&id2=<%=id2%>&schtml=开始生成>>&other=Confirm" frameborder="0" scrolling="no" width=0 height=0></iframe>
<%
end if
end if
Content="<table width='100%' border='0' cellspacing='5' cellpadding='0'>"
Content=Content&" <tr>"
Content=Content&" <td><strong style='color:#6C88A2;font-size:14px;'>操作成功,<a href='../modify/modify_info.asp'>返回上一页!</a></strong></td>"
Content=Content&"</tr>"
Content=Content&" <tr>"
Content=Content&" <td style='font-size:12px;color:#96A9BA;'><li>恭喜您,公司介绍已经修改成功!</td>"
Content=Content&" </tr>"
Content=Content&" </table>"
Call Operation(Content,1)
%>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -