savepress.htm

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

HTM
55
字号
<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
DocID=trim(request("ID"))
Body=rtrim(request("Suggest"))
FromID=session("LoginID")
IF DocID="" or FromID="" then
	response.write "失效,请重新登录!"
	oConn.close
	response.end
end if
FromName=GetTableValue("tblUser","Name","ID",FromID)

AddSuggest()

response.write "<h2>您的催办处理已经正确提交,谢谢!</h2><BR>"
response.write "<a href=Doc_press.htm><img src='../images/return.gif' border=0></a>"
oConn.close
response.end

Sub AddSuggest()
	sql="INSERT INTO tblDocPress(FromID, DocID,FromName,Body) VALUES(" & FromID & _
		","& DocID & _
		",'" & FromName & _
		"','"& body & _
		"');"		
		'response.write sql
		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
%>
</body>
</html>
<!--#include file="../inc/conn_close.htm"-->

⌨️ 快捷键说明

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