Purpose: Update method. This method will Update one existing row in the database.

[Visual Basic]
Public Overrides Function Update() As Boolean

Rückgabewert

True if succeeded, otherwise an Exception is thrown.

Hinweise

Properties needed for this method: <UL> <LI>iDokumentablageortNr</LI> <LI>iDokumentablagetypNr. May be SqlInt32.Null</LI> <LI>iDokumentNr. May be SqlInt32.Null</LI> <LI>sAblageort. May be SqlString.Null</LI> <LI>sBeschreibung. May be SqlString.Null</LI> <LI>daErstellt_am. May be SqlDateTime.Null</LI> <LI>daMutiert_am. May be SqlDateTime.Null</LI> <LI>iMutierer. May be SqlInt32.Null</LI> <LI>bAktiv. May be SqlBoolean.Null</LI> <LI>iMandantNr. May be SqlInt32.Null</LI> </UL> Properties set after a succesful call of this method: <UL> <LI>iErrorCode</LI> </UL>

Quellcode

[Visual Basic]
		Overrides Public Function Update() As Boolean 
			Dim scmCmdToExecute As SqlCommand	= New SqlCommand() 
			scmCmdToExecute.CommandText = "dbo.[pr_DokumentAblageort_Update]" 
			scmCmdToExecute.CommandType = CommandType.StoredProcedure 
 
			' // Use base class' connection object 
			scmCmdToExecute.Connection = m_scoMainConnection 
 
			Try 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@iDokumentablageortNr", SqlDbType.Int, 4, ParameterDirection.Input, False, 10, 0, "", DataRowVersion.Proposed, m_iDokumentablageortNr)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@iDokumentablagetypNr", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, m_iDokumentablagetypNr)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@iDokumentNr", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, m_iDokumentNr)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@sAblageort", SqlDbType.VarChar, 255, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, m_sAblageort)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@sBeschreibung", SqlDbType.VarChar, 255, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, m_sBeschreibung)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@daErstellt_am", SqlDbType.DateTime, 8, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, m_daErstellt_am)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@daMutiert_am", SqlDbType.DateTime, 8, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, m_daMutiert_am)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@iMutierer", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, m_iMutierer)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@bAktiv", SqlDbType.Bit, 1, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, m_bAktiv)) 
				scmCmdToExecute.Parameters.Add(New SqlParameter("@iMandantNr", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, m_iMandantNr)) 
				scmCmdToExecute.Parameters.Add(new SqlParameter("@iErrorCode", SqlDbType.Int, 4, ParameterDirection.Output, True, 10, 0, "", DataRowVersion.Proposed, m_iErrorCode)) 
 
				If m_bMainConnectionIsCreatedLocal Then 
					' // Open connection. 
					m_scoMainConnection.Open() 
				Else 
					If m_cpMainConnectionProvider.bIsTransactionPending Then 
						scmCmdToExecute.Transaction = m_cpMainConnectionProvider.stCurrentTransaction 
					End If 
				End If 
 
				' // Execute query. 
				m_iRowsAffected = scmCmdToExecute.ExecuteNonQuery() 
				m_iErrorCode = New SqlInt32(CType(scmCmdToExecute.Parameters.Item("@iErrorCode").Value, SqlInt32)) 
 
				If Not m_iErrorCode.Equals(New SqlInt32(LLBLError.AllOk)) Then 
					' // Throw error. 
					Throw New Exception("Stored Procedure 'pr_DokumentAblageort_Update' reported the ErrorCode: " & m_iErrorCode.ToString()) 
				End If 
 
				Return True 
			Catch ex As Exception 
				' // some error occured. Bubble it to caller and encapsulate Exception object 
				Throw New Exception("clsDokumentAblageort::Update::Error occured.", ex) 
			Finally 
				If m_bMainConnectionIsCreatedLocal Then 
					' // Close connection. 
					m_scoMainConnection.Close() 
				End If 
				scmCmdToExecute.Dispose() 
			End Try 
		End Function

Forderungen

Plattformen: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

Siehe auch

clsDokumentAblageort