set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO






ALTER PROCEDURE [dbo].[StpCreateGridLayoutFilter] 
           (@LayoutId  int=0
           ,@Field  nvarchar(1000)=''
           ,@DisplayText  nvarchar(1000)=''
           ,@FilterText  nvarchar(1000)  =''
			,@FilterId int=0 output
			,@Replace bit =0)

AS
if @filterid=0 
	begin
	INSERT INTO GridFilterTitleTbl
						  (LayoutId, DisplayText)
	VALUES     (@layoutId,@DisplayText)	
	set @filterid=@@identity
	end

if @Replace =1
	UPDATE    GridFilterTitleTbl
	SET              DisplayText = @DisplayText
	WHERE     (SysCode = @FilterId)
else
	INSERT INTO GridLayOutFilterTbl
						  ( Field, FilterText, FK_FilterId)
	VALUES     (@Field,@FilterText,@FilterId)