- Visual C++源码
- Visual Basic源码
- C++ Builder源码
- Java源码
- Delphi源码
- C/C++源码
- PHP源码
- Perl源码
- Python源码
- Asm源码
- Pascal源码
- Borland C++源码
- Others源码
- SQL源码
- VBScript源码
- JavaScript源码
- ASP/ASPX源码
- C#源码
- Flash/ActionScript源码
- matlab源码
- PowerBuilder源码
- LabView源码
- Flex源码
- MathCAD源码
- VBA源码
- IDL源码
- Lisp/Scheme源码
- VHDL源码
- Objective-C源码
- Fortran源码
- tcl/tk源码
- QT源码
MessageList.Asp
上传用户:mtjhgs
上传日期:2021-12-08
资源大小:3755k
文件大小:9k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
HTML/CSS
- <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
- <!--#include file="../Include/Const.asp" -->
- <!--#include file="../Include/NoHackSql.Asp" -->
- <!--#include file="../Include/ConnSiteData.asp" -->
- <%call SiteInfo
- headid=10
- Seotitle="View Message"
- %>
- <!--#include file="Head.Asp" -->
- <div class="clear"></div>
- <div id="contant">
- <div class="cleft">
- <div class="news">
- <div class="title">
- <b>News Sort</b>
- </div>
- <div>
- <ul>
- <%=WebMenu()%>
- </ul>
- </div>
- </div>
- </div>
- <div class="cright">
- <div class="crightb">
- <div class="crightbtitle">
- <div class="crightbtitlel">
- Location:
- </div>
- <div class="crightbtitler">
- <%=WebLocation()%>
- </div>
- </div>
- <div class="crightbcontent">
- <table border="0" cellpadding="0" cellspacing="0" width="100%">
- <tr>
- <td height="20"><%=WebContent()%></td>
- </tr>
- </table></div>
- </div>
- </div>
- </div>
- <!--#include file="Foot.Asp"-->
- <%
- function WebMenu()
- response.write "<Li> <img src=""images/Tx_Ar3.gif"" style=""margin-left:5px;"" /><a href=""MessageWrite.asp"" style=""margin-left:5px;"">Leave Message</a></li>"
- response.write "<Li> <img src=""images/Tx_Ar3.gif"" style=""margin-left:5px;"" /><a href=""MessageList.asp"" style=""margin-left:5px;"">All Message</a></li>"
- response.write "<Li> <img src=""images/Tx_Ar3.gif"" style=""margin-left:5px;"" /><a href=""MemberMessage.asp"" style=""margin-left:5px;"">My Message</a></li>"
- end function
- function WebLocation()
- WebLocation=" Location:<a href=""index.asp"" class=""agray"">Home</a> - <a href=""MessageList.asp"" class=""agray"">Feedback</a> - View Message"&VbCrLf
- end Function
- function WebContent()
- dim idCount
- dim pages
- pages=MessageInfo
- dim pagec
- dim page
- page=clng(request("Page"))
- dim pagenc
- pagenc=5
- dim pagenmax
- dim pagenmin
- dim pageprevious
- dim pagenext
- dim datafrom
- datafrom="Wygkcnflash_Message "
- dim datawhere
- datawhere="where ViewFlag"&Language&" "
- dim sqlid
- dim Myself,PATH_INFO,QUERY_STRING
- PATH_INFO = request.servervariables("PATH_INFO")
- QUERY_STRING = request.ServerVariables("QUERY_STRING")'
- if QUERY_STRING = "" then
- Myself = PATH_INFO & "?"
- elseif Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")=0 then
- Myself= PATH_INFO & "?" & QUERY_STRING & "&"
- else
- Myself = Left(PATH_INFO & "?" & QUERY_STRING,Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")-1)
- end if
- dim taxis
- taxis="order by id desc "
- dim i
- dim rs,sql
- set rs = server.createobject("adodb.recordset")
- sql="select count(ID) as idCount from ["& datafrom &"]" & datawhere
- set rs=server.createobject("adodb.recordset")
- rs.open sql,conn,0,1
- idCount=rs("idCount")
- if(idcount>0) then
- if(idcount mod pages=0)then
- pagec=int(idcount/pages)
- else
- pagec=int(idcount/pages)+1
- end if
- sql="select id from ["& datafrom &"] " & datawhere & taxis
- set rs=server.createobject("adodb.recordset")
- rs.open sql,conn,1,1
- rs.pagesize = pages
- if page < 1 then page = 1
- if page > pagec then page = pagec
- if pagec > 0 then rs.absolutepage = page
- for i=1 to rs.pagesize
- if rs.eof then exit for
- if(i=1)then
- sqlid=rs("id")
- else
- sqlid=sqlid &","&rs("id")
- end if
- rs.movenext
- next
- end if
- if(idcount>0 and sqlid<>"") then
- sql="select * from ["& datafrom &"] where id in("& sqlid &") "&taxis
- set rs=server.createobject("adodb.recordset")
- rs.open sql,conn,0,1
- while not rs.eof
- Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"">"&VbCrLf
- Response.Write " <tr>"&VbCrLf
- Response.Write " <td width=""5%"" height=""25"" bgcolor=""#820000"" align=""center""><font color=""#FFFFFF""><b>"&rs("ID")&"</b></font></td>"&VbCrLf
- Response.Write " <td width=""50%"" height=""25"" bgcolor=""#EDEEEF"" align=""left"" style=""padding-left: 8px""><font color=""#333333""><b>"&rs("Company")&"</b></font>("&rs("Linkman")&""&rs("Sex")&")</td>"&VbCrLf
- Response.Write " <td width=""45%"" height=""25"" bgcolor=""#EDEEEF"" align=""right"" style=""padding-right: 8px""><font color=""#808080"">Message time:</font>"&rs("Addtime")&"</td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- Response.Write "</table>"&VbCrLf
- Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""1"">"&VbCrLf
- Response.Write " <tr align=""left"">"&VbCrLf
- Response.Write " <td width=""15%"" height=""20"" align=""right"" style=""padding-right: 8px"">Message topic:</td>"&VbCrLf
- Response.Write " <td><b>"&rs("MesName")&"</b></td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- Response.Write " <tr align=""left"">"&VbCrLf
- Response.Write " <td height=""20"" align=""right"" style=""padding-right: 8px"">Message Content:</td>"&VbCrLf
- Response.Write " <td style=""padding-right: 5px"">"&MessageContent(rs("MemID"),rs("SecretFlag"),HtmlStrReplace(rs("Content")))&"</td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- If rs("ReplyContent") <> "" Then
- Response.Write " <tr>"&VbCrLf
- Response.Write " <td> </td>"&VbCrLf
- Response.Write " <td bgcolor=""#F7F7F7"" style=""line-height: 200%""><font color=""#333333""><b>Reply :</b></font><br />"&MessageReply (rs("MemID"),rs("MesName"),rs("SecretFlag"),rs("ReplyContent"))&"</td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- End If
- Response.Write " <tr>"&VbCrLf
- Response.Write " <td colspan=""2"" height=""5""></td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- Response.Write "</table>"&VbCrLf
- rs.movenext
- wend
- else
- response.write "<center>No Information</center>"
- exit function
- end if
- Response.Write "<table width=""98%"" border=""0"" cellspacing=""0"" cellpadding=""0"">"&VbCrLf
- Response.Write " <tr height=""35"">"&VbCrLf
- Response.Write " <td align=""center"">"&VbCrLf
- Response.Write "Total:<strong style=""color:red"">"&idcount&"</strong>Records Page:<strong style=""color:red"">"&page&"</strong>/"&pagec&" PageSize:<strong style=""color:red"">"&pages&"</strong>Records" & vbCrLf
- pagenmin=page-pagenc
- pagenmax=page+pagenc
- if(pagenmin<1) then pagenmin=1
- if(page>1) then response.write ("<a href="""& myself &"Page=1"" title=""Return to page 1""><font face=""webdings"" color=""#000000"">9</font></a> ")
- if page-(pagenc*2+1)<=0 then
- pageprevious=1
- else
- pageprevious=page-(pagenc*2+1)
- end if
- if(pagenmin>1) then response.write ("<a href="""& myself &"Page="& pageprevious &""" title=""page"& pageprevious &"""><font face=""webdings"" color=""#000000"">3</font></a> ")
- if(pagenmax>pagec) then pagenmax=pagec
- for i = pagenmin to pagenmax
- if(i=page) then
- response.write (" <strong style=""color:red"">"& i &"</strong> ")
- else
- response.write ("[<a href="""& myself &"Page="& i &""">"& i &"</a>]")
- end if
- next
- if page+(pagenc*2+1)>=pagec then
- pagenext=pagec
- else
- pagenext=page+(pagenc*2+1)
- end if
- if(pagenmax<pagec) then response.write (" <a href="""& myself &"Page="& pagenext &""" title=""Go to page"&pagenext&"""><font face=""webdings"" color=""#999999"">:</font></a> ")
- if(page<pagec) then response.write (" <a href="""& myself &"Page="& pagec &""" title=""Go to page"&pagec&"""><font face=""webdings"" color=""#000000"">:</font></a>")
- Response.Write " </td>"&VbCrLf
- Response.Write " </tr>"&VbCrLf
- Response.Write "</table>"&VbCrLf
- rs.close
- set rs=nothing
- end function
- function MessageContent(MemID,SecretFlag,Content)
- if SecretFlag then
- dim rs,sql
- set rs = server.createobject("adodb.recordset")
- sql="select * from Wygkcnflash_Members where ID="&MemID
- rs.open sql,conn,1,1
- if rs("MemName")=session("MemName") and session("MemLogin")="Succeed" then
- MessageContent= Content
- else
- MessageContent="Secret message"
- end if
- rs.close
- set rs=nothing
- else
- MessageContent=Content
- end if
- end function
- function MessageReply(MemID,MesName,SecretFlag,ReplyContent)
- if ReplyContent<>"" then
- if SecretFlag then
- dim rs,sql
- set rs = server.createobject("adodb.recordset")
- sql="select * from Wygkcnflash_Members where ID="&MemID
- rs.open sql,conn,1,1
- if rs("MemName")=session("MemName") and session("MemLogin")="Succeed" then
- MessageReply=MessageReply&HtmlStrReplace(ReplyContent)
- else
- MessageReply=MessageReply&"<font color=""#CC0000"">Please sign in.</font>"
- end if
- rs.close
- set rs=nothing
- else
- MessageReply=MessageReply&HtmlStrReplace(ReplyContent)
- end if
- end if
- end function
- %>