<% Set DBC = New DataBaseClass Set Conn = DBC.OpenConnection() Set DBC = Nothing %> <% set confimsn=conn.execute("select ReviewShow,domain from FS_config") if Request("Newsid")="" and Request("Downloadid")="" Then Response.Write("错误的参数") Response.End end if Dim Newsid,ReviewList,Content1,RsReview,sql,TempRsNewsObj1,Downloadid Newsid = Replace(Replace(Trim(Request("Newsid")),"'","''"),Chr(39),"") Downloadid = Replace(Replace(Trim(Request("Downloadid")),"'","''"),Chr(39),"") if Newsid<>"" Then Set TempRsNewsObj1 = Conn.Execute("Select ShowReviewTF,ReviewTF from FS_News where Newsid='" & Newsid & "'") if cint(TempRsNewsObj1("ShowReviewTF")) = 0 then response.Write("") response.end end if Set RsReview1 = server.CreateObject (G_FS_RS) Sql1 = "select * from FS_Review where Types = 1 and Newsid='" & Newsid &"' and isv=1 order by ID desc" RsReview1.Open Sql1,Conn,1,1 set RsReview = server.CreateObject (G_FS_RS) Sql = "select top 10 * from FS_Review where Types = 1 and Newsid='" & Newsid &"' and isv=1 order by ID desc" RsReview.Open Sql,Conn,1,3 ReviewList="" while Not RsReview.Eof if len(RsReview("Content"))>30 then Content1=""& RsReview("Content") &".." else Content1=""& RsReview("Content") &"" end if if confimsn("ReviewShow") = 1 then if RsReview("Audit") = 1 then ReviewList=ReviewList & "" else ReviewList=ReviewList & "" end if else ReviewList=ReviewList & "" end if RsReview.movenext Wend ReviewList=ReviewList & "
评论用户简单内容(共 "&RsReview1.recordcount&" 个评论)  查看全部内容发表日期
"& RsReview("UserID") &""& Content1 &""&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
"& RsReview("UserID") &"管理员还没有审核"&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
"& RsReview("UserID") &""& Content1 &""&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
" elseif Downloadid<>"" Then Set TempRsNewsObj1 = Conn.Execute("Select ShowReviewTF,ReviewTF from FS_download where Downloadid='" & Downloadid & "'") if cint(TempRsNewsObj1("ShowReviewTF")) = 0 then response.Write("") response.end end if set RsReview1 = server.CreateObject (G_FS_RS) Sql1 = "select * from FS_Review where Types = 2 and Newsid='" & Downloadid &"' and isv=1 order by ID desc" RsReview1.Open Sql1,Conn,1,1 set RsReview = server.CreateObject (G_FS_RS) Sql = "select top 10 * from FS_Review where Types = 2 and Newsid='"& Downloadid &"' and isv=1 order by ID desc" RsReview.Open Sql,Conn,1,3 ReviewList="" while Not RsReview.Eof if len(RsReview("Content"))>30 then Content1=""& Left(RsReview("Content"),30) &".." else Content1=""& RsReview("Content") &"" end if if confimsn("ReviewShow") = "1" then if RsReview("Audit") = "1" then ReviewList=ReviewList & "" else ReviewList=ReviewList & "" end if else ReviewList=ReviewList & "" end if RsReview.movenext wend ReviewList=ReviewList & "
作者简单内容(共"&RsReview1.recordcount&"个评论) 查看全部内容发表日期
"& RsReview("UserID") &""&Content1&""&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
"& RsReview("UserID") &"管理员还没有审核"&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
"& RsReview("UserID") &""&Content1&""&month(RsReview("AddTime"))&"-"&day(RsReview("AddTime"))&" "&Hour(RsReview("AddTime"))&":"&minute(RsReview("AddTime"))&"
" End if Response.write "document.write ('"& ReviewList &"')" RsReview1.close Set RsReview1=nothing RsReview.close Set RsReview=nothing %>