ordersblbase.cs

网上鲜花销售系统 内有源码和需求分析

			}
			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