📄 fbtg.asp
字号:
<!--#include file="asp/opendb.asp"-->
<!--#include file="asp/checkuser.asp"-->
<!--#include file="asp/top.asp"-->
<!--#include file="asp/style.asp"--><html>
<script Language="JavaScript">
function form_check(){
if(document.form2.title.value==""){window.alert("标题不能为空");document.form2.title.focus();return (false);}
if(document.form2.content.value==""){window.alert("内容不能为空");document.form2.content.focus();return (false);}
}
function form_checkadd(){
if(document.form1.title.value==""){window.alert("标题不能为空");document.form1.title.focus();return (false);}
if(document.form1.content.value==""){window.alert("内容不能为空");document.form1.content.focus();return (false);}
}
</script><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="css/css.css"></head>
<body topmargin="5" leftmargin="0">
<p>
<center>
<b>发布通报</b> "<font color=red>*</font>"号的表示必须填写
</center>
<center>
<%
set conn=opendb("oabusy","conn","accessdsn")
if request("action")="add" then
title=request("title")
content=request("content")
sql="select * from newnotice where title='"&title&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.EOF and not rs.BOF then
Response.Write "该通报已存在,请检查后在试!!!"&"<br>"
Response.Write "<a href='fbtg.asp'>返回</a>"
rs.Close
set rs=nothing
Response.End
end if
'rs.AddNew
'rs("title")=htmlencode(title)
'rs("content")=htmlencode(content)
'rs("username")=oabusyusername
'rs("jointime")=now()
'rs.Update
sql = "Insert Into newnotice (title,content,username,jointime) Values("
sql=sql & "'"&title& "','"
sql = sql & htmlencode(content) & "', '"
sql = sql & oabusyusername& "', '"
sql = sql & now()& "')"
conn.Execute sql
%>
<font color="red">发布通报成功！</font>
<%
end if
%>
<br>
<br>
<%
if request("action")="ok" then
sql="update newnotice set title='"&htmlencode(request("title"))&"',content='"&htmlencode(request("content"))&"' where id="&request("id")
conn.execute sql
Response.Write "修改成功!!!!!!!<P>"
Response.write "<a href='fbtg.asp'>返回</a>"
Response.End
end if
if request("action")="modify" then
set rs=server.CreateObject("adodb.recordset")
sql="select * from newnotice where id="&request("id")
rs.Open sql,conn,1
%>
<form method=post name=form2 action="fbtg.asp?action=ok" onsubmit="">
<table width="85%" border="0" cellpadding="1" cellspacing="0" align="center">
<tr>
<td>
<table width="100%" border="0" >
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#cccccc">
<tr>
<td colspan="3"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td width="12%" align="center"> 通报标题： </td>
<td width="88%">
<input type=text name="title" size=80 value="<%=htmstrcode(rs("title"))%>" style="border:1 solid #000000;background:#ffffff">
<font color=red>*</font>
<input type="hidden" name="id" value="<%=rs("id")%>">
</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="center">内 容：
</td>
<td>
<textarea rows="8" name="content" cols="80"style="border:1 solid #000000;background:#ffffff"><%=htmstrcode(rs("content"))%></textarea>
<font color=red>*</font> </td>
</tr>
<tr bgcolor="#eeeeee">
<td align="center" colspan=2> </td>
</tr>
</table>
</table>
</table>
<br>
<input type="submit" name="submit" value="提交" onclick="return form_check();" style="border:1 solid #000000;background:#cc6600">
</form>
</center>
<%
rs.Close
set rs=nothing
Response.End
end if
conn.close
set conn=nothing
%>
<form method=post name=form1 action="fbtg.asp?action=add" onsubmit="">
<table width="85%" border="0" cellpadding="1" cellspacing="0" align="center">
<tr>
<td>
<table width="100%" border="0">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#cccccc">
<tr>
<td colspan="3"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td width="12%" align="center"> 通报标题： </td>
<td width="88%">
<input type=text name="title" size=80 style="border:1 solid #000000;background:#ffffff">
<font color=red>*</font> </td>
</tr>
<tr bgcolor="#eeeeee">
<td width="12%">
<div align="center">内 容： </div>
</td>
<td width="88%">
<textarea rows="8" name="content" cols="80"style="border:1 solid #000000;background:#ffffff"></textarea>
<font color=red>*</font> </td>
</tr>
<tr bgcolor="#eeeeee">
<td align="center" colspan=2> </td>
</tr>
</table>
</table></table>
<br>
<input type="submit" name="submit" value="提交" onclick="return form_checkadd();" style="border:1 solid #000000;background:#cc6600">
</form>
</body>
</html><!--#include file="footer.htm"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -