You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
278 lines
7.3 KiB
278 lines
7.3 KiB
-- ================================================================================================================
|
|
-- Stored Procedures generated by LLBLGen v1.21.2003.712 Final on Sonntag, 15. November 2009, 10:42:03
|
|
-- For the Low Level Business Logic Layer for the database 'coldabgleich'
|
|
-- ================================================================================================================
|
|
SET NOCOUNT ON
|
|
GO
|
|
USE [coldabgleich]
|
|
GO
|
|
|
|
-- ========================================================================================================
|
|
-- [Stored Procedures generated for table: tmphost]
|
|
GO
|
|
|
|
-- //// Insert Stored procedure.
|
|
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pr_tmphost_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[pr_tmphost_Insert]
|
|
GO
|
|
|
|
---------------------------------------------------------------------------------
|
|
-- Stored procedure that will insert 1 row in the table 'tmphost'
|
|
-- Gets: @spartnernr_inhaber nvarchar(255)
|
|
-- Gets: @spartnernr_zusteller nvarchar(255)
|
|
-- Gets: @spartnername_inhaber nvarchar(255)
|
|
-- Gets: @spartnername_zusteller nvarchar(255)
|
|
-- Gets: @sreferenzzeile1 nvarchar(255)
|
|
-- Gets: @sreferenzzeile2 nvarchar(255)
|
|
-- Gets: @svalutadatum nvarchar(50)
|
|
-- Gets: @svalutadatum1 nvarchar(50)
|
|
-- Gets: @svalorennr nvarchar(255)
|
|
-- Gets: @sisinnr nvarchar(255)
|
|
-- Gets: @sdokumentid nvarchar(255)
|
|
-- Gets: @sanzahlseiten nvarchar(50)
|
|
-- Gets: @snachvollziehbarkeit nvarchar(255)
|
|
-- Gets: @sarchivdatum nvarchar(50)
|
|
-- Gets: @svvextern1 nvarchar(255)
|
|
-- Gets: @svvextern2 nvarchar(255)
|
|
-- Gets: @sex nvarchar(255)
|
|
-- Gets: @sstandamdatum nvarchar(50)
|
|
-- Gets: @sdokumenttypnr nvarchar(255)
|
|
-- Gets: @sloadid nvarchar(255)
|
|
-- Gets: @dainserttimestamp smalldatetime
|
|
-- Gets: @iinrpar00_inhaber int
|
|
-- Gets: @iinrpar00_zusteller int
|
|
-- Gets: @sMailingProductBezeichnung nvarchar(255)
|
|
-- Gets: @smetatype nvarchar(255)
|
|
-- Gets: @sordertype nvarchar(255)
|
|
-- Gets: @sXomaDocID nvarchar(255)
|
|
-- Gets: @stransactnr nvarchar(255)
|
|
-- Gets: @smanr nvarchar(255)
|
|
-- Gets: @sMailingProduct nvarchar(255)
|
|
-- Gets: @sBetreffzeile nvarchar(255)
|
|
-- Returns: @lpk bigint
|
|
-- Returns: @iErrorCode int
|
|
---------------------------------------------------------------------------------
|
|
CREATE PROCEDURE [dbo].[pr_tmphost_Insert]
|
|
@spartnernr_inhaber nvarchar(255),
|
|
@spartnernr_zusteller nvarchar(255),
|
|
@spartnername_inhaber nvarchar(255),
|
|
@spartnername_zusteller nvarchar(255),
|
|
@sreferenzzeile1 nvarchar(255),
|
|
@sreferenzzeile2 nvarchar(255),
|
|
@svalutadatum nvarchar(50),
|
|
@svalutadatum1 nvarchar(50),
|
|
@svalorennr nvarchar(255),
|
|
@sisinnr nvarchar(255),
|
|
@sdokumentid nvarchar(255),
|
|
@sanzahlseiten nvarchar(50),
|
|
@snachvollziehbarkeit nvarchar(255),
|
|
@sarchivdatum nvarchar(50),
|
|
@svvextern1 nvarchar(255),
|
|
@svvextern2 nvarchar(255),
|
|
@sex nvarchar(255),
|
|
@sstandamdatum nvarchar(50),
|
|
@sdokumenttypnr nvarchar(255),
|
|
@sloadid nvarchar(255),
|
|
@dainserttimestamp smalldatetime,
|
|
@iinrpar00_inhaber int,
|
|
@iinrpar00_zusteller int,
|
|
@sMailingProductBezeichnung nvarchar(255),
|
|
@smetatype nvarchar(255),
|
|
@sordertype nvarchar(255),
|
|
@sXomaDocID nvarchar(255),
|
|
@stransactnr nvarchar(255),
|
|
@smanr nvarchar(255),
|
|
@sMailingProduct nvarchar(255),
|
|
@sBetreffzeile nvarchar(255),
|
|
@lpk bigint OUTPUT,
|
|
@iErrorCode int OUTPUT
|
|
AS
|
|
SET NOCOUNT ON
|
|
-- INSERT a new row in the table.
|
|
INSERT [dbo].[tmphost]
|
|
(
|
|
[partnernr_inhaber],
|
|
[partnernr_zusteller],
|
|
[partnername_inhaber],
|
|
[partnername_zusteller],
|
|
[referenzzeile1],
|
|
[referenzzeile2],
|
|
[valutadatum],
|
|
[valutadatum1],
|
|
[valorennr],
|
|
[isinnr],
|
|
[dokumentid],
|
|
[anzahlseiten],
|
|
[nachvollziehbarkeit],
|
|
[archivdatum],
|
|
[vvextern1],
|
|
[vvextern2],
|
|
[ex],
|
|
[standamdatum],
|
|
[dokumenttypnr],
|
|
[loadid],
|
|
[inserttimestamp],
|
|
[inrpar00_inhaber],
|
|
[inrpar00_zusteller],
|
|
[MailingProductBezeichnung],
|
|
[metatype],
|
|
[ordertype],
|
|
[XomaDocID],
|
|
[transactnr],
|
|
[manr],
|
|
[MailingProduct],
|
|
[Betreffzeile]
|
|
)
|
|
VALUES
|
|
(
|
|
@spartnernr_inhaber,
|
|
@spartnernr_zusteller,
|
|
@spartnername_inhaber,
|
|
@spartnername_zusteller,
|
|
@sreferenzzeile1,
|
|
@sreferenzzeile2,
|
|
@svalutadatum,
|
|
@svalutadatum1,
|
|
@svalorennr,
|
|
@sisinnr,
|
|
@sdokumentid,
|
|
@sanzahlseiten,
|
|
@snachvollziehbarkeit,
|
|
@sarchivdatum,
|
|
@svvextern1,
|
|
@svvextern2,
|
|
@sex,
|
|
@sstandamdatum,
|
|
@sdokumenttypnr,
|
|
@sloadid,
|
|
@dainserttimestamp,
|
|
@iinrpar00_inhaber,
|
|
@iinrpar00_zusteller,
|
|
@sMailingProductBezeichnung,
|
|
@smetatype,
|
|
@sordertype,
|
|
@sXomaDocID,
|
|
@stransactnr,
|
|
@smanr,
|
|
@sMailingProduct,
|
|
@sBetreffzeile
|
|
)
|
|
-- Get the Error Code for the statement just executed.
|
|
SELECT @iErrorCode=@@ERROR
|
|
-- Get the IDENTITY value for the row just inserted.
|
|
SELECT @lpk=SCOPE_IDENTITY()
|
|
GO
|
|
|
|
|
|
-- //// Select Stored procedure, based on field [pk].
|
|
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pr_tmphost_SelectOneWpkLogic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[pr_tmphost_SelectOneWpkLogic]
|
|
GO
|
|
|
|
---------------------------------------------------------------------------------
|
|
-- Stored procedure that will select one existing row from the table 'tmphost'
|
|
-- based on the field [pk], which is unique per row.
|
|
-- Gets: @lpk bigint
|
|
-- Returns: @iErrorCode int
|
|
---------------------------------------------------------------------------------
|
|
CREATE PROCEDURE [dbo].[pr_tmphost_SelectOneWpkLogic]
|
|
@lpk bigint,
|
|
@iErrorCode int OUTPUT
|
|
AS
|
|
SET NOCOUNT ON
|
|
-- SELECT an existing row from the table.
|
|
SELECT
|
|
[partnernr_inhaber],
|
|
[partnernr_zusteller],
|
|
[partnername_inhaber],
|
|
[partnername_zusteller],
|
|
[referenzzeile1],
|
|
[referenzzeile2],
|
|
[valutadatum],
|
|
[valutadatum1],
|
|
[valorennr],
|
|
[isinnr],
|
|
[dokumentid],
|
|
[anzahlseiten],
|
|
[nachvollziehbarkeit],
|
|
[archivdatum],
|
|
[vvextern1],
|
|
[vvextern2],
|
|
[ex],
|
|
[standamdatum],
|
|
[dokumenttypnr],
|
|
[loadid],
|
|
[inserttimestamp],
|
|
[inrpar00_inhaber],
|
|
[inrpar00_zusteller],
|
|
[MailingProductBezeichnung],
|
|
[metatype],
|
|
[ordertype],
|
|
[XomaDocID],
|
|
[transactnr],
|
|
[manr],
|
|
[MailingProduct],
|
|
[Betreffzeile],
|
|
[pk]
|
|
FROM [dbo].[tmphost]
|
|
WHERE
|
|
[pk] = @lpk
|
|
-- Get the Error Code for the statement just executed.
|
|
SELECT @iErrorCode=@@ERROR
|
|
GO
|
|
|
|
|
|
-- //// Select All Stored procedure.
|
|
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pr_tmphost_SelectAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[pr_tmphost_SelectAll]
|
|
GO
|
|
|
|
---------------------------------------------------------------------------------
|
|
-- Stored procedure that will select all rows from the table 'tmphost'
|
|
-- Returns: @iErrorCode int
|
|
---------------------------------------------------------------------------------
|
|
CREATE PROCEDURE [dbo].[pr_tmphost_SelectAll]
|
|
@iErrorCode int OUTPUT
|
|
AS
|
|
SET NOCOUNT ON
|
|
-- SELECT all rows from the table.
|
|
SELECT
|
|
[partnernr_inhaber],
|
|
[partnernr_zusteller],
|
|
[partnername_inhaber],
|
|
[partnername_zusteller],
|
|
[referenzzeile1],
|
|
[referenzzeile2],
|
|
[valutadatum],
|
|
[valutadatum1],
|
|
[valorennr],
|
|
[isinnr],
|
|
[dokumentid],
|
|
[anzahlseiten],
|
|
[nachvollziehbarkeit],
|
|
[archivdatum],
|
|
[vvextern1],
|
|
[vvextern2],
|
|
[ex],
|
|
[standamdatum],
|
|
[dokumenttypnr],
|
|
[loadid],
|
|
[inserttimestamp],
|
|
[inrpar00_inhaber],
|
|
[inrpar00_zusteller],
|
|
[MailingProductBezeichnung],
|
|
[metatype],
|
|
[ordertype],
|
|
[XomaDocID],
|
|
[transactnr],
|
|
[manr],
|
|
[MailingProduct],
|
|
[Betreffzeile],
|
|
[pk]
|
|
FROM [dbo].[tmphost]
|
|
-- Get the Error Code for the statement just executed.
|
|
SELECT @iErrorCode=@@ERROR
|
|
GO
|
|
|
|
|
|
-- [End of Stored Procedures for table: tmphost]
|
|
-- ========================================================================================================
|
|
GO
|