Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 129
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
Option explicit
 3 
Option explicit
4 
Response.Expires = 0	' always load the page, dont store
 4 
Response.Expires = 0   ' always load the page, dont store
5 
%>
 5 
%>
6 
<%
 6 
<%
7 
'=====================================================
 7 
'=====================================================
8 
'					Additional Note
 8 
'               Additional Note
9 
'=====================================================
 9 
'=====================================================
10 
%>
 10 
%>
11 
<!--#include file="common/conf.asp"-->
 11 
<!--#include file="common/conf.asp"-->
12 
<!--#include file="common/globals.asp"-->
 12 
<!--#include file="common/globals.asp"-->
13 
<!--#include file="common/formating.asp"-->
 13 
<!--#include file="common/formating.asp"-->
Line 32... Line 32...
32 
parPv_id = Request("pv_id")
 32 
parPv_id = Request("pv_id")
33 
'----------------------------------------------
 33 
'----------------------------------------------
34 
%>
 34 
%>
35 
<%
 35 
<%
36 
Sub Get_Additional_Note ( nNote_id, nPv_id, OOrs )
 36 
Sub Get_Additional_Note ( nNote_id, nPv_id, OOrs )
37 
	Dim Query_String
 37 
   Dim Query_String
38 
	Query_String = _
 38 
   Query_String = _
39 
	" SELECT an.note_title, an.note_body"&_
 39 
   " SELECT an.note_title, an.note_body"&_
40 
	"   FROM ADDITIONAL_NOTES an"&_
 40 
   "   FROM ADDITIONAL_NOTES an"&_
41 
	"  WHERE an.note_id = "& nNote_id &_
 41 
   "  WHERE an.note_id = "& nNote_id &_
42 
	"    AND an.PV_ID = "& nPv_id
 42 
   "    AND an.PV_ID = "& nPv_id
43 
	Set OOrs = OraDatabase.CreateDynaset( Query_String, cint(0))
 43 
   Set OOrs = OraDatabase.CreateDynaset( Query_String, cint(0))
44 
End Sub
 44 
End Sub
45 
 
 45 
 
46 
Sub Update_Additional_Note ( nNote_id, nPv_id, sNote_Title, sNote_Body, nUser_Id )
 46 
Sub Update_Additional_Note ( nNote_id, nPv_id, sNote_Title, sNote_Body, nUser_Id )
47 
	Dim retErrCode
 47 
   Dim retErrCode
48 
	OraDatabase.Parameters.Add "NOTE_ID", 		nNote_id, 		ORAPARM_INPUT, 	ORATYPE_NUMBER
 48 
   OraDatabase.Parameters.Add "NOTE_ID",    nNote_id,    ORAPARM_INPUT,  ORATYPE_NUMBER
49 
	OraDatabase.Parameters.Add "PV_ID", 		nPv_id, 		ORAPARM_INPUT, 	ORATYPE_NUMBER
 49 
   OraDatabase.Parameters.Add "PV_ID",      nPv_id,      ORAPARM_INPUT,  ORATYPE_NUMBER
50 
	OraDatabase.Parameters.Add "NOTE_TITLE", 	sNote_Title, 	ORAPARM_INPUT, 	ORATYPE_VARCHAR2
 50 
   OraDatabase.Parameters.Add "NOTE_TITLE", sNote_Title, ORAPARM_INPUT,  ORATYPE_VARCHAR2
51 
	OraDatabase.Parameters.Add "NOTE_BODY", 	sNote_Body, 	ORAPARM_INPUT, 	ORATYPE_VARCHAR2
 51 
   OraDatabase.Parameters.Add "NOTE_BODY",  sNote_Body,  ORAPARM_INPUT,  ORATYPE_VARCHAR2
52 
	OraDatabase.Parameters.Add "USER_ID", 		nUser_Id, 		ORAPARM_INPUT, 	ORATYPE_NUMBER
 52 
   OraDatabase.Parameters.Add "USER_ID",    nUser_Id,    ORAPARM_INPUT,  ORATYPE_NUMBER
53 
	OraDatabase.Parameters.Add "ERRCODE", 		0, 				ORAPARM_OUTPUT, ORATYPE_NUMBER
 53 
   OraDatabase.Parameters.Add "ERRCODE",    0,           ORAPARM_OUTPUT, ORATYPE_NUMBER
