?? ordersblbase.cs
字號:
?//注意：當前類文件由開發助手自動產生，以后每次生成代碼時都將自動更新。用戶不可編輯此文件的任何內容，以免被覆蓋！
// This source code was auto-generated by DevHelper, on 2006-1-2 22:09:14. don't modify this file!
using System;
using System.Text;
using System.Data;
using System.Collections;
using DingHaokai.BussinessLogic;
using FlowerShop.MOD;
using FlowerShop.DAL;
namespace FlowerShop.BLL.Base
{
public class OrdersBLBase : BaseBL
{
/// <summary>
/// 受保護的內部構造函數，用戶不能創建該類實例，而應創建OrdersBL類實例
/// </summary>
protected internal OrdersBLBase()
{
}
/// <summary>
/// 從數據庫中獲取OrdersDS數據集的所有數據
/// </summary>
/// <param name="ds">輸出加載后的數據集類實例，注意此參數為out類型參數。</param>
public virtual void GetItems(out OrdersDS ds)
{
ds = new OrdersDS();
try
{
new OrdersDA().Load(ds);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 保存OrdersDS數據集
/// </summary>
/// <param name="ds">OrdersDS數據</param>
public void Save(OrdersDS ds)
{
int transID;
OrdersDA.BeginTrans(out transID);
try
{
Save(ds, transID);
OrdersDA.CommitTrans(transID);
}
catch(Exception ex)
{
OrdersDA.RollbackTrans(transID);
throw new BLException(ExceptionType.UpdateFailed, ex.Message);
}
}
/// <summary>
/// 保存OrdersDS數據集
/// </summary>
/// <param name="ds">OrdersDS數據</param>
/// <param name="transID">數據庫事務ID</param>
public void Save(OrdersDS ds, int transID)
{
OrdersDA da = new OrdersDA();
//
//根據數據集中各表間的關聯關系，先處理子表刪除的記錄
//
if(ds.Orders.GetChanges() != null)
da.Update(ds.Orders, transID);
if(ds.OrderDetails.GetChanges() != null)
da.Update(ds.OrderDetails, transID);
//da.Update(ds, transID);
}
/// <summary>
/// 根據枚舉表數組建立相應的枚舉表表名數組
/// </summary>
private string[] BuildDataTableNameArray(OrdersDS.TableEnum[] relatedTables, params OrdersDS.TableEnum[] excludeTables)
{
if (relatedTables != null && relatedTables.Length>0)
{
ArrayList relatedTableNames = new ArrayList();
foreach (OrdersDS.TableEnum relatedTable in relatedTables)
{
if (Array.IndexOf(excludeTables, relatedTable)<0)
{
relatedTableNames.Add(relatedTable.ToString());
}
}
return (string[])relatedTableNames.ToArray(typeof(string));
}
else
{
return null;
}
}
/// <summary>
/// 根據OrderID獲取Orders表數據及并填充關聯的數據表
/// </summary>
/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrdersRow GetOrders(OrdersDS ds, int OrderID, params OrdersDS.TableEnum[] relatedTables)
{
try
{
string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
OrdersDA da = new OrdersDA();
da.LoadWithRelated(ds, da.DataTables[OrdersDS.TableEnum.Orders.ToString()],"OrderID="+OrderID.ToString(), relatedTableNames);
return ds.Orders.FindByOrderID(OrderID);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 根據OrderID獲取Orders表數據及并填充向上關聯的數據表數據(不填充下級子表數據)
/// </summary>
/// <param name="loadParentRecursive">是否遞歸裝載所有關聯的上級(父)數據表，為false時只裝載上一層關聯數據表</param>
/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrdersRow GetOrders(OrdersDS ds, int OrderID, bool loadParentRecursive, params OrdersDS.TableEnum[] relatedTables)
{
try
{
string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
OrdersDA da = new OrdersDA();
da.LoadWithRequired(ds, da.DataTables[OrdersDS.TableEnum.Orders.ToString()],"OrderID="+OrderID.ToString(), loadParentRecursive, relatedTableNames);
return ds.Orders.FindByOrderID(OrderID);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 根據OrderID獲取Orders表數據及并填充關聯的數據表
/// </summary>
/// <param name="withRequired">是否裝載所有關聯的上級(父)數據表</param>
/// <param name="loadRecursive">是否遞歸裝載所有下級(子)數據表，為false時只裝載關聯的一級子數據表</param>
/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrdersRow GetOrders(OrdersDS ds, int OrderID, 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()],"OrderID="+OrderID.ToString(), withRequired, loadRecursive, relatedTableNames);
return ds.Orders.FindByOrderID(OrderID);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 根據OrderID獲取Orders表數據
/// </summary>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrdersRow GetOrders(OrdersDS.OrdersDataTable tb, int OrderID)
{
try
{
new OrdersDA().Load(tb, "OrderID="+OrderID.ToString());
return tb.FindByOrderID(OrderID);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 根據OrderDetailID獲取OrderDetails表數據及并填充關聯的數據表
/// </summary>
/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrderDetailsRow GetOrderDetails(OrdersDS ds, int OrderDetailID, 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(), relatedTableNames);
return ds.OrderDetails.FindByOrderDetailID(OrderDetailID);
}
catch(Exception ex)
{
throw new BLException(ExceptionType.DataLoadFailed, ex.Message);
}
}
/// <summary>
/// 根據OrderDetailID獲取OrderDetails表數據及并填充向上關聯的數據表數據(不填充下級子表數據)
/// </summary>
/// <param name="loadParentRecursive">是否遞歸裝載所有關聯的上級(父)數據表，為false時只裝載上一層關聯數據表</param>
/// <param name="relatedTables">指定填充關聯表范圍，在此范圍之外的關聯表將被忽略。此參數為空時將被忽略。</param>
/// <returns>返回主鍵值對應的數據行</returns>
public virtual OrdersDS.OrderDetailsRow GetOrderDetails(OrdersDS ds, int OrderDetailID, bool loadParentRecursive, params OrdersDS.TableEnum[] relatedTables)
{
try
{
string[] relatedTableNames = BuildDataTableNameArray(relatedTables);
OrdersDA da = new OrdersDA();
da.LoadWithRequired(ds, da.DataTables[OrdersDS.TableEnum.OrderDetails.ToString()],"OrderDetailID="+OrderDetailID.ToString(), loadParentRecursive, relatedTableNames);
return ds.OrderDetails.FindByOrderDetailID(OrderDetailID);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -