VB开发的ERP系统

VERSION 5.00
Begin VB.Form KF_FrmStartFinish 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "初始化完成"
   ClientHeight    =   1335
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   3585
   Icon            =   "期初_初始化完成.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   1335
   ScaleWidth      =   3585
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame1 
      Height          =   840
      Left            =   60
      TabIndex        =   2
      Top             =   60
      Width           =   3450
      Begin VB.Image Image1 
         Height          =   480
         Left            =   135
         Picture         =   "期初_初始化完成.frx":1042
         Top             =   195
         Width           =   480
      End
      Begin VB.Label Label1 
         Caption         =   "请确认要进行初始化完成设置？"
         Height          =   360
         Left            =   780
         TabIndex        =   3
         Top             =   315
         Width           =   2565
      End
   End
   Begin VB.CommandButton QdCommand 
      Caption         =   "取消(&C)"
      Height          =   300
      Index           =   1
      Left            =   2385
      TabIndex        =   1
      Top             =   975
      Width           =   1120
   End
   Begin VB.CommandButton QdCommand 
      Caption         =   "确定(&O)"
      Height          =   300
      Index           =   0
      Left            =   1200
      TabIndex        =   0
      Top             =   975
      Width           =   1120
   End
End
Attribute VB_Name = "KF_FrmStartFinish"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*****************************************************************
'   模块名称：初始化完成设置
'   模块功能：设置初始化完成
'   编 制 者：赵宇光
'   编制日期：2001/11/27
'   备    注：
'*****************************************************************

Private Sub QdCommand_Click(Index As Integer)
    
    Select Case Index
        Case 0                  '确定
            Call StartFinish
            Me.Hide
        Case 1                  '取消
            Unload Me
    End Select
End Sub
Private Sub StartFinish()
'函数功能：完成系统初始化设置
    
    Dim adoRec As New ADODB.Recordset
    Dim strSQL As String
    Dim Tsxx As String
    
    '判断是否期初完成记账
    strSQL = "select EndDealFlagWh from gy_WareHouse WHERE EndDealFlagWh=0"
    Set adoRec = Cw_DataEnvi.DataConnect.Execute(strSQL)
    
    With adoRec
        If Not .EOF Then
            Tsxx = "未完成期初结帐,不能进行初始化完成操作!"
            Call Xtxxts(Tsxx, 0, 1)
            Exit Sub
        End If
    End With
    
    '1.期初数据不可录入,期初记账不可用
    
    '2.初始化完成标志设为1
    Cw_DataEnvi.DataConnect.Execute ("UPDATE Gy_AccInformation SET itemvalue=1 WHERE SystemCode='KF' and ItemCode='KFInit'")
    '3.库房期末处理标志设为0
    Cw_DataEnvi.DataConnect.Execute ("UPDATE Gy_WareHouse SET EndDealFlagWh=0")
    '4.把期初数据加入现存量表
    Cw_DataEnvi.DataConnect.Execute ("KF_SP_StartIntoQuan")
    
    Tsxx = "初始化完成设置成功!"
    Call Xtxxts(Tsxx, 0, 4)
    Exit Sub
    
End Sub