main_xtgl_sjcsh.frm

来自「商品进销存管理系统 采用VB和SQL2000开发 具有很强的实用性」· FRM 代码 · 共 236 行

FRM
236 行
字号
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form main_xtgl_sjcsh 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "系统管理-【数据初始化】"
   ClientHeight    =   3495
   ClientLeft      =   2265
   ClientTop       =   3765
   ClientWidth     =   8640
   Icon            =   "main_xtgl_sjcsh.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3495
   ScaleWidth      =   8640
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Tag             =   "数据初始化"
   Begin VB.CommandButton cmdStart 
      Caption         =   "开始"
      Height          =   390
      Left            =   3780
      TabIndex        =   13
      Top             =   2895
      Width           =   1470
   End
   Begin MSComctlLib.ProgressBar ProgressBar1 
      Height          =   360
      Left            =   120
      TabIndex        =   6
      Top             =   2340
      Visible         =   0   'False
      Width           =   8430
      _ExtentX        =   14870
      _ExtentY        =   635
      _Version        =   393216
      Appearance      =   1
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "退出"
      Height          =   390
      Left            =   6750
      TabIndex        =   5
      Top             =   2895
      Width           =   1470
   End
   Begin VB.CommandButton cmdIniti 
      Caption         =   "初始化"
      Enabled         =   0   'False
      Height          =   390
      Left            =   5265
      TabIndex        =   4
      Top             =   2895
      Width           =   1470
   End
   Begin VB.Frame Frame2 
      Caption         =   "各种单据"
      Height          =   765
      Left            =   75
      TabIndex        =   3
      Top             =   1320
      Width           =   8445
      Begin VB.CheckBox Check1 
         Caption         =   "库存信息"
         Height          =   240
         Index           =   8
         Left            =   5595
         TabIndex        =   14
         Top             =   360
         Width           =   1410
      End
      Begin VB.CheckBox Check1 
         Caption         =   "入库退单"
         Height          =   240
         Index           =   7
         Left            =   4170
         TabIndex        =   12
         Top             =   360
         Width           =   1125
      End
      Begin VB.CheckBox Check1 
         Caption         =   "入库单"
         Height          =   240
         Index           =   6
         Left            =   3030
         TabIndex        =   11
         Top             =   360
         Width           =   855
      End
      Begin VB.CheckBox Check1 
         Caption         =   "销售单"
         Height          =   240
         Index           =   4
         Left            =   420
         TabIndex        =   10
         Top             =   360
         Width           =   885
      End
      Begin VB.CheckBox Check1 
         Caption         =   "销售退单"
         Height          =   240
         Index           =   5
         Left            =   1635
         TabIndex        =   9
         Top             =   360
         Width           =   1410
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "基础数据"
      Height          =   765
      Left            =   75
      TabIndex        =   1
      Top             =   450
      Width           =   8445
      Begin VB.CheckBox Check1 
         Caption         =   "客户信息管理"
         Height          =   240
         Index           =   3
         Left            =   3750
         TabIndex        =   8
         Top             =   330
         Width           =   1410
      End
      Begin VB.CheckBox Check1 
         Caption         =   "供应商信息管理"
         Height          =   240
         Index           =   2
         Left            =   2040
         TabIndex        =   7
         Top             =   330
         Width           =   1890
      End
      Begin VB.CheckBox Check1 
         Caption         =   "员工信息管理"
         Height          =   240
         Index           =   1
         Left            =   390
         TabIndex        =   2
         Top             =   330
         Width           =   1410
      End
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "注意:系统初始化将清空系统数据"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   285
      Left            =   210
      TabIndex        =   0
      Top             =   75
      Width           =   4830
   End
End
Attribute VB_Name = "main_xtgl_sjcsh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*************************************************************************
'**模 块 名:main_xtgl_sjcsh
'**版权说明:吉林省明日科技有限公司享有本软件的所有版权,如果本软件用于商
'**          业用途,必须经过吉林省明日科技有限公司授权。如果提供网上免费
'**          下载,必须经过吉林省明日科技有限公司授权,并保证程序的完整,
'**          不得修改代码、注释和相关内容,否则,我公司将追究其法律责任
'**网    址:www.mingrisoft.com  价值无限,服务无限
'**电    话:(0431)84978981,84978982
'**创 建 人:明日科技
'**日    期:2007-10-31
'**修 改 人:MRLBB
'**日    期:2007-10-31
'**描    述:
'*************************************************************************

Private Sub cmdStart_Click()     '开始
 cmdIniti.Enabled = True
End Sub

Private Sub cmdIniti_Click()
    Dim connter As Integer     '定义一个整型变量
    Dim sql, workarea(200) As String     '定义字符串变量
    ProgressBar1.Visible = True
    ProgressBar1.Max = UBound(workarea)
    ProgressBar1.Value = ProgressBar1.Min
    For Counter = LBound(workarea) To UBound(workarea)
        workarea(Counter) = "initial value " & Counter
        ProgressBar1.Value = Counter
        '清空选定的表中的数据tb_bank
'        If Check1(0).Value = 1 Then
'            Cnn.Execute ("delete from tb_myunits")
'        End If
        If Check1(1).Value = 1 Then
            Cnn.Execute ("delete from tb_employe")
        End If
        If Check1(2).Value = 1 Then
            Cnn.Execute ("delete from tb_gys")
        End If
        If Check1(3).Value = 1 Then
            Cnn.Execute ("delete from tb_kh")
        End If
        If Check1(4).Value = 1 Then
            Cnn.Execute ("delete from tb_xsd")
        End If
        If Check1(5).Value = 1 Then
            Cnn.Execute ("delete from tb_xstd")
        End If
        If Check1(6).Value = 1 Then
            Cnn.Execute ("delete from tb_rkd")
        End If
        If Check1(7).Value = 1 Then
            Cnn.Execute ("delete from tb_rktd")
        End If
        If Check1(8).Value = 1 Then
            Cnn.Execute ("delete from tb_kc")
        End If
    Next Counter
    ProgressBar1.Visible = False
    ProgressBar1.Value = ProgressBar1.Min
    cmdIniti.Enabled = False
    RegInfo Me
End Sub
Private Sub cmdExit_Click()
 Unload Me
End Sub

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?