/// <summary> /// Returns all Order Detail for the specified Order ID /// </summary> /// <param name="orderID">Order ID</param> /// <returns>Strongly typed list of OrderDetail entity objects</returns> public mmBindingList<OrderDetailEntity> GetOrderDetail(int? orderID) { mmBindingList<OrderDetailEntity> OrderDetailList; if (orderID != null) { OrderDetailList = this.GetEntityList("GetOrderDetailByOrderID", this.CreateParameter("@OrderID", orderID)); } else { this.GetEmptyDataSet(); OrderDetailList = new mmBindingList<OrderDetailEntity>(); } return OrderDetailList; } /// <summary> /// Parent Retrieved hook method /// </summary> /// <param name="bizObj">Parent business object</param> /// <param name="e">EventArgs</param> protected override void HookParentRetrieved(mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e) { this.GetOrderDetail((int?)e.PrimaryKeyValue); } ...>>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) >>>>