54
54 
 
- 
 
 55 
   objEH.TryORA ( OraSession )
55 
	OraSession.BeginTrans
 56 
   On Error Resume Next
- 
 
 57 
 
56 
	OraDatabase.ExecuteSQL _
 58 
   OraDatabase.ExecuteSQL _
57 
	"BEGIN Update_Additional_Note  ( :NOTE_ID,"&_
 59 
   "BEGIN Update_Additional_Note  ( :NOTE_ID,"&_
58 
	"	                             :PV_ID,"&_
 60 
   "                                :PV_ID,"&_
59 
	"	                             :NOTE_TITLE,"&_
 61 
   "                                :NOTE_TITLE,"&_
60 
	"	                             :NOTE_BODY,"&_
 62 
   "                                :NOTE_BODY,"&_
61 
	"	                             :USER_ID,"&_
 63 
   "                                :USER_ID,"&_
62 
	"	                             :ERRCODE ); END;"
 64 
   "                                :ERRCODE ); END;"
- 
 
 65 
 
- 
 
 66 
   objEH.CatchORA ( OraSession )
63
67 
 
64 
	retErrCode = OraDatabase.Parameters("ERRCODE").Value
68 
   retErrCode = OraDatabase.Parameters("ERRCODE").Value
65
69 
 
66 
	If retErrCode <> 0 Then
 70 
   If retErrCode <> 0 Then
67 
		OraSession.RollBack
 - 
 
68 
		Call RaiseMsg ( enum_MSG_DUPLICATE_AN, sNote_Title )
 71 
      Call RaiseMsg ( enum_MSG_DUPLICATE_AN, sNote_Title )
69 
	Else
 - 
 
70 
		OraSession.CommitTrans
 - 
 
71 
	End If
 72 
   End If
72
73 
 
73 
End Sub
 74 
End Sub
74 
%>
 75 
%>
75 
<%
 76 
<%
76 
'Process submition
 77 
'Process submition
77 
If CBool(Request("action")) AND objAccessControl.UserLogedIn  Then
 78 
If CBool(Request("action")) AND objAccessControl.UserLogedIn  Then
78 
	Call Update_Additional_Note ( parNote_id, parPv_id, Request("note_title"), Request("note_body"), objAccessControl.UserId )
 79 
   Call Update_Additional_Note ( parNote_id, parPv_id, Request("note_title"), Request("note_body"), objAccessControl.UserId )
