ALTER PROCEDURE [dbo].[SUBSTANCESelectBySubGroupFK] ( @GROUP_ID int = NULL -- optional parameter ) AS SET NOCOUNT ON; IF @Gropu_ID IS NOT NULL SELECT [COMPANY_ID], [CRE_DATE], [CRE_USER], [GROUP_ID], [MOD_DATE], [MOD_USER], [SUBSTANCE], [SUBSTANCE_ID] FROM [dbo].[SUBSTANCE] WHERE ([GROUP_ID] = @GROUP_ID) ELSE SELECT [COMPANY_ID], [CRE_DATE], [CRE_USER], [GROUP_ID], [MOD_DATE], [MOD_USER], [SUBSTANCE], [SUBSTANCE_ID] FROM [dbo].[SUBSTANCE] WHERE 1=0 -- Empty result>Hi all,
> public mmBindingList<SUBSTANCEEntity> GetSubsBySubGroupFK(int? groupID) > { > mmBindingList<SUBSTANCEEntity> SubsList; > > if (groupID != null) > { > SubsList = this.GetEntityList("SUBSTANCESelectBySubGroupFK"); > this.CreateParameter("@GROUP_ID", groupID); > } > else > { > this.GetEmptyDataSet(); > SubsList = new mmBindingList<SUBSTANCEEntity>(); > } > return SubsList; > //return null; > } >>
>set ANSI_NULLS ON >set QUOTED_IDENTIFIER ON >GO > > >ALTER PROCEDURE [dbo].[SUBSTANCESelectBySubGroupFK] >( > @GROUP_ID int >) >AS > SET NOCOUNT ON; > SELECT [COMPANY_ID], > [CRE_DATE], > [CRE_USER], > [GROUP_ID], > [MOD_DATE], > [MOD_USER], > [SUBSTANCE], > [SUBSTANCE_ID] > FROM [dbo].[SUBSTANCE] > WHERE > ([GROUP_ID] = @GROUP_ID) >>