}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}
		/// <summary>
		/// 根據OrderDetailID獲取OrderDetails表數據及并填充關聯的數據表
		/// </summary>
		/// <param name="withRequired">是否裝載所有關聯的上級(父)數據表</param>
		/// <param name="loadRecursive">是否遞歸裝載所有下級(子)數據表，為false時只裝載關聯的一級子數據表</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		/// <returns>返回主鍵值對應的數據行</returns>
		public virtual OrdersDS.OrderDetailsRow GetOrderDetails(OrdersDS ds, int OrderDetailID, bool withRequired, bool loadRecursive, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.OrderDetails.ToString()],"OrderDetailID="+OrderDetailID.ToString(), withRequired, loadRecursive, relatedTableNames);
				return ds.OrderDetails.FindByOrderDetailID(OrderDetailID);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}
		/// <summary>
		/// 根據OrderDetailID獲取OrderDetails表數據
		/// </summary>
		/// <returns>返回主鍵值對應的數據行</returns>
		public virtual OrdersDS.OrderDetailsRow GetOrderDetails(OrdersDS.OrderDetailsDataTable tb, int OrderDetailID)
		{
			try
			{
				new OrdersDA().Load(tb, "OrderDetailID="+OrderDetailID.ToString());
				return tb.FindByOrderDetailID(OrderDetailID);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}
		/// <summary>
		/// 獲取符合條件的Orders記錄并填充相關聯的數據
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderses(OrdersDS ds, string condition, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.Orders.ToString()], condition, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的Orders記錄并填充向上關聯的數據表數據(不填充下級子表數據)
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="loadParentRecursive">是否遞歸裝載所有關聯的上級(父)數據表，為false時只裝載上一層關聯數據表</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderses(OrdersDS ds, string condition, bool loadParentRecursive, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRequired(ds, da.DataTables[OrdersDS.TableEnum.Orders.ToString()], condition, loadParentRecursive, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的Orders記錄并填充相關聯的數據
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="withRequired">是否裝載所有關聯的上級(父)數據表</param>
		/// <param name="loadRecursive">是否遞歸裝載所有下級(子)數據表，為false時只裝載關聯的一級子數據表</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderses(OrdersDS ds, string condition, bool withRequired, bool loadRecursive, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.Orders.ToString()], condition, withRequired, loadRecursive, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的Orders記錄
		/// </summary>
		/// <param name="tb">接受數據填充的數據表(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		public virtual void GetOrderses(OrdersDS.OrdersDataTable tb, string condition)
		{
			try
			{
				OrdersDA da = new OrdersDA();
				da.Load(tb, condition);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的OrderDetails記錄并填充相關聯的數據
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderDetailses(OrdersDS ds, string condition, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.OrderDetails.ToString()], condition, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的OrderDetails記錄并填充向上關聯的數據表數據(不填充下級子表數據)
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="loadParentRecursive">是否遞歸裝載所有關聯的上級(父)數據表，為false時只裝載上一層關聯數據表</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderDetailses(OrdersDS ds, string condition, bool loadParentRecursive, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRequired(ds, da.DataTables[OrdersDS.TableEnum.OrderDetails.ToString()], condition, loadParentRecursive, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的OrderDetails記錄并填充相關聯的數據
		/// </summary>
		/// <param name="ds">接受數據填充的數據集實例(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		/// <param name="withRequired">是否裝載所有關聯的上級(父)數據表</param>
		/// <param name="loadRecursive">是否遞歸裝載所有下級(子)數據表，為false時只裝載關聯的一級子數據表</param>
		/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
		public virtual void GetOrderDetailses(OrdersDS ds, string condition, bool withRequired, bool loadRecursive, params OrdersDS.TableEnum[] relatedTables)
		{
			try
			{
				string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
				OrdersDA da = new OrdersDA();
				da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.OrderDetails.ToString()], condition, withRequired, loadRecursive, relatedTableNames);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

		/// <summary>
		/// 獲取符合條件的OrderDetails記錄
		/// </summary>
		/// <param name="tb">接受數據填充的數據表(需已創建)</param>
		/// <param name="condition">條件(不帶where前綴)</param>
		public virtual void GetOrderDetailses(OrdersDS.OrderDetailsDataTable tb, string condition)
		{
			try
			{
				OrdersDA da = new OrdersDA();
				da.Load(tb, condition);
			}
			catch(Exception ex)
			{
				throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
			}
		}

	}//end of class
}//end of namespace