saveconfirmer.htm

来自「全方面的OA管理程序代码」· HTM 代码 · 共 49 行

<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<%
DocID=trim(request("ID"))
Title=trim(request("title"))
title2=trim(request("title2"))
Body=trim(request("body"))
Remark=trim(request("Remark"))
confirmer=trim(request("confirmer"))
collateID=trim(request("collateID"))
FromID=session("LoginID")

IF DocID="" or FromID="" then
	response.write "失效，请重新登录！"
	oConn.close
	response.end
end if


UpdateDoc (DocID)

response.write "<h2>您的核对已经正确提交，谢谢！</h2><BR>"
response.write "<a href=docConfirmer.htm><img src='../images/return.gif' border=0></a>"
oConn.close
response.end

Sub UpdateDoc(ID)
	sql="Update tblDoc set Title='"&title&"',title2='"&title2&"',Body2='"&body&"',remark2='"& Remark &"',CurrentID="& collateID &",Times='"&now()&"' where ID="& ID
	oConn.execute (sql)
end sub

Function GetTableValue(TableName,Field,ValueField,Value)
	if TableName<>"" and Value<>"" then
		Set RsTmp = Server.Createobject("Adodb.recordset")
		strSql = "Select "& Field &" from "& TableName &" where "& ValueField &"='"& Value &"'"
		Rstmp.open strSql,oConn,1,1
		If not Rstmp.eof then
			GetTableValue=trim(Rstmp(Field))
		else
			GetTableValue=""
		end if
		Rstmp.close
		set RsTmp = Nothing
	else
		GetTableValue=""
	end if
End Function
%>
<!--#include file="../inc/conn_close.htm"-->