ASP.NET/資料訪問層和業務邏輯層

DAL (資料訪問層) & BLL (業務邏輯層)

資料集

新增新項: 資料集 開啟資料庫檢視器，將資料庫表拖放到資料集檢視器中。

從資料集檢視器中，您可以右鍵單擊表格，新增新的查詢並使用嚮導根據標準 SQL 配置它們。

BLL (業務邏輯層)

新增新項: 類命名約定是在類名後新增 BLL，例如“CustomersBLL”。

Imports OrderingSystemDSTableAdapters

<System.ComponentModel.DataObject()> _
Public Class CustomersBLL

    Private _customersAdapater As CustomersTableAdapter = Nothing
    Protected ReadOnly Property CustomersAdapater() As CustomersTableAdapter
        Get
            If _customersAdapater Is Nothing Then
                _customersAdapater = New CustomersTableAdapter()
            End If
            Return _customersAdapater 
        End Get
    End Property

    <System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Select, True)> _
    Public Function getCustomer() As OrderingSystemDS.CustomersDataTable
        Return CustomersAdapater.GetCustomers()
    End Function

    <System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Select, False)> _
    Public Function getCustomerByCustomerID(ByVal CustomerID As Integer) As OrderingSystemDS.CustomersDataTable
        Return CustomersAdapater.GetCustomerByCustomerID(CustomerID)
    End Function

End Class