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 + -
显示快捷键?