Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1
<%
2
'===================================================================
3
'							Node Common
4
'===================================================================
5
%>
6
<!--#include file="../class/classTemplateManager.asp"-->
7
<!--#include file="../class/classCrumbs.asp"-->
8
<!--#include file="../class/classTabControl.asp"-->
9
<!--#include file="../class/classActionButtonControl.asp"-->
10
<!--#include file="../class/classPopupMenuControl.asp"-->
11
<!--#include file="../class/classFormater.asp"-->
12
<%
13
'------------ VARIABLE DEFINITION -------------
14
Dim objTabControl
15
Dim objTemplateManager
16
Dim objNodeCollector
17
Dim objBomCollector
18
Dim objBtnControl
19
Dim objFormater
20
Dim aTabBtnsDef
21
'------------ CONSTANTS DECLARATION -----------
22
Const LIMG_EDIT = "<img src='icons/i_edit.gif' width='16' height='16' border='0' hspace='2'>"
23
Const LIMG_REMOVE = "<img src='icons/i_remove.gif' width='16' height='16' border='0' hspace='2'>"
24
'------------ VARIABLE INIT -------------------
25
Set objCrumbs = New Crumbs
26
Set objPMod = New PersistanceModule
27
Set objNodeCollector = CreateObject("Scripting.Dictionary")
28
Set objBomCollector = CreateObject("Scripting.Dictionary")
29
Set objBtnControl = New ActionButtonControl
30
Set objFormater = New Formater
31
'------------ CONDITIONS ----------------------
32
'----------------------------------------------
33
%>
34
<%
35
'------------ RUN BEFORE PAGE RENDER ----------
36
Call GetMainDBParameters ( dbPARproj_id, dbPARbranch_id, dbPARbom_id, dbPARnode_id, dbPARos_id, dbPARprod_id )
37
Call InitialiseCrumbs ( objCrumbs )
38
objPMod.PersistInCookie ("bom_browser")
39
objPMod.PersistInCookie ("user_bar")
40
objPMod.PersistInQryString ( aPersistList(enumPAR_BOM_ID) )
41
objPMod.PersistInQryString ( aPersistList(enumPAR_NODE_ID) )
42
Call GetBomDetails ( dbPARbom_id, objBomCollector )
43
Call GetNodeDetails ( dbPARnode_id, objNodeCollector )
44
'----------------------------------------------
45
%>
46
<%
47
'-----------------------------------------------------------------------------------------------------------------
48
Sub GetNodeDetails ( nNode_id, ByRef outobjDetails )
49
	Dim rsQry, query
50
	OraDatabase.Parameters.Add "NODE_ID", nNode_id,	ORAPARM_INPUT, ORATYPE_NUMBER 
51
 
52
	query = "SELECT nn.*  FROM NETWORK_NODES nn  WHERE nn.NODE_ID = :NODE_ID"
53
 
54
	Set rsQry = OraDatabase.DbCreateDynaset( query , ORADYN_DEFAULT )
55
 
56
	If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) Then
57
		outobjDetails.Item ("node_id")   = rsQry("node_id")
58
		outobjDetails.Item ("node_name") = rsQry("node_name")
59
 
60
	Else
61
		Err.Raise 8, "Sub GetNodeDetails", "Empty record set returned. nNode_id="& nNode_id
62
 
63
	End If
64
 
65
	OraDatabase.Parameters.Remove "NODE_ID"
66
	rsQry.Close
67
	Set rsQry = Nothing
68
End Sub
69
'-----------------------------------------------------------------------------------------------------------------
70
Sub RenderTitle ( objCollector )
71
	Response.write "<b>"& objCollector.Item("node_name") &"</b>"
72
End Sub
73
'-----------------------------------------------------------------------------------------------------------------
74
%>