/SQL/scripts/srv/srvcon.asp

http://github.com/khaneh/Orders · ASP · 56 lines · 54 code · 2 blank · 0 comment · 0 complexity · 52f763ed46818c9ed0fc96bdccfef680 MD5 · raw file 

    

  1. <!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->

    2. 

  2. <%

    3. 

  3. 	Dim myArrCon, myConCount, i, myObjStr, myStrClass, myStrImg, myStrTree

    4. 

  4. 	openConnection

    5. 

  5. 	myStrTree = getTreeStr("2_3_1", Array())

    6. 

  6. 	myArrCon = getSrvCon()

    7. 

  7. 	closeConnection

    8. 

  8. 	If isArray(myArrCon) Then myConCount = UBound(myArrCon, 2) Else myConCount = -1 End If

    9. 

  9. %>

    10. 

  10. <!-- #INCLUDE FILE="../inc/metaheader.asp" -->

    11. 

  11. <BODY>

    12. 

  12. 	<P CLASS="treeinfo"><% = myStrTree %></P>

    13. 

  13. 

    14. 

  14. 	<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">

    15. 

  15. 		<TR><TD CLASS="caption">

    16. 

  16. 		<IMG SRC="../../themes/<% = mla_cfg_theme %>/images/mylittletree/connection.gif" WIDTH="16" HEIGHT="16" BORDER=0 ALIGN="MIDDLE" ALT="Connections"> <% = myTObj.getTerm(230) %></TD></TR>

    17. 

  17. 		<TR><TD>

    18. 

  18. 			<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" SUMMARY="Connection List">

    19. 

  19. 				<THEAD>

    20. 

  20. 					<TR><TD CLASS="collabel"><% = myTObj.getTerm(240) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(241) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(242) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(243) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(122) %></TD></TR>

    21. 

  21. 				</THEAD>

    22. 

  22. 				<TBODY>

    23. 

  23. 					<%

    24. 

  24. 						Set myObjStr = New mlt_string

    25. 

  25. 						For i = 0 To myConCount

    26. 

  26. 							If i MOD 2 = 0 Then myStrClass = "odd" Else myStrClass = "even" End If

    27. 

  27. 							Select Case myArrCon(1, i) 

    28. 

  28. 								Case 1: myStrImg = "connection_ntgroup.gif"

    29. 

  29. 								Case 2 : myStrImg = "connection_ntuser.gif"

    30. 

  30. 								Case Else : myStrImg = "connection.gif"

    31. 

  31. 							End Select

    32. 

  32. 							myObjStr.strAppend "<TR CLASS=""" & myStrClass & """>" & vbCrLf

    33. 

  33. 							myObjStr.strAppend "<TD NOWRAP><IMG SRC=""../../themes/" & mla_cfg_theme & "/images/mylittletree/" & myStrImg & """ WIDTH=""16"" HEIGHT=""16"" BORDER=0 ALT=""" & myArrCon(0, i) & """ ALIGN=""MIDDLE""> "

    34. 

  34. 							myObjStr.strAppend "<B>" & myArrCon(0, i) & "</B>"

    35. 

  35. 							myObjStr.strAppend "</TD>" & vbCrLf

    36. 

  36. 							Select Case myArrCon(1, i) 

    37. 

  37. 								Case 1 : myObjStr.strAppend "<TD>" & myTObj.getTerm(244) & "</TD>" & vbCrLf

    38. 

  38. 								Case 2 : myObjStr.strAppend "<TD>" & myTObj.getTerm(245) & "</TD>" & vbCrLf

    39. 

  39. 								Case Else : myObjStr.strAppend "<TD>" & myTObj.getTerm(223) & "</TD>" & vbCrLf

    40. 

  40. 							End Select

    41. 

  41. 							myObjStr.strAppend "<TD>" & myArrCon(2, i) & "</TD>" & vbCrLf

    42. 

  42. 							myObjStr.strAppend "<TD>" & myArrCon(3, i) & "</TD>" & vbCrLf

    43. 

  43. 							myObjStr.strAppend "<TD>" & myArrCon(4, i) & "</TD>" & vbCrLf

    44. 

  44. 							myObjStr.strAppend "</TR>" & vbCrLf

    45. 

  45. 						Next

    46. 

  46. 						Response.Write myObjStr.getStr()

    47. 

  47. 						Set myObjStr = Nothing

    48. 

  48. 					%>

    49. 

  49. 				</TBODY>

    50. 

  50. 			</TABLE>

    51. 

  51. 		</TD></TR>

    52. 

  52. 	</TABLE>

    53. 

  53. 

    54. 

  54. </BODY>

    55. 

  55. </HTML>

    56. 

  56. <!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->
    57.