79 
	Call OpenInParentWindow ("fixed_issues.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id )
 80 
   Call OpenInParentWindow ("fixed_issues.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id )
80 
	Call CloseWindow
 81 
   Call CloseWindow
81
82 
 
82 
End If
 83 
End If
83 
Call Get_Additional_Note ( parNote_id, parPv_id, rsQry )
 84 
Call Get_Additional_Note ( parNote_id, parPv_id, rsQry )
84 
%>
 85 
%>
85 
<html>
 86 
<html>
86 
<head>
 87 
<head>
Line 91... Line 92...
91 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
 92 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
92 
<script language="JavaScript" src="images/common.js"></script>
 93 
<script language="JavaScript" src="images/common.js"></script>
93 
</head>
 94 
</head>
94 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();document.additionalnote.note_title.focus();">
 95 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();document.additionalnote.note_title.focus();">
95 
<form name="additionalnote" method="post" action="<%=scriptName%>" onSubmit="MM_validateForm('note_title','Note Title','R','note_body','Note Body','maxLength:4000');return document.MM_returnValue;">
 96 
<form name="additionalnote" method="post" action="<%=scriptName%>" onSubmit="MM_validateForm('note_title','Note Title','R','note_body','Note Body','maxLength:4000');return document.MM_returnValue;">
96 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
 97 
   <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
97 
    <tr>
98 
      <tr>
98 
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_additional_notes_off.gif" width="26" height="20" hspace="5" border="0"></td>
 99 
         <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_additional_notes_off.gif" width="26" height="20" hspace="5" border="0"></td>
99 
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;Additional
100 
         <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;Additional
100 
        Note </td>
 101 
         Note </td>
101 
      <td background="images/lbox_bg_blue.gif" align="right" width="50%">
102 
         <td background="images/lbox_bg_blue.gif" align="right" width="50%">
102 
        <input type="submit" name="btn" value="Submit" class="form_btn_comp">
 103 
            <input type="submit" name="btn" value="Submit" class="form_btn_comp">
103 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
 104 
            <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
104 
      </td>
 105 
         </td>
105 
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
106 
         <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
106 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
 107 
         <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
107 
    </tr>
 108 
      </tr>
108 
    <tr>
109 
      <tr>
109 
      <td height="100%" width="1%">&nbsp;</td>
 110 
         <td height="100%" width="1%">&nbsp;</td>
110 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
111 
         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
111 
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
 112 
         <table width="100%" border="0" cellspacing="1" cellpadding="2">
112 
          <tr>
113 
            <tr>
113 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
 114 
               <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
114 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
 115 
               <td width="1%" nowrap class="form_group" valign="bottom"></td>
115 
            <td nowrap width="100%">&nbsp; </td>
 116 
               <td nowrap width="100%">&nbsp; </td>
116 
          </tr>
 117 
            </tr>
117 
          <tr>
118 
            <tr>
118 
            <td>&nbsp;</td>
 119 
               <td>&nbsp;</td>
119 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Note Title</td>
 120 
               <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Note Title</td>
120 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_txt"><input name="note_title" type="text" class="form_item" id="note_title" value="<%=rsQry("note_title")%>" size="80" maxlength="50">
121 
               <td nowrap background="images/bg_form_lightbluedark.gif" class="form_txt"><input name="note_title" type="text" class="form_item" id="note_title" value="<%=rsQry("note_title")%>" size="80" maxlength="50">
121 
            </td>
 122 
               </td>
122 
          </tr>
 123 
            </tr>
123 
          <tr>
124 
            <tr>
124 
            <td width="1%">&nbsp;</td>
 125 
               <td width="1%">&nbsp;</td>
125 
            <td width="1%" valign="top" background="images/bg_form_lightbluedark.gif" class="form_field">Note Body</td>
 126 
               <td width="1%" valign="top" background="images/bg_form_lightbluedark.gif" class="form_field">Note Body</td>
126 
            <td width="100%" valign="top" nowrap background="images/bg_form_lightbluedark.gif" class="form_txt"><textarea cols="80" rows="20" name="note_body" class="form_item" id="note_body"><%=rsQry("note_body")%></textarea>
127 
               <td width="100%" valign="top" nowrap background="images/bg_form_lightbluedark.gif" class="form_txt"><textarea cols="80" rows="20" name="note_body" class="form_item" id="note_body"><%=rsQry("note_body")%></textarea>
127 
            </td>
 128 
               </td>
128 
          </tr>
 129 
            </tr>
129 
          <tr>
130 
            <tr>
130 
            <td width="1%">&nbsp;</td>
 131 
               <td width="1%">&nbsp;</td>
131 
            <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
 132 
               <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
132 
            <td nowrap width="100%"> <p>&nbsp;</p></td>
 133 
               <td nowrap width="100%"> <p>&nbsp;</p></td>
133 
          </tr>
 134 
            </tr>
134 
        </table> </td>
 135 
         </table> </td>
135 
    </tr>
 136 
      </tr>
136 
    <tr>
 137 
      <tr>
137 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
 138 
         <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
138 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
 139 
         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
139 
    </tr>
 140 
      </tr>
140 
  </table>
 141 
   </table>
141 
  <input type="hidden" name="note_id" value="<%=parNote_id%>">
 142 
   <input type="hidden" name="note_id" value="<%=parNote_id%>">
142 
  <input type="hidden" name="pv_id" value="<%=parPv_id%>">
 143 
   <input type="hidden" name="pv_id" value="<%=parPv_id%>">
143 
  <input type="hidden" name="rtag_id" value="<%=parRtag_id%>">
 144 
   <input type="hidden" name="rtag_id" value="<%=parRtag_id%>">
144 
  <input type="hidden" name="action" value="true">
 145 
   <input type="hidden" name="action" value="true">
145 
</form>
 146 
</form>
146 
</body>
 147 
</body>
147 
</html>
 148 
</html>
148 
 
 149 
 
149 
 
 150 
 
150 
<!-- DESTRUCTOR ------->
 151 
<!-- DESTRUCTOR ------->
151 
<!--#include file="common/destructor.asp"-->
 - 
 
152 

            152
            
<!--#include file="common/destructor.asp"-->

          

          

            -
            
 

            153