PageRenderTime 26ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/Wap/Plus/Vote.asp

https://github.com/joechen2010/health
ASP | 132 lines | 125 code | 2 blank | 5 comment | 0 complexity | 70092b329522a84b76c7ee437abbd3e5 MD5 | raw file
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <%
  3. Option Explicit
  4. '********************************
  5. '* 程序功能:调查结果
  6. '* 演示地址: http://wap.kesion.com/
  7. '********************************
  8. %>
  9. <!--#include file="../Conn.asp"-->
  10. <!--#include file="../KS_Cls/Kesion.CommonCls.asp"-->
  11. <%Response.ContentType = "text/vnd.wap.wml; charset=utf-8"%><?xml version="1.0" encoding="utf-8"?>
  12. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
  13. <wml>
  14. <head>
  15. <meta http-equiv="Cache-Control" content="no-Cache"/>
  16. <meta http-equiv="Cache-Control" content="max-age=0"/>
  17. </head>
  18. <card id="main" title="调查结果">
  19. <p>
  20. <%
  21. Dim KSCls
  22. Set KSCls = New Vote
  23. KSCls.Kesion()
  24. Set KSCls = Nothing
  25. %>
  26. </p>
  27. </card>
  28. </wml>
  29. <%
  30. Class Vote
  31. Private KS
  32. Private Sub Class_Initialize()
  33. Set KS=New PublicCls
  34. End Sub
  35. Private Sub Class_Terminate()
  36. Call CloseConn()
  37. Set KS=Nothing
  38. End Sub
  39. Sub Kesion()
  40. Dim Action,ID,VoteType,VoteOption,sqlVote,rsVote
  41. Action = KS.S("Action")
  42. ID = KS.ChkClng(KS.S("ID"))
  43. VoteType = KS.S("VoteType")
  44. VoteOption= KS.S("VoteOption")
  45. If Action = "Vote" And Id<> "" And VoteOption<>"" And Session("Voted" &ID) = "" Then
  46. If VoteType="Single" Then
  47. Conn.Execute "Update KS_Vote set answer" & VoteOption & "= answer" & VoteOption & "+1 where ID=" & ID
  48. Else
  49. Dim ArrOptions
  50. If Instr(VoteOption,",")>0 Then
  51. ArrOptions=split(VoteOption,",")
  52. Dim i
  53. For i=0 To ubound(arrOptions)
  54. Conn.Execute "Update KS_Vote set answer" & Cint(Trim(ArrOptions(i))) & "= Answer" & Cint(Trim(ArrOptions(i))) & "+1 where ID=" & Clng(ID)
  55. Next
  56. Else
  57. Conn.Execute "Update KS_Vote set answer" & VoteOption & "= answer" & VoteOption & "+1 where ID=" & Clng(ID)
  58. End If
  59. End If
  60. Session("Voted" & ID)="True"
  61. End If
  62. If ID<>"" Then
  63. sqlVote="Select * From KS_Vote Where ID=" & Clng(ID)
  64. Else
  65. sqlVote="select top 1 * From KS_Vote order by NewestTF desc"
  66. End If
  67. Set rsVote = Server.CreateObject("ADODB.Recordset")
  68. rsVote.Open sqlVote,Conn,1,1
  69. If not rsVote.EOF Then
  70. If Session("voted" & ID)="" Then
  71. If Cbool(KSUser.UserLoginChecked)=True Then Response.Write KSUser.RealName & ","
  72. Response.Write "您还没有投票,请您在此投下您宝贵的一票!<br/>"
  73. Response.Write "" & rsVote("Title") & "<br/>"
  74. Response.Write "<select name='VoteOption'>"
  75. If rsVote("VoteType")="Single" Then
  76. For i=1 to 8
  77. If trim(rsVote("Select" & i) & "")="" Then Exit For
  78. Response.Write "<option value='" & i & "'>" & rsVote("Select" & i) & "</option>"
  79. Next
  80. Else
  81. For i=1 To 8
  82. If Trim(rsVote("Select" & i) & "")="" Then Exit For
  83. Response.Write "<option value='" & i & "'>" & rsVote("Select" & i) & "</option>"
  84. Next
  85. End If
  86. Response.Write "</select> "
  87. Response.Write "<anchor>投一票<go href=""Vote.asp?Action=Vote&amp;" & KS.WapValue & """ method=""post"">"
  88. Response.Write "<postfield name=""VoteOption"" value=""$(VoteOption)""/>"
  89. Response.Write "<postfield name=""VoteType"" value=""" & rsVote("VoteType") & """/>"
  90. Response.Write "<postfield name=""ID"" value=""" & rsVote("ID") & """/>"
  91. Response.Write "</go></anchor><br/>"
  92. Response.Write "<br/>"
  93. End If
  94. If Action="Vote" And session("voted" & ID)<>"" Then
  95. If Cbool(KSUser.UserLoginChecked)=True Then Response.Write KSUser.RealName & ","
  96. Response.Write "非常感谢您的投票!<br/>"
  97. End If
  98. Response.Write "调查内容:<b>"&rsVote("Title")&"</b><br/>"
  99. Response.Write "总投票数:"
  100. Dim totalVote
  101. TotalVote=0
  102. For i=1 To 8
  103. If rsVote("Select" & i)="" Then Exit For
  104. TotalVote=TotalVote+rsVote("Answer"& i)
  105. Next
  106. Response.Write(totalVote & "票")
  107. If TotalVote=0 Then TotalVote=1
  108. Response.Write "<br/><br/>"
  109. For i=1 To 8
  110. If Trim(rsVote("Select" & i) & "")="" Then Exit For
  111. Response.Write ""&rsVote("Select"& i)&"<br/>"
  112. Response.Write "票数:"&rsVote("answer"& i)&""
  113. Dim perVote
  114. perVote=round(rsVote("answer"& i)/totalVote,4)
  115. 'Response.Write "<img src='../images/Default/bar.gif' width='" & round(260*perVote) & "' height='15'/>"
  116. perVote=perVote*100
  117. If perVote<1 And perVote<>0 Then
  118. Response.Write " 百分比:0" & perVote & "%"
  119. Else
  120. Response.Write " 百分比:" & perVote & "%"
  121. End If
  122. Response.Write "<br/>"
  123. Next
  124. End If
  125. rsVote.Close():Set rsVote = Nothing
  126. Response.Write "<br/>"
  127. Response.Write "<a href="""&KS.GetGoBackIndex&""">返回首页</a><br/>"
  128. End Sub
  129. End Class
  130. %>