Ausnahme im C#-Code beim Versuch, eine gespeicherte Prozedur mit verschlüsselten Parametern aufzurufen ⇐ C#

[Anonymous]

Ich habe eine Tabelle mit einer verschlüsselten Spalte Benutzername:


Ich habe auch eine gespeicherte Prozedur (in SQL Server), die wie folgt definiert ist:

Code: Select all

    SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[SelfServeNotes_GetReport]
(
@OrderLineID INT = 0,
@UserName NVARCHAR(100) = NULL,
@PciAsmachta INT = 0,
@CreatedFromDateValue DATETIME = NULL,
@CreatedToDateValue DATETIME = NULL,
@PaidDelivered INT = 99,
@Barcode NVARCHAR(20) = NULL
)
AS
BEGIN
SET NOCOUNT ON;

DECLARE @Paid INT = 99;
DECLARE @SendRashum INT = 99;

IF @PaidDelivered = 2
BEGIN
SET @Paid = 1;
SET @SendRashum = 0;
END
ELSE IF @PaidDelivered = 1
BEGIN
SET @Paid = 1;
END
ELSE IF @PaidDelivered = 0
BEGIN
SET @Paid = 0;
END

IF @Barcode IS NOT NULL AND @Barcode   ''
BEGIN
DECLARE @OrderLineIDTemp INT;

SELECT @OrderLineIDTemp = OrderLineID
FROM dbo.PCI_SelfServeNotesOrderItemData
WHERE Barcode = @Barcode;

IF @OrderLineIDTemp IS NULL OR @OrderLineIDTemp = 0
RETURN;

IF @OrderLineID IS NULL OR @OrderLineID = 0
SET @OrderLineID = @OrderLineIDTemp;
END

CREATE TABLE #FilteredOrders
(
OrderLineID INT PRIMARY KEY
);

INSERT INTO #FilteredOrders (OrderLineID)
SELECT L.OrderLineID
FROM dbo.PCI_SelfServeNotesOrderLine L
INNER JOIN dbo.PCI_OrderLine OL
ON L.OrderLineID = OL.OrderLineID
LEFT JOIN dbo.[User] U
ON L.SID = U.SID
LEFT JOIN dbo.PCI_OrderMasof M
ON OL.OrderMasofID = M.OrderMasofID
WHERE
(@UserName IS NULL OR U.UserName = @UserName)
AND (@OrderLineID = 0 OR L.OrderLineID = @OrderLineID)
AND (@PciAsmachta = 0 OR M.OrderID = @PciAsmachta)
AND (@CreatedFromDateValue IS NULL OR OL.Created_On >= @CreatedFromDateValue)
AND (@CreatedToDateValue IS NULL OR OL.Created_On