frmdatademo.frm

适合乡镇供电所使用电费处理系统v3 软件

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form FrmDataDemo 
   AutoRedraw      =   -1  'True
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "演示数据导入"
   ClientHeight    =   5370
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   8130
   Icon            =   "FrmDataDemo.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5370
   ScaleWidth      =   8130
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  '窗口缺省
   Begin MSComctlLib.ProgressBar Prg1 
      Height          =   255
      Left            =   2640
      TabIndex        =   7
      Top             =   4050
      Width           =   5130
      _ExtentX        =   9049
      _ExtentY        =   450
      _Version        =   393216
      Appearance      =   1
   End
   Begin VB.CommandButton Command4 
      Caption         =   "上一步(&P)"
      Height          =   360
      Left            =   3825
      TabIndex        =   6
      Top             =   4725
      Width           =   1200
   End
   Begin VB.CommandButton Command3 
      Caption         =   "帮助(&H)"
      Height          =   330
      Left            =   6885
      TabIndex        =   4
      Top             =   4740
      Width           =   1110
   End
   Begin VB.CommandButton Command2 
      Caption         =   "取消(&Q)"
      Height          =   360
      Left            =   2250
      TabIndex        =   1
      Top             =   4740
      Width           =   1200
   End
   Begin VB.CommandButton Command1 
      Caption         =   "开始(&S)"
      Height          =   345
      Left            =   5385
      TabIndex        =   0
      Top             =   4725
      Width           =   1140
   End
   Begin VB.Label Label4 
      Caption         =   "Label4"
      Height          =   180
      Left            =   3165
      TabIndex        =   11
      Top             =   2505
      Width           =   3435
   End
   Begin VB.Label Label5 
      Caption         =   "Label5"
      Height          =   255
      Left            =   3150
      TabIndex        =   10
      Top             =   2850
      Width           =   3480
   End
   Begin VB.Label Label6 
      Caption         =   "Label6"
      Height          =   195
      Left            =   3150
      TabIndex        =   9
      Top             =   3225
      Width           =   3450
   End
   Begin VB.Label Label7 
      Caption         =   "Label7"
      Height          =   210
      Left            =   3150
      TabIndex        =   8
      Top             =   3600
      Width           =   3405
   End
   Begin VB.Image Image6 
      Height          =   240
      Left            =   6720
      Picture         =   "FrmDataDemo.frx":1272
      Top             =   3585
      Width           =   240
   End
   Begin VB.Image Image5 
      Height          =   240
      Left            =   6720
      Picture         =   "FrmDataDemo.frx":17FC
      Top             =   3180
      Width           =   240
   End
   Begin VB.Image Image4 
      Height          =   240
      Left            =   6705
      Picture         =   "FrmDataDemo.frx":1D86
      Top             =   2820
      Width           =   240
   End
   Begin VB.Image Image3 
      Height          =   240
      Left            =   6720
      Picture         =   "FrmDataDemo.frx":2310
      Top             =   2430
      Width           =   240
   End
   Begin VB.Shape Shape2 
      BorderColor     =   &H80000003&
      Height          =   1995
      Left            =   2580
      Top             =   210
      Width           =   5325
   End
   Begin VB.Shape Shape1 
      BorderColor     =   &H00FFFFFF&
      Height          =   1995
      Left            =   2595
      Top             =   225
      Width           =   5325
   End
   Begin VB.Label Label1 
      BackColor       =   &H00C0C0C0&
      BackStyle       =   0  'Transparent
      Caption         =   $"FrmDataDemo.frx":289A
      ForeColor       =   &H00000000&
      Height          =   1455
      Left            =   2940
      TabIndex        =   5
      Top             =   585
      Width           =   4575
   End
   Begin VB.Label Label3 
      BackStyle       =   0  'Transparent
      Caption         =   "ND2000"
      BeginProperty Font 
         Name            =   "Comic Sans MS"
         Size            =   12
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   330
      Left            =   810
      TabIndex        =   3
      Top             =   4575
      Width           =   1065
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "ND2000"
      BeginProperty Font 
         Name            =   "Comic Sans MS"
         Size            =   12
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00000000&
      Height          =   330
      Left            =   780
      TabIndex        =   2
      Top             =   4590
      Width           =   1065
   End
   Begin VB.Image Image2 
      Height          =   480
      Left            =   240
      Picture         =   "FrmDataDemo.frx":29EE
      Top             =   4545
      Width           =   480
   End
   Begin VB.Line Line2 
      BorderColor     =   &H80000005&
      X1              =   375
      X2              =   7965
      Y1              =   4485
      Y2              =   4485
   End
   Begin VB.Line Line1 
      BorderColor     =   &H80000003&
      X1              =   390
      X2              =   7995
      Y1              =   4470
      Y2              =   4470
   End
   Begin VB.Image Image1 
      BorderStyle     =   1  'Fixed Single
      Height          =   3690
      Left            =   225
      Picture         =   "FrmDataDemo.frx":2CE9
      Top             =   195
      Width           =   1875
   End
End
Attribute VB_Name = "FrmDataDemo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

'开始导入代码段
Private Sub Command1_Click()
     'Dim VerStr As String, StA As String, StB As String, StC As String, StD As String
     If Command1.Tag <> "OK" Then
     Dim db2 As Database
     Dim RE2 As Recordset
     Dim nSec As Long
     Dim i As Integer
     
     If FileExists(App.Path & "\Data\EletDemo.MDB") = False Then
       MsgBox "数据导入失败，原始文件找不到！", vbCritical
       Exit Sub
     End If
     
     GzYue = Format(Month(Date), "0#")
     Call sTruInfo
     
     OpenMdb
     Screen.MousePointer = 11
     '导入镇档案
     'EletDemo
     
     nSec = Timer    '计时
     '打开演示数据库
     Set db2 = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\Data\EletDemo.MDB")
     '打开系统数据库
     Set NdMd = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\Data\Eletricity.MDB")
     
     
     Set MdbR = NdMd.OpenRecordset("乡镇档案") '正式