company_save.asp

asp+access开发的网上购物程序

<%@ codepage ="936" %>
<%
if id=session("id") then
session("pageid")="company_info"
response.redirect "../../login/login.asp"
else
id=session("id")
%>
<!--#include file="../../conn/dbconn2.asp"-->
<!--#include file="../../inc/config.asp"-->
<script LANGUAGE="JavaScript">
function goHist(a) 
{
history.go(a); 
}
</script>
<%
dim rsgs
dim gssql
dim qymc
dim qylb
dim qyxz
dim zczj
dim frdb
dim ygrs
dim zh
dim bank
dim nyye
dim zycp
dim jygs
dim qyjj
dim bighy
dim lithy
dim qylb1
dim qylb2
dim qylb3
dim qylb4
dim gsid
dim sortid
dim errmsg
qymc=request.form("qymc")
qyxz=request.form("qyxz")
zczj=request.form("zczj")
frdb=request.form("frdb")
ygrs=request.form("ygrs")
nyye=request.form("nyye")
zycp=request.form("zycp")
jygs=request.form("jygs")
qyjj=request.form("qyjj")
address=request.form("address")
bighy=request.form("bighy")
lithy=request.form("lithy")
qylb=request.form("qylb")
if trim(request.form("bighy"))="农业" then
Sortid="1"
end if
if trim(request.form("bighy"))="服饰" then
Sortid="2"
end if
if trim(request.form("bighy"))="安全、防护" then
Sortid="3"
end if
if trim(request.form("bighy"))="食品、饮料" then
Sortid="4"
end if
if trim(request.form("bighy"))="电子电工" then
Sortid="5"
end if
if trim(request.form("bighy"))="印刷、出版" then
Sortid="6"
end if
if trim(request.form("bighy"))="纺织" then
Sortid="7"
end if
if trim(request.form("bighy"))="环保" then
Sortid="8"
end if
if trim(request.form("bighy"))="玩具" then
Sortid="9"
end if
if trim(request.form("bighy"))="能源" then
Sortid="10"
end if
if trim(request.form("bighy"))="建材、房地产" then
Sortid="11"
end if
if trim(request.form("bighy"))="通讯" then
Sortid="12"
end if
if trim(request.form("bighy"))="交通运输" then
Sortid="13"
end if
if trim(request.form("bighy"))="工业用品" then
Sortid="14"
end if
if trim(request.form("bighy"))="商业服务" then
Sortid="15"
end if
if trim(request.form("bighy"))="家居用品" then
Sortid="16"
end if
if trim(request.form("bighy"))="化工" then
Sortid="17"
end if
if trim(request.form("bighy"))="包装、纸" then
Sortid="18"
end if
if trim(request.form("bighy"))="家用电器" then
Sortid="19"
end if
if trim(request.form("bighy"))="医药、保养" then
Sortid="20"
end if
if trim(request.form("bighy"))="汽车摩托及配件" then
Sortid="21"
end if
if trim(request.form("bighy"))="电脑、软件" then
Sortid="22"
end if
if trim(request.form("bighy"))="礼品、工艺品" then
Sortid="23"
end if
if trim(request.form("bighy"))="库存积压产品" then
Sortid="24"
end if
if trim(request.form("bighy"))="运动、休闲" then
Sortid="25"
end if
if trim(request.form("bighy"))="冶金矿产" then
Sortid="26"
end if
if trim(request.form("bighy"))="办公、文教" then
Sortid="27"
end if
if trim(request.form("sf"))="北京" then
cityid="1"
end if
if trim(request.form("sf"))="上海" then
cityid="2"
end if
if trim(request.form("sf"))="天津" then
cityid="3"
end if
if trim(request.form("sf"))="重庆" then
cityid="4"
end if
if trim(request.form("sf"))="黑龙江" then
cityid="5"
end if
if trim(request.form("sf"))="吉林" then
cityid="6"
end if
if trim(request.form("sf"))="辽宁" then
cityid="7"
end if
if trim(request.form("sf"))="内蒙古" then
cityid="8"
end if
if trim(request.form("sf"))="河北" then
cityid="9"
end if
if trim(request.form("sf"))="新疆" then
cityid="10"
end if
if trim(request.form("sf"))="甘肃" then
cityid="11"
end if
if trim(request.form("sf"))="宁夏" then
cityid="12"
end if
if trim(request.form("sf"))="山西" then
cityid="13"
end if
if trim(request.form("sf"))="山东" then
cityid="14"
end if
if trim(request.form("sf"))="青海" then
cityid="15"
end if
if trim(request.form("sf"))="西藏" then
cityid="16"
end if
if trim(request.form("sf"))="四川" then
cityid="17"
end if
if trim(request.form("sf"))="陕西" then
cityid="18"
end if
if trim(request.form("sf"))="河南" then
cityid="19"
end if
if trim(request.form("sf"))="湖北" then
cityid="20"
end if
if trim(request.form("sf"))="安徽" then
cityid="21"
end if
if trim(request.form("sf"))="江苏" then
cityid="22"
end if
if trim(request.form("sf"))="浙江" then
cityid="23"
end if
if trim(request.form("sf"))="江西" then
cityid="24"
end if
if trim(request.form("sf"))="湖南" then
cityid="25"
end if
if trim(request.form("sf"))="贵州" then
cityid="26"
end if
if trim(request.form("sf"))="云南" then
cityid="27"
end if
if trim(request.form("sf"))="广西" then
cityid="28"
end if
if trim(request.form("sf"))="广东" then
cityid="29"
end if
if trim(request.form("sf"))="福建" then
cityid="30"
end if
if trim(request.form("sf"))="海南" then
cityid="31"
end if
if trim(request.form("sf"))="香港" then
cityid="32"
end if
if trim(request.form("sf"))="澳门" then
cityid="33"
end if
if trim(request.form("sf"))="台湾" then
cityid="34"
end if
if trim(request.form("sf"))="郑州市" then
cityid="35"
end if
if trim(request.form("sf"))="安阳市" then
cityid="36"
end if
if trim(request.form("sf"))="濮阳市" then
cityid="37"
end if
if trim(request.form("sf"))="鹤壁市" then
cityid="38"
end if
if trim(request.form("sf"))="新乡市" then
cityid="39"
end if
if trim(request.form("sf"))="焦作市" then
cityid="40"
end if
if trim(request.form("sf"))="三门峡" then
cityid="41"
end if
if trim(request.form("sf"))="洛阳市" then
cityid="42"
end if
if trim(request.form("sf"))="南阳市" then
cityid="43"
end if
if trim(request.form("sf"))="平顶山" then
cityid="44"
end if
if trim(request.form("sf"))="漯河市" then
cityid="45"
end if
if trim(request.form("sf"))="许昌市" then
cityid="46"
end if
if trim(request.form("sf"))="开封市" then
cityid="47"
end if
if trim(request.form("sf"))="商丘市" then
cityid="48"
end if
if trim(request.form("sf"))="驻马店" then
cityid="49"
end if
if trim(request.form("sf"))="周口市" then
cityid="50"
end if
if trim(request.form("sf"))="信阳市" then
cityid="51"
end if
if trim(request.form("sf"))="济源市" then
cityid="52"
end if
if trim(request.form("sf"))="其它" then
cityid="53"
end if
if trim(request.form("frdb"))="" then
frdb="空"
else
frdb=request.form("frdb")
end if
if trim(request.form("bank"))="" then
bank="空"
else
bank=request.form("bank")
end if
if trim(request.form("zh"))="" then
zh="空"
else
zh=request.form("zh")
end if
id=session("id")
%>
<%
set rs=server.CreateObject ("adodb.recordset")
sql="select * from qyml where id="&id
rs.open sql,conn,1,3
rs("qymc")=qymc
rs("qylb")=qylb
rs("bighy")=bighy
rs("qyxz")=qyxz
rs("zczj")=zczj
rs("frdb")=frdb
rs("ygrs")=ygrs
rs("zh")=zh
rs("bank")=bank
rs("nyye")=nyye
rs("zycp")=zycp
rs("jygs")=jygs
rs("qyjj")=qyjj
rs("gsid")=user
rs("sortid")=bighy
rs("typeid")=lithy
rs("idate")=date()
rs.update
session("id")=rs("id")
session("Qymc")=rs("Qymc")
session("Qylb")=rs("Qylb")
session("sortid")=rs("sortid")
session("typeid")=rs("typeid")
session("Qyxz")=rs("Qyxz")
session("Zczj")=rs("Zczj")
session("Frdb")=rs("Frdb")
session("Ygrs")=rs("Ygrs")
session("Zh")=rs("zh")
session("Bank")=rs("Bank")
session("Nyye")=rs("Nyye")
session("Zycp")=rs("Zycp")
session("jygs")=rs("jygs")
session("Qyjj")=rs("Qyjj")
rs.close
set rs=noting 
conn.close
set conn=nothing 
response.write "<SCRIPT language=JavaScript>alert('您的资料已经发布成功！');"
response.write"this.location.href='../gg.asp#a';</SCRIPT>" 
%>
<LINK href="../../css/Style.css" rel=stylesheet type=text/css>
<a name="a"></a>
<HTML><HEAD><TITLE><%=WebName%>-会员管理平台</TITLE>
<META content=zh-cn http-equiv=Content-Language>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD>
<BODY leftMargin=0 topMargin=0 marginheight="0" marginwidth="0" bgcolor="#FFFFFF">
<p><%end if%> </p>
</BODY></HTML>