> 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) >>