frm_restoredatabase.frm

提供给入门级别的GPRS编程人员

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Object = "{2B12169D-6738-11D2-BF5B-00A024982E5B}#31.8#0"; "CoolButton.OCX"
Begin VB.Form frm_restoredatabase 
   BackColor       =   &H00FFC0C0&
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "GPRS用电管理系统"
   ClientHeight    =   1515
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5175
   Icon            =   "frm_restoredatabase.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   1515
   ScaleWidth      =   5175
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Begin VB.Frame Frame1 
      Caption         =   "还原数据库"
      ForeColor       =   &H00FF0000&
      Height          =   1500
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   5175
      Begin TButton.axButton xpcmdbutton3 
         Height          =   330
         Left            =   3900
         TabIndex        =   5
         Top             =   1080
         Width           =   1095
         _ExtentX        =   1931
         _ExtentY        =   582
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Caption         =   "退  出"
         MaskColor       =   -2147483633
      End
      Begin TButton.axButton xpcmdbutton2 
         Height          =   330
         Left            =   2640
         TabIndex        =   4
         Top             =   1080
         Width           =   1095
         _ExtentX        =   1931
         _ExtentY        =   582
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Caption         =   "还  原"
         MaskColor       =   -2147483633
      End
      Begin TButton.axButton xpcmdbutton1 
         Height          =   330
         Left            =   3900
         TabIndex        =   3
         Top             =   600
         Width           =   1100
         _ExtentX        =   1931
         _ExtentY        =   582
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Caption         =   "浏  览"
         MaskColor       =   -2147483633
      End
      Begin VB.TextBox txt_fname 
         Appearance      =   0  'Flat
         Height          =   330
         Left            =   360
         TabIndex        =   1
         Top             =   600
         Width           =   3375
      End
      Begin MSComDlg.CommonDialog dog 
         Left            =   3480
         Top             =   1200
         _ExtentX        =   847
         _ExtentY        =   847
         _Version        =   393216
      End
      Begin VB.Label Label1 
         BackStyle       =   0  'Transparent
         Caption         =   "请选择要还原的数据文件："
         Height          =   255
         Left            =   360
         TabIndex        =   2
         Top             =   360
         Width           =   2175
      End
   End
End
Attribute VB_Name = "frm_restoredatabase"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
    txt_fname.Text = App.Path & "\databasebak\gprspc.bak"
End Sub

Private Sub xpcmdbutton1_Click() '浏览
    dog.Filter = "备份文件(*.bak)|*.bak"
    dog.ShowSave
    txt_fname.Text = dog.FileName
    If dog.FileName = "" Then
        txt_fname.Text = App.Path & "\databasebak\gprspc.bak"
    End If
End Sub

Private Sub xpcmdbutton2_Click() '备份
    Dim returnmsg As String
    If Trim(txt_fname.Text) = "" Then
        MsgBox ("存储路径不能为空！"), vbOKOnly + vbInformation, "提示"
        Exit Sub
    End If
    returnmsg = fRestoreDatabase_a(Trim(txt_fname), "gprspc", App.Path & "\database1")
    If returnmsg = "" Then
        MsgBox ("还原成功！"), vbOKOnly + vbInformation, "提示"
        Exit Sub
    Else
        MsgBox (returnmsg), vbOKOnly + vbInformation, "提示"
        Exit Sub
    End If
End Sub

Private Sub xpcmdbutton3_Click()
    Unload Me
End Sub