📄 aa_inform.asp
字号:
<%@ LANGUAGE = VBScript CodePage = 936%>
<%
'***********************************************************************************
' 产品名称:CSYS.COM.CN企业全站管理系统(V2007简体中文版)
' 联系:QQ:61128110 Emial:61128110@163.com
' Copyright 2006 www.csys.com.cn - All Rights Reserved.
'***********************************************************************************
PageName="Admin,0"
%>
<!--#include file="Inc/Const.asp"-->
<!--#include file="Inc/Sysconn.asp"-->
<!--#include file="Inc/Design.asp"-->
<%
Call Page_formBody()
Call Page_Spane(5)
Page_HeadName="<A HREF=Aa_Inform.asp?Action=Add>添加公告</A> | <A HREF=Aa_Inform.asp?Action=Manage>公告列表</A>"
Select Case Action
Case "Add"
Call Page_AdminFlag(9)
Page_BootmName="添加公告"
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"&_
"<Form NAME=Form method=post action=Aa_Inform.asp?Action=sAdd onSubmit='return checkdata()'>"&_
"<TR>"&_
"<TD WIDTH=20% HEIGHT=30 CLASS=Table8>公告主题:</TD>"&_
"<TD CLASS=Table8><INPUT NAME='Inform_Title' TYPE=text id='Inform_Title' size=50> <FONT COLOR=ff0000>*</FONT></TD>"&_
"</TR>"&_
"<TR><TD CLASS=Table8>公告内容:</TD><TD>"
strIfb = "</TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>公告审核:</TD>"&_
"<TD CLASS=Table8><INPUT TYPE=radio CLASS=radio_all NAME=Inform_Flag VALUE='1' checked> 通过审核 <INPUT CLASS=radio_all TYPE=radio NAME=Inform_Flag VALUE='0'> 取消审核</TD>"&_
"</TR>"&_
"<TR ALIGN=center>"&_
"<TD HEIGHT=35 colspan=2 CLASS=Table8><INPUT CLASS=submit_all NAME=ok TYPE=submit id=ok VALUE=提交资料 onClick='document.Form.Content.value = frames.message.document.body.innerHTML;document.Form.PicUrl.value = frames.PicUrl.document.body.innerHTML;'> "&_
"<INPUT NAME=cl TYPE=reset id=cl CLASS=submit_all VALUE=重新输入><INPUT TYPE=hidden NAME=Content VALUE=''><INPUT TYPE=hidden NAME=PicUrl VALUE=''></TD>"&_
"</TR>"&_
"</form>"&_
"</TABLE>"
Call Page_aTable(1,0)
Case "Edit"
Call Page_AdminFlag(10)
Set Rs_edit=server.Createobject("Adodb.Recordset")
Sql="Select * from Tx_Inform Where Inform_Id=" & Id
Rs_edit.open Sql,Conn,1,1
Page_BootmName="公告修改 > " & Rs_edit("Inform_Title")
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
IF Rs_edit("Inform_Flag")=1 THEN
checked1="checked"
Else
checked2="checked"
End IF
Table_List1="Tx_Inform"
OldId="Inform_Id"
OldContent="Inform_Content"
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"&_
"<Form NAME=Form method=post action=Aa_Inform.asp?Action=sEdit&Id=" & Rs_edit("Inform_Id") & " onSubmit='return checkdata()'>"&_
"<TR>"&_
"<TD WIDTH=20% HEIGHT=30 CLASS=Table8>公告主题:</TD>"&_
"<TD CLASS=Table8><INPUT NAME='Inform_Title' TYPE=text id='Inform_Title' VALUE='" & Rs_edit("Inform_Title") & "' size=50> <FONT COLOR=ff0000>*</FONT></TD>"&_
"</TR>"&_
"<TR><TD CLASS=Table8>公告内容:</TD><TD>"
strIfb = "</TD>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>公告审核:</TD>"&_
"<TD CLASS=Table8><INPUT TYPE=radio CLASS=radio_all NAME=Inform_Flag VALUE='1' " & checked1 & "> 通过审核 <INPUT CLASS=radio_all TYPE=radio NAME=Inform_Flag VALUE='0' " & checked2 & ">取消审核</TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=50 CLASS=Table8>添加时间:</TD>"&_
"<TD CLASS=Table8><INPUT NAME=NewDate TYPE=text id=NewDate disabled VALUE='" & Rs_edit("Inform_Date") & "' size=25> 当前时间为" & Now() & " "&_
"更新时间:<INPUT NAME=EditDate CLASS=radio_all TYPE=checkbox id=EditDate VALUE=1></TD>"&_
"</TR>"&_
"<TR ALIGN=center>"&_
"<TD HEIGHT=35 colspan=2 CLASS=Table8><INPUT CLASS=submit_all NAME=ok2 TYPE=submit id=ok2 VALUE=提交资料 onClick='document.Form.Content.value = frames.message.document.body.innerHTML;document.Form.PicUrl.value = frames.PicUrl.document.body.innerHTML;'> "&_
"<INPUT NAME=cl2 TYPE=reset id=cl2 CLASS=submit_all VALUE=重新输入><INPUT TYPE=hidden NAME=Content VALUE=''><INPUT TYPE=hidden NAME=PicUrl VALUE=''></TD>"&_
"</TR>"&_
"</form>"&_
"</TABLE>"
Rs_edit.close
set Rs_edit=nothing
Call Page_aTable(1,0)
Case "Manage"
Call Page_AdminFlag(10)
Page_BootmName="公告列表"
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
Set Rs_Manage=server.Createobject("Adodb.Recordset")
Sql="Select * From Tx_Inform order by Inform_Date desc"
Rs_Manage.open Sql,Conn,1,1
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1><TR ALIGN=center><TD WIDTH=6% HEIGHT=23 CLASS=Table6>ID</TD><TD CLASS=Table6>公告主题</TD><TD WIDTH=10% CLASS=Table6>添加人</TD><TD WIDTH=17% CLASS=Table6>添加时间</TD><TD WIDTH=22% CLASS=Table6>操作</TD></TR>"
Rs_Manage.PageSize = 25
totalrec=Rs_Manage.RecordCount
iPageSize=Rs_Manage.PageSize
currentPage=Request("page")
IF currentpage="" THEN
currentpage=1
Else
IF Not isChkInteger(currentPage) THEN
response.Redirect "javascript:history.go(-1);"
End IF
currentpage=clng(currentpage)
End IF
IF totalrec mod Cint(iPageSize)=0 THEN
n= totalrec \ Cint(iPageSize)
Else
n= totalrec \ Cint(iPageSize)+1
End IF
IF not (Rs_Manage.bof and Rs_Manage.eof) THEN
Rs_Manage.MoveFirst
IF currentpage > n THEN currentpage = n
IF currentpage<1 THEN currentpage=1
Rs_Manage.Move (currentpage-1) * Cint(iPageSize)
While Not Rs_Manage.Eof and page_count<Cint(iPageSize)
page_count=page_count+1
IF Rs_Manage("Inform_Flag")=1 THEN
TitleFlag="<FONT COLOR=006600>取消</FONT>"
Else
TitleFlag="<FONT COLOR=ff0000>审核</FONT>"
End IF
strIfa = strIfa & "<Form NAME=inbox method=post action=Aa_Inform.asp?Action=Delall>"&_
"<TR CLASS=Table8 onmouseout=" & CHR(34) & "this.style.backgroundColor=''" & CHR(34) & " onmouseover=" & CHR(34) & "this.style.backgroundColor='#799ae1'" & CHR(34) & ">"&_
"<TD HEIGHT=25 ALIGN=center>" & Rs_Manage("Inform_Id") & "</TD>"&_
"<TD><A HREF=Aa_Inform.asp?Action=S&Id=" & Rs_Manage("Inform_Id") & ">" & Rs_Manage("Inform_Title") & "</A></TD>"&_
"<TD>" & Rs_Manage("Inform_Add") & "</TD>"&_
"<TD>" & Rs_Manage("Inform_Date") & "</TD>"&_
"<TD ALIGN=center>"&_
"<A HREF=Aa_Inform.asp?Action=Edit&Id=" & Rs_Manage("Inform_Id") & ">修改</A> | "&_
"<A HREF=Aa_Inform.asp?Action=Flag&Id=" & Rs_Manage("Inform_Id") & ">" & TitleFlag & "</A> | "&_
"<A HREF=Aa_Inform.asp?Action=Del&Id=" & Rs_Manage("Inform_Id") & " onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}'>删除</A> | "&_
"<INPUT CLASS=radio_all TYPE=checkbox NAME=Id VALUE=" & Rs_Manage("Inform_Id") & ">"&_
"</TD>"&_
"</TR>"
Rs_Manage.movenext
wEnd
End IF
Rs_Manage.close
set Rs_Manage=nothing
strIfa = strIfa & "<TR>"&_
"<TD HEIGHT=30 colspan=6 ALIGN=center CLASS=Table9><INPUT CLASS=radio_all TYPE=checkbox NAME=chkall VALUE=on onclick=CheckAll(this.form)>"&_
" 选择全部 "&_
"<INPUT CLASS=submit_all TYPE=submit NAME=Submit VALUE=' 删除 ' onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}'> "&_
"<INPUT CLASS=submit_all TYPE=submit NAME=FlagOk VALUE=通过审核 onClick=" & CHR(34) & "this.form.action='Aa_Inform.asp?Action=FlagallOk';this.form.submit()" & CHR(34) & "> "&_
"<INPUT CLASS=submit_all TYPE=submit NAME=FlagNo VALUE=取消审核 onClick=" & CHR(34) & "this.form.action='Aa_Inform.asp?Action=FlagallNo';this.form.submit()" & CHR(34) & "></TD>"&_
"</TR>"&_
"</form>"&_
"<TR>"&_
"<TD HEIGHT=25 colspan=6 ALIGN=center CLASS=Table8>"
strIfb = "</TD></TR>"&_
"</TABLE>"
Call Page_aTable(0,1)
Case "S"
Set Rs_edit=server.Createobject("Adodb.Recordset")
Sql="Select * from Tx_Inform Where Inform_Id=" & Id
Rs_edit.open Sql,Conn,1,1
Page_BootmName="查看公告 > " & Rs_edit("Inform_Title")
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
IF Rs_edit("Inform_Flag")=1 THEN
TitleFlag="<FONT COLOR=006600>取消审核</FONT>"
Else
TitleFlag="<FONT COLOR=ff0000>通过审核</FONT>"
End IF
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD ALIGN=center CLASS=Table8><TABLE WIDTH=570 BORDER=0 CELLPADDING=0 CELLSPACING=0>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD ALIGN=center CLASS=Table15><B>" & Rs_edit("Inform_Title") & "</B></TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD HEIGHT=1 background=Skins/Blue/Ar2.gif></TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD CLASS=Table15>" & Rs_edit("Inform_Content") & "</TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD HEIGHT=1 background=Skins/Blue/Ar2.gif></TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD HEIGHT=30>添加人:" & Rs_edit("Inform_Add") & " 添加时间:" & Rs_edit("Inform_Date") & "</TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "</TABLE></TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "<TR>"
strIfa = strIfa & "<TD HEIGHT=25 ALIGN=center CLASS=Table8>『 <A HREF=Aa_Inform.asp?Action=Add>添加公告</A> 』『 <A HREF=Aa_Inform.asp?Action=Edit&Id=" & Rs_edit("Inform_Id") & ">修改</A> 』『 <A HREF=As_Inform.asp?Action=Flag&Id=" & Rs_edit("Inform_Id") & ">" & TitleFlag & "</A> 』『 <A HREF=As_Inform.asp?Action=Del&Id=" & Rs_edit("Inform_Id") & " onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}'>删除</A> 』『 <A HREF=Aa_Inform.asp?Action=Manage>公告列表</A> 』</TD>"
strIfa = strIfa & "</TR>"
strIfa = strIfa & "</TABLE>"
Rs_edit.close
set Rs_edit=nothing
Call Page_aTable(0,0)
Case "sAdd"
IF Request.form("Inform_Title")="" THEN
Errorst="请输入公告主题!"
founderr=True
ElseIF Request.form("Content")="" THEN
Errorst="请输入公告内容!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
ContentFile=Replace(Request.form("PicUrl"),"../","")
ContentFile=split(ContentFile,"|")
For intTemp=0 to ubound(ContentFile)
IF instr(Request.form("Content"),ContentFile(intTemp)) and ContentFile(intTemp)<>"" THEN
UploadFile=ContentFile(intTemp) & "|" & UploadFile
End IF
next
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Inform"
Rs.open Sql,Conn,1,3
Rs.addnew
Rs("Inform_Title")=Request.form("Inform_Title")
Rs("Inform_Content")=replace(Request.form("Content"),replace(ToHistorys,"Aa_Inform.asp",""),"")
Rs("Inform_Flag")=Request.form("Inform_Flag")
Rs("UploadFiles")=UploadFile
Rs("Inform_Date")=Now()
Rs("Inform_Add")=session("Loginadmin")
Rs.update
Id=Rs("Inform_Id")
Rs.close
set Rs=nothing
ToHistory="Aa_Inform.asp?Action=S&Id=" & Id
saveok="公告:[ " & Request.form("Inform_Title") & " ] 添加成功!"
Call Form_Saveok()
End IF
Case "sEdit"
IF Request.form("Inform_Title")="" THEN
Errorst="请输入公告主题!"
founderr=True
ElseIF Request.form("Content")="" THEN
Errorst="请输入公告内容!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Inform Where Inform_Id=" & Id
Rs.open Sql,Conn,1,1
ContentFile=Rs("UploadFiles")
Rs.close
set Rs=nothing
ContentFile=Replace(Request.form("PicUrl"),"../","") & ContentFile
ContentFile=split(ContentFile,"|")
For intTemp=0 to ubound(ContentFile)
IF instr(Request.form("Content"),ContentFile(intTemp)) and ContentFile(intTemp)<>"" THEN
UploadFile=ContentFile(intTemp) & "|" & UploadFile
End IF
Next
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Inform where Inform_Id=" & Id
Rs.open Sql,Conn,1,3
Rs("Inform_Title")=Request.form("Inform_Title")
Rs("Inform_Content")=replace(Request.form("Content"),replace(ToHistorys,"Aa_Inform.asp",""),"")
Rs("Inform_Flag")=Request.form("Inform_Flag")
Rs("UploadFiles")=UploadFile
IF Request.form("EditDate")=1 THEN
Rs("Inform_Date")=Now()
End IF
Rs.update
Rs.close
set Rs=nothing
ToHistory=VisitorsForm
saveok="公告:[ " & Request.form("Inform_Title") & " ] 修改成功!"
Call Form_Saveok()
End IF
Case "Del"
Conn.Execute "Delete From Tx_Inform Where Inform_Id=" & Id
ToHistory="Aa_Inform.asp?Action=Manage"
saveok="删除成功!"
Call Form_Saveok()
Case "Flag"
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Inform where Inform_Id=" & Id
Rs.open Sql,Conn,1,3
IF Rs("Inform_Flag")=1 THEN
Rs("Inform_Flag")=0
saveok="公告:[ " & Rs("Inform_Title") & " ] 已取消审核!"
Else
Rs("Inform_Flag")=1
saveok="公告:[ " & Rs("Inform_Title") & " ] 已通过审核!"
End IF
Rs.update
Rs.close
set Rs=nothing
ToHistory=VisitorsForm
Call Form_Saveok()
Case "Delall"
IF Request.form("Id")="" THEN
Errorst="请选择要删除的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "Delete From Tx_Inform Where Inform_Id in (" & Request.form("Id") & ")"
ToHistory="Aa_Inform.asp?Action=Manage"
saveok="删除成功!"
Call Form_Saveok()
End IF
Case "FlagallOk"
IF Request.form("Id")="" THEN
Errorst="请选择要审核的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "upDate Tx_Inform set Inform_Flag=1 Where Inform_Id in (" & Request.form("Id") & ")"
ToHistory=VisitorsForm
saveok="已通过审核!"
Call Form_Saveok()
End IF
Case "FlagallNo"
IF Request.form("Id")="" THEN
Errorst="请选择要取消审核的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "upDate Tx_Inform set Inform_Flag=0 Where Inform_Id in (" & Request.form("Id") & ")"
ToHistory=VisitorsForm
saveok="已取消审核!"
Call Form_Saveok()
End IF
End Select
Call Page_Spane(5)
Call CloseConn()
Call Page_EndBody()
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -