save.asp

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

<%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
%>


<%	
	SET rs=Server.CreateObject("ADODB.RecordSet") 
	rs.ActiveConnection = Session("conn")
	rs.CursorType = 1
	rs.LockType =3
	
	dim op,hunumber,Number,opFlag,rs
	
	opFlag=Request("opFlag")
	Number=Cint(Request("Number"))
	select case opFlag
		'增加记录
		case "cmdAddNew"
	  		rs.open("select * from rizhi where vtime='" & Request.Form("vtime")& "' and vname='" & Session("id") & "'")
				rs.Addnew
				rs("vtime")=Request.Form("vtime")
				rs("vtext")=Request.Form("vtext")
				rs("vname")=Session("id")
				rs("vtitle")=Request.Form("vtitle")
				rs.Update
		'编辑记录
		case "cmdEdit"
			rs.Open(Session("SQL"))
			rs.Move Number
			rs("vtime")=Request.Form("vtime")
			rs("vtext")=Request.Form("vtext")
			rs("vtitle")=Request.Form("vtitle")
			rs.Update
	end select
	
	rs.close
	set rs=nothing

	response.redirect "main.asp"
%>