Subversion Repositories DevTools

Rev

Rev 6579 | Rev 7225 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6579 Rev 6793
Line 53... Line 53...
53
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
53
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
54
</head>
54
</head>
55
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
55
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
56
<!-- HEADER -->
56
<!-- HEADER -->
57
<!--#include file="_header.asp"-->
57
<!--#include file="_header.asp"-->
58
 
-
 
59
  <%
-
 
60
  '-- FROM START ---------------------------------------------------------------------------------------------------------
-
 
61
  objFormComponent.FormName = "GBE_BUILDSTANDARD"
-
 
62
  objFormComponent.Action = ScriptName
-
 
63
  objFormComponent.OnSubmit = "ShowProgress();"
-
 
64
  Call objFormComponent.FormStart()
-
 
65
  %>   
-
 
66
  <div class="div_table">
58
  <div class="div_table">
67
    <table class="center_table" >
59
        <table border="0" cellspacing="1" cellpadding="2" class="stdBrown center_table">
68
      <tr>
-
 
69
        <td background="images/bg_bage_0a.gif">
-
 
70
            <div align="center" class=" body_col">Build Standards</div>
60
            <caption>Build Standards</caption>
71
            <table width="100%"  border="0" cellspacing="1" cellpadding="2">
61
            <thead>
72
            <tr>
62
            <tr>
73
            <!-- BSA DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
63
            <!-- BSA DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
74
            <td background="images/bg_bage_0.gif" align="center"></td>
64
            <th>Id</th>
75
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Id</td>
-
 
76
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Build Standard</td>
65
            <th>Build Standard</th>
77
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Sub Type</td>
66
            <th>Sub Type</th>
78
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Edit</td>
67
            <th>Edit</th>
79
            </tr>
68
            </tr>
-
 
69
            </thead>
80
 
70
 
81
          <%
71
      <%
82
          ' Load some action buttons
72
      ' Load some action buttons
83
          Call objBtnControl.LoadActionButtons ( Array("btnEditGBE_BuildStandard", "btnDeleteGBE_BuildStandard"), OraDatabase )
73
      Call objBtnControl.LoadActionButtons ( Array("btnEditGBE_BuildStandard", "btnDeleteGBE_BuildStandard"), OraDatabase )
84
          objBtnControl.ButtonSpacer = 1
74
      objBtnControl.ButtonSpacer = 1
85
 
75
 
86
          If NOT bCanEdit Then
76
      If NOT bCanEdit Then
87
            Call objBtnControl.Active  ( "btnEditGBE_BuildStandard", "N" )
77
        Call objBtnControl.Active  ( "btnEditGBE_BuildStandard", "N" )
88
            Call objBtnControl.Active  ( "btnDeleteGBE_BuildStandard", "N" )
78
        Call objBtnControl.Active  ( "btnDeleteGBE_BuildStandard", "N" )
89
          End If
79
      End If
90
 
80
 
91
          
81
      
92
          Dim bsa_id,rsQry ,GBE_VALUE
82
      Dim bsa_id,rsQry ,GBE_VALUE
93
 
83
 
94
          Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM BUILD_STANDARDS BS, BUILD_STANDARDS_ADDENDUM BSA WHERE BSA.BS_ID=BS.BS_ID(+) ORDER BY BSA.BS_ID, BSA_ID", ORADYN_DEFAULT )
84
      Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM BUILD_STANDARDS BS, BUILD_STANDARDS_ADDENDUM BSA WHERE BSA.BS_ID=BS.BS_ID(+) ORDER BY BSA.BS_ID, BSA_ID", ORADYN_DEFAULT )
95
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
85
      While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
96
              bsa_id = rsQry("bsa_id")
86
          bsa_id = rsQry("bsa_id")
97
              GBE_VALUE = rsQry("bs_name") & " - " & rsQry("bsa_name")
87
          GBE_VALUE = rsQry("bs_name") & " - " & rsQry("bsa_name")
98
              %>
-
 
99
              <tr>  
-
 
100
                <td background="images/bg_bage_0.gif"></td>
-
 
101
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%=bsa_id%></td>
-
 
102
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%=rsQry("bs_name")%></td>
-
 
103
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%=rsQry("bsa_name")%></td>
-
 
104
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%Call objBtnControl.Render( Array("btnEditGBE_BuildStandard", "btnDeleteGBE_BuildStandard"), objAccessControl )%></td>
-
 
105
              </tr> 
-
 
106
              <%
-
 
107
              rsQry.MoveNext()
-
 
108
          Wend
-
 
109
          rsQry.Close()
-
 
110
          Set rsQry = nothing
-
 
111
          %>
88
          %>
112
        
89
          <tr>  
-
 
90
            <td nowrap><%=bsa_id%></td>
-
 
91
            <td nowrap><%=rsQry("bs_name")%></td>
-
 
92
            <td nowrap><%=rsQry("bsa_name")%></td>
-
 
93
            <td nowrap><%Call objBtnControl.Render( Array("btnEditGBE_BuildStandard", "btnDeleteGBE_BuildStandard"), objAccessControl )%></td>
113
        <tr>
94
          </tr> 
-
 
95
          <%
114
            <td background="images/bg_bage_0.gif"></td>
96
          rsQry.MoveNext()
-
 
97
      Wend
-
 
98
      rsQry.Close()
-
 
99
      Set rsQry = nothing
-
 
100
      %>
-
 
101
    
-
 
102
    <tr>
115
            <td bgcolor="#FFFFFF" class="body_row" nowrap colspan=3></td>
103
        <td colspan=3></td>
116
            <td bgcolor="#FFFFFF" class="body_row" nowrap><%Call Action_Buttons_State("Add GBE_BUILDSTANDARD", bCanEdit)%></td>
104
        <td><%Call Action_Buttons_State("Add GBE_BUILDSTANDARD", bCanEdit)%></td>
117
        </tr>
105
    </tr>
118
 
106
 
119
    </table>
107
</table>
120
    <%=objPMod.ComposeHiddenTags()%>
-
 
121
    <input type="hidden" name="action" value="true">
-
 
122
    <%Call objFormComponent.FormEnd()%>
-
 
123
    </table>
-
 
124
    </div>
108
    </div>
125
<!-- FOOTER -->
109
<!-- FOOTER -->
126
<!--#include file="_footer.asp"-->
110
<!--#include file="_footer.asp"-->
127
</body>
111
</body>
128
</html>
112
</html>