Genesis Hybrid Smart Client Framework part III

��USE [BlueMarble.Genesis.Dev]



/****** Object:  StoredProcedure [dbo].[Module_Ribbon_Find]    Script Date: 05/20/2009 22:37:07 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

/*

----------------------------------------------------------------------------------------------------

-- Date Created: 20 May 2007



-- Created By: Eliyahu Business Systems (http://www.eliyahu.co.za)

-- Purpose: Finds records in the Module_Ribbon table passing nullable parameters

----------------------------------------------------------------------------------------------------

*/





CREATE PROCEDURE [dbo].[Module_Ribbon_Find]

(



	@SearchUsingOR bit   = null ,



	@RibbonGuid uniqueidentifier   = null ,



	@RibbonId int   = null ,



	@ApplicationGuid uniqueidentifier   = null ,



	@RibbonName nvarchar (50)  = null ,



	@RibbonOrder int   = null 

)

AS





				

  IF ISNULL(@SearchUsingOR, 0) <> 1

  BEGIN

    SELECT

	  [RibbonGuid]

	, [RibbonId]

	, [ApplicationGuid]

	, [RibbonName]

	, [RibbonOrder]

    FROM

	dbo.[Module_Ribbon]

    WHERE 

	 ([RibbonGuid] = @RibbonGuid OR @RibbonGuid is null)

	AND ([RibbonId] = @RibbonId OR @RibbonId is null)

	AND ([ApplicationGuid] = @ApplicationGuid OR @ApplicationGuid is null)

	AND ([RibbonName] = @RibbonName OR @RibbonName is null)

	AND ([RibbonOrder] = @RibbonOrder OR @RibbonOrder is null)

						

  END

  ELSE

  BEGIN

    SELECT

	  [RibbonGuid]

	, [RibbonId]

	, [ApplicationGuid]

	, [RibbonName]

	, [RibbonOrder]

    FROM

	dbo.[Module_Ribbon]

    WHERE 

	 ([RibbonGuid] = @RibbonGuid AND @RibbonGuid is not null)

	OR ([RibbonId] = @RibbonId AND @RibbonId is not null)

	OR ([ApplicationGuid] = @ApplicationGuid AND @ApplicationGuid is not null)

	OR ([RibbonName] = @RibbonName AND @RibbonName is not null)

	OR ([RibbonOrder] = @RibbonOrder AND @RibbonOrder is not null)

	Select @@ROWCOUNT			

  END

GO