frmexportquery.frm

财务信息管理系统,适合做毕业论文的人使用

VERSION 5.00
Begin VB.Form frmExportQuery 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "导出条件选择"
   ClientHeight    =   3705
   ClientLeft      =   2880
   ClientTop       =   1080
   ClientWidth     =   5925
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3705
   ScaleWidth      =   5925
   Begin VB.Frame Frame1 
      Height          =   3015
      Left            =   120
      TabIndex        =   2
      Top             =   120
      Width           =   5655
      Begin VB.TextBox txtStartID 
         Height          =   270
         Left            =   1680
         MaxLength       =   20
         TabIndex        =   12
         Top             =   705
         Width           =   1575
      End
      Begin VB.ComboBox cboVchStyle 
         Height          =   300
         ItemData        =   "frmExportQuery.frx":0000
         Left            =   1680
         List            =   "frmExportQuery.frx":0002
         Style           =   2  'Dropdown List
         TabIndex        =   11
         Top             =   240
         Width           =   3735
      End
      Begin VB.TextBox txtEndID 
         Height          =   270
         Left            =   3840
         MaxLength       =   20
         TabIndex        =   10
         Top             =   705
         Width           =   1575
      End
      Begin VB.TextBox txtStartDate 
         Alignment       =   1  'Right Justify
         Height          =   270
         Left            =   1680
         TabIndex        =   9
         Top             =   1545
         Width           =   1575
      End
      Begin VB.TextBox txtEndDate 
         Alignment       =   1  'Right Justify
         Height          =   270
         Left            =   3840
         TabIndex        =   8
         Top             =   1545
         Width           =   1575
      End
      Begin VB.ComboBox cboBill 
         Height          =   300
         Left            =   1680
         TabIndex        =   7
         Top             =   2040
         Width           =   3735
      End
      Begin VB.ComboBox cboUnitName 
         Height          =   300
         Left            =   1680
         TabIndex        =   6
         Top             =   1080
         Width           =   3735
      End
      Begin VB.ComboBox cboCheck 
         Height          =   300
         Left            =   1680
         TabIndex        =   5
         Top             =   2520
         Width           =   3735
      End
      Begin VB.CommandButton cmdRef1 
         Height          =   255
         Left            =   3240
         Style           =   1  'Graphical
         TabIndex        =   4
         Top             =   1560
         Visible         =   0   'False
         Width           =   255
      End
      Begin VB.CommandButton cmdRef2 
         Height          =   255
         Left            =   5400
         Style           =   1  'Graphical
         TabIndex        =   3
         Top             =   1560
         Visible         =   0   'False
         Width           =   255
      End
      Begin VB.Label Label1 
         Alignment       =   1  'Right Justify
         Caption         =   "单据类型："
         Height          =   255
         Left            =   120
         TabIndex        =   20
         Top             =   240
         Width           =   1095
      End
      Begin VB.Label Label2 
         Alignment       =   1  'Right Justify
         Caption         =   "单据编号："
         Height          =   255
         Left            =   120
         TabIndex        =   19
         Top             =   720
         Width           =   1095
      End
      Begin VB.Label Label7 
         Alignment       =   2  'Center
         Caption         =   "至"
         Height          =   255
         Left            =   3360
         TabIndex        =   18
         Top             =   720
         Width           =   375
      End
      Begin VB.Label Label3 
         Alignment       =   1  'Right Justify
         Caption         =   "单位名称："
         Height          =   255
         Left            =   120
         TabIndex        =   17
         Top             =   1110
         Width           =   1095
      End
      Begin VB.Label Label4 
         Alignment       =   1  'Right Justify
         Caption         =   "日    期："
         Height          =   255
         Left            =   120
         TabIndex        =   16
         Top             =   1560
         Width           =   1095
      End
      Begin VB.Label Label5 
         Alignment       =   1  'Right Justify
         Caption         =   "制 单 人："
         Height          =   255
         Left            =   120
         TabIndex        =   15
         Top             =   2070
         Width           =   1095
      End
      Begin VB.Label Label6 
         Alignment       =   1  'Right Justify
         Caption         =   "审 核 人："
         Height          =   255
         Left            =   120
         TabIndex        =   14
         Top             =   2550
         Width           =   1095
      End
      Begin VB.Label Label8 
         Alignment       =   2  'Center
         Caption         =   "至"
         Height          =   255
         Left            =   3360
         TabIndex        =   13
         Top             =   1560
         Width           =   375
      End
   End
   Begin VB.CommandButton cmdQuit 
      Cancel          =   -1  'True
      Caption         =   "退出"
      Height          =   375
      Left            =   4680
      TabIndex        =   1
      Top             =   3240
      Width           =   1095
   End
   Begin VB.CommandButton cmdOK 
      Caption         =   "确定"
      Height          =   375
      Left            =   3120
      TabIndex        =   0
      Top             =   3240
      Width           =   1095
   End
End
Attribute VB_Name = "frmExportQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'and t1.istate<>'1' and t1.bdestroy<>'1' and t2.istate<>'1' and t2.bdestroy<>'1'
Option Explicit
Dim unitID As New Collection

Private Sub cboBill_LostFocus()
    cboBill.Text = Trim(cboBill.Text)
    If cboBill.Text <> "" And Not m_objAid.bContain(cboBill.Text, cboBill) And Me.ActiveControl.Name <> "cmdQuit" Then
        iShowMsg "制单人不存在!"
        cboBill.SetFocus
    End If
End Sub

Private Sub cboCheck_LostFocus()
    cboCheck.Text = Trim(cboCheck.Text)
    If cboCheck.Text <> "" And Not m_objAid.bContain(cboCheck.Text, cboCheck) And Me.ActiveControl.Name <> "cmdQuit" Then
        iShowMsg "审核人不存在!"
        cboCheck.SetFocus
    End If
End Sub

Private Sub cboUnitName_LostFocus()
    cboUnitName.Text = Trim(cboUnitName.Text)
    If cboUnitName.Text <> "" And Not m_objAid.bContain(cboUnitName.Text, cboUnitName) And Me.ActiveControl.Name <> "cmdQuit" Then
        iShowMsg "单位不存在!"
        cboUnitName.SetFocus
    End If
End Sub

Private Sub cmdOk_Click()
    Dim sql As String
    Dim rs As ADODB.Recordset
    '校验字段
    If bCheckField Then
        Set rs = New ADODB.Recordset
'        sql = " from fd_Transactions left join fd_accdef as t1 on fd_Transactions.rcv_acc_id=t1.accdef_id " & _
'            "left join fd_accdef as t2 on fd_Transactions.pay_acc_id=t2.accdef_id " & _
'            "left join fd_accunit as t3 on t1.accunit_id=t3.accunit_id " & _
'            "left join fd_accunit as t4 on t2.accunit_id=t4.accunit_id " & GetQuery
        sql = GetQuery
            
        frmExportList.SetSql sql, cboVchStyle.ListIndex
    Else
        Exit Sub
    End If
    Unload Me
End Sub

Private Sub ClearInfo()
    If cboVchStyle.ListCount <> 0 Then
        cboVchStyle.ListIndex = 0
    End If
    txtStartID.Text = ""
    txtEndID.Text = ""
    cboUnitName.Text = ""
    txtStartDate.Text = ""
    txtEndDate.Text = ""
    cboBill.Text = ""
    cboCheck.Text = ""
End Sub
    
Private Sub cmdQuit_Click()
    Unload Me
End Sub

Private Sub cmdRef1_Click()