taskfacade.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:  TaskFacade
' Purpose:  A pattern class that represents an entire subsystem.
' Description: 
'***************************************************************
Namespace Database
    
    <Serializable()>  _
    Public Class TaskFacade
        
        Private m_TaskDAO As TaskDAO = New TaskDAO
        
        Public Sub New()
            MyBase.New
            Me.InitializeClass
        End Sub
        
        Private Sub InitializeClass()
        End Sub
        
        Function GetTask(ByVal TaskID As Integer) As Task
            ' TODO: add security here...
            Dim biz As Task = m_TaskDAO.GetByPrimaryKey(TaskID)
            Return biz
        End Function
        
        Function GetTaskArrayWhere(ByVal sql As String) As Task()
            ' TODO: add security here...
            Return m_TaskDAO.GetTasksWhere(sql)
        End Function
        
        Function GetTaskTableWhere(ByVal sql As String) As System.Data.DataTable
            ' TODO: add security here...
            Return m_TaskDAO.GetTasksTableWhere(sql)
        End Function
        
        Function GetTasksWhere(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_TaskDAO.GetTasksWhere(args)
        End Function
        
        Function GetTasksWhereAndAlso(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_TaskDAO.GetTasksWhereAndAlso(args)
        End Function
        
        Function InsertTask(ByVal biz As Task) As Integer
            ' TODO: add security here...
            Return m_TaskDAO.Insert(biz)
        End Function
        
        Sub UpdateTask(ByVal biz As Task)
            ' TODO: add security here...
            m_TaskDAO.Update(biz)
        End Sub
        
        Sub DeleteTask(ByVal ID As Integer)
            ' TODO: add security here...
            m_TaskDAO.Delete(ID)
        End Sub
        
        Function GetAllTasks() As System.Collections.ArrayList
            ' TODO: add security here...
            Dim Tasks As System.Collections.ArrayList = m_TaskDAO.GetAllTasks
            Return Tasks
        End Function
    End Class
End Namespace