set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO






ALTER PROCEDURE [dbo].[STPEditInvoice] 
		@SysCode int,
		@CustomerName	nvarchar(1000),
		@FK_AccountSysCode	int	,
		@Comment	nvarchar(1000),	
		@InvoiceDate	char(8)	,
		@FK_DocsysCode	int	,
		@Amani	bit	,
		@InvoiceNo	int,	
		@VisitorSyscode	int,	
		--@VisitorPer	real	,
		--@VisitorAmount	money,
		@paymentDate char(8),
		@DeliveredtDate char(8),
		@RecievedDate char(8)
		
		
AS
if @FK_DocsysCode=0 set @FK_DocsysCode=null
if @VisitorSyscode=0 set @VisitorSyscode=null
if @FK_AccountSysCode=0 set @FK_AccountSysCode=null
UPDATE    InvoiceTbl
SET              CustomerName = @CustomerName, FK_AccountSysCode = @FK_AccountSysCode, Comment = @Comment, InvoiceDate = @InvoiceDate, 
                      FK_DocsysCode = @FK_DocsysCode, amani = @amani, InvoiceNo = @InvoiceNo, VisitorSyscode = @VisitorSyscode,
                       DelivaredDate =@DeliveredtDate, RecivedDate = @RecievedDate, PaymentDate =@paymentDate
WHERE     (InvoiceSerialNo = @SysCode)