addnews3.asp

一个不错的代码 一个不错的代码 一个不错的代码

<!--#include file=conn.asp -->
<!--#include file=../include/config.asp -->
<%
IF not(Session("KEY")="super"  or Session("KEY")="input") THEN
response.redirect "login.asp"
response.end
END IF


function changechr(str) 
    changechr=replace(replace(replace(replace(str,"<","&lt;"),">","&gt;"),chr(13),"<br>")," "," ") 
    changechr=replace(changechr,"'","&quot;")
    changechr=replace(changechr,mid(" "" ",2,1),"&quot;")
end function


SmallClassName=Request.Form("SmallClassName")
if SmallClassName="" then
%>
<script language=javascript>
history.back()
alert("请选择该新闻所属小类")
</script>
<%
Response.End
end if


txttitle=request.form("txttitle")
if txttitle="" then
%>
<script language=javascript>
history.back()
alert("请填写新闻标题！")
</script>
<%
Response.End
end if

if len(txttitle)>100 then
%>
<script language=javascript>
history.back()
alert("新闻标题过长！")
</script>
<%
Response.End
end if

Content=Request.Form("Content")
if Content="" then
%>
<script language=javascript>
history.back()
alert("请输入新闻内容！")
</script>

<%
Response.End
end if

if request.Form("goodnews")="1" then
goodnews=1
else
goodnews=0
end if

if request.Form("hot")="1" then
hot=1
else
hot=0
end if

if request.Form("sypic")="1" then
sypic=1
else
sypic=0
end if

SpecialID=Request.Form("SpecialID")
title=changechr(trim(request.form("txttitle")))
Author=replace(trim(Request.Form("Author")),"'","''")
Original=replace(trim(Request.Form("Original")),"'","''")
about=Request.Form("about")
image=Request.Form("image")
BigClassName=Request.Form("BigClassName")
EnCode=Request.Form("EnCode")

set rs=server.createobject("adodb.recordset")
sql="select * from news" 
rs.open sql,conn,1,3
rs.addnew
rs("title")=title
rs("Author")=Author
rs("content")=content
rs("Original")=Original
rs("hot")=hot
rs("goodnews")=goodnews
rs("sypic")=sypic
rs("image")=image
rs("BigClassName")=BigClassName
rs("SmallClassName")=SmallClassName
rs("SpecialID")=SpecialID
rs("EnCode")=EnCode
rs("about")=about
rs("UpdateTime")=now()
rs.update


if sypic=1 then
set rs=server.CreateObject("adodb.recordset")
rs.Source="select top " & PicNum &" NewsID,Title,BigClassName,SmallClassName,SpecialID,UpdateTime from News where sypic=1 order by NewsID DESC "
rs.Open rs.Source,conn,1,1

set fs=server.CreateObject("Scripting.FileSystemObject")

FilePath=server.MapPath("../LastPIC.js")

set JSFile=fs.CreateTextFile(FilePath)

JSFile.writeline("document.write(""<table cellpadding=3 cellspacing=0 border=0 >"")")

while not rs.EOF
JSFile.writeline("document.write(""   <tr>"")")
JSFile.writeline("document.write(""     <td width=100% align=center>"")")
strpic="<img border=0 src=http://" & xpurl & "/images/news/"&rs("NewsID" )&"-1.jpg width=125><br>"
JSFile.writeline("document.write(""" &  Strpic & """)")
JSFile.writeline("document.write(""     <td width=100% >"")")
JSFile.writeline("document.write(""   </tr>"")")
JSFile.writeline("document.write(""   <tr>"")")
JSFile.writeline("document.write(""     <td width=100% align=center>"")")
StrNews="<a href='http://" & xpurl & "/ReadNews.asp?NewsID=" & rs("NewsID") &  "&BigClassName=" & rs("BigClassName") & "&SmallClassName=" & rs("SmallClassName") & "&SpecialID=" & rs("SpecialID") & "' target=_blank>" & trim(rs("Title")) & "</a>"
JSFile.writeline("document.write(""" &  StrNews & """)")
JSFile.writeline("document.write(""     <td width=100% >"")")
JSFile.writeline("document.write(""   </tr>"")")
rs.MoveNext
wend
JSFile.writeline("document.write(""</table>"")")
end if
set JSFile=nothing
set fs=nothing

rs.Close
set rs=nothing
conn.close
set conn=nothing

if image=0 then
Response.Redirect "CreateJS.asp"
else
Response.Redirect "xpupload.asp?title=" & title
end if%>