save.asp

来自「Lirong网络办公系统」· ASP 代码 · 共 67 行

ASP
67
字号
<%response.expires=0%>
<%Response.Buffer=true%>
<!-- #include file="../conn_lr.asp"-->
<!-- #include file="../css.asp"-->
<%
oabusyname=session("oabusyname")
oabusyusername=session("oabusyusername")
oabusyuserdept=session("oabusyuserdept")
oabusyuserlevel=session("oabusyuserlevel")
session("id")=session("oabusyname")
if oabusyusername="" then 
	response.write("<script language=""javascript"">")
	response.write("window.top.location.href='../../default.asp';")
	response.write("</script>")
	response.end
end if
%>


<!--  #Include File=../inc/css.asp -->

<%	
	SET rs=Server.CreateObject("ADODB.RecordSet") 
	rs.ActiveConnection = oconn
	rs.CursorType = 1
	rs.LockType =3
	
	dim Number,opFlag
	opFlag=Request.QueryString("opFlag")
	Number=Request.QueryString("Number")
	
	select case opFlag
		'增加记录
		case "cmdAddNew"
	  			rs.open("select * from cinformation")
				rs.Addnew
	        	rs("Cbianhao")=Request.Form("Cbianhao")
            	rs("Cyyzhe")=Request.Form("Cyyzhe")
		    	rs("Cyyriqi")=Request.Form("Cyyriqi")
            	rs("Cyyqixian")=Request.Form("Cyyqixian")
            	rs("Cbeizhu")=Request.Form("Cbeizhu")
            	rs("Cmudi")=Request.Form("Cmudi")
            	rs("Csyzhe")=""
            	rs("Csyqixian")=""
            	rs("Cfenpei")=Request.Form("Cfenpei")
				rs.Update
				Response.write("<span class=vtext><font color=red><b>登记成功!</b></font></span>")
		case "cmdEdit"
		'编辑记录
				rs.Open(Session("SQL"))
				rs.Move Number
	        	rs("Cbianhao")=Request.Form("Cbianhao")
            	rs("Cyyzhe")=Request.Form("Cyyzhe")
		    	rs("Cyyriqi")=Request.Form("Cyyriqi")
            	rs("Cyyqixian")=Request.Form("Cyyqixian")
            	rs("Cbeizhu")=Request.Form("Cbeizhu")
            	rs("Cmudi")=Request.Form("Cmudi")
				rs.Update
				Response.write("<span class=vtext><font color=red><b>该项信息已经成功修改!</b></font></span>")
	end select
	
	rs.close
	set rs=nothing

	response.redirect "main.asp?opFlag=cmdEdit"+Session("isdepartment")
	
%>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?