MessageList.Asp
上传用户:mtjhgs
上传日期:2021-12-08
资源大小:3755k
文件大小:9k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

HTML/CSS

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <!--#include file="../Include/Const.asp" -->
  3. <!--#include file="../Include/NoHackSql.Asp" -->
  4. <!--#include file="../Include/ConnSiteData.asp" -->
  5. <%call SiteInfo
  6. headid=10
  7. Seotitle="View Message"
  8. %>
  9. <!--#include file="Head.Asp" -->
  10. <div class="clear"></div>
  11. <div id="contant">
  12.   <div class="cleft">
  13. <div class="news">
  14.       <div class="title">
  15.   &nbsp;<b>News Sort</b>
  16.   </div>
  17.   <div>
  18.   <ul>
  19. <%=WebMenu()%>
  20.  </ul>
  21.   </div>
  22.     </div>
  23.   </div>
  24.   <div class="cright">
  25. <div class="crightb">
  26.   <div class="crightbtitle">
  27.     <div class="crightbtitlel">
  28. Location:
  29. </div>
  30. <div class="crightbtitler">
  31. <%=WebLocation()%>
  32. </div>
  33.   </div>
  34.   <div class="crightbcontent">
  35. <table border="0" cellpadding="0" cellspacing="0" width="100%">
  36.         <tr>
  37.           <td height="20"><%=WebContent()%></td>
  38.         </tr>
  39.       </table></div>
  40. </div>
  41.   </div>
  42. </div>
  43. <!--#include file="Foot.Asp"-->
  44. <%
  45. function WebMenu()
  46.   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>"
  47.   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>"
  48.   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>"
  49. end function
  50. function WebLocation()
  51.   WebLocation="&nbsp;Location:<a href=""index.asp"" class=""agray"">Home</a> - <a href=""MessageList.asp"" class=""agray"">Feedback</a> - View Message"&VbCrLf
  52. end Function
  53. function WebContent()
  54.   dim idCount
  55.   dim pages
  56.       pages=MessageInfo
  57.   dim pagec
  58.   dim page
  59.       page=clng(request("Page"))
  60.   dim pagenc
  61.       pagenc=5
  62.   dim pagenmax
  63.   dim pagenmin
  64.   dim pageprevious
  65.   dim pagenext
  66.   dim datafrom
  67.       datafrom="Wygkcnflash_Message "
  68.   dim datawhere
  69.   datawhere="where ViewFlag"&Language&" "
  70.   dim sqlid
  71.   dim Myself,PATH_INFO,QUERY_STRING
  72.       PATH_INFO = request.servervariables("PATH_INFO")
  73.   QUERY_STRING = request.ServerVariables("QUERY_STRING")'
  74.       if QUERY_STRING = "" then
  75.     Myself = PATH_INFO & "?"
  76.   elseif Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")=0 then
  77.     Myself= PATH_INFO & "?" & QUERY_STRING & "&"
  78.   else
  79.     Myself = Left(PATH_INFO & "?" & QUERY_STRING,Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")-1)
  80.   end if
  81.   dim taxis
  82.       taxis="order by id desc "
  83.   dim i
  84.   dim rs,sql
  85.   set rs = server.createobject("adodb.recordset")
  86.   sql="select count(ID) as idCount from ["& datafrom &"]" & datawhere
  87.   set rs=server.createobject("adodb.recordset")
  88.   rs.open sql,conn,0,1
  89.   idCount=rs("idCount")
  90.   if(idcount>0) then
  91.     if(idcount mod pages=0)then
  92.   pagec=int(idcount/pages)
  93.     else
  94.       pagec=int(idcount/pages)+1
  95.     end if
  96.     sql="select id from ["& datafrom &"] " & datawhere & taxis
  97.     set rs=server.createobject("adodb.recordset")
  98.     rs.open sql,conn,1,1
  99.     rs.pagesize = pages
  100.     if page < 1 then page = 1
  101.     if page > pagec then page = pagec
  102.     if pagec > 0 then rs.absolutepage = page
  103.     for i=1 to rs.pagesize
  104.   if rs.eof then exit for
  105.   if(i=1)then
  106.     sqlid=rs("id")
  107.   else
  108.     sqlid=sqlid &","&rs("id")
  109.   end if
  110.   rs.movenext
  111.     next
  112.   end if
  113.   if(idcount>0 and sqlid<>"") then
  114.     sql="select * from ["& datafrom &"] where id in("& sqlid &") "&taxis
  115.     set rs=server.createobject("adodb.recordset")
  116.     rs.open sql,conn,0,1
  117.     while not rs.eof
  118. Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"">"&VbCrLf
  119. Response.Write "  <tr>"&VbCrLf
  120. Response.Write "    <td width=""5%"" height=""25"" bgcolor=""#820000"" align=""center""><font color=""#FFFFFF""><b>"&rs("ID")&"</b></font></td>"&VbCrLf
  121. 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
  122. 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
  123. Response.Write "  </tr>"&VbCrLf
  124. Response.Write "</table>"&VbCrLf
  125. Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""1"">"&VbCrLf
  126. Response.Write "  <tr align=""left"">"&VbCrLf
  127. Response.Write "    <td width=""15%"" height=""20"" align=""right"" style=""padding-right: 8px"">Message topic:</td>"&VbCrLf
  128. Response.Write "    <td><b>"&rs("MesName")&"</b></td>"&VbCrLf
  129. Response.Write "  </tr>"&VbCrLf
  130. Response.Write "  <tr align=""left"">"&VbCrLf
  131. Response.Write "    <td height=""20"" align=""right"" style=""padding-right: 8px"">Message Content:</td>"&VbCrLf
  132. Response.Write "    <td style=""padding-right: 5px"">"&MessageContent(rs("MemID"),rs("SecretFlag"),HtmlStrReplace(rs("Content")))&"</td>"&VbCrLf
  133. Response.Write "  </tr>"&VbCrLf
  134. If rs("ReplyContent") <> "" Then
  135. Response.Write "  <tr>"&VbCrLf
  136. Response.Write "    <td>&nbsp;</td>"&VbCrLf
  137. 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
  138. Response.Write "  </tr>"&VbCrLf
  139. End If
  140. Response.Write "  <tr>"&VbCrLf
  141. Response.Write "    <td colspan=""2"" height=""5""></td>"&VbCrLf
  142. Response.Write "  </tr>"&VbCrLf
  143. Response.Write "</table>"&VbCrLf
  144. rs.movenext
  145.     wend
  146.   else
  147.     response.write "<center>No Information</center>"
  148. exit function
  149.   end if
  150.   Response.Write "<table width=""98%"" border=""0"" cellspacing=""0"" cellpadding=""0"">"&VbCrLf
  151.   Response.Write "  <tr height=""35"">"&VbCrLf
  152.   Response.Write "    <td align=""center"">"&VbCrLf
  153.   Response.Write "Total:<strong style=""color:red"">"&idcount&"</strong>Records&nbsp;&nbsp;Page:<strong style=""color:red"">"&page&"</strong>/"&pagec&" PageSize:<strong style=""color:red"">"&pages&"</strong>Records" & vbCrLf
  154.   pagenmin=page-pagenc
  155.   pagenmax=page+pagenc
  156.   if(pagenmin<1) then pagenmin=1
  157.   if(page>1) then response.write ("<a href="""& myself &"Page=1"" title=""Return to page 1""><font face=""webdings"" color=""#000000"">9</font></a> ")
  158.   if page-(pagenc*2+1)<=0 then
  159. pageprevious=1
  160.   else
  161. pageprevious=page-(pagenc*2+1)
  162.   end if
  163.   if(pagenmin>1) then response.write ("<a href="""& myself &"Page="& pageprevious &""" title=""page"& pageprevious &"""><font face=""webdings"" color=""#000000"">3</font></a> ")
  164.   if(pagenmax>pagec) then pagenmax=pagec
  165.   for i = pagenmin to pagenmax
  166. if(i=page) then
  167.   response.write ("&nbsp;<strong style=""color:red"">"& i &"</strong>&nbsp;")
  168. else
  169.   response.write ("[<a href="""& myself &"Page="& i &""">"& i &"</a>]")
  170. end if
  171.   next
  172.   if page+(pagenc*2+1)>=pagec then
  173.     pagenext=pagec
  174.   else
  175.     pagenext=page+(pagenc*2+1)
  176.   end if
  177.   if(pagenmax<pagec) then response.write (" <a href="""& myself &"Page="& pagenext &""" title=""Go to page"&pagenext&"""><font face=""webdings"" color=""#999999"">:</font></a> ")
  178.   if(page<pagec) then response.write (" <a href="""& myself &"Page="& pagec &""" title=""Go to page"&pagec&"""><font face=""webdings"" color=""#000000"">:</font></a>")
  179.   Response.Write "    </td>"&VbCrLf
  180.   Response.Write "  </tr>"&VbCrLf
  181.   Response.Write "</table>"&VbCrLf
  182.   rs.close
  183.   set rs=nothing
  184. end function
  185. function MessageContent(MemID,SecretFlag,Content)
  186.   if SecretFlag then
  187.     dim rs,sql
  188.     set rs = server.createobject("adodb.recordset")
  189.     sql="select * from Wygkcnflash_Members where ID="&MemID
  190.     rs.open sql,conn,1,1
  191.     if rs("MemName")=session("MemName") and session("MemLogin")="Succeed" then
  192.   MessageContent= Content
  193. else
  194.   MessageContent="Secret message"
  195. end if
  196.     rs.close
  197.     set rs=nothing
  198.   else
  199.     MessageContent=Content
  200.   end if
  201. end function
  202. function MessageReply(MemID,MesName,SecretFlag,ReplyContent)
  203.   if ReplyContent<>"" then
  204.     if SecretFlag then
  205.       dim rs,sql
  206.       set rs = server.createobject("adodb.recordset")
  207.       sql="select * from Wygkcnflash_Members where ID="&MemID
  208.       rs.open sql,conn,1,1
  209.       if rs("MemName")=session("MemName") and session("MemLogin")="Succeed" then
  210.         MessageReply=MessageReply&HtmlStrReplace(ReplyContent)
  211.   else
  212.         MessageReply=MessageReply&"<font color=""#CC0000"">Please sign in.</font>"
  213.   end if
  214.       rs.close
  215.       set rs=nothing
  216.     else
  217.         MessageReply=MessageReply&HtmlStrReplace(ReplyContent)
  218.     end if
  219.   end if
  220. end function
  221. %>