CREATE PROC [dbo].[SIPARIS_FISI_GUNCELLE]
(
@durum VARCHAR(50),
@sipNo VARCHAR(100),
@tarih DATE,
@aciklama VARCHAR(MAX),
@fis VARCHAR(100),
@fisRate FLOAT
)
AS 
BEGIN
DECLARE @sonuc INT
IF @durum = 'TAMAMLANDI'
BEGIN
SET @sonuc = ISNULL((SELECT COUNT(*) FROM [IHR].[dbo].[FICHE_LINES] WHERE [STATUS]<>1 AND [FICHEREF]=(SELECT REF FROM [IHR].[dbo].[FICHES] WHERE [FICHENO] = @fis)),0)
IF @sonuc = 0
BEGIN
UPDATE [IHR].[dbo].[FICHES] SET [STATUS]=ISNULL((SELECT REF FROM [IHR].[dbo].[FICHE_STATUS] WHERE DURUM=@durum),0),[FICHENO]=@sipNo,[DATE_]=@tarih,[GENEXP]=@aciklama,[REPORTRATE]=@fisRate WHERE [FICHENO] = @fis
END
END
ELSE
BEGIN
UPDATE [IHR].[dbo].[FICHES] SET [STATUS]=ISNULL((SELECT REF FROM [IHR].[dbo].[FICHE_STATUS] WHERE DURUM=@durum),0),[FICHENO]=@sipNo,[DATE_]=@tarih,[GENEXP]=@aciklama,[REPORTRATE]=@fisRate WHERE [FICHENO] = @fis
END
END