VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Begin VB.Form FrmData 
   Caption         =   "數據維護"
   ClientHeight    =   2490
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4095
   LinkTopic       =   "Form1"
   ScaleHeight     =   2490
   ScaleWidth      =   4095
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cmdBrowse 
      Caption         =   "..."
      Height          =   285
      Left            =   2880
      TabIndex        =   7
      Top             =   1250
      Width           =   555
   End
   Begin VB.TextBox txtDataFileName 
      Height          =   345
      Left            =   1200
      TabIndex        =   4
      Top             =   1200
      Width           =   2295
   End
   Begin VB.ComboBox cmbDatabaseName 
      Height          =   300
      Left            =   1200
      TabIndex        =   3
      Top             =   360
      Width           =   2295
   End
   Begin VB.CommandButton cmdRestore 
      Caption         =   "還原"
      Height          =   465
      Left            =   1560
      TabIndex        =   2
      Top             =   1800
      Width           =   825
   End
   Begin VB.CommandButton cmdBackup 
      Caption         =   "備份"
      Height          =   465
      Left            =   360
      TabIndex        =   1
      Top             =   1800
      Width           =   945
   End
   Begin VB.CommandButton Command1 
      Caption         =   "退出"
      Height          =   465
      Left            =   2640
      TabIndex        =   0
      Top             =   1800
      Width           =   825
   End
   Begin MSComDlg.CommonDialog CommonDialog1 
      Left            =   2400
      Top             =   720
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
      DialogTitle     =   "Data File Name:"
   End
   Begin VB.Label Label2 
      Caption         =   "數據庫路徑"
      Height          =   255
      Left            =   120
      TabIndex        =   9
      Top             =   1320
      Width           =   975
   End
   Begin VB.Label Label1 
      Caption         =   "數據庫名稱"
      Height          =   255
      Left            =   120
      TabIndex        =   8
      Top             =   480
      Width           =   975
   End
   Begin VB.Label labchoose 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Height          =   180
      Left            =   0
      TabIndex        =   6
      Top             =   0
      Width           =   960
   End
   Begin VB.Label labml 
      BackStyle       =   0  'Transparent
      Height          =   255
      Left            =   0
      TabIndex        =   5
      Top             =   840
      Width           =   2475
   End
End
Attribute VB_Name = "FrmData"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim gSQLServer As SQLDMO.SQLServer
Dim WithEvents oBackupEvent As SQLDMO.Backup
Attribute oBackupEvent.VB_VarHelpID = -1
Dim WithEvents oRestoreEvent As SQLDMO.Restore
Attribute oRestoreEvent.VB_VarHelpID = -1
Dim gbConnected As Boolean
Dim gDatabaseName As String
Dim gBkupRstrFileName As String
Dim gBkupRstrFilePath As String
Const gTitle = "服務器連接"


Private Sub Command1_Click()
Unload Me
End Sub

Private Sub Form_Load()
    Set gSQLServer = Nothing
    gbConnected = False
    buttonsConnectClosed
    
    Dim ServerName As String
    Dim UserName As String
    Dim Password As String
    On Error GoTo errhandler:
    If gSQLServer Is Nothing Then
        Set gSQLServer = New SQLDMO.SQLServer
    End If
   ' ServerName = "YE-5B3D5361F47D"
   '114EF334F637425
    ServerName = "127.0.0.1"
    UserName = "sa"
    Password = "sa"
    gSQLServer.Connect ServerName, UserName, Password
    gbConnected = True
    FillDatabaseList
    buttonsConnectOpen
    Exit Sub
errhandler:
    MsgBox "Error " & Err.Description
    If Screen.MousePointer = vbHourglass Then
        Screen.MousePointer = vbDefault
    End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
    If gbConnected = True Then
        Call gSQLServer.Disconnect
    End If
    If Not gSQLServer Is Nothing Then
        Set gSQLServer = Nothing
    End If
End Sub

Private Sub cmdBackup_Click()
    On Error GoTo errhandler:
    CommonDialog1.CancelError = False
    CommonDialog1.Filter = "All Files (*.*)|*.*|Backup Files (*.bak)|*.bak"
    CommonDialog1.FilterIndex = 2
    CommonDialog1.InitDir = gBkupRstrFilePath
    CommonDialog1.DefaultExt = "bak"
    CommonDialog1.DialogTitle = "Data File Name:"
    CommonDialog1.Action = 2
    txtDataFileName.Text = CommonDialog1.FileName
    
    If txtDataFileName.Text <> "" Then
    On Error GoTo errhandler:
    Dim oBackup As SQLDMO.Backup
    gDatabaseName = cmbDatabaseName.Text
    Set oBackup = New SQLDMO.Backup
    Set oBackupEvent = oBackup ' enable events
    oBackup.Database = gDatabaseName
    gBkupRstrFileName = "[" + txtDataFileName.Text + "]"
    oBackup.Files = gBkupRstrFileName
