saveunit.asp

来自「这是一个很小的电子商务网站」· ASP 代码 · 共 54 行

<!--#include file="conn.asp"-->
<!--#include file="session2.asp"-->
<%
dim danweiid,danweiorder,danweiname,danweino,i
if request("action")="update" then
    for i=1 to request.form("danweiid").count
	danweiid=replace(request.form("danweiid")(i),"'","")
	danweiorder=replace(request.form("danweiorder")(i),"'","")
	danweiname=replace(request.form("danweiname")(i),"'","")
	if replace(request.form("danweiorder")(i),"'","")="" then
%>
<script language=javascript>
history.back()
alert("请填写单位的显示排序！")
</script>
<%
		Response.End
	end if
	conn.execute("update sh_danwei set danweiorder="&danweiorder&",danweiname='"&danweiname&"' where id="&danweiid)
    next
conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('单位设置成功！');window.location.href='ManageUnit.asp';</script>"
response.End
end if


if request("action")="add" then
	danweino=request.form("danweino")
	danweiname=trim(request("danweiname"))
	danweiorder=request.form("danweiorder")
	If danweiname="" Then
		response.Write "<script language='javascript'>alert('单位名称不能为空！');javascript:history.go(-1);</script>"
		response.end
	end if
	If danweiorder="" Then
		response.Write "<script language='javascript'>alert('排序不能为空！');javascript:history.go(-1);</script>"
		response.end
	end if
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "select * from sh_danwei",conn,1,3
rs.addnew
rs("danweiname")=danweiname
rs("danweiorder")=danweiorder
rs.update
rs.close
set rs=nothing

conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('单位添加成功！');window.location.href='ManageUnit.asp';</script>"
response.End
end if
%>