Subversion Repositories DevTools

Rev

Rev 13 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<%
'===================================================================
'                                                       OS Common
'===================================================================
%>
<!--#include file="../class/classTemplateManager.asp"-->
<!--#include file="../class/classCrumbs.asp"-->
<!--#include file="../class/classTabControl.asp"-->
<!--#include file="../class/classActionButtonControl.asp"-->
<!--#include file="../class/classPopupMenuControl.asp"-->
<!--#include file="../class/classFormater.asp"-->
<!--#include file="../controls/ERGFormComponent/classFormComponent.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
Dim objTabControl
Dim objTemplateManager
Dim objOsCollector
Dim objBomCollector
Dim objBtnControl
Dim objFormater
Dim objFormComponent
Dim aTabBtnsDef
'------------ CONSTANTS DECLARATION -----------
Const LIMG_EDIT = "<img src='icons/i_edit.gif' width='16' height='16' border='0' hspace='2'>"
Const LIMG_REMOVE = "<img src='icons/i_remove.gif' width='16' height='16' border='0' hspace='2'>"
Const LIMG_PRODUCT = "<img src='icons/i_product.gif' width='19' height='19' border='0' hspace='2' align='absmiddle'>"
Const LIMG_PROCESS = "<img src='icons/i_process_2.gif' border='0' hspace='2' align='absmiddle'>"
'------------ VARIABLE INIT -------------------
Set objCrumbs = New Crumbs
Set objPMod = New PersistanceModule
Set objOsCollector = CreateObject("Scripting.Dictionary")
Set objBomCollector = CreateObject("Scripting.Dictionary")
Set objBtnControl = New ActionButtonControl
Set objFormater = New Formater
Set objFormComponent = New FormComponent
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'------------ RUN BEFORE PAGE RENDER ----------
Call GetMainDBParameters ( dbPARproj_id, dbPARbranch_id, dbPARbom_id, dbPARnode_id, dbPARos_id, dbPARprod_id )
Call InitialiseCrumbs ( objCrumbs )
objPMod.PersistInCookie ("bom_browser")
objPMod.PersistInCookie ("user_bar")
objPMod.PersistInQryString ( aPersistList(enumPAR_BOM_ID) )
objPMod.PersistInQryString ( aPersistList(enumPAR_OS_ID) )
Call GetBomDetails ( dbPARbom_id, objBomCollector )
Call GetOsDetails ( dbPARos_id, objOsCollector )
'----------------------------------------------
%>
<%
'-----------------------------------------------------------------------------------------------------------------
Sub GetOsDetails ( nOs_id, ByRef outobjDetails )
        Dim rsQry, query
        OraDatabase.Parameters.Add "OS_ID", nOs_id,     ORAPARM_INPUT, ORATYPE_NUMBER 
        
        Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("OsDetails.sql") , ORADYN_DEFAULT )
        
        If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) Then
                outobjDetails.Item ("os_id")   = rsQry("os_id")
                outobjDetails.Item ("os_name") = rsQry("os_name")
                outobjDetails.Item ("base_env_id") = rsQry("base_env_id")
                outobjDetails.Item ("base_env_name") = rsQry("base_env_name")
                
        Else
                Err.Raise 8, "Sub GetOsDetails", "Empty record set returned. nOs_id="& nOs_id
                
        End If
        
        OraDatabase.Parameters.Remove "OS_ID"
        rsQry.Close
        Set rsQry = Nothing
End Sub
'-----------------------------------------------------------------------------------------------------------------
Sub RenderTitle ( objCollector )
        Response.write "<b>"& objCollector.Item("os_name") &"</b>"
End Sub
'-----------------------------------------------------------------------------------------------------------------
%>