frm_系统初始化.frm

计量器具管理系统

VERSION 5.00
Begin VB.Form Frm_系统初始化 
   Caption         =   "系统初始化"
   ClientHeight    =   2265
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   6270
   Icon            =   "Frm_系统初始化.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   2265
   ScaleWidth      =   6270
   StartUpPosition =   3  '窗口缺省
   Begin VB.PictureBox Picture2 
      Appearance      =   0  'Flat
      BackColor       =   &H80000005&
      ForeColor       =   &H80000008&
      Height          =   2265
      Left            =   4410
      ScaleHeight     =   2235
      ScaleWidth      =   1830
      TabIndex        =   1
      Top             =   0
      Width           =   1860
      Begin VB.CommandButton SNXpInit 
         Caption         =   "确认初始化"
         Height          =   495
         Left            =   120
         TabIndex        =   10
         Top             =   600
         Width           =   1455
      End
      Begin VB.CommandButton SNXpExit 
         Caption         =   "退    出"
         Height          =   495
         Left            =   120
         TabIndex        =   9
         Top             =   1440
         Width           =   1455
      End
   End
   Begin VB.PictureBox Picture1 
      Appearance      =   0  'Flat
      BackColor       =   &H80000005&
      ForeColor       =   &H80000008&
      Height          =   2265
      Left            =   -15
      ScaleHeight     =   2235
      ScaleWidth      =   4395
      TabIndex        =   0
      Top             =   0
      Width           =   4425
      Begin VB.CheckBox Check1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "单位信息"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   300
         Left            =   540
         TabIndex        =   7
         Top             =   465
         Value           =   1  'Checked
         Width           =   1215
      End
      Begin VB.CheckBox Check2 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "部门信息"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   405
         Left            =   540
         TabIndex        =   6
         Top             =   990
         Value           =   1  'Checked
         Width           =   1095
      End
      Begin VB.CheckBox Check3 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "计量器具信息表"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   330
         Left            =   540
         TabIndex        =   5
         Top             =   1605
         Value           =   1  'Checked
         Width           =   1590
      End
      Begin VB.CheckBox Check4 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "计量器具检定表"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   255
         Left            =   2190
         TabIndex        =   4
         Top             =   465
         Value           =   1  'Checked
         Width           =   1575
      End
      Begin VB.CheckBox Check5 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "强制检定计量器具"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   330
         Left            =   2190
         TabIndex        =   3
         Top             =   1005
         Value           =   1  'Checked
         Width           =   1950
      End
      Begin VB.CheckBox Check6 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "计量器具维修表"
         Enabled         =   0   'False
         ForeColor       =   &H80000008&
         Height          =   375
         Left            =   2190
         TabIndex        =   2
         Top             =   1560
         Value           =   1  'Checked
         Width           =   1590
      End
      Begin VB.Label Label1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         Caption         =   "请选择需要清除数据的表"
         ForeColor       =   &H80000008&
         Height          =   240
         Left            =   150
         TabIndex        =   8
         Top             =   135
         Width           =   2025
      End
      Begin VB.Shape Shape2 
         BorderColor     =   &H00FF8080&
         Height          =   2070
         Left            =   75
         Top             =   75
         Width           =   4230
      End
      Begin VB.Shape Shape1 
         BorderColor     =   &H00FF8080&
         Height          =   2160
         Left            =   30
         Top             =   30
         Width           =   4320
      End
   End
End
Attribute VB_Name = "Frm_系统初始化"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
    Me.Left = (Screen.Width - Me.Width) / 2
    Me.Top = (Screen.Height - Me.Height) * (1 - 0.618)
End Sub
 

Private Sub SNXpEXIT_Click()
    Unload Me
End Sub

Private Sub SNXpInit_Click()
If Conn.State = 1 Then
    If MsgBox("请确认是否需要系统初始化,系统初始化将清除所有信息!", vbYesNo, "提示") = vbNo Then Exit Sub
    Conn.Execute "delete from dwxx "
    Conn.Execute "delete from bmxx  "
    Conn.Execute "delete from jlqjxx "
    Conn.Execute "delete from jlqjjd  "
    Conn.Execute "delete from jlqjbf  "
    Conn.Execute "delete from jlqjwx "
    MsgBox "系统初始化成功!", vbInformation, "提示"
End If
End Sub