saveout.asp

具有计划、任务、通告、公文、员工档案、等网络办公功能

<%response.expires=0%>
<%Response.Buffer=true%>
<!-- #include file="../conn_lr.asp"-->
<!-- #include file="../css.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
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 -->
<%	'定义变量
	dim Number,opFlag,vname,vintime,voutime,i
	'设置操作对象
	SET rs=Server.CreateObject("ADODB.RecordSet") 
	rs.ActiveConnection = Session("conn")
	rs.CursorType = 1
	rs.LockType = 3

	opFlag=Request("opFlag")
	Number=Cint(Request("Number"))
	
	select case opFlag
		'当信息为新增时保存
		case "cmdAddNew"
			rs.open("select * from bookout where 1=0 ")
			rs.Addnew
			for i=0 to rs.Fields.count-1 
				if Request.Form(rs.Fields(i).name)<>"" then 
					if rs.Fields(i).type="integer" then  rs(rs.Fields(i).name)=cint(Request.Form(rs.Fields(i).name)) 	else 	rs(rs.Fields(i).name)=Request.Form(rs.Fields(i).name)
				end if
			next 
			rs.Update
			rs.close			
			rs.open("select * from books where vnumber='" & request("vnumber") & "'")
			rs("voutcount")=rs("voutcount")+1
			rs.update
		'当信息为编辑时保存	
		case "cmdBack"
			rs.Open(Session("SQL"))
			rs.Move Number
			vname=rs("vname")
			vintime=rs("vintime")
			if vintime="尚未归还" then 
				vouttime=rs("vouttime")
				vnumber=rs("vnumber")
				Session("conn").execute("update bookout set vintime='" & nowdate & "' where vnumber='" & vnumber & "' and vname='" & vname & "' and vouttime='" & vouttime &"'" )
				Session("conn").execute("update books set voutcount=voutcount-1 where vnumber='" & vnumber & "'")
			end if
	end select
	rs.close
	set rs=nothing
	'重定向到主程序	
	response.redirect "mainout.asp"

%>