frm_xfzd.frm

一个完整的非接触IC卡会员管理系统

VERSION 5.00
Begin VB.Form frm_xfzd 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "帐单列表"
   ClientHeight    =   4350
   ClientLeft      =   30
   ClientTop       =   420
   ClientWidth     =   3615
   BeginProperty Font 
      Name            =   "宋体"
      Size            =   12
      Charset         =   134
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   4350
   ScaleWidth      =   3615
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   Begin VB.CommandButton Command1 
      Caption         =   "导入"
      Height          =   732
      Left            =   2760
      TabIndex        =   1
      Top             =   1680
      Width           =   612
   End
   Begin VB.ListBox List1 
      Height          =   3660
      Left            =   240
      TabIndex        =   0
      Top             =   240
      Width           =   2292
   End
End
Attribute VB_Name = "frm_xfzd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As New ADODB.Recordset
Dim sxfls As Long

Private Sub Command1_Click()
If sxfls <> 0 Then
    sWhere = "select * from 消费明细临时表 where 帐单号=" & sxfls
    frm_xfmx.txtxfLS.Text = sxfls
    Unload Me
Else
    MsgBox "请选择帐单号！", vbInformation + vbOKOnly, "中芯德立提示信息"
End If
End Sub

Private Sub Form_Load()
Me.Top = (Screen.Height - Me.Height) / 2
Me.Left = (Screen.Width - Me.Width) / 2
List1.Clear
'Set rs = GetRecordset(maSys_db, "select sum(实收金额） from 消费明细临时表 where 帐单号=298")
Set rs = GetRecordset(maSys_db, "select 帐单号 from 消费明细临时表 where 备注='0' group by 帐单号") '备注为0表示未结算
If rs.EOF Then
   Exit Sub
Else
    rs.MoveFirst
    Do While Not rs.EOF
        List1.AddItem rs!帐单号
        rs.MoveNext
    Loop
End If
End Sub

Private Sub List1_Click()
sxfls = List1.Text

End Sub