clsopshopinfo.cls

VB数据库设计的代码。需要根据自己的数据库再作调整

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "clsOpShopInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Attribute VB_Ext_KEY = "SavedWithClassBuilder6" ,"Yes"
Attribute VB_Ext_KEY = "Top_Level" ,"Yes"
Option Explicit

'***********************************************************************
'* 过程名：AppendNewShop
'* 功  能：追加新店
'* 参  数：clsOpuser                  当前用户
'* 版  本：2006.01.01 颜志军 初版
'***********************************************************************
Public Sub AppendNewShop(ByRef currentUser As clsOpuser)
    Dim memShop As clsMembershop
    Set memShop = New clsMembershop
    frmShopInfo.ShowDlg memShop, False, currentUser
End Sub

'***********************************************************************
'* 过程名：EditShop
'* 功  能：修改店信息
'* 参  数：clsMembershop            被修改店对象
'*       ：clsOpuser                 当前用户
'* 版  本：2006.01.01 颜志军 初版
'***********************************************************************
Public Sub editShop(ByRef editShop As clsMembershop, _
        ByRef currentUser As clsOpuser)
    frmShopInfo.ShowDlg editShop, True, currentUser
End Sub

'***********************************************************************
'* 过程名：RemoveShop
'* 功  能：删除连锁店
'* 参  数：clsOpuser                操作员信息
'*       ：clsOpuser                当前用户
'* 返回值：Boolean                  True 成功 False 失败
'* 版  本：2006.01.02 颜志军 初版
'***********************************************************************
Public Function RemoveShop(ByRef editShop As clsMembershop, _
        ByRef currentUser As clsOpuser) As Boolean
    RemoveShop = False
    If currentUser.userRank > 1 Then
        MsgBox "您没有删除连锁店的权利！", vbExclamation Or vbOKOnly, "警告"
    ElseIf editShop Is Nothing Or Not IsObject(editShop) Then
        MsgBox "没有指定删除对象！", vbExclamation Or vbOKOnly, "警告"
    Else
        Select Case editShop.Delete()
        Case DbOpOk
            RemoveShop = True
        Case DbOpOnlyRec
            MsgBox "总公司不可删除！", vbExclamation Or vbOKOnly, "警告"
        End Select
    End If
End Function