userfacade.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:  UserFacade
' Purpose:  A pattern class that represents an entire subsystem.
' Description: 
'***************************************************************
Namespace Database
    
    <Serializable()>  _
    Public Class UserFacade
        
        Private m_UserDAO As UserDAO = New UserDAO
        
        Public Sub New()
            MyBase.New
            Me.InitializeClass
        End Sub
        
        Private Sub InitializeClass()
        End Sub
        
        Function GetUser(ByVal UserID As Integer) As User
            ' TODO: add security here...
            Dim biz As User = m_UserDAO.GetByPrimaryKey(UserID)
            Return biz
        End Function
        
        Function GetUserArrayWhere(ByVal sql As String) As User()
            ' TODO: add security here...
            Return m_UserDAO.GetUsersWhere(sql)
        End Function
        
        Function GetUserTableWhere(ByVal sql As String) As System.Data.DataTable
            ' TODO: add security here...
            Return m_UserDAO.GetUsersTableWhere(sql)
        End Function
        
        Function GetUsersWhere(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_UserDAO.GetUsersWhere(args)
        End Function
        
        Function GetUsersWhereAndAlso(ByVal args() As Object) As System.Collections.ArrayList
            ' TODO: add security here...
            Return m_UserDAO.GetUsersWhereAndAlso(args)
        End Function
        
        Function InsertUser(ByVal biz As User) As Integer
            ' TODO: add security here...
            Return m_UserDAO.Insert(biz)
        End Function
        
        Sub UpdateUser(ByVal biz As User)
            ' TODO: add security here...
            m_UserDAO.Update(biz)
        End Sub
        
        Sub DeleteUser(ByVal ID As Integer)
            ' TODO: add security here...
            m_UserDAO.Delete(ID)
        End Sub
        
        Function GetAllUsers() As System.Collections.ArrayList
            ' TODO: add security here...
            Dim Users As System.Collections.ArrayList = m_UserDAO.GetAllUsers
            Return Users
        End Function
    End Class
End Namespace