'    If Len(Dir(gBkupRstrFileName)) > 0 Then
'        Kill (gBkupRstrFileName)
'    End If
    oBackup.SQLBackup gSQLServer
    Set oBackupEvent = Nothing ' disable events
    Set oBackup = Nothing
    Exit Sub
errhandler:
    MsgBox "Error " & Err.Description
    Resume Next
    End If
End Sub
Private Sub oBackupEvent_Complete(ByVal Message As String)
'
End Sub

Private Sub oBackupEvent_NextMedia(ByVal Message As String)
'
End Sub

Private Sub oBackupEvent_PercentComplete(ByVal Message As String, ByVal Percent As Long)
'
End Sub

Private Sub oRestoreEvent_Complete(ByVal Message As String)
'
End Sub

Private Sub oRestoreEvent_NextMedia(ByVal Message As String)
'
End Sub

Private Sub oRestoreEvent_PercentComplete(ByVal Message As String, ByVal Percent As Long)
'
End Sub

Private Sub cmdRestore_Click()
    On Error GoTo errhandler:
    
    Dim oRestore As SQLDMO.Restore
    
    Dim Msg As String
    Dim Response As String
    gDatabaseName = cmbDatabaseName.Text
    Set oRestore = New SQLDMO.Restore
    Set oRestoreEvent = oRestore        ' enable events
    
    oRestore.Database = gDatabaseName
    gBkupRstrFileName = "[" + txtDataFileName.Text + "]"
    oRestore.Files = gBkupRstrFileName
    Screen.MousePointer = vbHourglass
    oRestore.SQLRestore gSQLServer
    Screen.MousePointer = vbDefault
   
    Set oRestoreEvent = Nothing         ' disable events
    Set oRestore = Nothing
    Exit Sub
errhandler:
    MsgBox "Error " & Err.Description
    Resume Next
End Sub

Private Sub cmdBrowse_Click()
    On Error GoTo errhandler:
    CommonDialog1.CancelError = True
    CommonDialog1.Filter = "All Files (*.*)|*.*|Backup Files (*.bak)|*.bak"
    CommonDialog1.FilterIndex = 2
    CommonDialog1.InitDir = gBkupRstrFilePath
    CommonDialog1.DefaultExt = "bak"
    CommonDialog1.DialogTitle = "Data File Name:"
    CommonDialog1.Action = 1
    txtDataFileName.Text = CommonDialog1.FileName
    Exit Sub
errhandler:
    Exit Sub
End Sub


Private Sub optSSAuth_Click()
    If optSSAuth.Value = True Then
'        SSAuthOptionsOn
    End If
End Sub

Private Sub optWinNTAuth_Click()
    optWinNTAuth.Value = True
'    WinNTAuthOptionsOn
    txtUserName.Text = ""
    txtPassword.Text = ""
End Sub

Private Sub buttonsConnectClosed()
    
    cmdBackup.Enabled = False
    cmdRestore.Enabled = False
    cmdBrowse.Enabled = False
    cmbDatabaseName.Enabled = False
    txtDataFileName.Enabled = False
    
End Sub

Private Sub buttonsConnectOpen()
    cmdBackup.Enabled = True
    cmdRestore.Enabled = True
    cmdBrowse.Enabled = True
    cmbDatabaseName.Enabled = True
    txtDataFileName.Enabled = True
    
End Sub


Private Sub FillDatabaseList()
    cmbDatabaseName.Clear
    
    Dim oDB As SQLDMO.Database
    For Each oDB In gSQLServer.Databases
        If oDB.SystemObject = False Then
            cmbDatabaseName.AddItem oDB.Name
        End If
    Next oDB
    
    Dim MyPos As Integer
    gBkupRstrFilePath = CurDir
    MyPos = InStr(1, CurDir, "DevTools", 1)
    If MyPos > 0 Then
        gBkupRstrFilePath = Left(gBkupRstrFilePath, MyPos - 1)
        If Len(Dir(gBkupRstrFilePath + "backup", vbDirectory)) Then
            gBkupRstrFilePath = gBkupRstrFilePath + "backup\"
        Else
            gBkupRstrFilePath = "c:\"
        End If
    Else
        gBkupRstrFilePath = "c:\"
    End If
    If cmbDatabaseName.ListCount > 0 Then
        cmbDatabaseName.ListIndex = 0
        If Len(cmbDatabaseName.Text) > 0 Then
            txtDataFileName.Text = gBkupRstrFilePath + cmbDatabaseName.Text + ".bak"
        End If
    End If
    
End Sub
Private Sub cmbDatabaseName_Click()
    If Len(cmbDatabaseName.Text) > 0 Then
        txtDataFileName.Text = gBkupRstrFilePath + cmbDatabaseName.Text + ".bak"
    End If
End Sub