index_left.asp 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <!--#include file="common.asp"-->
  2. <!--#include file="CheckComeUrl.asp"-->
  3. <%
  4. Dim uid, rsRole, isAdmin, psql, rsp, arealist, arealist_arr, userGroupID0
  5. uid = trim(request("uid"))
  6. if Lcase(AdminName) = "admin" then
  7. isAdmin = true
  8. else
  9. isAdmin = false
  10. set userGroupID0 = conn.execute("select group_id from t_role_user where userid = '" & trim(AdminName) & "'")
  11. psql = "select t_classid,parentpath from t_area where t_classid in (select areaid from t_dev_property where uid in (select uid from t_role_equip where group_id = " & userGroupID0(0) & "))"
  12. set rsp = conn.execute(psql)
  13. if rsp.bof and rsp.eof then
  14. arealist = ""
  15. else
  16. do while not rsp.eof
  17. if arealist = "" then
  18. arealist = rsp(0) & "," & rsp(1)
  19. else
  20. arealist = arealist & "," & rsp(0) & "," & rsp(1)
  21. end if
  22. rsp.movenext
  23. loop
  24. end if
  25. rsp.close
  26. set rsp = nothing
  27. if arealist = "" then arealist = "0"
  28. end if
  29. %>
  30. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  31. <html xmlns="http://www.w3.org/1999/xhtml">
  32. <head>
  33. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  34. <title><%=systemPageTitle%></title>
  35. <link href="bs2010.css" rel="stylesheet" type="text/css" />
  36. <script type="text/javascript" src="js/share.js"></script>
  37. <link rel="stylesheet" href="jquery.treeview.css" />
  38. <link rel="stylesheet" href="screen.css" />
  39. <script src="lib/jquery.js" type="text/javascript"></script>
  40. <script src="lib/jquery.cookie.js" type="text/javascript"></script>
  41. <script src="jquery.treeview.js" type="text/javascript"></script>
  42. <script type="text/javascript" src="demo.js"></script>
  43. <script language="javascript">
  44. function changeVoiceAlarm()
  45. {
  46. if(document.getElementById("voiceAlarm").checked == true)
  47. {
  48. document.cookie = "voiceAlarm" + "=" + escape("on");
  49. }
  50. else
  51. {
  52. document.cookie = "voiceAlarm" + "=" + escape("off");
  53. }
  54. window.parent['main'].location.reload();
  55. }
  56. </script>
  57. <style>
  58. html, body {
  59. overflow-x: hidden;
  60. overflow-y:auto;
  61. }
  62. </style>
  63. </head>
  64. <body style="background:url(images/2010_leftbg.gif) left top no-repeat">
  65. <div style="line-height:180%;margin-top:20px;font-weight:bold;" class="leftMenu">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index_main.asp" target="main">首页</a></div>
  66. <div><img src='images/2010_leftLine.png'></div>
  67. <div id="main">
  68. <%
  69. dim rsClass
  70. set rsClass = conn.execute("select t_classid, classname, child, parentid, classpicurl from t_area where parentid = 0 order by rootid")
  71. response.write "<ul id='navigation' class='leftMenu'>"
  72. if rsClass.bof and rsClass.eof then
  73. response.write "<span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;没有菜单</span>"
  74. else
  75. call subTree(0, "&nbsp;&nbsp;&nbsp;&nbsp;|-")
  76. end if
  77. response.write "</ul>"
  78. %>
  79. </div>
  80. <div style="height:30px;"></div>
  81. <div style=" position:absolute; z-index:20; background:#FFF; bottom:0px; width:180px; padding-left:20px; padding-bottom:10px;"><label style=" cursor:pointer;">
  82. <input type="checkbox" name="voiceAlarm" id="voiceAlarm" value="voiceAlarm" onclick="changeVoiceAlarm();" <%if request.Cookies("voiceAlarm") = "on" then response.write "checked"%> />
  83. 启用BS声音报警</label></div>
  84. <%
  85. sub subTree(parentid,str)
  86. dim rsSubClass, sql
  87. if isAdmin = false then
  88. sql = "select t_classid, classname, child, parentid, classpicurl from t_area where parentid = " & parentid & " and t_classid in (" & arealist & ") order by rootid"
  89. else
  90. sql = "select t_classid, classname, child, parentid, classpicurl from t_area where parentid = " & parentid & " order by rootid"
  91. end if
  92. set rsSubClass = conn.execute(sql)
  93. if rsSubClass.bof and rsSubClass.eof then
  94. response.write "<li><span style='margin-left:20px'>无设备</span></li>"
  95. else
  96. do while not rsSubClass.eof
  97. if isAdmin = false then
  98. response.write "<li class='open'><span>"
  99. if rsSubClass("parentid") = 0 then
  100. response.write "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
  101. else
  102. response.write str
  103. end if
  104. if rsSubClass("ClassPicUrl") <> "" then
  105. response.write "<a href='" & rsSubClass("ClassPicUrl")& "?id=" & rsSubClass("t_classid") & "' target='main'>"
  106. else
  107. response.write "<a href='javascript:;'>"
  108. end if
  109. if rsSubClass("parentid") = 0 then response.write "<strong>"
  110. response.write "<img src='images/tree_folder4.gif'>"
  111. response.write rsSubClass("classname")
  112. if rsSubClass("parentid") = 0 then response.write "</strong>"
  113. response.write "</a></span><ul>"
  114. if rsSubClass("child") <> 0 then
  115. call subTree(rsSubClass("t_classid"), "&nbsp;&nbsp;&nbsp;&nbsp;" & str)
  116. else
  117. call devList(rsSubClass("t_classid"), "&nbsp;&nbsp;&nbsp;&nbsp;" & str)
  118. end if
  119. response.write "</ul></li>"
  120. if rsSubClass("parentid") = 0 then response.write "<div style='padding-left:16px;'><img src='images/2010_leftLine.png'></div>"
  121. rsSubClass.movenext
  122. if rsSubClass.eof then
  123. rsSubClass.close
  124. exit sub
  125. end if
  126. else
  127. response.write "<li class='open'><span>"
  128. if rsSubClass("parentid") = 0 then
  129. response.write "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
  130. else
  131. response.write str
  132. end if
  133. if rsSubClass("ClassPicUrl") <> "" then
  134. response.write "<a href='" & rsSubClass("ClassPicUrl")& "?id=" & rsSubClass("t_classid") & "' target='main'>"
  135. else
  136. response.write "<a href='javascript:;'>"
  137. end if
  138. if rsSubClass("parentid") = 0 then response.write "<strong style='line-height:180%;'>"
  139. response.write "<img src='images/tree_folder4.gif'>"
  140. response.write rsSubClass("classname")
  141. if rsSubClass("parentid") = 0 then response.write "</strong>"
  142. response.write "</a></span><ul>"
  143. if rsSubClass("child") <> 0 then
  144. call subTree(rsSubClass("t_classid"), "&nbsp;&nbsp;&nbsp;&nbsp;" & str)
  145. else
  146. call devList(rsSubClass("t_classid"), "&nbsp;&nbsp;&nbsp;&nbsp;" & str)
  147. end if
  148. response.write "</ul></li>"
  149. if rsSubClass("parentid") = 0 then response.write "<div style='padding-left:16px;'><img src='images/2010_leftLine.png'></div>"
  150. rsSubClass.movenext
  151. if rsSubClass.eof then
  152. rsSubClass.close
  153. exit sub
  154. end if
  155. end if
  156. loop
  157. end if
  158. end sub
  159. sub devList(classid, str)
  160. if isAdmin = false then
  161. dim rsR, iList, userGroupID
  162. set userGroupID = conn.execute("select group_id from t_role_user where userid = '" & trim(AdminName) & "'")
  163. set rsR = conn.execute("select uid from t_role_equip where group_id = " & userGroupID(0) & " order by uid")
  164. if rsR.bof and rsR.eof then
  165. response.write "<li>" & str & "无权限<li>"
  166. else
  167. do while not rsR.eof
  168. dim rsdl, sqldl
  169. sqldl = "select * from t_dev_property where areaid = " & classid & " and uid = '" & rsR(0) & "' and isuse = '1' order by uid, devicename"
  170. set rsdl = server.CreateObject("adodb.recordset")
  171. rsdl.open sqldl, conn, 1, 1
  172. do while not rsdl.eof
  173. response.write "<li class='equiplink'>" & str & "<a href='index_main.asp?uid=" & rsdl("uid") & "' target='main'>"
  174. if instr(rsdl("devicename"),"(") <> 0 then
  175. response.write left(rsdl("devicename"),instr(rsdl("devicename"),"(")-1)
  176. else
  177. response.write rsdl("devicename")
  178. end if
  179. response.write "</a></li>"
  180. rsdl.movenext
  181. loop
  182. rsdl.close
  183. set rsdl = nothing
  184. rsR.movenext
  185. loop
  186. end if
  187. rsR.close
  188. set rsR = nothing
  189. else
  190. sqldl = "select * from t_dev_property where areaid = " & classid & " and isuse = '1' order by uid,devicename"
  191. set rsdl = server.CreateObject("adodb.recordset")
  192. rsdl.open sqldl, conn, 1, 1
  193. if rsdl.bof and rsdl.eof then
  194. response.write "<li>" & str & "无设备</li>"
  195. else
  196. do while not rsdl.eof
  197. response.write "<li class='equiplink'><div>" & str & "<a href='index_main.asp?uid=" & rsdl("uid") & "' target='main'>"
  198. if instr(rsdl("devicename"),"(") <> 0 then
  199. response.write left(rsdl("devicename"),instr(rsdl("devicename"),"(")-1)
  200. else
  201. response.write rsdl("devicename")
  202. end if
  203. response.write "</a></div></li>"
  204. rsdl.movenext
  205. loop
  206. end if
  207. rsdl.close
  208. set rsdl = nothing
  209. end if
  210. end sub
  211. %>
  212. </body>
  213. </html>
  214. <%
  215. Call CloseConn
  216. function inArr(id,arr)
  217. dim i
  218. for i = lbound(arr) to ubound(arr)
  219. if int(id) = int(arr(i)) then
  220. inArr = true
  221. exit function
  222. end if
  223. next
  224. inArr = false
  225. end function
  226. %>