projectfacade.vb

使用Access数据库演示的任务分配管理程序 一个使用ADO.NET基于Microsoft Access数据库演示的任务分配管理的程序

'------------------------------------------------------------------------------
' <auto-generated>
'     This code was generated by a tool.
'     Runtime Version:2.0.50727.42
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------

Option Strict Off
Option Explicit On

Imports Common.Business
Imports Database.DataAccess
Imports System
Imports System.Collections
Imports System.Text

'*************************************************************
' Class Name:  ProjectFacade
' Purpose:  A pattern class that represents an entire subsystem.
' Description: 
'***************************************************************
Namespace Database
    
    <Serializable()>  _
    Public Class ProjectFacade
        
        Private m_ProjectDAO As ProjectDAO = New ProjectDAO
        
        Public Sub New()
            MyBase.New
            Me.InitializeClass
        End Sub
        
        Private Sub InitializeClass()
        End Sub
        
        Function GetProject(ByVal ProjectID As Integer) As Project
            ' TODO: add security here...
            Dim biz As Project = m_ProjectDAO.GetByPrimaryKey(ProjectID)
            Return biz
        End Function
        
        Function GetProjectArrayWhere(ByVal sql As String) As Project()
            ' TODO: add security here...
            Return m_ProjectDAO.GetProjectsWhere(sql)
        End Function
        
        Function GetProjectTableWhere(ByVal sql As String) As System.Data.DataTable
            ' TODO: add security here...
            Return m_ProjectDAO.GetProjectsTableWhere(sql)
        End Function
        
        Function GetProjectsWhere(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_ProjectDAO.GetProjectsWhere(args)
        End Function
        
        Function GetProjectsWhereAndAlso(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_ProjectDAO.GetProjectsWhereAndAlso(args)
        End Function
        
        Function InsertProject(ByVal biz As Project) As Integer
            ' TODO: add security here...
            Return m_ProjectDAO.Insert(biz)
        End Function
        
        Sub UpdateProject(ByVal biz As Project)
            ' TODO: add security here...
            m_ProjectDAO.Update(biz)
        End Sub
        
        Sub DeleteProject(ByVal ID As Integer)
            ' TODO: add security here...
            m_ProjectDAO.Delete(ID)
        End Sub
        
        Function GetAllProjects() As System.Collections.ArrayList
            ' TODO: add security here...
            Dim Projects As System.Collections.ArrayList = m_ProjectDAO.GetAllProjects
            Return Projects
        End Function
    End Class
End Namespace