| 13 |
rsolanki |
1 |
<%
|
|
|
2 |
'===================================================================
|
|
|
3 |
' Admin Project Browser
|
|
|
4 |
'===================================================================
|
|
|
5 |
%>
|
|
|
6 |
<%
|
|
|
7 |
'------------ VARIABLE DEFINITION -------------
|
|
|
8 |
Dim rsBrowseQry
|
| 19 |
rsolanki |
9 |
'Dim ScriptName
|
| 13 |
rsolanki |
10 |
'------------ CONSTANTS DECLARATION -----------
|
|
|
11 |
'------------ VARIABLE INIT -------------------
|
|
|
12 |
parProj_id = Request("proj_id")
|
|
|
13 |
'----------------------------------------------
|
|
|
14 |
%>
|
|
|
15 |
<%
|
|
|
16 |
'----------------------------------------------------------------------------------------------------------------------------------------------
|
|
|
17 |
|
|
|
18 |
'----------------------------------------------------------------------------------------------------------------------------------------------
|
|
|
19 |
%>
|
|
|
20 |
<%
|
|
|
21 |
'------------ RUN BEFORE CONTROL RENDER -------
|
|
|
22 |
'----------------------------------------------
|
|
|
23 |
%>
|
|
|
24 |
<table width="100%" border="0" cellspacing="0" cellpadding="5">
|
|
|
25 |
<tr>
|
|
|
26 |
<td background="images/bg_bage_0a.gif"> </td>
|
|
|
27 |
</tr>
|
|
|
28 |
</table>
|
|
|
29 |
<table width="100%" border="0" cellspacing="5" cellpadding="0">
|
|
|
30 |
<tr>
|
|
|
31 |
<td>
|
|
|
32 |
<table width="100%" border="0" cellspacing="8" cellpadding="0">
|
|
|
33 |
<tr>
|
|
|
34 |
<td><a href='AdminDefault.asp' class='menu_link' title='Back to Main Menu'><img src="icons/i_caretone.gif" width="11" height="7" border="0" hspace="5">Main Menu</a></td>
|
|
|
35 |
</tr>
|
|
|
36 |
<tr>
|
|
|
37 |
<td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
|
| 27 |
rsolanki |
38 |
</tr>
|
| 13 |
rsolanki |
39 |
<%
|
|
|
40 |
OraDatabase.Parameters.Add "PROJ_ID", parProj_id, ORAPARM_INPUT, ORATYPE_NUMBER
|
|
|
41 |
|
|
|
42 |
If SCRIPT_NAME = "AdminProject_List.asp" Then
|
|
|
43 |
ScriptName = "AdminProject_Iterations.asp"
|
| 27 |
rsolanki |
44 |
ElseIf SCRIPT_NAME = "AdminProductionManager.asp" Then
|
|
|
45 |
ScriptName = "AdminProductionManager_Configuration.asp"
|
| 13 |
rsolanki |
46 |
Else
|
|
|
47 |
ScriptName = SCRIPT_NAME
|
|
|
48 |
End If
|
|
|
49 |
|
|
|
50 |
Set rsBrowseQry = OraDatabase.DbCreateDynaset( GetQuery ("ProjectList.sql"), ORADYN_DEFAULT )
|
|
|
51 |
While (NOT rsBrowseQry.BOF) AND (NOT rsBrowseQry.EOF)
|
| 27 |
rsolanki |
52 |
If ScriptName = "AdminProductionManager_Configuration.asp" Then
|
|
|
53 |
If InStr(rsBrowseQry("proj_name"), "PRODUCTION") <> 0 Then
|
| 13 |
rsolanki |
54 |
%>
|
|
|
55 |
<tr>
|
|
|
56 |
<td nowrap><a href='<%=ScriptName%>?proj_id=<%=rsBrowseQry("proj_id")%>' class='menu_link'><img src='icons/i_world.gif' hspace='5' align='absmiddle' border='0'><SPAN class="<%=rsBrowseQry("style")%>"><%=rsBrowseQry("proj_name").Value%></SPAN></a></td>
|
|
|
57 |
</tr>
|
| 27 |
rsolanki |
58 |
<%End If%>
|
|
|
59 |
<%Else%>
|
|
|
60 |
<tr>
|
|
|
61 |
<td nowrap><a href='<%=ScriptName%>?proj_id=<%=rsBrowseQry("proj_id")%>' class='menu_link'><img src='icons/i_world.gif' hspace='5' align='absmiddle' border='0'><SPAN class="<%=rsBrowseQry("style")%>"><%=rsBrowseQry("proj_name").Value%></SPAN></a></td>
|
|
|
62 |
</tr>
|
|
|
63 |
<%End If
|
| 13 |
rsolanki |
64 |
rsBrowseQry.MoveNext
|
|
|
65 |
WEnd
|
|
|
66 |
|
|
|
67 |
rsBrowseQry.Close()
|
|
|
68 |
Set rsBrowseQry = Nothing
|
|
|
69 |
|
|
|
70 |
OraDatabase.Parameters.Remove "PROJ_ID"
|
|
|
71 |
%>
|
|
|
72 |
</table>
|
|
|
73 |
</td>
|
|
|
74 |
</tr>
|
|
|
75 |
</table>
|
|
|
76 |
<%
|
|
|
77 |
'------------ RUN AFTER CONTROL RENDER --------
|
|
|
78 |
'----------------------------------------------
|
|
|
79 |
%>
|