frmimgimport.frm

用vb编了一个数据库程序

VERSION 5.00
Begin VB.Form frmImgImport 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "从输入设备导入图片"
   ClientHeight    =   5475
   ClientLeft      =   2205
   ClientTop       =   2355
   ClientWidth     =   7410
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5475
   ScaleWidth      =   7410
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton cmdPathSet 
      Caption         =   "图片路径设置(&P)"
      Height          =   375
      Left            =   720
      TabIndex        =   7
      Top             =   4890
      Width           =   1600
   End
   Begin VB.Frame frmSplitter 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   4125
      Left            =   3660
      MouseIcon       =   "frmImgImport.frx":0000
      MousePointer    =   99  'Custom
      TabIndex        =   6
      Top             =   510
      Width           =   75
   End
   Begin VB.CommandButton cmdFileImport 
      Caption         =   "从文件导入(&F)"
      Height          =   375
      Left            =   4200
      TabIndex        =   5
      Top             =   4890
      Width           =   1500
   End
   Begin VB.ListBox lstCase 
      Height          =   3840
      Left            =   3750
      TabIndex        =   4
      Top             =   600
      Width           =   3525
   End
   Begin VB.ListBox lstQY 
      Height          =   3840
      Left            =   150
      TabIndex        =   3
      Top             =   600
      Width           =   3500
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "取消(&C)"
      Height          =   375
      Left            =   5700
      TabIndex        =   2
      Top             =   4890
      Width           =   1500
   End
   Begin VB.CommandButton CmdStartScan 
      Caption         =   " 扫描仪导入(&S)"
      Height          =   375
      Left            =   2700
      TabIndex        =   0
      Top             =   4890
      Width           =   1500
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "以下是您选择的企业(单位)和文书类型"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   210
      Left            =   210
      TabIndex        =   1
      Top             =   180
      Width           =   3570
   End
End
Attribute VB_Name = "frmImgImport"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Dim rstImgPath As ADODB.Recordset

Dim mbMoving As Boolean
Const sglSplitLimit As Integer = 1800

Public ImgSavePath As String
Public ImgSaveName As String

Private Sub cmdExit_Click()
    Unload Me
End Sub

Private Sub cmdFileImport_Click()

'检查图片路径是否存在
Call CheckImgSavePath

'再次检查图片路径,如果还是为空,则退出
With rstImgPath
    If Not .EOF Then .MoveLast
    If Not .BOF Then .MoveFirst
    If rstImgPath.RecordCount = 0 Then
        MsgBox "只有先设置文书存放路径,才能导入图片!", vbInformation
        Exit Sub
    End If
End With

Dim fImgCopy As frmImgCopy
    
Set fImgCopy = New frmImgCopy
fImgCopy.Show vbModal
    
End Sub

Private Sub cmdPathSet_Click()
    Dim fImgPathSet As frmImgPathSet
    
    Set fImgPathSet = New frmImgPathSet
    fImgPathSet.Show vbModal
    
End Sub

Private Sub CmdStartScan_Click()

'检查图片路径是否存在
Call CheckImgSavePath

'再次检查图片路径,如果还是为空,则退出
With rstImgPath
    If Not .EOF Then .MoveLast
    If Not .BOF Then .MoveFirst
    If rstImgPath.RecordCount = 0 Then
        MsgBox "只有先设置文书存放路径,才能导入图片!", vbInformation
        Exit Sub
    End If
End With

Dim fImgScan As frmImgScan
    
Set fImgScan = New frmImgScan
fImgScan.Show vbModal

End Sub

Private Sub CheckImgSavePath()
'****************************************************
'功能:检查系统图片目录是否存在
'****************************************************
    Dim Msg As String
       
    With rstImgPath
        If Not .EOF Then .MoveLast
        If Not .BOF Then .MoveFirst
        If .RecordCount = 0 Then
            Msg = MsgBox("未设置文书存放路径,要现在设置吗?", vbYesNo + vbInformation)
            Select Case Msg
                Case vbYes
                    Call cmdPathSet_Click
                Case vbNo
            End Select
        End If
    End With
    
    rstImgPath.Requery

End Sub

Private Sub Form_Load()
    On Error Resume Next

    Set rstImgPath = New ADODB.Recordset
    rstImgPath.Open "SELECT Img_Path FROM Sys_Path", conCaseMain, 1, 1 ', adCmdText

    '清除原有项
    lstQY.Clear
    lstCase.Clear
    
    Dim i As Integer
    For i = 0 To UBound(CompanyCodeName)
        If CompanyCodeName(i) <> vbNullString Then
            lstQY.AddItem CompanyCodeName(i)
        End If
    Next i
    For i = 0 To UBound(CaseCodeName)
        If CaseCodeName(i) <> vbNullString Then
            lstCase.AddItem Left(CaseCodeName(i), Len(CaseCodeName(i)) - 1)
        End If
    Next i
        
End Sub

Private Sub Form_Unload(Cancel As Integer)

    '清除原有数组元素
    ReDim CompanyCodeName(0)
    ReDim CaseCodeName(0)
    
    If UBound(CompanyCaseType) > 0 Then
        ReDim CompanyCaseType(0)
    End If
    If Not rstImgPath Is Nothing Then
        rstImgPath.Close
        Set rstImgPath = Nothing
    End If
End Sub

Private Sub frmSplitter_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    With frmSplitter
        frmSplitter.Move .Left, .Top, .Width, .Height
    End With
    mbMoving = True
End Sub

Private Sub frmSplitter_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Dim sglPos As Single
    
    If mbMoving Then
        sglPos = X + frmSplitter.Left
        If sglPos < sglSplitLimit Then
            frmSplitter.Left = sglSplitLimit
        ElseIf sglPos > Me.Width - sglSplitLimit Then
            frmSplitter.Left = Me.Width - sglSplitLimit
        Else
            frmSplitter.Left = sglPos
        End If
    End If

End Sub

Private Sub frmSplitter_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
    SizeControls frmSplitter.Left
    mbMoving = False
End Sub

Sub SizeControls(X As Single)
    On Error Resume Next
    
    '设置 x
    If X < sglSplitLimit Then X = sglSplitLimit
    If X > Me.Width - sglSplitLimit Then X = Me.Width - sglSplitLimit
        
    '设置控件的 Left属性
    frmSplitter.Left = X
    lstQY.Left = 115
    lstCase.Left = X + frmSplitter.Width + 15
    
    '设置控件的Width属性
    lstQY.Width = X - 115
    lstCase.Width = Me.Width - X - 275

End Sub